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

Table: REL_PREF_TBL - Religious Preference Table

Short Description: Setup table for Religious Preference codes

Long Description: Join to this table from RELIGIOUS_PREF for the Religious Preference code description.

Useful Fields:

Field Name	Field Descr
RELIGIOUS_PREF	Code for Religious Preference
EFFDT	Date the data or action takes effect
EFF_STATUS	Active or inactive as of effective date
DESCR	Religious Preference description

Criteria Notes:

Join to this table for RELIGIOUS_PREF description.

Not all students select a reglisous preference. Outer join not to lose anyone.

Related Tables: RELIGIOUS_PREF  U_CC_PDATA_TBL 

For updates, corrections or questions Email Stephen Forrest.