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

Table: ACAD_SUBPLAN - Student Academic Subplan Table

Short Description: Students and their Academic Sub Plans

Long Description: Lists Subplans for Students. Not all Acad Plans have Subplans. Defaults to current date, but does have history. You would begin with ACAD_PROG, join to ACAD_PLAN, and then join to ACAD_SUBPLAN.

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
ACAD_CAREER	Code for Academic Career. Value attached to the student.
STDNT_CAR_NBR	Career Number assigned to Academic Program
EFFDT	Date the data or action takes effect
EFFSEQ	Sequence for actions with the same Effective Date
ACAD_PLAN	Code for Academic Plan, or Major/Minor
ACAD_SUB_PLAN	Code for Academic Sub Plan

Criteria Notes:

Join from ACAD_PLAN to get ACAD_SUB_PLAN. Not all Plans have Subplans.

Related Tables: ACAD_PLAN  ACAD_SUBPLN_TBL  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.