Data Warehouse Enhancements and Changes - December 2013

Student Warehouse changes
Summary:
SDSP: The logic for SDSP (Sun Devil Success Program) fields is being enhanced to use a cross reference table to determine which student group(s) are associated to this program. This change also enables these fields to start populating for 2147 and beyond. Jira case(s): AD-349, AD-626

Note: the logic changes will be migrated to production on Monday evening 12/9/13; the logic will first be applied - and therefore visible in ASU_ADM_APPLICATION - on Tuesday morning when the DW load runs during its normal time, which is typically before 7am.

Table:
ASU_ADM_APPLICATION

Affected fields:
GRE_VERB
GRE_QUANT
GRE_ANLY_WRITING
GRE_VERB_PERCENTILE
GRE_QUANT_PERCENTILE
GRE_ANLY_WRITING_PERCENTILE
SDSP_FLG
SDSP_DT


Summary:
Below are two changes related to the Admissions fact data warehouse tables. Please contact datawarehouse@asu.edu with questions or concerns about these changes.

The obsolete Admissions Fact table (ASU_A_ADM, a.k.a. PS_ASU_A_ADM) is being deprecated using a phased approach:

As planned, as of December 31, 2013, we will stop refreshing this table. The table will still be available for queries for a period of time, but the data will no longer be updated. The data warehouse team invites feedback at datawarehouse@asu.edu.

After approximately two months (early March 2014), the table will be renamed, and general queries will no longer have access to it. By that time, queries that need up-to-date admissions information should have been adjusted to use the new Admissions Fact tables (ASU_ADM_APPLICATION, ASU_ADM_APPLICANT, ASU_ADM_INTL_STUDENT and ASU_ADM_APP_FIRST_AD_SNP) or other tables/views as needed. 
Jira case(s): AD-589


Summary:
These changes are related to logic only: there are no database schema changes.

GMAT: The logic to calculate GMAT scores in ASU_ADM_APPLICATION is being adjusted, to 1) use PS_STDNT_TEST_COMP rather than PS_ADM_APPL_MATLS, b) find each maximum test score per student per test component type, and 3) limit to tests taken within 5 years of the application date. This change applies to 2141 cohort term forward. This change mimics the change made to GRE score logic that went into Production on 12/10/13. Jira case(s): AD-638

Note: the logic changes will be migrated to production on Tuesday 12/31/13; the logic will first be applied - and therefore visible in ASU_ADM_APPLICATION - on Wednesday morning when the DW load runs during its normal time, which is typically before 7am.

Table:
ASU_ADM_APPLICATION

Affected fields:
GMAT_TOT
GMAT_PERCENTILE