The page in progress
Background
The admission has requested us to modify some of their queries and create some new queries to serve their purpose for new applicant for Baruch College (CUNY). Attached is the documentation that has provided by admission, please see below:
Math Placements: CU_BAR_AD-00006A_1 and CUN_BAR_AD_00006B_2 following issues need to be addressed:
- Remove duplication
- should return most recent record
- Student who passed 'ACT-MATH-2' doesn't need to correspond 'ACT-MATH-1'. Therefore, exclude 'ACT-MATH-1' from criteria.
For a query detail please see the link CU_BAR_AD_00006A_1 and CU_BAR_AD_00006B_2
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.