Query Power Users

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
Field Information for ACCOUNT_NBR:

Field: ACCOUNT_NBR
Field Name: ACCOUNT_NBR

Relevant Tables:
TableField NameField Descr
ACCOUNT_SFACCOUNT_NBRAccount Number differentiates between tuition/fees, misc, and payment plan accounts
ITEM_LINE_SFACCOUNT_NBRAccount Number differentiates between tuition/fees, misc, and payment plan accounts
ITEM_LNDDT_VWACCOUNT_NBRAccount Number differentiates between tuition/fees, misc, and payment plan accounts
ITEM_SFACCOUNT_NBRAccount Number differentiates between tuition/fees, misc, and payment plan accounts




For updates, corrections or questions Email Stephen Forrest.