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

Table: CITIZEN_STS_TBL - Citizen Status Table

Short Description: Descriptions for citizenship status code

Long Description: Contains the descriptions for the citizenship status codes.

Useful Fields:

Field Name	Field Descr
COUNTRY	Country that corresponds with citizenship status code
CITIZENSHIP_STATUS	Code that represents citizenship status
DESCR	Description for a citizenship status code

Criteria Notes:

To pull citizenship status code Description, join to this table from SCC_CITIZEN_QVW or U_CC_PDATA_TBL, by COUNTRY and CITIZENSHIP_STATUS

Related Tables: SCC_CITIZEN_QVW  U_CC_PDATA_TBL 

For updates, corrections or questions Email Stephen Forrest.