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

Table: ETHNIC_GRP_TBL - Ethnic Group Table

Short Description: Descriptions for Ethnic Group Code

Long Description: Contains the descriptions for the ethnic group codes

Useful Fields:

Field Name	Field Descr
ETHNIC_GRP_CD	Code that represents ethnic group
DESCR50	Long Description for ethnic group code
DESCRSHORT	Short Description for ethnic group code

Criteria Notes:

To pull ethnic group code description, join to this table from SCC_DIV_ETH_QVW.

Ethnic reporting value is on U_CC_PDATA_TBL

Related Tables: SCC_DIV_ETH_QVW  U_CC_PDATA_TBL 

For updates, corrections or questions Email Stephen Forrest.