TRN_TUIT_VW

(SQL View)
 Index Back

Student Training Summary

TRN_TUIT_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.

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

# 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
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

34 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

Prompt Table: PER_ORG_ASGN