SS_TRN_STG_VW(SQL View) |
Index Back |
|---|---|
Staged Training EnrollmentsEnrollment Requests waiting approval (used for prerequisite checking) |
| SELECT A.EMPLID , B. COURSE , B. SESSION_NBR , C.COURSE_START_DT , D.ATTENDANCE FROM PS_SS_KEYS A , PS_SS_DTL_TRAINING B , PS_CRSE_SESSN_TBL C , PS_TRAINING D WHERE A.TRANSACTION_NAME = B.TRANSACTION_NAME AND A.SS_GRP_ID = B.SS_GRP_ID AND A.SS_TRANS_ID = B.SS_TRANS_ID AND C.COURSE = B.COURSE AND C.SESSION_NBR = B.SESSION_NBR AND D.EMPLID = A.EMPLID AND D.COURSE = B.COURSE AND D.SESSION_NBR = B.SESSION_NBR AND NOT EXISTS ( SELECT 'X' FROM PS_SS_KEYS D WHERE D.TRANSACTION_NAME = B.TRANSACTION_NAME AND D.SS_GRP_ID = B.SS_GRP_ID AND D.SS_TRANS_ID = B.SS_TRANS_ID AND D.LAST_PROC_ACTION = 'D') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL | Course Code |
| 3 | SESSION_NBR |
Character(4) | VARCHAR2(4) NOT NULL | Course Session Nbr |
| 4 | COURSE_START_DT | Date(10) | DATE | Course Start Date |
| 5 | 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 |