Job Rate field specifications
This table lists the field-column specifications of the Job Rate part of the Job Rate Import Interface. Fields with the asterisk symbol (*) are required.
| Col. | Field Name | Type | Size/Format | Description |
|---|---|---|---|---|
| 1 | TYPE* | Varchar2 | 1 | The type of record: J - for Job records R - for Job Rate records |
| 2 | JOB.Job_Name* | Varchar2 | 40 | Job name (alpha numeric) |
| 3 | JOB_RATE.Jobrate_Index* | Varchar2 | 40 | Index |
| 4 | JOB_RATE.Jobrate_Rate* | Varchar2 | 40 | Job rate |
| 5 | JOB_RATE.Jobrate_Effective_Date* | Varchar2 | 40 | Effective date of job rate |
| 6 | JOB_RATE.Flag1..5 | Varchar2 | 5 | |
| 7 | JOB_RATE.UDF1 | Varchar2 | 40 | |
| 8 | JOB_RATE.UDF2 | Varchar2 | 40 | |
| 9 | JOB_RATE.UDF3 | Varchar2 | 40 | |
| 10 | JOB_RATE.UDF4 | Varchar2 | 40 | |
| 11 | JOB_RATE.UDF5 | Varchar2 | 40 |