HR Data Reports

MyReports is UCSF's campus-wide reporting solution that provides financial and human resources data to meet the needs of users at all levels within our organization. The HR Data Reports in MyReports include:

Employee Appointment Report

The Employee Appointment Report (job aid) displays HR appointment details in a list format by Employee, Appointment Number, and Appointment Begin and End Dates. The Employee Appointment Report:

  • Provides detailed information related to an employee’s appointment information
  • Allows for reporting at the Home Department level down to the individual employee level
  • Allows for drill-through to Employee Lookup
  • Highlights appointments with end dates within the next three months

Employee Distribution Report

The Employee Distribution Report (job aid) displays HR distribution details in a list format by Employee, Distribution Number, Distribution %, Distribution Chartstring, and Distribution Begin and End Dates. The Employee Distribution Report:

  • Provides detailed information related to all employee distributions
  • Allows for reporting at the Home Department level down to the individual employee level
  • Allows for drill-through to Employee Lookup report

Employee Lookup Report

The Employee Lookup Report (job aid) displays all current HR appointment and distribution details by employee. The report provides current, active employee appointment and distribution details in three available displays:

  • Appointment View: Displays all appointment data
  • Distribution View: Displays all distribution data by appointment
  • Combined View: Displays both appointment and distribution data

HR Event Report

The HR Event Report (job aid) displays HR Events such as Appointments or Separations with the ability to drill-through to the HR Event Detail Report and Employee Lookup Report for more information. Data is available from July, 2013 forward. The HR Event Report displays information by employee name with a unique row for each HR Event.

HR Event(s) displayed in the HR Event Report

  • APPT – Appointment
  • BENE – Benefits
  • EDAP – Additional Pay
  • EDFT – One Time Payment
  • EDLR – Late/Reduce Payment
  • EDLR – Late/Reduce Payment
  • EDRA – Retroactive Pay
  • HIRE – Hire/Rehire
  • LEAV – Leave of Absence
  • SEPR – Separation

Events can include multiple Actions. Common HR Actions include:

  • 18 – Change in Fund Source
  • 24 – Change in Leave Plan
  • 40 – Other Appointment Action
  • 46 – Change in % Full Time
  • 50 – Other Distribution Action

HR Monthly Review Report

The HR Monthly Review Report (job aid) combines several report subgroups into a single review report with the ability to display the following data: New Hires, Separations, Appointments near end, Distributions near end, Probation period near end, Work permit end date, Limited employee hours, and Distributions greater than 100%. The HR Monthly Review Report

  • Supports users who manage employee appointments by providing the ability to review and monitor specific HR activities and statuses every month
  • Provides the ability to run for all subgroups or for specific activity types