Background:
Stephanie Govan already uses CU_BAR_SR_00045_1. She is requesting some additional data in the report. Based on the additional data, some of which is undergraduate or graduate specific, it might make sense to split out the query based on career.
Final Report Delivery with requirements:
CU_BAR_SR_00080 00045_3 Prompts are below:
- Institution: Bar01
- Career: UGRD
- Term: pick any term
- Degree: (optional) ( pick any degree)
- AcadProg (optional) If you want to be more specific
- AcadPlan (optional) If you want to be more specific
...
Records | Description of fields | ||
|---|---|---|---|
| ACAD_PROG | EMPLID, ADMIT TERM,ACAD_CAREER, ACAD_PROG, | ||
| ACAD_PLAN | ACAD_PLAN,PLAN_SEQ, | ||
| ADM_APPL_DATA | ADMIT_TYPE | ||
| CU_BOI_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 |
| STDNT_CAR_TERM | ACADEMIC ACADEMIC LEVEL,UNT_TAKEN_PRGRSS,TOT_CUM,TOT_PASSED_GPA, CUM_GPA | ||
| ACAD_PLAN_TBL | DESCR, DEGREE, SSR_NSC_CRD_LVL(DEG LEVEL) | ||
| SERV_IND_DATA | SRVC_IND_CD for 'APS' have used it with reason code | ||
| SERV_IND_DATA | SRVC_IND_CD for 'ACP' have used it with reason code | ||
| ACAD_SUBPLAN | DESCR, DEGREE, SSR_NSC_CRD_LVL(DEG LEVEL) | ||
| ACAD_PLAN | ACAD_PLAN | ||
| ACAD_SUBPLAN | ACAD_SUB_PLAN | ||
| STNDT_GRPS | Student Group (SG) |
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 Indicators
...