TRN_CRSE_ENROLL(SQL View) |
Index Back |
|---|---|
Trn Course Enrollees ViewTRN_CRSE_ENROLL is a view of TRAINING data used to retrieve all students who are currently enrolled in any session of a particula |
| SELECT EMPLID ,COURSE ,SESSION_NBR ,ATTENDANCE ,STATUS_DT FROM PS_TRAINING WHERE ATTENDANCE IN ('E','A','C') |
| # | 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 |
Character(6) | VARCHAR2(6) NOT NULL |
Course Code
Prompt Table: COURSE_TBL |
| 3 | SESSION_NBR | Character(4) | VARCHAR2(4) NOT NULL | Course Session Nbr |
| 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 |