Wednesday, December 9, 2009

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.

Tuesday, August 11, 2009

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

Tuesday, August 4, 2009

7/30/2009 ASU EPM 9.0.61 Release Notes

New or Changed Tables and Views

Operational Warehouse Staging (OWS) Tables/Views

  • Student Finance
    • PS_ASU_SF_SELF_SUP
  • Student Records
    • PS_ASU_ERROR_LOG
    • PS_ASU_OCLSS_PRMSN
    • PS_ASU_OCRSE_PRMSN
    • PS_ASU_OVALLOW
    • PS_AUDIT_ASU_OCLSS
    • PS_AUDIT_ASU_OCRSE
    • PS_ASU_FACEBOOK
  • Human Resource
    • PS_BAS_PARTIC

Changes to EPM Business Rules and Logic
- none

Thursday, July 30, 2009

7/28/2009 ASU EPM 9.0.60 Release Notes

New or Changed Tables and Views

Operational Warehouse Staging (OWS) Tables/Views

  • Student Records
    • Removed the following table from EPM which are no longer being used for reporting:
      • PS_ASU_RATA_HDR
      • PS_ASU_ADS_ETH_TBL

Changes to EPM Business Rules and Logic
- none

6/18/2009 ASU EPM 9.0.58 Release Notes

New or Changed Tables and Views

Operational Warehouse Staging (OWS) Tables/Views

  • Human Resources
    • Changed table FW_TRANSACTION_DETAIL_JV, adding 4 columns (FISCAL_MONTH, TRANSACTION_DOCUMENT_CODE, OBJECT_CODE, EXPENDITURE_CODE)
    • PS_EG_OTH_DPT_TBL (new)

  • Admissions
    • Changed table PS_ASU_ACADP_EXTNS, adding 4 columns (ASU_ACADP_LRF_TEXT, ASU_MATH_REQ_FLAG, ASU_ACADP_MRF_CRSE, ASU_ACADP_MRF_TEXT)
    • Changed table PS_ASU_AD0010_PROG, adding CAMPUS column

  • DARS (peoplesoft)
    • PS_ASU_DARS_XWALK (new)

Changes to EPM Business Rules and Logic
  • Added one more object code, 7200, to the transactions sent nightly from the legacy financial warehouse to EPM: This results in additional transactional data in: FW_TRANSACTION_DETAIL_JV, ASU_BPC_VW, ASU_BPC_VW_ALL, ASU_BPC_VW_2009.

Monday, June 8, 2009

ASU EPM 9.0.57 Release Notes

New or Changed Tables and Views

Operational Warehouse Staging (OWS) Tables/Views

  • Human Resources
    • ASU_NOA_EE_EXCL
    • ASU_NOA_EE_HIST
    • ASU_NOA_GRP_TBL
    • ASU_NOA_NOSP_VW
    • ASU_NOA_OVRD_VW
    • ASU_NOA_SPON_VW
    • ASU_NOA_TENR_VW
    • ASU_NOA_TENS_VW
    • ASU_NOA_CURR_VW
    • ASU_NOA_EMPL_VW
    • ASU_NOA_MSS_VW
    • PS_DEPT_SEC_SRCH
  • Student Records
    • JOB_QUEUE_LIST
Changes to EPM Business Rules and Logic - None

Monday, June 1, 2009

06/01/2009 ASU EPM 9.0.56 Release Notes

New or Changed Tables and Views

Operational Warehouse Staging (OWS) Tables/Views
  • Human Resources
    • ASU_BPC_VW_2009:
      1. Added manual transactions from Advantage
      2. Adjusted fiscal year cutoff logic to use

    • FW_XWALK_FYFM_TO_PS_DATES:
      1. Defined cutoff dates for Distributions and Redistributions

    • FW_TRANSACTION_DETAIL_JV:
      1. Contains manual JVs entered in Advantage for salaries and wages

  • Student Financials
    • PS_GROUP_LINE


Monday, May 11, 2009

5/11/2009 ASU EPM 9.0.55 Release Notes

New or Changed Tables and Views

