...
Final Report Delivery with requirements:
---------
...
Query Development:
Following table shows all necessary records that have been used to generate fields as requested by an user to create this report.
Records | Description of fields |
---|---|
ADM_MC_VW | EMPLID, ADMIT TYPE |
CU_BOI_VW | LAST_NAME, FIRST_NAME, MIDDLE_NAME, PHONE, EMAIL_ADDR |
SCC_PERS_NI_QVW | SSN |
STDNT_TEST_COMP | TEST ID, TEST DT, DATA SRCE, TOTAL SCORE, SG |
SUB-QUEREIES: |
...
STDNT_TEST_COMP | max (J.TEST_DT) |
STDNT_GRPS_HIST | B.EMPLID - Empl ID (DOESN'T EXIST sg ('M1','M2'), NTMT, S100 ) |
STDNT_TEST_COMP | BLANK (DOESN'T EXIST 'SMA3','MATHB' test component) |
STDNT_TEST_COMP | |
STDNT_TEST_COMP | |
STDNT_TEST_COMP | |
STDNT_TEST_COMP |
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
Prompt:
Institution, Career, 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.
...