TRN_PROGRM_TBL (SQL Table)	Index Back
Training Programs Use TRN_PROGRM_TBL to record the high-level information about training programs offered by your company. 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. You can use a subordinate record named TRN_PROGRM_CRSE to identify the specific courses that make up a training program. 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. This program can then used as the default training program in the employee's career plan.

TRN_PROGRM_TBL

(SQL Table)

Training Programs

Use TRN_PROGRM_TBL to record the high-level information about training programs offered by your company. 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. You can use a subordinate record named TRN_PROGRM_CRSE to identify the specific courses that make up a training program. 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. This program can then used as the default training program in the employee's career plan.

Related Language Record: TRN_PROGRM_LANG

Parent Record Of TRN_PROGRM_CRSE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TRN_PROGRAM Character(6) VARCHAR2(6) NOT NULL Training Program

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

4 CREATION_DT Date(10) DATE Creation Date

5 REVISION_DT Date(10) DATE Revision Date

6 COURSE_STATUS Character(1) VARCHAR2(1) NOT NULL Program Status
A=Active
I=Inactive
P=Proposed
Default Value: A

7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: BUS_UNIT_TBL_HR

8 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: DEPT_TBL

9 COMMENTS Long Character CLOB Comment

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TRN_PROGRAM	Character(6)	VARCHAR2(6) NOT NULL	Training Program
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
4	CREATION_DT	Date(10)	DATE	Creation Date
5	REVISION_DT	Date(10)	DATE	Revision Date
6	COURSE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Program Status A=Active I=Inactive P=Proposed Default Value: A
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUS_UNIT_TBL_HR
8	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
9	COMMENTS	Long Character	CLOB	Comment