PeopleSoft 9.1 Upgrade: Reporting Impact

The PS 9.1 Upgrade is scheduled for production release for both PeopleSoft and the HR Data Warehouse in April 2012. The following outlines changes to CREW HRMS reports that were impacted by the PS 9.1 version upgrade from the current PS 8.9 version. An updated list of HR Data Warehouse (EUL) Objects impacted by the upgrade is attached to this eNews announcement.

CREW HRMS Reports (18 reports required functional changes; 31 required database synchronization)

CREW Report Functional Notes
BNHNWDP017 Retrofit; replace PS_BN_SNAP_PLAN_SV with SBN_PS_BN_SNAP_PLAN_SV
BNHNWEE016 Retrofit; replace PS_BN_SNAP_PLAN_SV with SBN_PS_BN_SNAP_PLAN_SV
BNRHSVC040 Retrofit; replace PS_PA_SVC_TRANS_V with SPN_PS_PA_SVC_TRANS_V
HRACCDP221 Retrofit using new Accomplishment's design.
HRACCDP222 Retrofit using new Accomplishment's design.
HRACCDP229 Report will be end dated; no longer available.
HRCMPDP020 Synchronize report with database and hint change for performance.
HREMRDP037 PHONE_EXTENSION added to report.
HREMREE036 PHONE_EXTENSION added to report.
HRJOBDP007 Retrofit to new ODS view: OHR_ACCOMP_DEG_V
HRJOBEE003 Retrofit to new ODS view: OHR_ACCOMP_DEG_V
HRJOBEE058 Updated report metadata (Business Purpose and Suggested Run Times)
HRTRNDP220 Retrofit; redirect columns (previously existed in STRN_PS_HU_EMPTRNG_COS_V; now added to STRN_PS_TRAINING_V): payment_method, acct_cd, dist_pct, commentshort, fee)amt
HRTRNDP232 Retrofit; redirect columns (previously existed in STRN_PS_HU_EMPTRNG_COS_V; now added to STRN_PS_TRAINING_V): payment_method, acct_cd, dist_pct, commentshort, fee_amt
PNHISEE048 Retrofit; replace PS_PA_SVC_TRANS_V with SPN_PS_PA_SVC_TRANS_V
SCTLGLS044 GROUP_ID will be renamed to TL_GROUP_ID in the database object: SSEC_PS_TL_GRP_SECURITY_V
SCUSRSC046 GROUP_ID will be renamed to TL_GROUP_ID in the database object: SSEC_PS_TL_GRP_SECURITY_V
SCUSRSC078 GROUP_ID will be renamed to TL_GROUP_ID in the database object: SSEC_PS_TL_GRP_SECURITY_V

If you have questions or concerns please contact the HUIT Support Center at 496-2001 or dls@harvard.edu.

Tags: PeopleSoft

Email | Top