Spill Cleans Report Description

Permissions Required

You must have one of the following permissions to generate this report:

Run Any Reports, Including Those that Reveal Patient Information
Run Only Reports That Do Not Reveal Patient Information

Purpose

The Spill Cleans report shows totals and averages related to spill cleaning jobs. Data is displayed either by bed cleaner or by cost center. This report can help you to determine the areas that have had the most spill cleaning jobs, how many spill cleaning jobs have been completed or cancelled per cost center or per bed cleaner, and the time it took to respond to and complete spill cleaning jobs.

Note: See About the Report Data for restrictions related to the data that appears on the report.

Report Parameters

Criteria selected when the report was being generated appear under Report Parameters. An example is the name of the campus selected when the report was generated.

About the Report Data

Only completed or cancelled spill cleaning jobs for beds that are associated with the BedTracking® application and that are within the membership of the user who generated the report are included.
Only spill cleaning jobs that were completed or cancelled within the selected date range and shift appear on the report. However, if a shift starts on the end date of the report date range and ends on the next day, data from the entire shift will be included on the report. For example, if the end date of the report is September 2, 2012, and a shift started at 11:00 PM on September 2 and ended at 7:00 AM on September 3, then data from the entire shift, including the part on September 3, will be on the report.
The report can be grouped by bed cleaner name or by cost center. If it is grouped by bed cleaner, bed cleaners' names are listed with information about the spill cleaning jobs they completed or cancelled underneath. If the report is grouped by cost center, then cost centers are listed with details about the spill cleaning jobs completed or cancelled within those cost centers. However, grouping is not in effect if the report is in Microsoft Excel-Unformatted format.
If No was selected for Summary View?, then details about individual jobs appear. If Yes was selected for Summary View?, then counts and averages are listed per cost center or per bed cleaner. However, details about locations, times, and requesters do not appear.
The report is sorted in ascending or descending chronological order by the date and time that spill clean jobs were requested or in ascending or descending numerical order by the IVR ID of the beds associated with the spill cleaning job. However, sorting is not in effect if the report is in Microsoft Excel-Unformatted format.

Detailed Spill Clean Report Column Descriptions (.pdf and Microsoft Excel output)

The following information appears in the columns on the detailed Spill Clean report in .pdf or Microsoft Excel format.

This column...	Displays...
Bed ID	The IVR ID code of the bed associated with the spill cleaning job.
Spill Type	The spill type associated with the job (such as Blood, Water, Beverages, or Food).
Request Date and Request Time	The date and time that the job was requested. Dates are in DD/MM/YYYY format (for example, 01/11/2011 for November 1, 2011). Times are in hh:mm AM/PM format (for example, 07:30 AM).
Completed Time	The time that the spill cleaning job was completed. Times are in hh:mm AM/PM format (for example, 07:50 AM). If the job was cancelled, then this column is blank.
Response Time	Amount of time between when the job was created and when the employee started working on it. The time that the employee started working on the job is the time that the Spill In Progress status started. Time is in hh:mm:ss format (for example, 00:10:30 for 10 minutes and 30 seconds).
Clean Time	Amount of time between the employee started working on the job and when it was completed. The time that the employee started working on the job is the time that the Spill In Progress status started. The time it was completed is when the Completed status started. Time is in hh:mm:ss format (for example, 00:05:30 for 5 minutes and 30 seconds).
Turn Time	Amount of time taken to both respond to and complete a job (Response time + Clean time). Time is in hh:mm:ss format (for example, 00:15:30 for 15 minutes and 30 seconds).
Bed Cleaner	EVS bed cleaner who received credit for the job.
Requested by	The user who requested the spill cleaning job. For a found spill cleaning job, the name of the bed cleaner who put the job in progress appears.
Canceled Time	The time that the spill cleaning job was cancelled. Times are in hh:mm AM/PM format (for example, 07:40 AM). If the job was not cancelled, then this column is blank.
Canceled by	The name of the user who cancelled the job. The spill clean job might have been cancelled because the bed was marked as unclean and a cleaning job request was created. If the bed cleaning job was created by an ADT transaction, then the column displays "Interface." If the bed cleaning job was created by a transport job, then the column displays the name of the transporter who completed the transport job. For a found bed cleaning job, the column displays the bed cleaner who found the bed and completed the job.

Group Summary on Detailed Spill Clean Report Column Descriptions (.pdf and Microsoft Excel output)

For each bed cleaner name and IVR ID or each cost center abbreviation, the following information appears:

This...	Displays...
Spill Type	The type of item that was spilled and was to be cleaned during this spill cleaning job (for example, Blood, Water, Bodily Fluids).
Requested	For each spill type and for all spill types as a group, the number of spill cleaning jobs requested.
Cleaned	For each spill type and for all spill types as a group, the number of spill cleaning jobs that were completed.
Canceled	For each spill type and for all spill types as a group, the number of spill cleaning jobs canceled.
Avg Response	Average time taken to respond to a spill cleaning job request for this cost center or this bed cleaner. Found spill cleaning jobs are excluded from calculations. If a job is cancelled after the In Progress status starts, then the amount of time from when the job was requested to when the status changed to In Progress will be included in the calculation.
Avg Clean	Average time taken to complete the spill cleaning job. Completed found spill cleaning jobs are included in the calculation. Canceled found spill cleaning jobs are excluded.
Avg Turn	Average time taken on a spill cleaning job from request to completion. Found spill cleaning jobs are excluded from calculations.

