Job field specifications

This table lists the field-column specifications of the Job 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.Job_Desc	Varchar2	40	Description (alpha numeric)
4	JOB.Job_Start_Date*	Varchar2	40/yyyy-mmdd	Start date The default is 19000101
5	JOB.Job_End_Date*	Varchar2	40/yyyy-mmdd	End date The default is 30000101
6	JOB.Flag1..5	Varchar2	1
7	JOB.Refkey1	Number
8	JOB.Refkey2	Number
9	JOB.Refkey3	Number
10	JOB.Refkey4	Number
11	JOB.Refkey5	Number	40
12	JOB.Val1	Varchar2	40
13	JOB.Val2	Varchar2	40
14	JOB.Val3	Varchar2	40
15	JOB.Val4	Varchar2	40
16	JOB.Val5	Varchar2	40
17	JOB.Val6	Varchar2	40
18	JOB.Val7	Varchar2	40	N
19	JOB.Val8	Varchar2	40	N
20	JOB.Val9	Varchar2	40	N
21	JOB.Val10	Varchar2	40	N
22	JOB LMS Name	Varchar2	40	Optional. The name of a labor metric security record (the LMS_NAME of a LABOR_METRIC_SEC record).
23	JOB.JOB_EXC_FRM_QLFY	Varchar2	1	Optional. Set to Y to exclude the job from the processing of job qualifications for skills and training. All values other than Y are converted to N.
24	JOB.JOB_UNAUTH	Varchar2	1	Optional. Set to True for this job to be considered 'unauthorizing' by authorization rules that consider jobs. If a value is not provided then N is used for new jobs. For updated jobs the existing value is kept. Valid values include Y, N, or an empty field.
25	JOB.JOB_PBJ_TITLE_CODE	Number		Optional. Specify the job title code to be used in the Payroll Based Journal (PBJ) for CMS Report. The ampersand (&) character can be used to set a blank value in this field if the field has previously been specified in a job record.