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. |