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 GRADE_ROSTER:

Table: GRADE_ROSTER - Grade Roster

Short Description: Class section grade rosters

Long Description: Grades entered by class instructors, once posted the grade appears on the student's record (STDNT_ENRL).

Useful Fields:

Field Name	Field Descr
STRM	Term
CLASS_NBR	Class Number, a unique value within each term for a class section.
GRD_RSTR_TYPE_SEQ	Grade Roster Sequence
EMPLID	Student/Person ID number
ACAD_CAREER	Code for Academic Career. Value attached to the student.
CRSE_GRADE_INPUT	Grade entered by the instructor
GRADE_ROSTER_STAT	Status of individual row on the Grade Roster (posted, pending, etc.)

Criteria Notes:

The header record, GRADE_RSTR_TYPE, has roster status, dates, and grade roster type

Grade changes on recorded on table ENRL_REQ_DETAIL

Related Tables: CLASS_TBL  ENRL_REQ_DETAIL  GRADE_RSTR_TYPE  STDNT_ENRL  TERM_TBL  U_CC_DATA_TBL 

For updates, corrections or questions Email Stephen Forrest.