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

Table: SCC_NAMES_QVW - Person Names Query View

Short Description: Names

Long Description: All name types for a person

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
NAME_TYPE	Name Type (primary, preferred, etc.)
EFFDT	Date the data or action takes effect
EFF_STATUS	Active or inactive as of effective date
NAME	Full Name
LAST_NAME	Last Name
FIRST_NAME	First Name
MIDDLE_NAME	Middle Name
NAME_PREFIX	Name Prefix
NAME_SUFFIX	Name Suffix

Criteria Notes:

PRI is the primary, or legal name. DEG is what prints on diplomas. PREF is preferred.

To pull PREF or DEG, then when not populated you must pull PRI instead. Use a not-in-list subquery with an OR statement preferred, OR not-in-list of those with preferred and pull PRI.

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

Related Tables: CLASS_INSTR  U_CC_PDATA_TBL 

For updates, corrections or questions Email Stephen Forrest.