Data Dictionary Keyword Search

This Data Dictionary contains student related Access.SMU database tables commonly used in the query tool. In the keyword search below you may enter the table name, field name, or the common name for the information you are seeking.

| List All Tables

Table Information for CLASS_INSTR:

Table: CLASS_INSTR - Class Instructor Table

Short Description: Instructors attached to class sections

Long Description: All instructors, TA's, and grading admins attached to class sections.

Useful Fields:

Field Name	Field Descr
CRSE_ID	Course ID number
CRSE_OFFER_NBR	Course Offer Number
STRM	Term
SESSION_CODE	Session Code, within a term
CLASS_SECTION	Class Section
CLASS_MTG_NBR	Class Meeting Pattern Number. Different for when a class section has multiple meeting patterns.
INSTR_ASSIGN_SEQ	Instructor Sequence Number for a class section
EMPLID	Student/Person ID number
INSTR_ROLE	Instructor Role in a class section (primary, TA, etc.)
GRADE_RSTR_ACCESS	Flag to denote if instructor has access to update grade rosters

Criteria Notes:

Typically join from CLASS_TBL.

A class section has a row of data for each meeting pattern. A few sections have multiple meeting patters and could have a different instructor for each.

For each meeting pattern a instructor sequence is assigned, that can be used to select one instructor

Multiple instructors can be attached to a section with INSTR_ROLE values for primary, secondary, supervisory, teaching assistants, administrative aides

To pull a single primary instructor for a class, use a subquery to pull the minimum CLASS_MTG_NBR with INSTR_ROLE = 'PI'. Another subquery to pull the minimum INSTR_ASSIGN_SEQ for the minimum CLASS_MTG_NBR that has an INSTR_ROLE = 'PI'

Related Tables: ACAD_CALTRM_TBL  CLASS_MTG_PAT  CLASS_TBL  INSTR_ADVISOR  SCC_NAMES_QVW  U_CC_PDATA_TBL  U_SR_CEN_CLASS  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.