Updates to Three DS_ Tables

On October 24, 2012, The following changes in the Data Warehouse (EPM) will affect several DS_ tables:

1a) DS_ZIP_CODE_INFO - the table structure is changing, because ASU is purchasing the data from a new vendor. This change may affect applications that use it. The table is also moving, from SYSADM to ASUDW schema. After the change, queries should be directed to ASUDW.DS_ZIP_CODE_INFO. The data and structure is described at http://www.zip-codes.com/files/documents/ZipCodeDatabaseSpecifications-B.... The physical table definition is in the following google doc: https://docs.google.com/a/asu.edu/document/d/1QsJHRbIpFi-rgKmnaMrScDTNAJ....

1b) DS_ZIP_CODE_INFO_FULL – this table has the same data as DS_ZIP_CODE_INFO, but has even more rows. The _FULL table supports multiple rows for a given zip code, because zip codes can be associated to multiple cities. By contrast, DS_ZIP_CODE_INFO has only one row (the ‘primary’ one) per zip code.

2) DS_IP_TO_LOCATION: the ZIPCODE column will be increased, from 5 to 10 characters.

3) DS_APPS_ADMITS_SNP_DAY_SUM: this table will be dropped, as it is not used for the original intended purpose and no longer appears to be needed.

Email datawarehouse@asu.edu with questions or concerns about this change or its timeline.

For details see http://uto.asu.edu/node/7673.

If you experience difficulties as a result of this change, please call the ASU Help Desk at 480.965.6500.

PeopleSoft 9 Upgrade

Looking for information about the PeopleSoft 9 upgrade?  Please visit the upgrade page at http://peoplesoft.asu.edu/

New Report! "Job Data Report" replaces "Employee Job Data by Dept"

The newly available "Job Data Report" can be used to identify active employees and their current job information.

This report replaces the "Employee Job Data by Dept", which has been retired. Please replace any existing copies of the retired report in your personal folder with this new report.