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

Field: EFFDT

Field Name: EFFDT

Relevant Tables:

Table	Field Name	Field Descr
ACAD_GROUP_TBL	EFFDT	Date the data or action takes effect
ACAD_ORG_TBL	EFFDT	Date the data or action takes effect
ACAD_PLAN	EFFDT	Date the data or action takes effect
ACAD_PLAN_OWNER	EFFDT	Date the data or action takes effect
ACAD_PLAN_TBL	EFFDT	Date the data or action takes effect
ACAD_PROG	EFFDT	Date the data or action takes effect
ACAD_PROG_TBL	EFFDT	Date the data or action takes effect
ACAD_STDNG_ACTN	EFFDT	Date the data or action takes effect
ACAD_SUBPLAN	EFFDT	Date the data or action takes effect
ACAD_SUBPLN_TBL	EFFDT	Date the data or action takes effect
ADDRESSES	EFFDT	Date the data or action takes effect
ADM_INTERESTS	EFFDT	Date the data or action takes effect
ADM_MC_VW	EFFDT	Date the data or action takes effect
BLDG_TBL	EFFDT	Date the data or action takes effect
CRSE_ATTR_TBL	EFFDT	Date the data or action takes effect
CRSE_ATTR_VALUE	EFFDT	Date the data or action takes effect
CRSE_ATTRIBUTES	EFFDT	Date the data or action takes effect
CRSE_CATALOG	EFFDT	Date the data or action takes effect
CRSE_OFFER	EFFDT	Date the data or action takes effect
DEGR_HONORS_TBL	EFFDT	Date the data or action takes effect
DEGREE_TBL	EFFDT	Date the data or action takes effect
EXT_ORG_SCHL_VW	EFFDT	Date the data or action takes effect
EXT_ORG_TBL	EFFDT	Date the data or action takes effect
EXT_ORG_TBL_ADM	EFFDT	Date the data or action takes effect
EXT_SUBJECT_TBL	EFFDT	Date the data or action takes effect
FACILITY_TBL	EFFDT	Date the data or action takes effect
INSTR_ADVISOR	EFFDT	Date the data or action takes effect
ISIR_CONTROL	EFFDT	Date the data or action takes effect
ISIR_PARENT	EFFDT	Date the data or action takes effect
ISIR_STUDENT	EFFDT	Date the data or action takes effect
ITEM_TYPE_FA	EFFDT	Date the data or action takes effect
ITEM_TYPE_TBL	EFFDT	Date the data or action takes effect
PROG_ACTION_TBL	EFFDT	Date the data or action takes effect
PROG_RSN_TBL	EFFDT	Date the data or action takes effect
REL_PREF_TBL	EFFDT	Date the data or action takes effect
RELATIONSHIPS	EFFDT	Date the data or action takes effect
SCC_NAMES_QVW	EFFDT	Date the data or action takes effect
SCC_PER_EFF_QVW	EFFDT	Date the data or action takes effect
SCC_VISA_P_QVW	EFFDT	Date the data or action takes effect
SERVICE_IMPACT	EFFDT	Date the data or action takes effect
SRVC_IMPACT_TBL	EFFDT	Date the data or action takes effect
SRVC_IN_RSN_TBL	EFFDT	Date the data or action takes effect
SRVC_IND_CD_TBL	EFFDT	Date the data or action takes effect
STDNT_ADVR_HIST	EFFDT	Date the data or action takes effect
STDNT_GROUP_TBL	EFFDT	Date the data or action takes effect
STDNT_GRPS_HIST	EFFDT	Date the data or action takes effect
STUDY_FIELD_TBL	EFFDT	Date the data or action takes effect
U_SA_AUTH_AREA	EFFDT	Date the data or action takes effect
U_SR_ACADPG_TBL	EFFDT	Date the data or action takes effect
U_SR_HONORS_TBL	EFFDT	Date the data or action takes effect
XLATTABLE_VW	EFFDT	Date the data or action takes effect

For updates, corrections or questions Email Stephen Forrest.