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

Table: U_CC_PDATA_TBL - 8.9 Refresh PRDATA Table

Short Description: Bio/Demo data

Long Description: Contain names for students and parents. Also has HOME address and phone, MAIL address and phone, campus email, gender, religious preference, Ethnic Group, Age, USA Citizenship, and FERPA code.

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
NAME	Full Name
NAME_PREFIX	Name Prefix
LAST_NAME	Last Name
FIRST_NAME	First Name
MIDDLE_NAME	Middle Name
NAME_SUFFIX	Name Suffix
ADDRESS1	Home Addr1
ADDRESS2	Home Addr2
ADDRESS3	Home Addr3
ADDRESS4	Home Addr4
CITY	Home City
STATE	Home State
POSTAL	Home Postal
COUNTRY	Home country
COUNTY	County for home address
ADDRESS1_OTHER	Mail Addr1
ADDRESS2_OTHER	Mail Addr2
ADDRESS3_OTHER	Mail Addr3
ADDRESS4_OTHER	Mail Addr4
CITY_OTHER	Mail City
STATE_OTHER	Mail State
POSTAL_OTHER	Mail Postal
COUNTRY_OTHER	Mail address country
COUNTY_OTHER	County for mail address
PHONE	Home Phone
PHONE1	Mail Phone
SEX	Gender
RELIGIOUS_PREF	Code for Religious Preference
EMAIL_ADDR	Campus Email
AGE	Age
U_CC_ETHNIC_REPORT	Ethnicity
U_CC_USA_CIT_STATS	USA Citizenship
U_CC_CNTRY_OF_CITZ	Country of Citizenship
FERPA	FERPA (directory restriction)
DT_OF_DEATH	Date of Death
MAR_STATUS	Marital Status

Criteria Notes:

Join to this table from any table with EMPLID to pull Name, Address, and other bio/demo data.

Related Tables: ADDRESSES  ADDRESSES4_VW  CITIZEN_STS_TBL  CLASS_INSTR  COUNTRY_TBL  ETHNIC_GRP_TBL  ISIR_CONTROL  ISIR_PARENT  ISIR_STUDENT  REL_PREF_TBL  RELATIONSHIPS  RELIGIOUS_PREF  SCC_CITIZEN_QVW  SCC_DIV_ETH_QVW  SCC_EMAIL_QVW  SCC_EMERG_C_QVW  SCC_EMERG_P_QVW  SCC_NAMES_QVW  SCC_PER_EFF_QVW  SCC_PERS_NI_QVW  SCC_PERS_PH_QVW  SCC_PERS_SA_VW  SCC_VISA_P_QVW  SRVC_IND_DATA  STATE_TBL  STDNT_ADVR_HIST  STDNT_AWARDS  STDNT_AWRD_DISB  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.