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

Table: CRSE_CATALOG - Course Catalog Data

Short Description: Setup table for courses.

Long Description: Many of the these setup values propagate to CLASS_TBL when a class schedule is created.

Useful Fields:

Field Name	Field Descr
CRSE_ID	Course ID number
EFFDT	Date the data or action takes effect
EFF_STATUS	Active or inactive as of effective date
DESCR	Course description (short)
UNITS_MINIMUM	Minimum Units (hours) for a course
UNITS_MAXIMUM	Maximum Units (hours) for a course
CRSE_REPEATABLE	Course Repeatable (Y or N)
COURSE_TITLE_LONG	Course Title
DESCRLONG	Course Description (very long)

Criteria Notes:

When pull catalog data the standard is to set effective date to Last Eff Date, pulling any future dated rows.

When joining from CLASS_TBL use a date to pull setup data as of that term. START_DT from CLASS_TBL, or TERM_BEGIN_DT from TERM_TBL

Field COURSE_TITLE_LONG is the course title

Field DESCRLONG is the long description, with any requisites listed at the end of the description.

When pulling DESCRLONG you cannot set select distinct, this is a character long field with no defined length.

Related Tables: CLASS_ATTRIBUTE  CLASS_TBL  CRSE_ATTR_TBL  CRSE_ATTR_VALUE  CRSE_ATTRIBUTES  CRSE_OFFER  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.