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

Table: CRSE_OFFER - Course Catalog Offerings

Short Description: Setup table for courses.

Long Description: Data that can change over time for a course, and so it is on a separate table. 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
CRSE_OFFER_NBR	Course Offer Number
ACAD_GROUP	Code for Academic Group, or School
SUBJECT	Subject
CATALOG_NBR	Class Catalog Number
ACAD_ORG	Code for Academic Organization, or Department, used in Acad Org tree.
ACAD_CAREER	Academic Career of the course.

Criteria Notes:

When pulling catalog data the standard is to set effective date 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

Where you can find subject and catalog numbers for transfer and test credit. Typically pull current date, can also use the term begin date for the articulation term

Related Tables: CLASS_ATTRIBUTE  CLASS_TBL  CRSE_ATTR_TBL  CRSE_ATTR_VALUE  CRSE_ATTRIBUTES  CRSE_CATALOG  TRNS_CRSE_DTL  TRNS_TEST_DTL  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.