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

Table: CLASS_TBL - Class Table

Short Description: Setup table for classes offered in a term

Long Description: Lists classes offered with term. Shows subject, catalog number, class description, number enrolled, Acad Group, and Acad Org

Useful Fields:

Field Name	Field Descr
CRSE_ID	Code for the Course ID
STRM	Code for Term
SESSION_CODE	Session Code, within a term (most useful in Summer)
CLASS_SECTION	Class Section
ACAD_GROUP	Code for Academic Group, or School
SUBJECT	Class subject
CATALOG_NBR	Class Catalog Number
ACAD_CAREER	Code for Academic Career. Value attached to the class.
DESCR	Class description
CLASS_NBR	Class Number, a unique value within each term for a class section.
SSR_COMPONENT	Category for class (lecture, lab, etc.)
ENRL_STAT	Status of class (open, closed, etc.)
CLASS_STAT	Class Enrollment Status, open, closed, etc.
CLASS_TYPE	Class Type (graded, not graded)
ENRL_CAP	Enroll capacity for a class section
WAIT_CAP	Wait List Capacity for a class
MIN_ENRL	Minimum enrollment required for a class
ENRL_TOT	Total enrollment in a class section
WAIT_TOT	Student count on wait list for class
ACAD_ORG	Code for Academic Organization, or Department, used in Acad Org tree.
LOCATION	Location code for class
END_DT	Class end date
START_DT	Class start date
COMBINED_SECTION	Flag denoting if the section is combined with another

Criteria Notes:

Join to this table from STDNT_ENRL to bring in Subject, Catalog Number, and Class Section.

This table also has the ACAD_GROUP and the ACAD_ORG for the class.

You need only join by STRM and CLASS_NBR (SESSION_CODE is optional), if the automatic join includes EMPLID then it will pull no data.

To pull classes that count as full-time status: SSR_COMPONENT in list FTS,INT,COP

Beginning Spring 2015 LOCATION as populated to CLASS_TBL was refined. Expected values:

ABROAD

MAIN

MAINWTRVL (regularly meets on campus, has a travel component that will be a separate meeting pattern)

OFFSITE (within Texas)

OUTOFSTATE (a specific facility in another state)

PLANO

TAOS

STDNTSPEC (wherever the student is, for online, distance, internships, etc., student location is based on OFFC address or HOME address.)

Related Tables: ACAD_CALTRM_TBL  ACAD_GROUP_TBL  ACAD_ORG_TBL  CLASS_ATTRIBUTE  CLASS_INSTR  CLASS_MTG_PAT  CRSE_CATALOG  CRSE_OFFER  ENRL_REQ_DETAIL  GRADE_ROSTER  GRADE_RSTR_TYPE  STDNT_ENRL  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.