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

Table: EXT_SUBJECT_TBL - External Subject Table

Short Description: Setup table for non-SMU subjects

Long Description: Subjects for other institutions, and admissions interest

Useful Fields:

Field Name	Field Descr
EXT_SUBJECT_AREA	Subject code from an external source
EFFDT	Date the data or action takes effect
DESCR	External Subject description

Criteria Notes:

Join from EXT_COURSE or from ADM_INTERESTS

Related Tables: ADM_INTERESTS  EXT_ACAD_DATA  EXT_ACAD_SUM  EXT_COURSE  EXT_ORG_SCHL_VW  EXT_ORG_TBL  EXT_ORG_TBL_ADM 

For updates, corrections or questions Email Stephen Forrest.