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

Table: SCC_PERS_PH_QVW - Phone Numbers Query View

Short Description: Phone numbers

Long Description: Phone numbers

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
PHONE_TYPE	Phone Type (home, mail, etc.)
COUNTRY_CODE	Country Code
PHONE	Phone number
PREF_PHONE_FLAG	Flag to denote if a phone number is the preferred number to call

Criteria Notes:

Use field PREF_PHONE_FLAG to select a person preferred phone number

NOTE: This is data is not effective dated, nor is there a status field.

The parent record (PERSONAL_PHONE) 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.