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.

Fall 2012 Admissions query now available

The UGA MASTER LIST FALL 2012 is now available in MyReports and is located in the STUDENT – ADMISSIONS FOLDER.

Spring will be available soon.

The “huge” set of queries will be run by UGA every day or so. You need only open and find your relevant table and export. New elements will be added as requests come in.

NOTE: An administrative decision was made that while your denied and withdrawn population will be included in order to provide a complete picture of your recruitment cycle efforts, contact information for these populations has been stripped out to prevent any accidental communication efforts.

Field definitions used in this Master List can be found at: UGA Master List Field Definitions.