CAREER_TRAINING (SQL Table)	Index Back
EE Career Training Plan CAREER_TRAINING is part of Career Planning for an employee. Use it to identify training courses an employee should take to further enhance their career potential.

CAREER_TRAINING

(SQL Table)

EE Career Training Plan

CAREER_TRAINING is part of Career Planning for an employee. Use it to identify training courses an employee should take to further enhance their career potential.

Parent record: CAREERPLAN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

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

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

4 EST_COMPLETION_DT Date(10) DATE Estimated Completion Date

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

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

7 COURSE_TITLE Character(30) VARCHAR2(30) NOT NULL Course Title

8 INTERNAL_EXTERNAL Character(1) VARCHAR2(1) NOT NULL Internal/External
E=External
I=Internal

9 TRAINING_REASON Character(2) VARCHAR2(2) NOT NULL Training Reason
CM=Compliance
DV=Development
EN=Enrichment
JR=Job Requirement
LC=License Renewal
MD=Management Discretion
RQ=Requalification
SE=Skill Enhancement

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

11 SCHOOL_CODE Character(10) VARCHAR2(10) NOT NULL School Code
Prompt Table: SCHOOL_TBL_VW2

12 SCHOOL Character(30) VARCHAR2(30) NOT NULL School Name

13 NEED_IDENTIFIED_DT Date(10) DATE Date Need Identified
Default Value: CAREERPLAN.EFFDT

14 ACT_COMPLETION_DT Date(10) DATE Actual Completion Date

15 GVT_SELF_DEVELOP Character(1) VARCHAR2(1) NOT NULL Self-Development
Y/N Table Edit
Default Value: N

16 GVT_ESTIMATED_COST Number(10,2) DECIMAL(9,2) NOT NULL Estimated Cost

17 GVT_ACTUAL_COST Number(10,2) DECIMAL(9,2) NOT NULL Actual Cost

18 GVT_ACT_STATUS Character(2) VARCHAR2(2) NOT NULL Activity Status
1=Requested
2=Approved
3=Disapproved
4=Deferred
5=In Progress
6=Completed

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	TRN_PROGRAM	Character(6)	VARCHAR2(6) NOT NULL	Training Program
4	EST_COMPLETION_DT	Date(10)	DATE	Estimated Completion Date
5	COURSE_SEQUENCE	Number(2,0)	SMALLINT NOT NULL	Course Sequence
6	COURSE	Character(6)	VARCHAR2(6) NOT NULL	Course Code Prompt Table: COURSE_TBL
7	COURSE_TITLE	Character(30)	VARCHAR2(30) NOT NULL	Course Title
8	INTERNAL_EXTERNAL	Character(1)	VARCHAR2(1) NOT NULL	Internal/External E=External I=Internal
9	TRAINING_REASON	Character(2)	VARCHAR2(2) NOT NULL	Training Reason CM=Compliance DV=Development EN=Enrichment JR=Job Requirement LC=License Renewal MD=Management Discretion RQ=Requalification SE=Skill Enhancement
10	REQUIRED_CRSE	Character(1)	VARCHAR2(1) NOT NULL	Required Y/N Table Edit Default Value: N
11	SCHOOL_CODE	Character(10)	VARCHAR2(10) NOT NULL	School Code Prompt Table: SCHOOL_TBL_VW2
12	SCHOOL	Character(30)	VARCHAR2(30) NOT NULL	School Name
13	NEED_IDENTIFIED_DT	Date(10)	DATE	Date Need Identified Default Value: CAREERPLAN.EFFDT
14	ACT_COMPLETION_DT	Date(10)	DATE	Actual Completion Date
15	GVT_SELF_DEVELOP	Character(1)	VARCHAR2(1) NOT NULL	Self-Development Y/N Table Edit Default Value: N
16	GVT_ESTIMATED_COST	Number(10,2)	DECIMAL(9,2) NOT NULL	Estimated Cost
17	GVT_ACTUAL_COST	Number(10,2)	DECIMAL(9,2) NOT NULL	Actual Cost
18	GVT_ACT_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Activity Status 1=Requested 2=Approved 3=Disapproved 4=Deferred 5=In Progress 6=Completed