UM_D_CLSS_INSTV - Instructors with Role Assignments

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

 

Details

Details

Article ID: 172879
Created
Wed 9/11/24 1:43 PM
Modified
Tue 9/17/24 9:34 AM
Applies To
Faculty
Staff
Community

Related Services / Offerings

Related Services / Offerings (1)

Submit an inquiry about UMS Data (except Data Governance)

Attachments

;