Operational Warehouse Staging (OWS) Tables/Views

  • Student Financials
    • PS_ASU_SF_FEE_RATE
    • PS_ASU_SF_FEECDDSC
    • PS_ASU_SF_RATETYPE
    • PS_ASU_SF_TUIT_GRP
    • PS_ASU_SF_TUIT_DT

Friday, May 1, 2009

04/30/2009 ASU EPM 9.0.54 Release Notes

New or Changed Tables and Views

Operational Warehouse Staging (OWS) Tables/Views
  • Financial Aid
    • PS_SCC_CKLSITM_TBL
    • PS_VAR_DATA_FINA
  • Human Resources
    • ASU_BPC_VW_2008:
      • Added FINANCIAL_FISCAL_YEAR column to reflect the financial (Advantage) fiscal year for the record.
      • Adjusted logic to filter out PeopleSoft 2008 distributions with Pay Period End Date >= 7/25/08, and PeopleSoft 2008 redistributions with GL Post Dt >= 7/14/08.
    • ASU_BPC_VW_2009: added FINANCIAL_FISCAL_YEAR column to reflect the financial (Advantage) fiscal year for the record.
    • ASU_BPC_VW_ALL: added FINANCIAL_FISCAL_YEAR column to reflect the financial (Advantage) fiscal year for the record.
    • ASU_BPC_VW: added FINANCIAL_FISCAL_YEAR column to reflect the financial (Advantage) fiscal year for the record.
    • Dropped table LG_APPROPRIATION_TRANSACTION. It has been reincarnated as FW_APPROPRIATION_TRANSACTION.
    • PS_ASU_PERS_AFF_SB: changed structure to match changes made to Sub Affiliation data structures in PeopleSoft.
    • PS_ASU_SUBAFIL_TBL: changed structure to match changes made to Sub Affiliation data structures in PeopleSoft.

Changes to EPM Business Rules and Logic
  • PS_ASU_DIRECT_SRVC (Directory Services): modified logic to use changed data structures in Sub Affiliation source tables

Friday, April 10, 2009

04/09/2009 ASU EPM 9.0.53 Release Notes

New or Changed Tables and Views
  • Operational Warehouse Staging (OWS) Tables/Views
    • Human Resource
      • ASU_BPC_VW_ALL (new) - has all available years of BPC data (currently 2008 and 2009)
      • ASU_BPC_VW (changed) – will always have current year(s) only, similar to Transaction Detail data in the legacy Financial warehouse. Presently this view contains 2009 only.
      • ASU_BPC_VW_2008 (changed) – the view has been 'materialized', or frozen; querying the view should be much faster
      • FW_APPROPRIATION_TRANSACTION table (new): loaded nightly from APPROPRIATION_TRANSACTION table from legacy Financial warehouse on Enterprise1

Thursday, April 2, 2009

4/2/2009 ASU EPM 9.0.52 Release Notes

New or Changed Tables and Views
  • Operational Warehouse Staging (OWS) Tables/Views
    • Hyperion Repository
      • HY_V8_EVENT_VW_P
      • HY_V8_QUERY_VW_P
      • HY_V8_OBJECT_VW_P
      • HY_V8_USER_VW_P
    • FAR (Faculty Activity Report)
      • FAR_MENTORING
      • FAR_ENCYCLOPEDIAARTICLES
    • Event Tracking
      • ET_TBL_EVENT_TYPE
    • DARS
      • DA_JOB_QUEUE_DETAIL
      • DA_JOB_QUEUE_RUN
Changes to EPM Business Rules and Logic
  • Directory Services table (PS_ASU_DIRECT_SRVC) – TITLE field now reflects working titles. Specifically, TITLE will be employee’s Primary job position working title, if it exists, otherwise the title reflects the employee’s Primary job jobcode description.

Tuesday, March 31, 2009

3/31/2009 ASU EPM 9.0.51 Release Notes

Retired Tables (these objects will no longer be available for reporting)
  • Operational Warehouse Staging (OWS) Tables/Views
    • Student Financials
      • PS_SF_ACCTG_LN
      • PS_TUIT_CALC_TBL
      • PS_CREDIT_HISTORY

Changes to EPM Business Rules and Logic
- None

Sunday, March 22, 2009

Two New Human Resource Profile Views!

