Student Warehouse changes
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.
Below are two changes related to the Admissions fact data warehouse tables. Please contact firstname.lastname@example.org 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 email@example.com.
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
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.