TRN_SESN_STUDNT(SQL View) |
Index Back |
|---|---|
Trn Session Students ViewTRN_SESN_STUDENT is a view of TRAINING data used to retrieve all student statuse |
| SELECT COURSE ,EMPLID ,SESSION_NBR ,ATTENDANCE ,STATUS_DT FROM PS_TRAINING WHERE SESSION_NBR <> ' ' AND ATTENDANCE NOT IN ('W','S') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  COURSE |
Character(6) | VARCHAR2(6) NOT NULL |
Course Code
Prompt Table: COURSE_TBL |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 3 | SESSION_NBR |
Character(4) | VARCHAR2(4) NOT NULL |
Course Session Nbr
Prompt Table: CRSE_SESSN_TBL |
| 4 | 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 |
| 5 | STATUS_DT | Date(10) | DATE | Status Date |