| Consumer health inspection backlog of less than 700.CC-Code Compliance |
Analysis | |
Measure Definition & Importance |
The Consumer Health workload is a combination of scheduled monthly work and seasonal work. Each month a minimum number of inspections must be completed to ensure each business is inspected based on their risk of causing disease/illness. During the spring/summer additional work efforts are required, for example, mosquito disease prevention temporary event inspections. Additionally, the bulk of the public swimming pools and spas open during the summer months and must be inspected. Due to finite resources, priorities are shifted and a backlog of the monthly inspections due occurs annually. It is important to track this number to ensure we are being efficient with our resources. According to our calculations we should be able to address this ebb and flow in the work load with the staff that is assigned to Consumer Health.
Consumer health inspection backlog |
Service Areas |
-
CC.4.1 Plan Review, Permitting, & Health Inspections
CC-Code Compliance
Attachments |
Measure Data | Last Calculated 5 months ago |
| Period | | Status | Actual | Overall Target | High Variance (FY Target) | Low Variance |
|---|---|---|---|---|---|---|
| Oct-18 |  | On Target | 439.00 | 700.00 | 800.00 | |
| Nov-18 | | On Target | 430.00 | 700.00 | 800.00 | |
| Dec-18 | | On Target | 453.00 | 700.00 | 800.00 | |
| Jan-19 | | On Target | 504.00 | 700.00 | 800.00 | |
| Feb-19 | | On Target | 653.00 | 700.00 | 800.00 | |
| Mar-19 |  | Lagging | 786.00 | 700.00 | 800.00 | |
| Apr-19 |  | Insufficient Progress | 1,030.00 | 700.00 | 800.00 | |
| May-19 | | Insufficient Progress | 1,229.00 | 700.00 | 800.00 | |
| Jun-19 | | Insufficient Progress | 1,486.00 | 700.00 | 800.00 | |
| Jul-19 | | Insufficient Progress | 1,608.00 | 700.00 | 800.00 | |
| Aug-19 | | Insufficient Progress | 1,365.00 | 700.00 | 800.00 | |
| Sep-19 | | Insufficient Progress | 1,316.00 | 700.00 | 800.00 | |
| Oct-19 | | Insufficient Progress | 807.00 | 700.00 | 800.00 | |
| Nov-19 | | On Target | 521.00 | 700.00 | 800.00 | |
| Dec-19 | | On Target | 383.00 | 700.00 | 800.00 | |
| Jan-20 | | On Target | 196.00 | 700.00 | 800.00 | |
| Feb-20 | | On Target | 82.00 | 700.00 | 800.00 | |
| Mar-20 | | On Target | 134.00 | 700.00 | 800.00 | |
| Apr-20 | | Insufficient Progress | 950.00 | 700.00 | 800.00 | |
| May-20 | | Insufficient Progress | 1,786.00 | 700.00 | 800.00 | |
| Jun-20 | | Insufficient Progress | 2,341.00 | 700.00 | 800.00 | |
| Jul-20 | | Insufficient Progress | 2,450.00 | 700.00 | 800.00 | |
| Aug-20 | | Insufficient Progress | 2,671.00 | 700.00 | 800.00 | |
| Sep-20 | | Insufficient Progress | 2,649.00 | 700.00 | 800.00 | |
| Oct-20 | | Insufficient Progress | 2,471.00 | 700.00 | 800.00 | |
| Nov-20 | | Insufficient Progress | 2,236.00 | 700.00 | 800.00 | |
| Dec-20 | | Insufficient Progress | 2,067.00 | 700.00 | 800.00 | |
| Jan-21 | | Insufficient Progress | 2,050.00 | 700.00 | 800.00 | |
| Feb-21 | | Insufficient Progress | 1,650.00 | 700.00 | 800.00 | |
| Mar-21 | | Insufficient Progress | 1,625.00 | 700.00 | 800.00 | |
| Apr-21 | | Insufficient Progress | 1,518.00 | 700.00 | 800.00 | |
| May-21 | | Insufficient Progress | 1,638.00 | 700.00 | 800.00 | |
| Jun-21 | | Monitoring/No Info | 700.00 | 800.00 | ||
| Jul-21 | | Monitoring/No Info | 700.00 | 800.00 | ||
| Aug-21 | | Monitoring/No Info | 700.00 | 800.00 | ||
| Sep-21 | | Not Defined | 700.00 | 800.00 | ||
| Oct-21 | | Monitoring/No Info | ||||
| Nov-21 | | Monitoring/No Info | ||||
| Dec-21 | | Monitoring/No Info | ||||
| Jan-22 | | Not Defined | ||||
| Feb-22 | | Not Defined | ||||
| Mar-22 | | Not Defined | ||||
| Apr-22 | | Not Defined | ||||
| May-22 | | Not Defined | ||||
| Jun-22 | | Not Defined | ||||
| Jul-22 | | Not Defined | ||||
| Aug-22 | | Not Defined | ||||
| Sep-22 | | Not Defined |
Data Source Details & Calculation Information |
The data source for the backlog is in Sweeps. In Sweeps, click on the tab <Field>, then click on <Inspections Due Report>. Select the Sort buttons of the following Options in order of "Employee","Program","Inspection Freq" on the right side of the screen. Then select in <Sub-sort/Planned Inspection List>"Due Date". Ensure the <Status> is marked "A" for Active. Put the date for the end of the previous month in the <Ending Date> box. Ensure "Regular Inspections" and "Call-Backs" are selected with check marks. This report is saved as a PDF. Click on <Printer>, then select "PDF File", then select the location of where the file should be saved and name the file, click "open", then click OK. Then Click OK on the main screen. This report is obtained and monitored by a Consumer Health Supervisor. An excel spread sheet is kept monthly in the CH Supervisor folder.
Actual = # of inspections in backlog
Measure Type |
Performance Liaison |
| |
Data Owner |
Target Type |
Measure ID |
Performance Liaison Notes |