JOBCD_TRN_PROG (SQL Table)	Index Back
Job Codes Use JOBCODE_TBL to record information about the job assignments in your company. Assign a job code to each job. Data includes description, salary grade, standard hours, and salary survey equivalents. You can create multiple JOBCODE_TBL records for a job code, each with a unique effective date.

JOBCD_TRN_PROG

(SQL Table)

Job Codes

Use JOBCODE_TBL to record information about the job assignments in your company. Assign a job code to each job. Data includes description, salary grade, standard hours, and salary survey equivalents. You can create multiple JOBCODE_TBL records for a job code, each with a unique effective date.

Parent record: JOBCODE_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_HR.SETID
Prompt Table: SET_VLD_HR_02

2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 TRN_PROGRAM Character(6) VARCHAR2(6) NOT NULL Training Program
Prompt Table: TRN_PROGRM_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SET_VLD_HR_02
2	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	TRN_PROGRAM	Character(6)	VARCHAR2(6) NOT NULL	Training Program Prompt Table: TRN_PROGRM_TBL