Changed Table: Vendor

Financial Warehouse
 
VENDOR table has been replaced by VENDOR_TBL in the Financial Data Warehouse.

Here is what you need to do to modify your query:

1. Change VENDOR table to VENDOR_TBL table in your existing query.
2. If you also join VENDOR table in your existing query, you will need to change the link to Left join instead full join in your query.

We have created another help article (http://help.asu.edu/sims/selfhelp/SelfhelpKbView.seam?parature_id=8373-8193-7884) for instructions on how to change a table name.

If you have any further questions regarding the new Vendor table, please contact the Advantage Helpline at advantage-q@asu.edu.  If you need assistance in modifying your existing query, please contact the BI Reporting team at myreports@asu.edu.

Making Internet Explorer (IE) 10 Compatible

The interactive reporting format within our current Hyperion software version (11.1.1.3) is only officially compatible with Internet Explorer 8. However, certain modifications can possibly resolve this issue for Internet Explorer 10. If you are using Internet Explorer 10 (IE10) and already have the Hyperion plugin installed, the instructions on making IE10 compatible can be found at: https://asu.service-now.com/ess/kb_view.do?sysparm_article=KB0010086.

New or Changed Tables and Views

Student Records/Census

•  CS__DESCR_CENSUS_DATES - is now available for reporting in My Reports.  This table can be used by  to find out special term specific dates such as the 21st day and the 21st day of session B. This table is refreshed nightly from CENSUS on Enterprise1 (E1) on which Institutional Analysis maintains this information.

PS_ASU_D_PERSON_VW Enhancements

Changed Multi-Dimensional Warehouse (MDW) Tables/Views

Long-awaited enhancements to PS_ASU_D_PERSON_VW are now in production (PMPRD), as of 05/31/13. Thanks again to Marco for his development work on this!

Changes and improvements are:

• Query performance; it is faster 
•  New fields
• DECEASED_FLG
•  ASU_SIS_DIR_RL_FLG
•  RES_HALL_STATUS
•  RES_HALL_COMMUNITY
•  ETHNIC_GROUP_SD_LIST
•  ASU_CITZN_COUNTRY_LD
•  HOME_CNTRY_LD

 For more details see PS_ASU_D_PERSON_VW enhancements - May 2013) 

 

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.