TRAINING_SUM_VW

(SQL View)
 Index Back

Student Training Summary

TRAINING_SUM_VW is a copy of TRN_SUMMARY_VW view (with the FACILITY columns removed for faster performance) of training courses which a student has completed or in which they are currently enrolled. It is used for training history and tuition reimbursement. Therefore this has removed the dependancy on CRSE_SESSN_VW and on CRS_1ST_SESS_VW

SELECT A.EMPLID ,A.COURSE_START_DT ,A.COURSE ,A.SESSION_NBR ,A.COURSE_TITLE ,A.COURSE_END_DT ,A.INTERNAL_EXTERNAL ,A.SCHOOL_CODE ,A.SCHOOL ,A.DT_NEEDED ,A.ATTENDANCE ,A.STATUS_DT ,A.WAIT_DT ,A.TRAINING_REASON ,A.COURSE_GRADE ,A.LETTER_CD ,A.LETTER_PRINTED_DT ,A.PREREQ_MET ,A.DEPTID ,A.DEMAND_ID ,%subrec(TRAININGFRA_SBR,A) ,A.BUSINESS_UNIT FROM PS_TRAINING A WHERE A.ATTENDANCE IN ('A','C','E','S')

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

Prompt Table: PERSON

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_SESSN_TBL

5 COURSE_TITLE Character(30) VARCHAR2(30) NOT NULL Course Title
6 COURSE_END_DT Date(10) DATE Course End Date
7 INTERNAL_EXTERNAL Character(1) VARCHAR2(1) NOT NULL Internal/External
E=External
I=Internal
8 SCHOOL_CODE Character(10) VARCHAR2(10) NOT NULL School Code

Prompt Table: SCHOOL_TBL

9 SCHOOL Character(30) VARCHAR2(30) NOT NULL School Name
10 DT_NEEDED Date(10) DATE Date Needed
11 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: A

12 STATUS_DT Date(10) DATE Status Date
13 WAIT_DT Date(10) DATE Waitlist Entry Date
14 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
15 COURSE_GRADE Character(3) VARCHAR2(3) NOT NULL Grade
A=A
B=B
C=C
D=D
F=F
FL=Fail
P=Pass
16 LETTER_CD Character(3) VARCHAR2(3) NOT NULL Letter code

Prompt Table: TRN_STD_LTR_VW

17 LETTER_PRINTED_DT Date(10) DATE Date letter was printed
18 PREREQ_MET Character(1) VARCHAR2(1) NOT NULL Prerequisites Met

Y/N Table Edit

Default Value: N

19 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPT_TBL

20 DEMAND_ID Character(10) VARCHAR2(10) NOT NULL Demand ID
21 TRAINING_LEAVE_FRA Character(1) VARCHAR2(1) NOT NULL Training Leave

Y/N Table Edit

Default Value: N

22 TRN_PLN_CATEGORY Character(1) VARCHAR2(1) NOT NULL Feild for Training Plan Category
0=Not Specified
1=Adaptation to Job Changement
2=Job Preservation
3=Skill Development

Default Value: 0

23 PART_TIME_CRSE_FRA Character(1) VARCHAR2(1) NOT NULL Part Time Course

Y/N Table Edit

Default Value: N

24 COST_UNIT_CD Character(10) VARCHAR2(10) NOT NULL Cost Unit

Default Value: H

Prompt Table: DT_COST_UNIT_VW

25 TIME_SPENT_FRA Number(6,1) DECIMAL(5,1) NOT NULL Time spent at training
26 DURATION_CONVERTED Number(6,1) DECIMAL(5,1) NOT NULL Converted Duration
27 TRN_IMPUTABLE_FLG Character(1) VARCHAR2(1) NOT NULL Chargeable

Y/N Table Edit

Default Value: N

28 TRN_DIF_FRA_FLG Character(1) VARCHAR2(1) NOT NULL Field for Training DIF

Y/N Table Edit

Default Value: N

29 TRN_HOURS_FRA Number(3,0) SMALLINT NOT NULL Training Hours
30 TRN_PROF_FLG_FRA Character(1) VARCHAR2(1) NOT NULL Professionalisation Period Flag

Y/N Table Edit

Default Value: N

31 TRN_OUTWRK_FLG_FRA Character(1) VARCHAR2(1) NOT NULL Out of Working Schedule Flag

Y/N Table Edit

Default Value: N

32 TRN_EE_DURATION_SW Character(1) VARCHAR2(1) NOT NULL Radio Button for Training Employee Duration
0=Training Duration from Session
1=Specify Student Duration

Default Value: 0

33 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BUS_UNIT_TBL_HR