...
- Last Name
- First Name
- Middle Name
- Empl Id
- 1st Plan
- Sub-plan
- 2nd Plan
- Career
- Admit Term
- Term Credits Taken
- Total Taken Credits
- Total Passed Credits
- Cum GPA
- Prior Term GPA
- Gender
...
ACAD_PROG | EMPLID, ADMIT TERM,ACAD_CAREER |
ACAD_PLAN | 1ST ACAD_PLAN |
CU_BIO_VW | LAST_NAME, FIRST_NAME, MIDDLE_NAME |
STDNT_CAR_TERM | UNT_TAKEN_PRGRSS, TOT_TAKEN_PRGRSS, TOT_PASSD_PRGRSS, CUM_GPA |
ACAD_PLAN | 2ND ACAD_PLAN |
STDNT_CAR_TERM | CUR_GPA |
SF_STDNT_PRS_VW | SEX - Gender |
ACAD_SUBPLAN | ACAD_SUB_PLAN (it's not showing into the report but it's depends as per their request) |
Records | Description of fields |
---|
...
ACAD_PROG_STATUS is 'AC' because the report is based on active students. The subquery include ' CU_STDNTGRP_VW' record because according to the requirement we need to exclude international executive student group from the report. Exclude B.ACAD_PLAN NOT IN ('IOP-MS','FINENGR-MS','HCA-MBA','ILR-MS'). Added sub plan with plan in order to find 'MGTEXE-MBA' students. Created sub query with Does not Exist to filter 'MGTEXE-MBA' group. 'Gender' field also newly added to the query.
The image of CU_BAR_SR_00078_1:
...