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

Table: CRSE_ATTRIBUTES - Course Attribute Tbl

Short Description: Attributes attached to courses at the catalog level.

Long Description: Course attributes defined at the catalog level apply to all sections for a course, and propagates down to CLASS_ATTRIBUTE when the class schedule is created. UC "tags" are setup at course attributes.

Useful Fields:

Field Name	Field Descr
CRSE_ID	Course ID number
EFFDT	Date the data or action takes effect
CRSE_ATTR	Course Attribute (parent to course attribute value)
CRSE_ATTR_VALUE	Course Attribute Value (child of course attribute)

Criteria Notes:

Join from CLASS_TBL, CRSE_CATALOG, or CRSE_OFFER

Related Tables: CLASS_ATTRIBUTE  CRSE_ATTR_TBL  CRSE_ATTR_VALUE  CRSE_CATALOG  CRSE_OFFER 

For updates, corrections or questions Email Stephen Forrest.