Timestamp issue

As many of you know, myReports has occasionally been experiencing some unusual challenges in delivering your ASU warehouse data recently.

The May 23, 2010 implementation of the PeopleSoft tools upgrade v8.5 converted some table fields to TIMESTAMP automatically. This can affect your existing queries and batch jobs to not process as expected. The result can be null/missing data values or any number of server errors and their respective messages.

More information regarding this can be found at: http://helptech.asu.edu/Fix_TIMESTAMP. Please check this page daily as more content will be added.

4/08/2010 ASU EPM 9.0.73 Release Notes

New or Changed Tables and Views

New Operational Warehouse Staging (OWS) Tables/Views

• Student Financials


• PS_ASU_FA_DSP_EFFD


• PS_ASU_FA_DSP_TERM


• PS_ASU_FA_DSP_APPR
  

Modified Operational Warehouse Staging (OWS) Tables/Views

• Student Records


• EA_CRITICAL_COURSE - Two columns have been added to the EAdvisor table, EA_CRITICAL_COURSE: SUBJECT and CATALOG_NBR.