JOBCDTRN_CAREER (SQL Table)	Index Back
Job Codes - Career Planning 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.

JOBCDTRN_CAREER

(SQL Table)

Job Codes - Career Planning

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.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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

3 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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	TRN_PROGRAM	Character(6)	VARCHAR2(6) NOT NULL	Training Program Prompt Table: TRN_PROGRM_TBL