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

Table: ACAD_DEGR_PLAN - Student Degree Plan Table

Short Description: Students and awarded Acad Plans

Long Description: Lists the Acad Plans awarded with a Degree. Begin with ACAD_DEGR and then join to ACAD_DEGR_PLAN.

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_CAREER	Code for Academic Career. Value attached to the student.
STDNT_CAR_NBR	Career Number assigned to Academic Program

Criteria Notes:

Join from ACAD_DEGR_PLAN to ACAD_PLAN_TBL by ACAD_PLAN. The beginning of STUDY_FIELD will be the ACAD_GROUP code. Join to ACAD_GROUP_TBL by: SUBSTR(A.STUDY_FIELD, 1, I

The beginning of STUDY_FIELD will be the ACAD_GROUP code. Join to ACAD_GROUP_TBL by: SUBSTR(A.STUDY_FIELD, 1, INSTR(A.STUDY_FIELD, '-') - 1)

Begin with ACAD_DEGR when pulling degrees awarded.

For Subplans awarded, join to ACAD_DEG_SPLN by EMPLID, STDNT_DEGR, and ACAD_PLAN.

To exclude minors set ACAD_PLAN not like %MN.

School is not attached to Degrees Awarded, but is available through Academic Structure.

Related Tables: ACAD_DEGR  ACAD_DEGR_HONS  ACAD_DEGR_SPLN  ACAD_PLAN_OWNER  ACAD_PLAN_TBL  XLATTABLE_VW 

For updates, corrections or questions Email Stephen Forrest.