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

Table: ACAD_DEGR_SPLN - Student Degree Sub-Plan Table

Short Description: Students and awarded Subplans

Long Description: Lists the Acad Subplans awarded with a Degree. Begin with ACAD_DEGR, then join to ACAD_DEGR_PLAN, and then to ACAD_DEGR_SUBPLAN. Not every awarded Plan has a Subplan.

Useful Fields:

Field Name	Field Descr
EMPLID	Student/Person ID number
STDNT_DEGR	Number for a student's Degree Awarded (01, 02, etc.)
ACAD_PLAN	Code for Academic Plan, or Major/Minor
ACAD_SUB_PLAN	Code for Academic Sub Plan

Criteria Notes:

Begin with ACAD_DEGR when pulling degrees awarded, and then go to ACAD_DEGR_PLAN prior to joining to this table.

Not all Acad Plans have subplans, so you would want to outer join if you want all plans.

Related Tables: ACAD_DEGR_PLAN  ACAD_SUBPLN_TBL  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.