Employee Actual Hours Report

This Healthcare Productivity report shows which employees worked in a unit during a pay period, based on the jobs as grouped into work groups.

  • Pay period or year-to-date (YTD)
  • Hours or money amounts
  • Regular, Other, Overtime (OT), Float In, and Float Out

This report shows the employee, paycode, and job level data from the payroll system as follows:

  • Productive and non-productive groupings
  • Paycode subcategory breakdown
  • Employees by job work group, employment status, and labor type

Note: To schedule reports, see the Schedule and Manage Report Jobs topic.

  1. Select Main Menu  > Dataviews & Reports > Report Library.
  2. From the Report Library, click tap Run Report .
  3. In the Select Report panel, select Healthcare Productivity > the Employee Actual Hours report.
  4. Click Tap Select.
  5. Select the applicable report parameters:

    • By default, the Reference Date is set to yesterday's date (today —1).

      • This date changes daily. So, the Reference Date is always the day before the day of the report run.

        Examples:

        You manually run a report on Tuesday, November 3; the Reference Date is Monday, November 2.

        A scheduled report runs on Tuesday, November 10; the Reference Date is Monday, November 9.

        A recurring scheduled report runs every Tuesday; the Reference Date is the Monday before each run.

      • You can select a different Reference Date for this run of the report.

        Caution: If you change the default Reference Date for a recurring scheduled report, that date becomes fixed for subsequent runs. As a result, the subsequent reports do not show updated data. See the Schedule and Manage Report Jobs topic.

      • To configure a different offset from today's date, you can change the site.healthcareanalytics.referencedate.offset system setting; see the Healthcare Analytics System Settings topic.

    • Work Unit Hyperfind: Select one of the following hyperfind queries that contains the appropriate work unit:

      Caution: If the report will be in Excel format, make sure that the report contains no more than 90 work units because spreadsheets cannot contain more worksheets (tabs), and each work unit occupies one worksheet.

      • All My Department Work Units: Show all Department-type work units in the organizational sets that you can access in the business structure.

        Example: If you can access 100 departments, and each department has a corresponding work unit, this hyperfind returns 100 department-type work units.

      • All My Work Units: Show all work units, regardless of location type, in the organizational sets that you can access in the business structure.

        Caution: This hyperfind returns work units of different types that are excluded from reports; the Healthcare Productivity reports show department types only.

        Example: If you can access 2 out of 5 facilities, this hyperfind returns only those 2 facility work units plus all department and work group work units that are in those facilities.

      • Work unit hyperfinds: Select one of the custom hyperfinds.
      • Single Work Unit: Select one work unit.

    • Work Unit: (Available only if you select Single Work Unit in Work Unit Hyperfind) Select the work unit. The list shows only work units that you can access.

    • Timeframe: Select the pay period:

      • Pay Period Year to Date (Fiscal) = All completed pay periods from the beginning of the fiscal year based on the reference date.

      • Last 6 Pay Periods = Six completed pay periods, if available, based on the reference date.

      • Pay Period = The most recently completed pay period based on the reference date.

  6. In Output Format, select one of the following:

    Caution: The CSV (comma-separated values) output is not suited for Healthcare Productivity reports because of the complex structure of the reports.

    Note: Healthcare Productivity reports support only PDF, Excel, and Interactive formats; other formats are not supported.

  7. Click Tap Run Report.

    Status indicators

    •  In-Progress: The report is running.
    •  Completed: The report ran successfully without errors.
    •  Failed: The report has errors; check the Run Summary for details. Correct the error and run the report again.

  8. Select the report and click tap the right arrow .

    1. Click Tap View Report.
    2. To modify interactive reports, see the Organize and modify data with interactive viewer topic.
  9. If the report has multiple pages, click tap the arrows or enter the page number Change Page to change pages.
  10. Select Menu  and one of the following:
    • Enable Interactivity: Select to sort, filter, group, or analyze the data in the table. See the Organize and modify data with interactive viewer topic.
    • Parameters
    • Report output: In Table of Contents: Select to filter the report by one of the following Types:

      Note: Both types are sorted by Total > Work (skill) Group > Employment Status > Employee for regular and supplemental labor.

      Hours (employees worked): Shows the productive hours, non-productive hours, and total paid hours for each employee.

      Money (employees earned): Shows the productive amounts, non-productive amounts, and total paid amounts for each employee.

    • Export Contentf
    • Export Data
    • Print

At the top of the report

  • Time Period — The time period of the report. The format is defined by the locale settings.

  • Reference Date — The report includes data for the pay period that contains this reference date.

  • Work Unit — The work units that are being reported.

  • Type — The type of output: Hours or Money.

  • Current as of — The date when the system data was updated; the data is current on this date.

  • Executed on — The date and time when the report ran.

  • Printed for — The user name — LastName, FirstName — of the person who ran the report.

  • Pay Period

In the report

Productive:

  • Regular: Total number of productive hours or money worked under paycodes that are mapped to the Productive Hours pay category.
  • Other: Total number of productive hours or money worked under paycodes that are mapped to the Other Productive pay category.
  • OT: Total number of overtime (OT) hours or money attributed to labor under paycodes that are mapped to the Overtime pay category.
  • Extra PT: Total number of productive hours or money worked by part time (PT) employee who worked more than their standard part time hours or money.
  • Float Out Regular: Total number of productive hours or money worked by employees who worked outside their home work unit (non-OT).
  • Float Out OT: Total number of productive hours worked by employees who worked outside their home work unit (OT).
  • Total: Sum of regular and supplemental labor.

Non-Productive:

  • Regular NonProd: Total number of non-productive hours or money worked that are mapped to the Non-Productive0 pay category.
  • Regular NonProd1: Total number of non-productive hours or money worked that are mapped to the Non-Productive1 pay category.
  • Regular NonProd2: Total number of non-productive hours or money worked that are mapped to the Non-Productive2 pay category.
  • Other: Total number of non-productive hours or money worked that are mapped to the Other Non-Productive pay category.
  • Float Out: Total number of non-productive hours or money worked by employees who worked outside their home work unit (Non-Productive Float Out pay category).
  • Total: Sum of Non-Productive0, Non-Productive1, Non-Productive2, and Other Non-Productive pay categories.

Total Paid: Paid Hours or the sum of Productive and Non Productive hours or money in the report.