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

Table: U_SR_CEN_CLASS - Term Class Census Data

Short Description: Census version of CLASS_TBL

Long Description: Data captured from CLASS_TBL. Subject, catalog number, course ID

Useful Fields:

Field Name	Field Descr
STRM	Term
CLASS_NBR	Class Number, a unique value within each term for a class section.
SUBJECT	Subject
CATALOG_NBR	Class Catalog Number
CLASS_SECTION	Class Section
DESCR	Class description (short title)
SESSION_CODE	Session Code, within a term
ACAD_CAREER	Academic Career of the class.
ACAD_GROUP	Code for Academic Group, or School
CRSE_ID	Course ID number
SSR_COMPONENT	Class Component (lecture, lab, etc.)
LOCATION	Location code of a class section

Criteria Notes:

When joining to other U_SR_CENSUS records, include U_SR_CAPTURE_CODE in the join

Capture codes that end in "4" are census captures. "1" and "2" are preliminary captures

Related Tables: CLASS_INSTR  U_SR_CEN_PROG  U_SR_CENCAP_TBL  U_SR_CENSUS_CLS  U_SR_CENSUS_TRM  U_SR_CENSUS_TRN  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.