Question: Can you provide a list of vacancies that have been open for more than a year? (Councilman Chapman)
Response:
Attached is a list of 123 full-time vacancies and 17 part-time vacancies that have been open for more than one year. The data presented is from MUNIS payroll and position records, both of which are updated bi-weekly. We have identified vacant positions by comparing employee payroll data with the position dataset to find position codes without a corresponding employee identification number. The data last updated February 28, 2025, so we have made March 1, 2025, the effective date from which we calculated one year. Additional methodology information can be found below.
Vacant Position Identification Methodology: A current position is considered vacant under two circumstances: 1) the most recent employee attached to the position code has a termination date or 2) the most recent employee attached to the position code has more recently been paid under a different position code (generally if there was a transfer or promotion). We have assumed in the latter situation that if the position code is still active, the department plans to refill the position, and therefore, it is vacant. New positions are also considered vacant if there has never been an employee attached to the position code. New positions are added to the MUNIS position dataset once departments submit a personnel action form (PAF).
Time Vacant Calculation Methodology: When the previous employee in the position left the City, time vacant is calculated from the previous incumbent's termination date to March 1, 2025. For empty positions due to transfer or promotion, time vacant is calculated from the last date of the incumbent's final pay period in that position. This means there may be up to two weeks (14 days) time-vacant-calculation error for positions left vacant by promotions or internal transfers. Positions that have never had an incumbent attached (in most cases a new position) are tracked from the last new record created for that position, which generally indicates that a position has been activated or reclassified.
Attachments:
Attachment 1 Long-term Vacancy List