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

Table: ACAD_SUBPLN_TBL - Academic Sub Plan Table

Short Description: Setup table for Academic Subplan codes

Long Description: Contains setup data on Acad Subplans. Subplans belong to Acad Plans, which in turn belong to Acad Prog and Acad Group.

Useful Fields:

Field Name	Field Descr
ACAD_PLAN	Code for Academic Plan, or Major/Minor
ACAD_SUB_PLAN	Code for Academic Sub Plan
EFFDT	Date the data or action takes effect
EFF_STATUS	Active or inactive as of effective date
ACAD_SUBPLAN_TYPE	Category for type of Sub Plan
DESCR	Academic Sub Plan description

Criteria Notes:

Join to this table from ACAD_SUB_PLAN for the Subplan description.

Related Tables: ACAD_DEGR_SPLN  ACAD_SUBPLAN  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.