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 |