Report Summary on Detailed Spill Clean Report Column Descriptions (.pdf and Microsoft Excel output)

The following information appears about all spill cleaning jobs on the report.

This...	Displays...
Requested	Total number of spill cleaning jobs requested in all cost centers included on the report.
Cleaned	Total number of spill cleaning jobs that were completed in all cost centers included on the report.
Canceled	Total number of spill cleaning jobs that were canceled in all cost centers included on the report.
Avg Response	Average time taken to respond to a spill cleaning job request for all spill cleaning jobs included on the report. Found spill cleaning jobs are excluded from calculations. If a job is cancelled after the In Progress status starts, then the amount of time from when the job was requested to when the status changed to In Progress will be included in the calculation.
Avg Clean	Average time taken to complete the spill cleaning jobs included on the report. Completed found spill cleaning jobs are included in the calculation. Canceled found spill cleaning jobs are excluded.
Avg Turn	Average time taken on spill cleaning job from request to completion. Found spill cleaning jobs are excluded from calculations.

Summary Spill Clean Report Description (.pdf and Microsoft Excel output)

The following information appears on the report in Microsoft Excel-Unformatted output.

This column...	Displays...
Bed ID	The IVR ID code of the bed associated with the spill cleaning job.
Spill Type	The spill type associated with the job (such as Blood, Water, Beverages, or Food).
Request Date and Request Time	The date and time that the job was requested. Dates are in DD/MM/YYYY format (for example, 01/11/2011 for November 1, 2011). Times are in hh:mm AM/PM format (for example, 07:30 AM).
Completed Time	The time that the spill cleaning job was completed. Times are in hh:mm AM/PM format (for example, 07:50 AM). If the job was cancelled, then this column is blank.
Response Time	Amount of time between when the job was created and when the employee started working on it. The time that the employee started working on the job is the time that the Spill In Progress status started. Time is in hh:mm:ss format (for example, 00:10:30 for 10 minutes and 30 seconds).
Clean Time	Amount of time between the employee started working on the job and when it was completed. The time that the employee started working on the job is the time that the Spill In Progress status started. The time it was completed is when the Completed status started. Time is in hh:mm:ss format (for example, 00:05:30 for 5 minutes and 30 seconds).
Turn Time	Amount of time taken to both respond to and complete a job (Response time + Clean time). Time is in hh:mm:ss format (for example, 00:15:30 for 15 minutes and 30 seconds).
Bed Cleaner	EVS bed cleaner who received credit for the job.
Requested by	The user who requested the spill cleaning job. For a found spill cleaning job, the name of the bed cleaner who put the job in progress appears.
Canceled Time	The time that the spill cleaning job was cancelled. Times are in hh:mm AM/PM format (for example, 07:40 AM). If the job was not cancelled, then this column is blank.
Canceled by	The name of the user who cancelled the job. The job might have been cancelled because the bed associated with the job was marked unclean and a bed cleaning request was created. If the bed cleaning job was created by an ADT transaction, then the column displays "Interface." If the bed cleaning job was created by a transport job, then the column displays the name of the transporter who completed the job. For a found bed cleaning job, the column displays the bed cleaner who found the bed and completed the job.

Detailed Spill Clean Report Column Descriptions (Microsoft Excel-Unformatted output)

The following information appears in the columns on the detailed Spill Clean report in Microsoft Excel-Unformatted output.

This column...	Displays...
Cost Center	Abbreviation of the cost center associated with the spill cleaning job. The same cost center can be listed multiple times.
Bed ID	The IVR ID code of the bed associated with the spill cleaning job.
Spill Type	The spill type associated with the job (such as Blood, Water, Beverages, or Food).
Request Time	The date and time that the job was requested. Dates are in DD/MM/YYYY format (for example, 01/11/2011 for November 1, 2011). Times are in 24-hour format (for example, 15:30 for 3:30 PM).
Completed Time	The time that the spill cleaning job was completed. Times are in 24-hour format (for example, 15:50 for 3:50 PM). If the job was cancelled, then this column is blank.
Response Time (Minutes)	Amount of time between when the job was created and when the employee started working on it. The time that the employee started working on the job is the time that the Spill In Progress status started. Time is in minutes (for example, 10.5 is 10 and a half minutes).
Clean Time	Amount of time between the employee started working on the job and when it was completed. The time that the employee started working on the job is the time that the Spill In Progress status started. The time it was completed is when the Completed status started. Time is in minutes (for example, 5.5 is 5 and a half minutes).
Turn Time	Amount of time taken to both respond to and complete a job (Response time + Clean time). Time is in minutes (for example, 15.5 is 15 and a half minutes).
Bed Cleaner	EVS bed cleaner who received credit for the job.
Requested by	The user who requested the spill cleaning job. For a found spill cleaning job, the name of the bed cleaner who put the job in progress appears.
Canceled Time	The time that the spill cleaning job was cancelled. Times are in 24-hour format (for example, 15:40 for 3:40 PM). If the job was not cancelled, then this column is blank.
Canceled by	The name of the user who cancelled the job. The job might have been cancelled because the bed associated with the job was marked unclean and a bed cleaning request was created. If the bed cleaning job was created by an ADT transaction, then the column displays "Interface." If the bed cleaning job was created by a transport job, then the column displays the name of the transporter who completed the transport job. For a found bed cleaning job, the column displays the bed cleaner who found the bed and completed the job.