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