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. |