|
2023 Payroll for Capital Area District Libraries (CADL) June 9, 2024
Two files with payroll data were provided to me in response to a Freedom of Information Act request, one on April 11 and one on April 22. Here are the files exactly as received. They are "spreadsheets" - Excel files. You can download them.
I made copies of the files and then sorted them in various sequences. The following are from the April 11 file. No download necessary.
The purpose of the April 22 report was to provide the components of Miscellaneous, since the April 11 report revealed that 30 employees had Miscellaneous over $10,000. The new report did that, but also included some other fields that are not, such as Retro Pay and Double Time pay. I suspect they are components of Regular Wages, not Miscellaneous. On this report, they serve only to confuse.
The April 22 file has so many columns that I could not display all of them across a web page, like I could with the April 11 file. In addition to employee name and ID number, it contained the columns listed below. I've linked to separate reports for all except Hourly and Earnings Totals.
"Hourly" in the April 22 report is a puzzle. It is not the same as Regular Wages in the April 11 report. Regular Wages includes Retro Pay; Hourly does not.
There is an Overtime column on both of the reports, but they are not the same. 58 employees have overtime on the April 11 report, while only 23 do on the April 22 report. For anyone who has overtime on both reports, the amounts are not the same.
Both files include multiple records for some employees - usually 2, rarely 3. Jenny says this is because the person worked more than one job during the year. The April 22 file contains more of these than the April 11 file and that is why it contains 315 records and the April 11 file contains 296. I compared them side-by-side here.
If there is anything that stands out in these reports, it is the payments received in 2023 by former executive director Scott Duimstra. He left on October 6, but did not retire - probably because he had not reached age 55. He got the biggest bonus, the fourth biggest holiday pay, the only merit increase payment ($5,000), the largest retro pay, the third largest vacation, and the third largest vacation payout.
Except for the merit increase, which looks like it was created especially for him, all these could have been legitimate. He worked there for 18 years and if he didn't take vacations, he could easily have accumulated $14,424 in vacation pay. Same for holiday. The thing about large payments at retirement (or in the last year) is that they increase FAC (final average compensation), a factor in the pension calculation, and therefore boost the pension.
The full story of my quest for CADL payroll info, including correspondence with CADL is here. |