HHS PRF Report

Report Definition

This report runs using the following logic;

The HHS Provider Relief Fund field separates the 7 categories like this:

It takes all employee that were included in the pivot grid report and then checks on each individual employee as to which of the 7 categories the employee belongs to in the following order. As soon as the employee gets a category, it stops checking and moves on to the next employee.

1. If employee doesn't have any hours for the date range = No Worked Hours
2. What is the employee's last status entry in the date range if any? if the last status entry is Active = Hired
3. If the last status entry is “Suspension” status = Furloughed
4. If it's any other status entry = Separated
5. If the employee was in an agency company at the end of the date range = Contract
6. If the employee worked 390 or more hours in the date range = Full Time
7. If the employee worked lest then 390 hours in the date range = Part Time

Setup

For softwares that need this report - once the software is updated, create an hours pivot grid layout with the fields as pictured below. Make sure to use Employee Count instead of Hours. In a multi-facility software add Facility as the second column after Date Range. Save the layout with the 'HHS PRF' name. Once this is done, copy the pined response and just make sure to substitute the correct labor levels if they use 'Position' vs 'Department' and change the facility name.

Instructions for client

We updated your facility with a new report:

1. Prepare the positions/departments as Clinical vs Non-Clinical:

   Reports/Hours/Hours Pivot Grid

   Take off all filters (nothing should be in red), then on the Position/Department tab select only the clinical positions.

   On the options tab select the new layout file "HHS PRF".

   Save the report on the Save tab and give it a name something like "HHS PRF Clinical", Save, and close the popup.

   Repeat the above steps for the non-clinical positions/departments and save it as "HHS PRF Non-Clinical".

1. Get the Count for all 5 categories:

   Open your saved HHS PRF clinical report

   On the Date Range tab select correct Quarter

   click Run.

   After it opens, get the count for each category and fill it in on your report sheet.

1. Run the report again for the next Quarter etc. (the report should only be run for one quarter at a time. Selecting on the date range more than a quarter will give incorrect data).

1. Repeat the above for the HHS PRF Non-Clinical saved report.

Please note that this report will not give any furloughed employees. They will all be included in the 'Separated' category. If you know of any employees that were furloughed in any quarter then please manually deduct these employees from the 'Separated' category count.