UX_TRN_SUMM(SQL View) |
Index Back |
|---|---|
Upcoming Training Summary ViewView of training courses student enrolled in having a status of enrolled, wait listed or active. This view is used for upcoming training on Alerts Pagelet |
| SELECT A.EMPLID , A.COURSE_START_DT , A.COURSE , A.SESSION_NBR , A.COURSE_TITLE , A.COURSE_END_DT , A.ATTENDANCE , B.FACILITY_NAME FROM PS_TRAINING A ,PS_CRSE_SESS_DATES B WHERE ATTENDANCE IN('A','E','S') AND A.COURSE=B.COURSE AND A.SESSION_NBR = B.SESSION_NBR |
| # | 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 | |
| 6 | COURSE_END_DT | Date(10) | DATE | Course End Date |
| 7 | 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 |
| 8 | FACILITY_NAME | Character(30) | VARCHAR2(30) NOT NULL | Facility Name |