...
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' has been used to define active student group through student hist group.
Prompt:
...
Institution, Term have been mandatory for an user to input and Career, ACAD_PLAN are optional to extract more precise data.
Criteria:
...
ACAD_PROG_STATUS is 'AC' because the report is based on active students. There is a subquery based on 'RESIDENCY_OFF' record because we would like to have current residency information. Create join with ACAD_PLAN with ACAD_SUB_PLAN to define the major concentration.
...