TRN_SUMMARY_VW

(SQL View)
 Index Back

Student Training Summary

TRN_SUMMARY_VW is a view of training courses which a student has completed or in which they are currently enrolled. It is used for training history and tuition reimbursement. Dependent on CRSE_SESSN_VW which is dependent 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 ,B.FACILITY ,B.FACILITY_NAME ,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 , PS_CRSE_ALL_SSN_VW B WHERE A.COURSE=B.COURSE(+) AND A.SESSION_NBR=B.SESSION_NBR(+) AND 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 FACILITY Character(6) VARCHAR2(6) NOT NULL Facility
11 FACILITY_NAME Character(30) VARCHAR2(30) NOT NULL Facility Name
12 DT_NEEDED Date(10) DATE Date Needed
13 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

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

Prompt Table: TRN_STD_LTR_VW

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

Y/N Table Edit

Default Value: N

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

Prompt Table: DEPT_TBL

22 DEMAND_ID Character(10) VARCHAR2(10) NOT NULL Demand ID
23 TRAINING_LEAVE_FRA Character(1) VARCHAR2(1) NOT NULL Training Leave

Y/N Table Edit

Default Value: N

24 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

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

Y/N Table Edit

Default Value: N

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

Default Value: H

Prompt Table: DT_COST_UNIT_VW

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

34 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

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

Prompt Table: BUS_UNIT_TBL_HR