| 85% of new hires successfully complete the probationary period.HR-Human Resources |
Analysis | |
The retention rate for this quarter has increased by 5%. This can be contributed to successful internal recruitment efforts in acquiring quality talent.
Measure Definition & Importance |
Regular, full-time and part-time general employees are in an initial probationary status for six months from the date of hire unless they are enrolled in the Police or Fire Training Academy. During their probationary period, the new employee determines whether he or she can perform the duties of the job. Likewise, the City determines whether the employee can perform assigned tasks satisfactorily and whether the employee complies with work rules and regulations. With this performance indicator, we are measuring the percentage of new hires successfully completing their 6 month probationary period. If employees are successfully completing their probationary period, we have confirmation that Talent Acquisition and hiring departments are successfully recruiting qualified new hires. If probationary periods are not successfully completed, there may be reason to review the hiring process. This year we are targeting an 85% success rate.
% of new hires who complete probationary period (YOY) |
# Employees Originally Hired vs. # Employees Still Employed |
Linked Objects |
-
HR.5.1 Recruitment Processing
HR-Human Resources
Attachments |
Measure Data | Last Calculated a month ago |
| Period |  | Status | FYTD Actual | Actual | # still employed | # originally hired | Overall Target | High Variance (FY Target) | Low Variance |
|---|---|---|---|---|---|---|---|---|---|
| Aug-16 |  | Monitoring/No Info | 88.56% | ||||||
| Q1-FY2017 | | On Target | 87.08% | 0.87 | 182.00 | 209.00 | 85.00 | 65.00 | |
| Q2-FY2017 | | On Target | 91.36% | 0.97 | 167.00 | 173.00 | 85.00 | 65.00 | |
| Q3-FY2017 | | On Target | 89.28% | 0.87 | 267.00 | 308.00 | 85.00 | 65.00 | |
| Q4-FY2017 | | On Target | 87.07% | 0.81 | 212.00 | 261.00 | 85.00 | 65.00 | |
| Q1-FY2018 | | On Target | 76.89% | 0.77 | 193.00 | 251.00 | 85.00 | 65.00 | |
| Q2-FY2018 | | On Target | 77.17% | 0.78 | 145.00 | 187.00 | 85.00 | 65.00 | |
| Q3-FY2018 | | On Target | 81.04% | 0.87 | 269.00 | 311.00 | 85.00 | 65.00 | |
| Q4-FY2018 | | On Target | 82.62% | 0.88 | 201.00 | 229.00 | 85.00 | 65.00 | |
| Q1-FY2019 | | On Target | 80.59% | 0.81 | 303.00 | 376.00 | 85.00 | 65.00 | |
| Q2-FY2019 | | On Target | 77.60% | 0.71 | 130.00 | 182.00 | 85.00 | 65.00 | |
| Q3-FY2019 | | On Target | 77.34% | 0.77 | 161.00 | 210.00 | 85.00 | 65.00 | |
| Q4-FY2019 | | On Target | 80.23% | 0.91 | 181.00 | 198.00 | 85.00 | 65.00 | |
| Q1-FY2020 | | On Target | 83.95% | 0.84 | 293.00 | 349.00 | 85.00 | 65.00 | |
| Q2-FY2020 | | On Target | 82.62% | 0.81 | 244.00 | 301.00 | 85.00 | 65.00 | |
| Q3-FY2020 | | On Target | 82.70% | 0.83 | 228.00 | 275.00 | 85.00 | 65.00 | |
| Q4-FY2020 | | On Target | 83.08% | 0.84 | 261.00 | 310.00 | 85.00 | 65.00 | |
| Q1-FY2021 | | On Target | 75.61% | 0.76 | 31.00 | 41.00 | 85.00 | 65.00 | |
| Q2-FY2021 | | On Target | 77.01% | 0.77 | 113.00 | 146.00 | 85.00 | 65.00 | |
| Q3-FY2021 | | On Target | 82.03% | 0.85 | 235.00 | 275.00 | 85.00 | 65.00 | |
| Q4-FY2021 | | On Target | 85.37% | 0.90 | 286.00 | 317.00 | 85.00 | 65.00 | |
| Q1-FY2022 | | Monitoring/No Info | |||||||
| Q2-FY2022 | | Monitoring/No Info | |||||||
| Q3-FY2022 | | Monitoring/No Info | |||||||
| Q4-FY2022 | | Monitoring/No Info |
Data Source Details & Calculation Information |
Step Instructions
1 Run Z_PY_TERMINATED_EES_LIST query for the following effective dates: July 1, 2015 - March 31, 2016
2 Rename tab in excel work book, "Term Query".
3 Sort information by "DESCR" column.
4 Eliminate all rows with "Invol - Complete Temp Emplymnt" as their DESCR.
5 Add new column between "Start Date" and "Last Start Date". Title it "6 Month Probation Ends".
6 Enter the following equation to the cell below the new heading to calculate when employees' 6 month probation ends: =edate(select corresponding start date cell,6)
7 Copy the equation all the way down to the last cell with an active row
8 Sort information of "6 Month Probation Ends" by "Newest to Oldest". If asked to expand sort, select yes.
9 Remove all rows that do not have a "6 Month Probation Ends" date between January 1, 2016 and March 31, 2016.
10 Compare "Term Date" to "6 Month Probation Ends" date to determine if employees completed 6 months of employment before being terminated.
11 I chose to highlight "Term Date" cells green, if employees did NOT make it.
12 Create new tap in excel work book and title it "New Hire Query".
13 Run Z_NEWHIES_FOR_RECRUITMENT3 query for the following effective dates: July 1, 2015 - September 30, 2015
14 Copy and paste the results of this query into the newly created tab.
15 Sort information by "Reg/Temp"
16 Remove all rows with "Temp" status.
17 Add new column between "Eff Date" and "Action". Title the new column: "6 Month Probation Ends".
18 Enter the following equation to the cell below the new heading to calculate when employees' 6 month probation ends: =edate(select corresponding start date cell,6)
19 Copy the equation all the way down to the last cell with an active row
20 Sort information of "6 Month Probation Ends" by "Newest to Oldest". If asked to expand sort, select yes.
21 Remove all rows that do not have a "6 Month Probation Ends" date between January 1, 2016 and March 31, 2016.
Note: All employees in this query should have a probation period ending in the desired quarter, because of the effective dates we used. Therefore, instruction in grey above may be removed unless used as a safeguard.
22 Reference the excel row heading number of the last employee/active cell and subtract two for the headings at the top of the spreadsheet to determine the number of new hires in this quarter.
23 All reports are saved in the Staffing Services (AS141) Shared folder labeled
"Performance Measures" Select the Performance Measure Folder "6 Months"
Select or Create a folder for current fiscal year. For example, "FY 2016 , FY 2015, FY 2014, etc."
Save the spreadsheet in the fiscal year folder
(Staffing_Services (AS141) folder -> Perfomance Measures -> "Select Fiscal Year Needed" ->
Select Performance Measure Folder (ie, 6 Months);
-> Select Quarter (FY 2016 - Qrt. 1))
24 ∙Overall Target (NA)
∙High Variance (FY Target): = 85%
∙Low Variance = 65%
Measure Type |
Performance Liaison |
| CA | Courtney August (HR- Human Resources) |
Measure ID |
304487
Administrator Notes |