TRN_SUMMARY_VW(SQL View) |
Index Back |
---|---|
Student Training SummaryTRN_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 |