2/20/2009 ASU EPM 9.0.43 Release Notes

New or Changed Tables and Views

• Operational Warehouse Staging (OWS) Tables/Views

• Faculty Activity Reporting
• FAR_AUTHOREDBOOKS
• FAR_EDITEDBOOKS
• FAR_BOOKCHAPTERS
• FAR_CONFERENCEPROCEED
• FAR_FACULTY
• FAR_FACULTYDEPARTMENT

Changes to EPM Business Rules and Logic - None

2/11/2009 ASU EPM 9.0.42 Release Notes

New or Changed Tables and Views

Operational Warehouse Staging (OWS) Tables/Views

Student Records:

• PS_EG_CHANGE_HIST
• PS_COMMUNICATION
• PS_STDNT_RTN_TIV
• PS_TIV_SCHOOL_TBL
• PS_PKG_BATCH_PER
• PS_PKG_BATCH_SUMM
• PS_PERSON_COMMENT

Financial Aid:

• PS_ASU_FA_FNA_REQ
• PS_ASU_FA_FNA_SEQ
• PS_ASU_FA_FNA_TERM

Human Resource:

• PS_TL_TRC_TBL
• PS_TL_PAYABLE_TIME

Effort Reporting:

• PS_ER_TRANS

Changes to EPM Business Rules and Logic:

• Logic changes to drive a better ‘primary’ Academic Program and Plan, in Directory Services (PS_ASU_DIRECT_SRVC)
• Added ASU_ASURITE_ID to PS_ASU_D_PERSON_VW

No Warehouse Data Updates on February 9, 2009

Due to 21st day processing tonight, the warehouse load will not take place.
This means no new data from source systems will be loaded into the warehouse
tonight. Load will resume as normal on Tuesday Feb 10th.

1/22/2009 ASU EPM 9.0.40 Release Notes

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

Residence Life:

• RL_ACCT_T_INVOICE_DETAILS
• RL_ACCT_T_MISCTRANS_PERSON
• RL_ACCT_T_ORDERS
• RL_APPL_T_ROOM_PREFERENCES
• RL_LOG_T_LOG
• RL_LOG_T_STUDENT
• RL_PPLE_T_ADDRESS
• RL_PPLE_T_CONTACT_PROFILE
• RL_PPLE_T_USER_DEFINED

Changes to EPM Business Rules and Logic - None

1/9/2009 ASU EPM 9.0.39 Release Notes

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

Human Resources:

• PS_ASU_VISA_PM_DAT
• PS_ASU_CITIZENSHIPS
• PS_ACCOMPLISHMENTS

Student Records:

• PS_STDNT_GRPS

Changes to EPM Business Rules and Logic - None

New Query: Faculty and Graduates in Short Work Break.bqy

There is a new query available for Human Resource data warehouse users: Faculty and Graduates in Short Work Break.bqy.

The first query (Qry - Fac and Grad Short Work Break) identifies employees on Short Work Week who may need renewal. The second query (Qry - Fac and Grad Renewed) lists employees who have been renewed. If the return date is reached, they will be in active status, otherwise they will be in Short Work Break Status until their return date is reached.

Helpful pivot views of the results are included as well.

12/09/2008 ASU EPM 9.0.37 Release Notes

New or Changed Tables and Views Operational Warehouse Staging (OWS) Tables/Views - Human Resources Records

• PS_PER_ORG_INST

• PS_CHECK_YTD

Changes to EPM Business Rules and Logic - None