Two new views have been added that will make reporting easier and more flexible. The new views are:
  • ASU_EMP_JOB_PROFILE_VW
  • ASU_EMP_JOB_PROFILE_CURR_VW
ASU_EMP_JOB_PROFILE_VW contains Job snapshots taken after each Pay End Dt. The view is a snapshot per pay period, of all active jobs and jobs terminated during the pay period.

ASU_EMP_JOB_PROFILE_CURR_VW contains just the most recent snapshot of Job data from ASU_EMP_JOB_PROFILE_VW.

More information can be found at: Data Dictionary: ASU_EMP_JOB_PROFILE_VW.

3/19/2009 ASU EPM 9.0.48 Release Notes

New or Changed Tables and Views
  • Operational Warehouse Staging (OWS) Tables/Views
    • Student Finance
      • PS_ASU_FA_ITEM_SUP
      • PS_ITEM_TYPE_FA_VW
      • PS_ITEM_TYPE_VW
      • PS_ASU_FA_ITEM_REQ
      • PS_ADM_MC_VW
      • PS_AID_YR_CAR_TERM
      • PS_ASU_FA_ADV_VW
      • PS_ASU_FA_FTF_VW
      • PS_ASU_FA_RES_VW
      • PS_ASU_FA_ITEM_VW
      • PS_ASU_FA_ATRBT_VW
    • HR
      • PS_ASU_PY_CHK_ERNS

Changes to EPM Business Rules and Logic - None

Monday, March 16, 2009

3/16/2009 ASU EPM 9.0.46 Release Notes

New or Changed Tables and Views
  • Operational Warehouse Staging (OWS) Tables/Views
    • Human Resources
      • FW_ACCOUNT: refreshed nightly from ACCOUNT table from Financial data warehouse on Enterprise1
    • Faculty Activity Report
      • FAR_COMMUNITYSERVICES
      • FAR_HONORS
      • FAR_BOOKREVIEWS
      • FAR_MONETARYAWARDPURPOSES
      • FAR_MONETARYAWARDS
      • FAR_NONREFEREEDARTICLES
      • FAR_PROFESSIONALSERVICES
      • FAR_REFEREEDARTICLES
      • FAR_SHORTSTORIES
      • FAR_UNIVERSITYSERVICES
      • FAR_EVALUATIONS
  • Multi-Dimensional Warehouse (MDW) Tables/Views
    • Human Resources
      • ASU_EMP_JOB_PROFILE_VW: contains Job snapshots taken after each Pay End Dt. The view is a snapshot per pay period, of all active jobs and jobs terminated during the pay period.
      • ASU_EMP_JOB_PROFILE_CURR_VW: view providing just the most recent snapshot of Job data from ASU_EMP_JOB_PROFILE_VW

Changes to EPM Business Rules and Logic

  • PS_ASU_HR158_VW: modified logic behind the view, to significantly improve performance. The view may now return different results in some cases, due to improvements and changes in source tables and derivation logic. There is discussion of retiring PS_ASU_HR158_VW; recommend use of ASU_EMP_JOB_PROFILE_VW or ASU_EMP_JOB_CURR_VW

Thursday, March 12, 2009

3/11/2009 ASU EPM 9.0.44 Release Notes

New or Changed Tables and Views

  • Operational Warehouse Staging (OWS) Tables/Views
    • Human Resource
      • PS_PAY_CHECK_EARNS

    • Transcript Audit
      • PS_ASU_SR0138_C_RH
      • PS_ASU_SR0138_C_RD
      • PS_ASU_SR0138_C_TR
      • PS_ASU_SR0138_C_RC
      • PS_ASU_SR0138_C_HC
      • PS_ASU_SR0138_D_RH
      • PS_ASU_SR0138_D_RD
      • PS_ASU_SR0138_D_RE

  • Changes to EPM Business Rules and Logic - None

Tuesday, March 3, 2009

3/2/2009 ASU EPM 9.0.45 Release Notes

New or Changed Tables and Views

  • Operational Warehouse Staging (OWS) Tables/Views
    • Student Records
      • PS_CLST_DETL_TBL
    • Human Resource
      • PS_EG_ADMIN_POSTS

Wednesday, February 25, 2009

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

Monday, February 16, 2009

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

Monday, February 9, 2009

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.

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