...
Records | Description of fields | ||
|---|---|---|---|
| ACADSTDNT_CAR_PROGTERM | EMPLID, ADMIT TERMSTERM, ACAD_CAREER, ACAD_PROG, | ||
| ACADNAME_PLAN | ACAD_PLAN,PLAN_SEQ, | ||
| ADM_APPL_DATA | ADMIT_TYPE | ||
| CU_BOI_CURR_VW | LAST_NAME, FIRST_NAME, MIDDLE_NAME, PHONE, EMAIL_ADDR | SERV_IND_DATA | SRVC_IND_CD for 'APS' and 'ACP' and have used for their reason codes|
| SCC_PERS_NI_QVW | NATIONAL_ID_TYPE, NATIONAL_ID | ||
| PERSNL_FERPA_VW | BIRTHDATE | ||
Subquery for A.STRM - Term | |||
| STDNT_CAR_TERM | ACADEMIC LEVEL,UNT_TAKEN_PRGRSS,TOT_CUM,TOT_PASSED_GPA, CUM_GPA | ||
| ACAD_PLAN_TBL | DESCR, DEGREE, SSR_NSC_CRD_LVL(DEG LEVEL) | ||
| ACAD_SUBPLAN | ACAD_SUB_PLAN | ||
| max (G.STRM) | |||
| UNION | |||
| STDNT_CAR_TERM | EMPLID, ACAD_CAREER, STRM | ||
| NAME_CURR_VW | LAST_NAME, FIRST_NAME | ||
| EXTERNAL_SYSTEM | EXTERNAL_SYSTEM, EXTERNAL_SYSTEM_ID | ||
| PERSNL_FERPA_VW | BIRTHDATE | ||
Subquery for exists | |||
| SCC_PERS_NI_QVW | EMPLID | ||
Subquery for E.STRM - Term | |||
| STDNT_CAR_TERM | max (D.STRM) |
Legend of Query:
Expressions:
Few 'Expressions' have been added to find 'Academic Level' have described the prompt as null and define the value of 'ACP' and 'APS'. Reference for Service Indicator: Service IndicatorsMaximum term' which pick up the latest update about students such as 'max (G.STRM)','max (D.STRM)' . 'SUBSTR(C.NATIONAL_ID,6,4)', 'SUBSTR(I.NATIONAL_ID,1,1)' have been used to mask national id.
Prompt:
Institution, Career, From Enroll Term and To Enroll Term have been mandatory for an user to input and Degree, ACAD_PROG, ACAD_PLAN are optional to extract more precise data.
Criteria:
ACAD_PROG_STATUS is 'AC' because the report is based on active students. Added 2 service indicator records to define 'APS' and 'ACP' with their reason code. Create join with ACAD_PLAN with ACAD_SUB_PLAN to define the major concentration.
...