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

Table: STATE_TBL - States

Short Description: Setup table for states

Long Description: Has state names

Useful Fields:

Field Name	Field Descr
COUNTRY	Country code
STATE	State code
DESCR	State name

Criteria Notes:

Join by STATE and COUNTRY (or set COUNTRY = 'USA') for the state name.

Related Tables: ADDRESSES  U_CC_PDATA_TBL 

For updates, corrections or questions Email Stephen Forrest.