...
- 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 |
---|
Expressions:
Few 'Expressions' have been added such as to find 'Ethnicity' which has described the student ethnic background. 'USA' has described the students visa status other than USA. 'A' has been used to define active student group through student hist group.
':3' has been used to retrieve prior history (Prior Term) of active student through STDNT_CAR_TERM.
Prompt:
Institution, Term Term for Current and Prior have been mandatory for an user to input and Career, ACAD_PLAN are optional to extract more precise in order to retrieve data.
Criteria:
ACAD_PROG_STATUS is 'AC' because the report is based on active students. There is a subquery based on 'RESIDENCY_OFF The subquery include ' CU_STDNTGRP_VW' record because we would like to have current residency information. Create join with ACAD_PLAN with ACAD_SUB_PLAN to define the major concentrationaccording 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:
...