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

Table: U_SR_CENSUS_TRM - SR Census Data Capture - Term

Short Description: Census version of STDNT_CAR_TERM

Long Description: Data captured from STDNT_CAR_TERM and U_CC_PDATA_TBL. Student term data.

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
ACAD_CAREER	Code for Academic Career. Value attached to the student.
STRM	Term
U_SR_CAPTURE_CODE	Census Capture Code
REG_CARD_DATE	Date of first enrollment action for a term (set by tuition process)
WITHDRAW_CODE	Not Withdrawn, Withdrawn, or Cancelled
WITHDRAW_DATE	Date withdrawn or Cancelled
ACAD_PROG_PRIMARY	Student's Primary Academic Program
ACADEMIC_LOAD	Based on hours, full-time, half-time, etc.
ACAD_LEVEL_BOT	Academic Level, or Classification, and beginning of a term
UNT_TAKEN_PRGRSS	Term SMU hours taken
REGISTERED	Registered flag (set by tuition process)
SEX	Gender
RELIGIOUS_PREF	Code for Religious Preference
U_CC_ETHNIC_REPORT	Ethnicity
U_CC_CNTRY_OF_CITZ	Country of Citizenship
U_CC_USA_CIT_STATS	USA Citizenship Status

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: ACAD_CALTRM_TBL  U_SR_CEN_CLASS  U_SR_CEN_PROG  U_SR_CENCAP_TBL  U_SR_CENSUS_CLS  U_SR_CENSUS_TRN  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.