...
The query for Student Enrollment CU_BAR_SR_00085 has not been shared with Warren but not Mike and Patrick. The query is working fine.
...
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 IndicatorsREGENTS' math test score.
TEST_ID and TEST_COMPONENT have been used as left outer join in different manner to find 'SMA3' and 'RGNTS'.
Prompt:
Institution, Career, Term From and Term To have been mandatory for an user to input and Degree, ACAD_PROG, ACAD_PLAN are optional to extract more precise to retrieve data.
Criteria:
ACAD_PROG_STATUS CAREER is 'ACUGRD' because the report is based on active undergradute 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. PROG_ACTION is 'MATR' matriculated to find current enrollment of a given semester.
AND B.EMPLID = G.EMPLID (+)
AND ( G.TEST_ID (+) = 'RGNTS'
AND G.TEST_COMPONENT (+) IN ('SMA3','MATHB')) ))
The left outer join has been defined differently to pull Regents with other math courses such as ('090828','093130','093135','093157','093160') .
Query Prompt:
Query Output Image:
...