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

Table: ACAD_GROUP_TBL - Academic Group Table

Short Description: Setup table for Academic Group codes

Long Description: Contains setup data on Academic Groups, or Schools. Acad Plans belong to Acad Programs, and Acad Programs belong to Acad Groups. Acad Group is also attached to courses and classes. Use this table to see the description for an Acad Groups (schools).

Useful Fields:

Field Name	Field Descr
ACAD_GROUP	Code for Academic Group, or School
EFFDT	Date the data or action takes effect
EFF_STATUS	Active or inactive as of effective date
DESCR	Academic Group description
DESCRSHORT	Academic Group short description

Criteria Notes:

Join to this table from ACAD_PROG_TBL or CLASS_TBL for the School name.

Can also derive school from STUDY_FIELD. ACAD_GROUP code = SUBSTR(A.STUDY_FIELD, 1, INSTR(A.STUDY_FIELD, '-') - 1)

Related Tables: ACAD_PROG_TBL  CLASS_TBL 

For updates, corrections or questions Email Stephen Forrest.