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

Table: GRADE_RSTR_TYPE - Grade Roster Type

Short Description: Header record for grade rosters

Long Description: Has grade roster status, posting dates, and grade roster type (early, mid-term, final)

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
GRADE_ROSTER_TYPE	Grade Roster Type (early, mid, final)
GRADING_STATUS	Status of an overall class Grade Roster (posted, ready to post
POSTING_DATE	Posting Date of a class grade roster
PARTIAL_POST	Grade roster Partially posted (Y or N)

Criteria Notes:

Grade roster types are ERLY (early), FIN (final), and MIDL (mid-term)

Early and mid-term grade rosters are purged for a term prior to the next grade roster type being created for that term. Eventually only final remains.

Grade roster can be partial posted, when not all grades are entered and the ones that are entered will appear on the student's record.

Related Tables: CLASS_TBL  GRADE_ROSTER  TERM_TBL 

For updates, corrections or questions Email Stephen Forrest.