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

Table: U_SR_CENSUS_TRN - SR Census Data Capture - Trans

Short Description: Transfer student reporting values

Long Description: Categories for the transfer retention and graduation report

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
U_SR_CAPTURE_CODE	Census Capture Code
STDNT_GROUP	Code for Transfer Cohort Student Group
U_SR_TRN_HRS_GRP	Transfer Hours grouping
U_SR_TRN_GPA_GRP	Transfer GPA grouping
U_SR_TRN_INST_GRP	Transfer Previous School Count grouping
U_SR_TRN_TYPE_GRP	Transfer School Type grouping

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

For updates, corrections or questions Email Stephen Forrest.