...
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) |
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' ':3' has been used to define active student group through student hist group. 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.
The image of CU_BAR_SR_00078_1:
...