Body
This View was built for the Discoverer Tool which has been retired, The view remains valid and is available for use.
It includes Class Instructors and Role Details from the Source Tables listed.
Detailed Information
Databases
PeopleSoft Campus Solutions CSPRD
PeopleSoft Campus Solutions Reporting CSRPT
Source Tables
CLASS_TBL - Class Table
CLASS_INSTR - Class Instructor Table
UM_NAMES_VW - Person Names Query
View SQL Code
Download SQL Code
| Key |
Record.Fieldname |
Format |
XLAT |
Heading Text |
Source Tables |
| Key |
CLASS_MTG_NBR - Class Meeting Pattern Nbr |
Num2.0 |
|
Pat Nbr |
CLASS_INSTR |
| Key |
CLASS_SECTION - Class Section |
Char4 |
|
Section |
CLASS_INSTR |
| Key |
CRSE_ID - Course ID |
Char6 |
|
Course ID |
CLASS_INSTR |
| Key |
CRSE_OFFER_NBR - Course Offering Nbr |
Num2.0 |
|
Offer Nbr |
CLASS_INSTR |
| |
EMPL_RCD - Empl Rcd Nbr |
Num3.0 |
|
Empl Rcd# |
CLASS_INSTR |
| |
EMPLID - Empl ID |
Char11 |
|
ID |
CLASS_INSTR |
| |
GRADE_RSTR_ACCESS - Grade Roster Access |
Char1 |
N |
Access |
CLASS_INSTR |
| Key |
INSTITUTION - Academic Institution |
Char5 |
|
Institution |
CLASS_TBL |
| Key |
INSTR_ASSIGN_SEQ - Class/Instructor Assign Seq # |
Num3.0 |
|
Assign Seq # |
CLASS_INSTR |
| |
INSTR_ROLE - Instructor Role |
Char4 |
N |
Role |
CLASS_INSTR |
| |
NAME - Name |
Char50 |
|
Name |
UM_NAMES_VW |
| |
SCHED_PRINT_INSTR - Print Instructor in Schedule |
Char1 |
N |
Print |
CLASS_INSTR |
| Key |
SESSION_CODE - Session |
Char3 |
N |
Session |
CLASS_INSTR |
| Key |
STRM - Term |
Char4 |
|
Term |
CLASS_INSTR |