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

Table: SCC_EMAIL_QVW - Email Addresses Query View

Short Description: Email addresses

Long Description: Contains email addresses. History is not maintained on this table.

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
E_ADDR_TYPE	Address Type, HOME, MAIL, etc.
EMAIL_ADDR	Email address
PREF_EMAIL_FLAG	Preferred flag for email (should be type CAMP for students)

Criteria Notes:

Join to this table to pull email addresses.

E_ADDR_TYPE = CAMP for student email addresses.

U_CC_PDATA_TBL has SMU email address.

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

Related Tables: U_CC_PDATA_TBL 

For updates, corrections or questions Email Stephen Forrest.