TRN_CRS_STUD_VW(SQL View) |
Index Back |
|---|---|
Student Training ViewAdminister Training view detailing student training information for course sessions. |
| SELECT DISTINCT SEC.OPRID , A.COURSE ,A.SESSION_NBR ,SEC.EMPLID ,SEC.NAME ,A.ATTENDANCE , A.COURSE_GRADE FROM PS_TRAINING A , PS_PERSON_NAME B , PS_TRNPER_SEC_SRCH SEC WHERE A.EMPLID=B.EMPLID AND A.SESSION_NBR <> ' ' AND A.EMPLID = SEC.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL | Course Code |
| 3 | SESSION_NBR |
Character(4) | VARCHAR2(4) NOT NULL | Course Session Nbr |
| 4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 6 | 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 |
| 7 | COURSE_GRADE | Character(3) | VARCHAR2(3) NOT NULL |
Grade
A=A B=B C=C D=D F=F FL=Fail P=Pass |