Data Warehouse: Enhancements and Changes - November 2013

Financial Warehouse changes
Summary:
Because of data changes from the SunRise vendor, two new columns will be added to the SD_PO_DATA table.

Table:
SD_PO_DATA

New Columns:
GREEN_PRODUCT_DESCR
LEED_COMPLIANCE_DETAIL

 
Student Warehouse changes
Summary:
The Financial Aid view PS_ASU_FA_P_YR_VW is being changed in the Data Warehouse to accommodate changes made in the PeopleSoft source database

View:
PS_ASU_FA_P_YR_VW

Columns being removed:
ASU_FA_FAPROG

New Columns:
ASU_FA_FAFSA_DT

ASU_FA_PKG_DT_SUM
ASU_FA_TOT_LN_OFFR
ASU_FA_STD_LN_OFFR
ASU_FA_PRT_LN_OFFR
ASU_FA_NAMU_COHT
ASU_FA_NAMU_DT
ASU_FA_NAMU_AMT
ASU_FA_PROM_COHT
ASU_FA_PROM_DT
ASU_FA_PROM_AMT

Please contact datawarehouse@asu.edu with questions or concerns about these changes.