Human Resources Reporting News: New HR Historical Job Profile Reports in CREW

What is CREW?

We are pleased to announce that two new reports are now available in CREW:

HRJOBDP238 - Departmental-Historical Job Profile allows users to view job information for any employee working in, or having worked in the department(s) selected as of the date entered. This report shows all employees who were active regardless of which department currently owns the empl rcd.

Report example:

  • Scenario: John Harvard had two active jobs as of 1/1/2008 - one in the Science Department (Dept A) and the other in the English Department (Dept B). If Dept A is chosen (as of 1/1/2008), the only job that will appear on the report will be his Dept A job. The report will indicate that John Harvard had two active jobs as of 1/1/2008, but only the job details for Dept A are outputted to the report.

HRJOBDP239 - Departmental-Historical Job Profile (All Jobs) allows users to view job information for any employee working in, or having worked in the department(s), including any other active jobs (as of the date entered) at the University regardless of which department currently owns the empl rcd.

Report examples:

  • Scenario 1: John Harvard had three active jobs as of 7/1/2009 - two in the Science Department (Dept A) and the other in the English Department (Dept B). If Dept A is chosen (as of 7/1/2009), both of his jobs from the Science Department will appear on the report as well as his Dept B job.
  • Scenario 2: Fred Jones has an active job in Dept A and an active job in Dept B. If Dept A and Dept B are both chosen on the parameter page, both of Fred's jobs will appear twice; once under Dept A and the other under Dept B.

On the parameters page, checking the Include Multiple Jobs Only checkbox will result in displaying employees who have multiple active jobs as of the date selected. Employees with only one job will not appear on the report.

Security Setting for the Two Reports

The two new reports do not call row level security; therefore, you can now find employees who once worked in your school or department and no longer work in your school or department (whose empl rcd is owned by another school or department).

Required roles:
HDW^PUB^TUB^Reports User
HDW^HRUNV^TUB^Job No Comp

If you have any questions or concerns, please contact the HUIT Support Center at 496-2001 or dls@harvard.edu.

Thank you,
Harvard Human Resources Analytics and Reporting (HRAR) and Information Technology Teams (HUIT)

Tag: CREW

Email | Top