Public Policy
  Analysis, opinion & ideas from Steve Harry

Directory

About/Contact

Wage transparency at CATA

March 14, 2019

 

In an effort to be open about wages, CATA (the Capital Area Transportation Authority) has provided on its website a downloadable list of employees who earned more than $100,000 in 2018. Here it is:

 

 

To provide a little more transparency, I obtained full payroll data from CATA for 2018 for all employees. I divided it by department and present it below as 3 separate lists:

Maintenance

Operations (3 pages)

Executive and other departments

Most of the information comes directly from an Excel file provided by CATA. I added two items. One is the annualized salary, which I calculated from the pay rate. Pay rates in the CATA file are either hourly or weekly. I multiplied the hourly rates by 2080 (40 x 52) and the weekly rates by 52. The other added item is "Difference" - the annualized amount subtracted from the gross pay for 2018. My hope was that amount would show pay received over and above regular salary, such as overtime.

 

On January 22, 2019, I sent a FOIA request to CATA asking for 2018 salary information. I requested the same information I asked for in 2017 for the 2016 year:

Name

Department

Position/job title

Union affiliation

Salary/hourly rate

Date hired

Date terminated

Breakdown of 2016 earnings by category

Final leave payment (for terminations)

Total earnings for 2016

I asked for digital files.

 

Before I got a response - on February 4 - an opinion piece by CATA CEO Brad Funkhouser and a story by reporter Megan Banta appeared in the print edition of the Lansing State Journal.

 

A few days later, I got a thumb drive and a letter from the CATA FOIA coordinator in the mail. The letter said my request was denied. "Your request for records would require CATA to make a compilation or report of information and, thus, a new public record." They did provide free of charge a PDF file listing all CATA employees by group, and it included 2018 wages and pay rate. This file was completely worthless to me because I wanted the data in a form that would allow me to sort and do calculations. I emailed Brad Funkhouser and said I didn't understand why they couldn't give me what I asked for. Was this something their IT staff was incapable of providing? I said I wanted exactly what I asked for in my FOIA request, including a full breakdown of 2018 wages for each employee, and if they couldn't do that, he should let me know and I would appeal to the CATA board.

 

On February 14, I got an email from an attorney representing CATA. He wanted clarification of what I meant by "digital" files. After a few email exchanges, I agreed to pay $193.12 to get the files I wanted. I got the file by snail mail on March 9, on a thumb drive. Click here to download that Excel file.

 

The breakdown of wages I requested went way beyond what I had expected. For each employee, there are 143 possible types of payment, and the headings aren't very helpful. (At my request, CATA has provided this key to pay codes.) For any one employee, amounts are present for only a few pay types. For example, for Brian Gould, the mechanic in the maintenance department with the highest earnings for the year, regular earnings and overtime earnings are zero. But he does have amounts for these pay types:

 
 

100_ST - Mechanic_earnings

49,880.08

 
 

101_OT - Mechanic_earnings

44,660.80

 
 

102_DT - Mechanic_earnings

17,555.27

 
 

121_OT - Maint Utility_earnings

32.91

 
 

400_National Holiday-ATU_earnings

1,891.52

 
 

401_National Holiday-ADM_earnings

945.76

 
 

409_ATU Paid Vacation_earnings

14,067.22

 
 

445_Lumpsumpay_earnings

1,000.00

 
 

BON_Incentive Pay_earnings

2,000.00

 
 

TOTAL:   

132,033.56

 

 

For Scott Spicer, the operator (bus driver) with the highest earnings, regular earnings and overtime earnings are zero, just like with Gould. Here are pay types for which he has amounts:

 
 

10_ST - Linehaul_earnings

37,809.96

 
 

11_OT - Linehaul_earnings

28,073.20

 
 

12_DT - Linehaul_earnings

10,180.37

 
 

13_ST - Special Service_earnings

1,717.60

 
 

14_OT - Special Service_earnings

1,460.51

 
 

15_DT - Special Service_earnings

298.32

 
 

150_ST - Holdover_earnings

421.82

 
 

151_OT - Holdover_earnings

615.25

 
 

152_DT - Holdover_earnings

137.67

 
 

20_ST - SpecTran_earnings

2,352.58

 
 

21_OT - SpecTran_earnings

2,427.96

 
 

22_DT - SpecTran_earnings

1,624.03

 
 

30_ST - Protection_earnings

5,171.34

 
 

31_OT - Protection_earnings

5,980.35

 
 

32_DT - Protection_earnings

3,978.50

 
 

400_National Holiday-ATU_earnings

1,493.36

 
 

401_National Holiday-ADM_earnings

634.56

 
 

409_ATU Paid Vacation_earnings

10,845.62

 
 

445_Lumpsumpay_earnings

1,000.00

 
 

50_ST - Training OFRS_earnings

211.52

 
 

51_OT - Training OFRS_earnings

46.40

 
 

70_ST - Delhi_earnings

466.41

 
 

71_OT - Delhi_earnings

337.14

 
 

73_ST - Lot Link_earnings

211.52

 
 

74_OT - Lot Link_earnings

99.15

 
 

75_DT - Lot Link_earnings

845.37

 
 

76_ST - Meridian_earnings

1,454.64

 
 

77_OT - Meridian_earnings

413.87

 
 

80_ST - Night Owl_earnings

849.98

 
 

81_OT - Night Owl_earnings

6.88

 
 

82_DT - Night Owl_earnings

638.64

 
 

BON_Incentive Pay_earnings

2,000.00

 
 

TOTAL:   

123,804.52

 

 

Here is CEO Brad Funkhouser's breakdown:

 
  Regular Earnings Total 178,115.48  

 

260_ST - Executive Ofc_earnings

188.48

 

 

506_Auto Allowance_earnings

115.38

 
 

BON_Incentive Pay_earnings

8,307.70

 
 

TOTAL:   

186,727.04

 

 

And here is former CEO Sandra Dragoo's breakdown. Her termination date was 3/1/2018.

 
 

Regular Earnings Total

31,744.35

 

 

260_ST - Executive Ofc_earnings

2,116.29

 

 

403_Floating Holiday-ADM_earnings

2,821.76

 
 

420_Vaca Adm_earnings

21,163.20

 
 

422_30yrsvacadm_earnings

52,908.00

 
 

BON_Incentive Pay_earnings

2,116.32

 
 

VPO_Vac Payout_earnings

10,581.60

 
 

TOTAL:   

123,451.52

 

 

Send comments, questions, and tips to stevenrharry@gmail.com, or call or text me at 517-505-2696. If you'd like to be notified by email when I post a new story, let me know.

 

Previous stories