Human Resources Data Warehouse Release 41

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