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

Table: SCC_EMERG_P_QVW - Emergency Cntct-Phone Quer Vw

Short Description: Emergency contacts phone

Long Description: Additional phones numbers for an emergency contact

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
CONTACT_NAME	Emergency contact name
PHONE	Phone number

Criteria Notes:

Outer join by EMPLID and CONTACT_NAME to get additional phone numbers for emergency contacts.

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

Related Tables: ACAD_PROG_TBL  SCC_EMERG_C_QVW  STDNT_CAR_TERM  U_CC_PDATA_TBL  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.