Here are the upcoming changes to HR reporting going into production on December 9, 2014 with Release 40 (DWH_40.0).
Changes to Disability Status: columns added, changed view, removed view, removed column
In order to support the OFCCP regulation changes to Section 503 of the Rehabilitation Act of 1973, Harvard rolled out the PS-delivered self-service Disability page. This impacts where disability status is stored (it is a new delivered PS field).
- Alter table PS_DISABILITY: Add the attributes DISABILITY_STS_USA, HR_EE_SIGNATURE, HR_DISCLOSURE_DT
- Alter view SHR_PS_DISABILITY_SV: Map columns HR_EE_SIGNATURE, HR_DISCLOSURE_DT to the view
- Alter view SHR_PS_DISABILITY_SV: Remove column DISABLED (see new PS-delivered column DISABILITY_STS_USA)
- Remove view SHR_PS_DISABILITY_V
Changes to PERS CURR objects: Columns added, columns altered, changed views
A number of changes have been made to the PERS CURR objects.
- Change PERS CURR tables and views that are impacted by the Disability Status changes that were made in PeopleSoft with Release 39. The changes support the OFCCP regulation changes to Section 503 of the Rehabilitation Act of 1973. This impacts where DISABILITY STATUS is stored in PS. DISABILITY_STATUS has been added to the following views:
- OHR_PERS_CURR_V
- OHR_PERS_CURR_SV
- OHR_PERS_CURR_AUDIT_V
- Altered view OHR_PERS_CURR_NOCOMP_V and OHR_PERS_CURR_AUDIT_NOCOMP_V: added WORK_ELIGIBILITY_FLAG (identifies I9 status)
- Change NULL values to 0 (zero) in column SUPERVISOR_DIRECT_REPORTS_COUNT. If using this attribute in reports, the reports now show up as numbers vs nulls. This change impacts all PERS CURR views (specific attribute name):
- OHR_PERS_CURR_NOCOMP_V, OHR_PERS_CURR_SV and OHR_PERS_CURR_AUDIT_NOCOMP_V (SPRVSR_DIRECT_REPORTS_COUNT)
- OHR_PERS_CURR_V and OHR_PERS_CURR_AUDIT_V (SUPERVISOR_DIRECT_REPORTS)
Changes to IDMS_FLAGS_SV: New column added
New benefit programs for the grandfathered LTD participants (RBO group) have been implemented in PeopleSoft (effective 1/1/2014). A flag has been added to the Harvard Flags Page in PeopleSoft to identify grandfathered LTD participants.
- HU_RBO_BEN_PRG has been added to the view to identify RBO program
- Security required for this view is HDW^HR^TUB^Reports Reports User
Changes to Job Actn, Job Curr Job Hist(Job Empl) tables: Column length reduced
The following columns have been reduced from VARCHAR(4000) to VARCHAR2(100):
- AA_SUB_AFFIL_DESC
- AA_MAJOR_AFFIL_DESC
- CTR_SUB_AFFIL_DESC
- CTR_MAJOR_AFFIL_DESC