COURSESESSION_NBRCRS_SESSINST_VW(SQL View) |
Index Back |
|---|---|
Course Session InstructorsThis view displays a distinct list of instructors for a course session. This view is used on the Course Evaluations panel to overcome the fact that the same instructor may be used for different cut sessions. |
| SELECT DISTINCT COURSE, SESSION_NBR, INSTRUCTOR_ID, NAME, VENDOR FROM PS_CRSE_SESS_INSTR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL | Course Code |
| 2 | SESSION_NBR |
Character(4) | VARCHAR2(4) NOT NULL | Course Session Nbr |
| 3 | INSTRUCTOR_ID | Character(11) | VARCHAR2(11) NOT NULL | Instructor ID |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 5 | VENDOR | Character(6) | VARCHAR2(6) NOT NULL | Vendor ID |