Human Resources Reporting and Analytics News

CREW HR 6.6 Report Changes

Production Date: 6/18/2010

Category Report Name Description
Human Resources HRCMPDP217 - Departmental FTE Salary Comparison

The report has a new column that displays the FTE.
This report will allow users with the ability to compare the FTE salary and FTE time status for employees for two points in time.
Human Resources HRMAGOP061 - Harvard Magazine Added employee ID to the report
Human Resources HRJOBEE003 - Individual Job Profile Add Multiple employee ID parameter to the report

CREW HR REL 27.0 Database Changes

Production Date: 9/11/2010

Database Objects Change Type Notes Zone
OHR_HR_PRIMARY_EMPL_V New New view created from ohr_pers_curr_max,
ohr_job_curr_max
HDW_SEC_ZONE_ADMIN_TUB
OHR_CONTACT_SV New New view created from stghr.ps_addresses
ohr_pers_curr_max,
ohr_job_curr_max
HDW_SEC_ZONE_ADMIN_TUB
SHR_PS_DIVERS_ETHNIC_SV New New view created from
stghr.ps_divers_ethnic
HDW^HR^TUB^Reports User
SHR_PS_DISABILITY_SV New New view created from
stghr.ps_disability
HDW^HR^TUB^Reports User
SHR_PS_PERS_DATA_USA_SV New New view created from
stghr.ps_pers_data_usa
HDW^HR^TUB^Reports User
DHR_PAYGROUP_D_V New Added 2 Fields :
outsourced_payroll_flag,
hu_payroll_flag
HDW^PUB^TUB^Reports User
DHR_ORGANIZATIONS_D_V Update Added 6 Fields :
dept_abbr_curr,
dept_desc30_curr,
dept_desc_curr,
dept_type_cd,
dept_type_abbr,
dept_type_desc
HDW^PUB^TUB^Reports User
DHR_JOBS_D_V Update Added 6 Fields :
job_family_cd,
job_family_abbr,
job_family_desc,
tenure_trk_cd,
tenure_trk_abbr,
tenure_trk_desc
HDW^PUB^TUB^Reports User
DHR_TURNOVER_ALL_F_V Update Added 1 Field :
dw_hr_pri_job_flag_to_key
HDW_SEC_ZONE_DHR_MOB_CTR
DHR_MOBILITY_ALL_F_V Update Added 6 Fields :
job_family_cd,
job_family_abbr,
job_family_desc,
tenure_trk_cd,
tenure_trk_abbr,
tenure_trk_desc
HDW^PUB^TUB^Reports User
DHR_TURNOVER_ALL_F_V Update Added 1 Field :
dw_hr_pri_job_flag_to_key
HDW_SEC_ZONE_DHR_MOB_CTR
DHR_ORGANIZATIONS_FROM_D_V Update Added 6 Fields :
dept_abbr_curr,
dept_desc30_curr,
dept_desc_curr,
dept_type_cd,
dept_type_abbr,
dept_type_desc
HDW^PUB^TUB^Reports User
DHR_ORGANIZATIONS_TO_D_V Update Added 6 Fields :
dept_abbr_curr,
dept_desc30_curr,
dept_desc_curr,
dept_type_cd,
dept_type_abbr,
dept_type_desc
HDW^PUB^TUB^Reports User

Human Resources Reporting News

  • CREW Excel Output Limit:
    • Hyperion only allows XLS as an Excel output option (worksheet size is only 256 columns by 65,536 rows)
    • Hyperion does not support an XLSX export to Excel 2007 (worksheet size is 16,384 columns by 1,048,576 rows)
    • The workaround for reports that generate >65K rows is to use the CSV output option and import the file into Excel 2007

  • CREW Load Status: For load status, outage information, please go to the CREW splash page for details. The splash page appears just before you login to CREW.
    • You can also click on the System Msgs link from within CREW

  • CREW Metadata: For information such as the Detailed Description, Business Purpose, Suggested Run Times, Parameters and Security about CREW HRMS reports, use the 'metadata' link for each report:
    • click on the report code (i.e.: HRDIREE001) to open the metadata for the report

If you have any questions or concerns, please contact the UIS Helpdesk at 496-2001 or via email at uis_helpdesk@harvard.edu.

Email | Top