EPM Release Notes - September 1, 2011

New or Changed Tables and Views
Operational Warehouse Staging (OWS) Tables/Views

• Human Resources
• ASU_EMP_LAST_BEN_SERVICE_DT, new table with validated employee benefit service dates.

• Campus Solutions
• Altered PS_ASU_FA_P_YR_VW: added columns ASU_FA_GIFT_AID, ASU_FA_PSH_NEED, and PELL_ELIGIBILITY
• Altered PS_ASU_AD0104_MAPP: added column ASU_PLAN_CAT_TYPE

Changes to EPM Business Rules and Logic
n/a

EPM Release Notes - August 23, 2011

New or Changed Tables and Views
Operational Warehouse Staging (OWS) Tables/Views

• Campus Solutions
• ASU_STDNT_PROFILE_MAJ_CURRENT*
• PS_ASU_SR205_CKLST
• PS_ASU_SR205_PROFL
• PS_ASU_SR205_STAT
• PS_ASU_SR205_THSIS
• PS_ASU_SR205_THS_R

*ASU_STDNT_PROFILE_MAJ_CURRENT is the new Current Student Profile table that includes student major-related data such as program, plan, subplan and campus. It includes data for all records that are active as of the current date (the day you run your query), even if the student is not yet term activated - for example, first-time freshmen who have not yet made an orientation reservation. This new table simplifies the data, reduces errors, promotes consistency, and reduces the complexities of the tables so users can easily create their own queries.

Three student Data Warehouse tables were renamed to make them easier to find in the My Reports table catalog:

New Name: ASU_STDNT_PROFILE_MAJ_CURRENT
Old Name: PS_ASU_SPRF_CURR

New Name: ASU_STDNT_PROFILE_MAJ_TERM
Old Name: PS_ASU_SR0189_SPRF

New Name: ASU_STDNT_PROFILE_TERM
Old Name: PS_ASU_SR0189_SBYT

This change will not cause existing queries to break. However, when building new queries, you need to look for the new names.

Changes to EPM Business Rules and Logic
n/a

2/3/2011 ASU EPM 9.0.79 Release Notes

New or Changed Tables and Views

Operational Warehouse Staging (OWS) Tables/Views

• Campus Solutions
• MAT_CLASS_TEST
• MAT_CLASS_TEST_STUDENT
• MAT_TEST_LOCATION
  

MDW Warehouse Tables/Views

• Campus Solutions
  • Changed minority status logic in PS_ASU_D_PERSON_VW
    
    The minority status calculation for an indivudial is now changed based on the following federal guideline changes:
    
    1. Identify Nonresident Alien (X) students using the logic currently in place.
    2. Additionally, now people with visa_code='AR1' will be considered as citizens and given the minority code of 'X'
    3. Students who identify as Hispanic, even if they also select additional ethnic codes, should be coded as Hispanic/Latino (H).
    4. Non-Hispanic students who have more than one first character ethnic code, not including Unspecified (U), should be coded as Two or More Races (T). This is a new code.
    5. All other students should be assigned to the single ethnic code they selected
    6. Else to Unspecified (U) if they selected none.
    
    

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.
  

12/07/2009 ASU EPM 9.0.68 Release Notes

New or Changed Tables and Views
Operational Warehouse Staging (OWS) Tables/Views

• Effort Reporting
• PS_ER_USER_APR_FLT - This is a filter table for the original PS_ER_USER_APRSEQ table in EPM. This filter table contains the most effective dated rows for DEPT_APPROVER, DEPT_REVIEWER, PI_CERTIFIER and EMPLOYEE, EffortReporting Application Roles only and will replace the original PS_ER_USER_APPRSEQ table in EPM.

HR Expenditures Queries Revised

Effective for the pay period beginning July 10, 2009, ERE will be budgeted and charged based on established rates applicable to all account types; state, local and sponsored. Accounts will no longer be charged ERE based on actual costs, the ERE assessment will be based on the new ERE rates. Each Employee Class in PeopleSoft will be assigned an ERE rate.

The HR Expenditures queries in My Reports contain both the new ERE rate and the actual ERE charges. For the pay beginning July 10, 2009, only the new ERE rates will appear in the queries. More information regarding the ERE rate change can be found at: http://www.asu.edu/fs/documents/commitment_accounting/ERE_RATES.pdf