HR_CP_TRAIN_VW

(SQL View)
 Index Back

EE Training History

Use TRAINING to record data about training courses, both internal and external, taken by a student. A student can be an employee, an applicant, or a non-employee. You can create multiple TRAINING records for a student.

SELECT EMPLID , COURSE_START_DT , COURSE , SESSION_NBR , COURSE_TITLE , ATTENDANCE , ' ' , GVT_TC_TYPE , GVT_TC_PURPOSE , 0 , ' ' , ' ' , ' ' FROM PS_TRAINING

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERS_SRCH_GBL

2 COURSE_START_DT Date(10) DATE Course Start Date
3 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code

Prompt Table: COURSE_TBL

4 SESSION_NBR Character(4) VARCHAR2(4) NOT NULL Course Session Nbr

Prompt Table: CRSE_ATV_SSN_VW

5 COURSE_TITLE Character(30) VARCHAR2(30) NOT NULL Course Title
6 ATTENDANCE Character(1) VARCHAR2(1) NOT NULL Enrollment/Attendance
A=Currently Attending
C=Completed
D=Dropped
E=Enrolled
I=Incomplete
L=Cancelled
N=No Show
O=Training Request Approved
P=Need for Career Plan
R=Request
S=Session Waitlist
T=Need for Training Program
U=Training Request Authorized
W=Course Waitlist
X=Cancel Request for Training

Default Value: W

7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
8 GVT_TC_TYPE Character(1) VARCHAR2(1) NOT NULL Training Code Type
1=Executive & Management
2=Supervisory
3=Lgl,Medical,Scientific,Engrng
4=Administration and Analysis
5=Specialty and Technical
6=Clerical
7=Trade or craft
8=Orientation
9 GVT_TC_PURPOSE Character(1) VARCHAR2(1) NOT NULL Training Code Purpose
1=Mission or program Change
2=New Technology
3=New work assignment
4=Improve Present Performance
5=Meet Future Staffing Needs
6=Develop unavailable skill
7=Trade or Craft Apprenticeship
8=Orientation
9=Basic Adult Education
10 DURATION_TIME Number(6,1) DECIMAL(5,1) NOT NULL Duration Time
11 COST_UNIT_CD Character(10) VARCHAR2(10) NOT NULL Cost Unit
12 DESCR3 Character(30) VARCHAR2(30) NOT NULL Descr 3
13 DESCR4 Character(30) VARCHAR2(30) NOT NULL Descr 4