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

Table: SCC_CITIZEN_QVW - Citizenship Query View

Short Description: Citizenship status for persons

Long Description: Shows citizenship status (coded) for both USA and other countries.

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
COUNTRY	Country that corresponds with citizenship status code
CITIZENSHIP_STATUS	Code that represents citizenship status

Criteria Notes:

U_CC_PDATA_TBL has fields for USA citizenship, and citizenship country

Join to this table for a person's Citizenship Status. To pull status within USA: COUNTRY = USA

Should join to this table by EMPLID, if COUNTRY = COUNTRY is added then remove this criteria.

The parent record (CITIZENSHIP) has HR row level security attached, do not use in query.

Related Tables: CITIZEN_STS_TBL  U_CC_PDATA_TBL  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.