Human Resources Data Warehouse (DWH_39.0) Release Notes

September 18, 2014

Changes to Job Curr (Job Empl) views: New column added

FULL_PART_TIME has been added to following Job Empl (Job Curr) views:

OHR_JOB_CURR_ALL_SV   Visible to HDW^HR^TUB^Reports User
OHR_JOB_CURR_AUDIT_NOCOMP_V  Visible to HDW^HRUNV^TUB^Job No Comp
OHR_JOB_CURR_AUDIT_V   Visible to HDW^HR^CTR^Reports User
OHR_JOB_CURR_NOCOMP_V  Visible to HDW^HRUNV^TUB^Job No Comp
OHR_JOB_CURR_V  Visible to HDW^HR^CTR^Reports User

For these views, the change will cause a large increment of rows to be added. These increments might affect the run time of your queries.

Changes to OHR_HR_PRIMARY_EMPL_V: New column added

  • FULL_PART_TIME has been added to view
  • Security required for this view is HDW^ALL^TUB^Admin Reports User

Change to Military Status: column removed, new view

  • Remove the attribute MIL_DISCHRG_DT_USA from SHR_PS_PERS_DATA_USA_SV
  • Create new view: SHR_PS_PERS_MILIT_USA_SV (contains attribute MIL_DISCHRG_DT_USA)
  • Security required for this view is HDW^HR^TUB^Reports User

Changes to ORM_CANDIDATES_PERS_INFO_V: Add new name function

  • For this view, the changes will allow it to return ORM_CANDIDATES_PERS_INFO_V.NAME_FULL and ORM_CANDIDATES_PERS_INFO_V.LAST_FIRST_MIDDLE_NAME with FIRST_NAME, MIDDLE_NAME and LAST_NAME longer than 30 characters
  • Security required for this view is HDW^RM^CTR^User

Changes to HR Analytics star schema: new columns added, column changes, new views

DHR_DEMOGRAPHICS_COST_ALL_F_V and DHR_DEMOGRAPHICS_COST_SEC_F_V:

  • The current attribute EFF_DATE (date costing went into effect) is now renamed COSTING_EFF_DATE
  • Add new attribute JOB_EFF_DATE

DHR_TURNOVER_FLAGS_D:

  • Add new attributes QUICK_QUIT_FLAG and QUICK_QUIT_COUNTER

New Department-Secured Views

Below are new star schema views that are used to secure data by department (aka “user sees department”). Note that for both views, the dept_id needed to implement department-level security is determined by joining to DHR_ORGANIZATIONS_D as is done with DHR_EARNINGS_F_DEPT_SV.

  • DHR_DEMOGRAPHICS_F_DEPT_SV
    • New view DHR_DEMOGRAPHICS_F_DEPT_SV with “user sees dept” row-level security
    • Same attributes as DHR_DEMOGRAPHICS_ALL_F_V
    • Role is HDW_SEC_ZONE_DHR_EARN_DEPT
  • DHR_DEMOGRAPHICS_COST_F_DEPT_SV
    • New view DHR_DEMOGRAPHICS_COST_F_DEPT_SV with “user sees dept” row-level security
    • Same attributes as DHR_DEMOGRAPHICS_COST_ALL_F_V
    • Role is HDW_SEC_ZONE_DHR_EARN_DEPT

 If you have questions, please contact us via the HUIT Helpdesk at 495-7777 or ithelp@harvard.edu

Thank you,
The Human Resources Analytics and Reporting and HUIT Enterprise Data Warehouse teams