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

Field Information for EFF_STATUS:

Field: EFF_STATUS

Field Name: EFF_STATUS

Relevant Tables:

Table	Field Name	Field Descr
ACAD_GROUP_TBL	EFF_STATUS	Active or inactive as of effective date
ACAD_ORG_TBL	EFF_STATUS	Active or inactive as of effective date
ACAD_PLAN_TBL	EFF_STATUS	Active or inactive as of effective date
ACAD_PROG_TBL	EFF_STATUS	Active or inactive as of effective date
ACAD_SUBPLN_TBL	EFF_STATUS	Active or inactive as of effective date
ADDRESSES	EFF_STATUS	Active or inactive as of effective date
CRSE_CATALOG	EFF_STATUS	Active or inactive as of effective date
DEGREE_TBL	EFF_STATUS	Active or inactive as of effective date
EXT_ORG_TBL	EFF_STATUS	Active or inactive as of effective date
FACILITY_TBL	EFF_STATUS	Active or inactive as of effective date
INSTR_ADVISOR	EFF_STATUS	Active or inactive as of effective date
REL_PREF_TBL	EFF_STATUS	Active or inactive as of effective date
RELATIONSHIPS	EFF_STATUS	Active or inactive as of effective date
SCC_NAMES_QVW	EFF_STATUS	Active or inactive as of effective date
STDNT_GROUP_TBL	EFF_STATUS	Active or inactive as of effective date
STDNT_GRPS_HIST	EFF_STATUS	Active or inactive as of effective date

For updates, corrections or questions Email Stephen Forrest.