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