Query Power Users

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

Table: CLASS_ATTRIBUTE - Class Attribute Table
Short Description: Listing of "tags" for the University Curriculum for undergraduates

Long Description: Attributes defined at the course level roll down to class sections as they are scheduled. Section specific attributes are only at this level.

Useful Fields:
Field NameField Descr
CRSE_IDCourse ID number
CRSE_OFFER_NBRCourse Offer Number
STRMTerm
SESSION_CODESession Code, within a term
CLASS_SECTIONClass Section
CRSE_ATTRCourse Attribute (parent to course attribute value)
CRSE_ATTR_VALUECourse Attribute Value (child of course attribute)

Criteria Notes:
Join from CLASS_TBL.
Descriptions are on records CRSE_ATTR_TBL and CRSE_ATTR_VALUE.

Related Tables: ACAD_CALTRM_TBL  CLASS_TBL  CRSE_ATTR_TBL  CRSE_ATTR_VALUE  CRSE_ATTRIBUTES  CRSE_CATALOG  CRSE_OFFER 



For updates, corrections or questions Email Stephen Forrest.