Monday, July 7, 2014

Data Warehouse Enhancements and Changes - July 3, 2014

The following staging tables have been added/changed in the Enterprise Data Warehouse (PMPRD):

Changed Tables:
PS_ASU_AD0107_PYMT - Jira DW-404: add columns and change primary key to match source system (CSPRD)
PS_ASU_ADM_SA_TBL - Jira DW-345: add ASU_CLASSROOM_LCTN
PS_ASU_AA_POS - Jira DW-345: add fields ASU_ADS_SPECIALZ & ASU_CLASSROOM_LCTN


For information about how to update your existing reports to reflect these table changes, please see article https://asu.service-now.com/kb_view.do?sysparm_article=KB0011284.

New Tables:
PS_CMNT_CATG_TBL - Jira DW-331
PS_ASU_GRAD_CHG - Jira DW-350
PS_ASU_AD0138_TRK - Jira DW-470


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

Thank you,
UTO Data Warehouse team