TRN_PROGRM_CRSE (SQL Table)	Index Back
Training Program Courses Use TRN_PROGRM_CRSE to identify the specific courses that make up a training program. The high-level information about a training program is located on TRN_PROGRM_TBL. A training program is a set of training courses with a common goal, i.e., to teach an employee a new job skill or to refresh their skills for recertification. This functionality is part of the Training Administration application. You can use the JOBCODE_TBL to specify a training program for a particular job code.

TRN_PROGRM_CRSE

(SQL Table)

Training Program Courses

Use TRN_PROGRM_CRSE to identify the specific courses that make up a training program. The high-level information about a training program is located on TRN_PROGRM_TBL. A training program is a set of training courses with a common goal, i.e., to teach an employee a new job skill or to refresh their skills for recertification. This functionality is part of the Training Administration application. You can use the JOBCODE_TBL to specify a training program for a particular job code.

Parent record: TRN_PROGRM_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 COURSE_SEQUENCE Number(2,0) SMALLINT NOT NULL Course Sequence

3 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code
Prompt Table: COURSE_TBL

4 REQUIRED_CRSE Character(1) VARCHAR2(1) NOT NULL Required
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TRN_PROGRAM	Character(6)	VARCHAR2(6) NOT NULL	Training Program Prompt Table: TRN_PROGRM_TBL
2	COURSE_SEQUENCE	Number(2,0)	SMALLINT NOT NULL	Course Sequence
3	COURSE	Character(6)	VARCHAR2(6) NOT NULL	Course Code Prompt Table: COURSE_TBL
4	REQUIRED_CRSE	Character(1)	VARCHAR2(1) NOT NULL	Required Y/N Table Edit Default Value: N