Associated Job field specifications

This table lists the field-column specifications in the Associated Job import interface. Fields with the asterisk (*) symbol are required.

Col. Field Name Type Size/Format Description
1 JOB_NAME* Varchar2 40 Name of the job (JOB_NAME), which is resolved to the JOB_ID field.
2 CHILD_JOB_NAME* Varchar2 40 Name of the associated job (JOB_NAME), which is resolved to the JOB_ID field.
3 JOBASSOC_FLAG1 Varchar2 1 One-character flag for general use.
4 JOBASSOC_FLAG2 Varchar2 1 One-character flag for general use.
5 JOBASSOC_FLAG3 Varchar2 1 One-character flag for general use.
6 JOBASSOC_FLAG4 Varchar2 1 One-character flag for general use.
7 JOBASSOC_FLAG5 Varchar2 1 One-character flag for general use.
8 JOBASSOC_UDF1 Varchar2 40 User defined field.
9 JOBASSOC_UDF2 Varchar2 40 User defined field.
10 JOBASSOC_UDF3 Varchar2 40 User defined field.
11 JOBASSOC_UDF4 Varchar2 40 User defined field.
12 JOBASSOC_UDF5 Varchar2 40 User defined field.
13 JOBASSOC_RANK* Number 8 Determines priorities. When a user creates a shift for a parent job, all the child jobs available for the employee are checked and the child job with the highest rank is selected.