Saturday, January 24, 2009

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

Friday, January 16, 2009

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

Thursday, January 15, 2009

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.

Wednesday, January 14, 2009

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