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

Table: SCC_PERS_NI_QVW - Person National ID Query View

Short Description: Social Security Number

Long Description: Social Security Number

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
COUNTRY	Country
NATIONAL_ID	Social Security Number

Criteria Notes:

Set the country equal to USA to pull social security number

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