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

Table: U_SR_CENCAP_TBL - SR Census Capture Setup Record

Short Description: Setup table for census data captures

Long Description: Setup table for census data captures

Useful Fields:

Field Name	Field Descr
STRM	Term
U_SR_CAPTURE_CODE	Census Capture Code
U_SR_CAPTURE_TYPE	Census Capture Type
U_SR_CAPTURE_DATE	Census Capture Date
DESCR	Census Capture description

Criteria Notes:

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

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

Related Tables: ACAD_CALTRM_TBL  U_SR_CEN_CLASS  U_SR_CEN_PROG  U_SR_CENSUS_CLS  U_SR_CENSUS_TRM  U_SR_CENSUS_TRN  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.