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

Table: CRSE_ATTR_VALUE - Course Attribute Value Tbl
Short Description: Description for CRSE_ATTR_VALUE codes

Long Description: Course attribute values setup data. Course attribute value defines the specific attribute that has been attached to course or class section. UC "tags" are setup at course attributes.

Useful Fields:
Field NameField Descr
CRSE_ATTRCourse Attribute (parent to course attribute value)
EFFDTDate the data or action takes effect
CRSE_ATTR_VALUECourse Attribute Value (child of course attribute)
DESCRCourse Attribute Value description
DESCRFORMALCourse Attribute Value description (100 characters)

Criteria Notes:
Join from CRSE_ATTRIBUTES or CLASS_ATTRIBUTE

Related Tables: CLASS_ATTRIBUTE  CRSE_ATTR_TBL  CRSE_ATTRIBUTES  CRSE_CATALOG  CRSE_OFFER 



For updates, corrections or questions Email Stephen Forrest.