June 10, 2015
Read about the upcoming changes to HR reporting that will be released into production on June 1st, 2015 with DWH_41.0.
Change to SPRVSR_NAME effective date logic in OHR_JOB_ACTN
Effective date logic of the SPRVSR_NAME attribute has been altered to reflect the most current name of a supervisor.
- The date logic was altered to retrieve the most current name of a supervisor using the most recent effective date. This means that we will have the current name (across all historical rows) for supervisors.
- Changes are reflected in views that contain the supervisor name:
- OHR_JOB_ACTN_ALL_DEPT_SV
- OHR_JOB_ACTN_ALL_SV
- OHR_JOB_ACTN_AUDIT_NOCOMP_V
- OHR_JOB_ACTN_AUDIT_V
- OHR_JOB_ACTN_DEPT_SV
- OHR_JOB_ACTN_NOCOMP_V
- OHR_JOB_ACTN_SV
- OHR_JOB_ACTN_V
- OHR_JOB_CURR_ALL_SV
- OHR_JOB_CURR_AUDIT_NOCOMP_V
- OHR_JOB_CURR_AUDIT_V
- OHR_JOB_CURR_NOCOMP_V
- OHR_JOB_CURR_V
- OHR_JOB_HIST_ALL_DEPT_SV
- OHR_JOB_HIST_ALL_SV
- OHR_JOB_HIST_AUDIT_NOCOMP_V
- OHR_JOB_HIST_AUDIT_V
- OHR_JOB_HIST_DEPT_SV
- OHR_JOB_HIST_NOCOMP_V
- OHR_JOB_HIST_SV
- OHR_JOB_HIST_V
Change to Records impacted by PeopleSoft Rel41 bundles: columns added (changed views)
- BN_ACA_ELIG_IND column added to view SBN_PS_BN_SNAP_JOB_SV
- Security required for PS_BN_SNAP_JOB_SV is HDW_SEC_ZONE_BEN_TUB
- LASTUPDDTTM column added to views PS_COMPANY_TBL_V, PS_DEPT_TBL_V and PS_LOCATION_TBL_V
- Security required for PS_COMPANY_TBL_V, PS_DEPT_TBL_V and PS_LOCATION_TBL_V is HDW^PUB^TUB^Reports User