|
City of Lansing 2023 Payroll Introduction
The following information comes from a report prepared by the City's internal auditor. It provides detail on all payments made to employees and retirees in 2023.
The Internal Auditor report has additional detail that I did not include here. It has breakdowns of regular pay, overtime, miscellaneous and buyout. For example, the components of buyout pay are as follows:
This detail can be seen only in the original report. You can download that report here.
The Internal Auditor report has 3353 lines of data (records). 1792 are for retirees, 1116 are for employees who received wages in 2023 (above), 432 are for TEA LEADER/TEA SPORTS OFFICIALs which includes multiple detail lines for most of 127 employees, and 14 are for former employees who took a refund of their retirement accounts. If an employee retired during 2023, he may have both an active employee record and a retiree record (he won't if he took a deferred retirement in a previous year.)
A note at the top of the report says that if the employee has multiple positions in calendar year, they will have more than one row of data with the total duplicated in amount and not prorated between positions. The only employees I can see who have multiple positions are the TEA LEADER/TEA SPORTS OFFICIAL employees:
Of the 1776 retiree records, 70 have "separation" dates, which I am assuming is the date of death. Most of those dates are in 2022 with a few in late 2021 and early 2023.
That leaves 1792 retirees who are still receiving pensions. The same column headings used for active employees were also used for retirees, which is kind of confusing. "Position" is really the system the person retired from - either Police and Fire (P&F) or the Employees Retirement System (ERS). "Hire Date" seems to be the effective date of the pension. "Hourly Wage" seems to have no meaning at all for retirees. And "Regular Pay" is the total of pension payments received in 2022. "Total" seems to the same as "Regular Pay" except when "Miscellaneous" is present.
Here are the employees who quit and took refunds of their retirement accounts:
How this information was obtained
I've published City of Lansing payroll information for 5 different calendar years, this time for the year2023. Here are links to the previous years: All were provided in response to FOIA requests. There was difficulty early on, but in the battle for the 2021 payroll in 2022, it was discovered that there was a report designed by the Internal Auditor that more than met my needs. This year, I got it in 6 days.
The report looks nothing like what you see here; I spend hours sorting and reformatting the data to reveal what I think might be interesting. You can download the original Excel file here.
If you see any errors or have any questions, email me at stevenrharry@gmail.com or call or text me at 517-730-2638. |