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

Table: STUDY_FIELD_TBL - Field of Study Table

Short Description: Setup table Academic Departments

Long Description: Study Field (department) is attached to subjects and academic plans, separate from academic organization tree and program/plan structure.

Useful Fields:

Field Name	Field Descr
STUDY_FIELD	Study Field code
EFFDT	Date the data or action takes effect
DESCR	Department description
DESCRFORMAL	Department description (100 characters)

Criteria Notes:

Each value for STUDY_FIELD begins with an ACAD_GROUP value followed by a dash. You can use the dash in an expression to parse out the ACAD_GROUP code and join to ACAD_GROUP_TBL to get the school.

Example: ACAD_GROUP code = SUBSTR(A.STUDY_FIELD, 1, INSTR(A.STUDY_FIELD, '-') - 1)

Related Tables: ACAD_ORG_TBL  ACAD_PLAN_TBL  SUBECT_TBL  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.