Human Resources Reporting and Analytics News
| Category | Module | Report, View or Object | Description | Release | Actual or *Target Release Date |
| Human Resources | Database Object | OHR_PERS_CURR objects: EMPL_PAY_TUB_SV EMPL_PUB_TUB_V OHR_PERS_CURR_AUDIT_NOCOMP_V OHR_PERS_CURR_AUDIT_V OHR_PERS_CURR_NOCOMP_V OHR_PERS_CURR_SV OHR_PERS_CURR_V OHR_PUBLCTN_MAILING_LABELS_V |
Data in degrees_list and hu_alum_flag columns now limited to records where the accomplishment category type = DEG | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Database Object | OHR_PUBLCTN_MAILING_LABELS_V | Add HVRD_EMAIL_ADDR, SCND_EMAIL_ADDR and HMS_EMAIL_ADDR | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Database Object | JOB_CD_D_V | Added new column - TENURE_TRK_CD | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Database Object | PS_JOB_CD_R_V | Added new column - TENURE_TRK_CD | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Database Object | OHR_AAD_ELECTION_V | Create custom database view for AAD for annual election process | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Database Object | DWGL.DGL_COA_TUBS_D DWGL.DGL_COA_ORGS_D DWGL.DGL_COA_OBJECTS_D DWGL.DGL_COA_FUNDS_D DWGL.DGL_COA_ACTIVITIES_D DWGL.DGL_COA_SUBACTIVITIES_D DWGL.DGL_COA_ROOTS_D |
Bring over DWCENPRD COA segment dimension tables (needed for HRA costing development) | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Database Object/Security | Retire "HR Executive User" zone, other zone metadata | HDW HR 26.0 | 5/10/2010 | |
| Human Resources | Database Object/Security | OSEC_ROLESEC_HRCI_V | New view | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Database Object | EMPL_PAY_TUB_SV | Updated email address columns as follows - Rename work_email_addr to HVRD_EMAIL_ADDR; Add SCND_EMAIL_ADDR and HMS_EMAIL_ADDR. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Database Object | EMPL_PUB_TUB_V | Updated email address columns as follows - Rename work_email_addr to HVRD_EMAIL_ADDR; Add SCND_EMAIL_ADDR and HMS_EMAIL_ADDR. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Database Object | OHR_PERS_CURR_AUDIT_NOCOMP_V | Updated email address columns as follows - Rename work_email_addr to HVRD_EMAIL_ADDR; Add SCND_EMAIL_ADDR and HMS_EMAIL_ADDR. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Database Object | OHR_PERS_CURR_AUDIT_V | Updated email address columns as follows - Rename work_email_addr to HVRD_EMAIL_ADDR; Add SCND_EMAIL_ADDR and HMS_EMAIL_ADDR. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Database Object | OHR_PERS_CURR_NOCOMP_V | Updated email address columns as follows - Rename work_email_addr to HVRD_EMAIL_ADDR; Add SCND_EMAIL_ADDR and HMS_EMAIL_ADDR. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Database Object | OHR_PERS_CURR_SV | Updated email address columns as follows - Rename work_email_addr to HVRD_EMAIL_ADDR; Rename home_email_addr to SCND_EMAIL_ADDR; and add HMS_EMAIL_ADDR. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Database Object | OHR_PERS_CURR_V | Updated email address columns as follows - Rename work_email_addr to HVRD_EMAIL_ADDR; Rename home_email_addr to SCND_EMAIL_ADDR; and add HMS_EMAIL_ADDR. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Database Object | SBN_PS_BN_SNAP_JOB_SV | Added new column - HU_LTD_GF_RBO. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Database Object | SHR_PS_JOB_SV | Added new column - SETID_EMPL_CLASS. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Database Object | SHR_PS_JOB_V | Added new column - SETID_EMPL_CLASS. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Database Object | SHR_PS_LOCATION_TBL_V | Added new column - TELE_LOCATION. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Database Object | SPY_PS_SRC_BANK_V | Added new column - IAT_IND; re-ordered column - INTL_BANK_ACCT_NBR. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRACCDP221 - DEP REL12532 & 12629 | Report changes due to changes (email address). | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRACCDP222 - DEP REL12532 & 12629 | Report changes due to changes (email address). | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRACCDP229 - DEP REL12532 & 12629 | Report changes due to changes (email address). | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRDIRDP004 - DEP REL12532 & 12629 | Report changes due to changes (email address). | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRDIRDP006 - DEP REL12532 & 12629 | Report changes due to changes (email address). | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRDIREE001 - DEP REL12532 & 12629 | Report changes due to changes (email address). | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HREMRDP037 - DEP REL12532 & 12629 | Report changes due to changes (email address). | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRJOBDP007 - DEP REL12532 & 12629 | Report changes due to changes (email address). | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRMAGOP061 - Add Report/Updates (DEP 12300, 12532, 12629) | Report changes due to changes (email address). Add reports for Harvard Magazine. |
HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRRESOP063 - Email source change (DEP 12300, 12532, & 12629) | Report changes due to changes (email address). | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRSEROP066 - (DEP REL12532, 12300 & 12629) | Report changes due to changes (email address). | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRU55CI096 - DEP REL12532 & 12629 | Report changes due to changes (email address). | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | BNRHSVC040 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | BNRHSVC076 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | BNRHSVC077 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | CODCOUW034 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRCMPDP020 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRCMPDP217 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRCMPEE019 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRCOMOP057 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HREMREE036 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRFINDP105 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRGAZOP060 - SYNC (DEP 12300, 12532, 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRJBMUL023 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRJBMUL025 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRJBMUL026 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRJOBDA028 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRJOBDA029 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRJOBDA030 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRJOBDA031 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRJOBDP005 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRJOBDP052 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRJOBEE003 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRJOBEE058 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRSTUDP210 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRSVCDP013 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRSVCDP014 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRTRMDP038 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRTRMDP039 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRTRNDP220 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRU55CI064 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRU55CI065 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRXFRDP204 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | PNHISEE048 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
| Human Resources | Report | HRWKFDP231 - SYNC ONLY (DEP REL12532 & 12629) | Structural changes where made to the underlying database objects that support these reports. There is no impact to the data or report structures. | HDW HR 26.0 | 5/10/2010 |
Human Resources Reporting News
If you have any questions or concerns, please contact the UIS Helpdesk at 496-2001 or uishelpdesk@harvard.edu.