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

Table: SCC_PER_EFF_QVW - Eff Dated Person Data Query Vw

Short Description: Marital Status and Gender

Long Description: Personal data that can change over time, and so it is effective dated.

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
EFFDT	Date the data or action takes effect
MAR_STATUS	Marital Status
MAR_STATUS_DT	Date of marital status
SEX	Gender

Criteria Notes:

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