Spreadsheet: 875122d1721684991-pulling-data-from-a-weirdly-formatted-report-test
Sheet: Sheet1

pyLaborDist |  | Labor Distribution Report |  |  |  |  |  |  |  |  |  |  |  | Page: 1
7/1/2024   8:13:21AM |  | City of Union City
 | Month of June 2024
 | Account # |  | Employee # |  |  | Employee Name |  |  |  |  | Amount |  | Hours
Position Title: ADMINISTRATIVE ASSISTANT III - 50530-002
 | E 1110-5109-51009-51110 - Regular Pay |  | 04903 |  |  | MCCARTNETY, PAUL |  |  |  |  | 5988.18 |  | 128
 | E 1110-5109-51009-51115 - Overtime Pay |  |  |  |  |  |  |  |  |  | 803.98 |  | 11.6
 | E 1110-5109-51009-52110 - Medicare Tax |  |  |  |  |  |  |  |  |  | 87.55
 | E 1110-5109-51009-52111 - PERS |  |  |  |  |  |  |  |  |  | 622.78
 | E 1110-5109-51009-52112 - Health Insurance |  |  |  |  |  |  |  |  |  | 1613.2
 | E 1110-5109-51009-52113 - Workers Compensation |  |  |  |  |  |  |  |  |  | 74.69
 | E 1110-5109-51009-52115 - Disability Insurance |  |  |  |  |  |  |  |  |  | 10
 | E 2440-5109-51014-51110 - Regular Pay |  |  |  |  |  |  |  |  |  | 748.54 |  | 16
 | E 2440-5109-51014-51115 - Overtime Pay |  |  |  |  |  |  |  |  |  | 100.5 |  | 1.45
 | E 2440-5109-51014-52110 - Medicare Tax |  |  |  |  |  |  |  |  |  | 10.96
 | E 2440-5109-51014-52111 - PERS |  |  |  |  |  |  |  |  |  | 77.85000000000001
 | E 2440-5109-51014-52112 - Health Insurance |  |  |  |  |  |  |  |  |  | 201.67
 | E 2440-5109-51014-52113 - Workers Compensation |  |  |  |  |  |  |  |  |  | 9.35
 | E 2440-5109-51014-52115 - Disability Insurance |  |  |  |  |  |  |  |  |  | 1.25
 | E 2440-5109-51023-51110 - Regular Pay |  |  |  |  |  |  |  |  |  | 748.5 |  | 16
 | E 2440-5109-51023-51115 - Overtime Pay |  |  |  |  |  |  |  |  |  | 100.5 |  | 1.45
 | E 2440-5109-51023-52110 - Medicare Tax |  |  |  |  |  |  |  |  |  | 10.96
 | E 2440-5109-51023-52111 - PERS |  |  |  |  |  |  |  |  |  | 77.83
 | E 2440-5109-51023-52112 - Health Insurance |  |  |  |  |  |  |  |  |  | 201.63
 | E 2440-5109-51023-52113 - Workers Compensation |  |  |  |  |  |  |  |  |  | 9.35
 | E 2440-5109-51023-52115 - Disability Insurance |  |  |  |  |  |  |  |  |  | 1.25
 | Employee: MCCARTNEY, PAUL |  |  |  |  |  |  |  |  |  |  |  | 174.5
 |  |  |  |  |  |  |  |  |  |  | 11500.52
 | Position Title: ADMINISTRATIVE ASSISTANT III
 |  |  |  |  |  |  |  |  |  |  | 11500.52 |  | 174.5
Position Title: CASE MANAGER - 30090-003
 | E 1110-5109-51009-51110 - Regular Pay |  | 05131 |  |  | LENNON, [NAME] |  |  |  |  | 1907.86 |  | 43.2
 | E 1110-5109-51009-51115 - Overtime Pay |  |  |  |  |  |  |  |  |  | 167.7 |  | 2.57
 | E 1110-5109-51009-52110 - Medicare Tax |  |  |  |  |  |  |  |  |  | 29.34
 | E 1110-5109-51009-52111 - PERS |  |  |  |  |  |  |  |  |  | 198.42
 | E 1110-5109-51009-52112 - Health Insurance |  |  |  |  |  |  |  |  |  | 544.44
 | E 1110-5109-51009-52113 - Workers Compensation |  |  |  |  |  |  |  |  |  | 135.74
 | E 1110-5109-51009-52115 - Disability Insurance |  |  |  |  |  |  |  |  |  | 9.64
 | E 2440-5109-51012-51110 - Regular Pay |  |  |  |  |  |  |  |  |  | 1625.18 |  | 36.8
Position Title: CASE MANAGER - 30090-003  (Continued)
 | E 2440-5109-51012-51115 - Overtime Pay |  | 05131 |  |  | LENNON, [NAME] |  |  |  |  | 142.85 |  | 2.18
 | E 2440-5109-51012-52110 - Medicare Tax |  |  |  |  |  |  |  |  |  | 25
 | E 2440-5109-51012-52111 - PERS |  |  |  |  |  |  |  |  |  | 169.02
 | E 2440-5109-51012-52112 - Health Insurance |  |  |  |  |  |  |  |  |  | 463.78
 | E 2440-5109-51012-52113 - Workers Compensation |  |  |  |  |  |  |  |  |  | 115.63
 | E 2440-5109-51012-52115 - Disability Insurance |  |  |  |  |  |  |  |  |  | 8.23
 | E 2440-5109-51023-51110 - Regular Pay |  |  |  |  |  |  |  |  |  | 3533.1 |  | 80
 | E 2440-5109-51023-51115 - Overtime Pay |  |  |  |  |  |  |  |  |  | 310.56 |  | 4.75
 | E 2440-5109-51023-52110 - Medicare Tax |  |  |  |  |  |  |  |  |  | 54.35
 | E 2440-5109-51023-52111 - PERS |  |  |  |  |  |  |  |  |  | 367.44
 | E 2440-5109-51023-52112 - Health Insurance |  |  |  |  |  |  |  |  |  | 1008.28
 | E 2440-5109-51023-52113 - Workers Compensation |  |  |  |  |  |  |  |  |  | 251.37
 | E 2440-5109-51023-52115 - Disability Insurance |  |  |  |  |  |  |  |  |  | 17.88
 | Employee: LENNON, [NAME] |  |  |  |  |  |  |  |  |  |  |  | 169.5
 |  |  |  |  |  |  |  |  |  |  | 11085.81
 | E 1110-5109-51009-51110 - Regular Pay |  | 05044 |  |  | HARRISON, GEORGE |  |  |  |  | 3661.4 |  | 80
 | E 1110-5109-51009-51115 - Overtime Pay |  |  |  |  |  |  |  |  |  | 448.08 |  | 6
 | E 1110-5109-51009-52110 - Medicare Tax |  |  |  |  |  |  |  |  |  | 61.64
 | E 1110-5109-51009-52111 - PERS |  |  |  |  |  |  |  |  |  | 380.78
 | E 1110-5109-51009-52112 - Health Insurance |  |  |  |  |  |  |  |  |  | 146.7
 | E 1110-5109-51009-52113 - Workers Compensation |  |  |  |  |  |  |  |  |  | 268.75
 | E 1110-5109-51009-52115 - Disability Insurance |  |  |  |  |  |  |  |  |  | 18.28
 | E 2440-5109-51023-51110 - Regular Pay |  |  |  |  |  |  |  |  |  | 3661.38 |  | 80
 | E 2440-5109-51023-51115 - Overtime Pay |  |  |  |  |  |  |  |  |  | 448.08 |  | 6
 | E 2440-5109-51023-52110 - Medicare Tax |  |  |  |  |  |  |  |  |  | 61.65
 | E 2440-5109-51023-52111 - PERS |  |  |  |  |  |  |  |  |  | 380.8
 | E 2440-5109-51023-52112 - Health Insurance |  |  |  |  |  |  |  |  |  | 146.72
 | E 2440-5109-51023-52113 - Workers Compensation |  |  |  |  |  |  |  |  |  | 268.76
 | E 2440-5109-51023-52115 - Disability Insurance |  |  |  |  |  |  |  |  |  | 18.32
 | E 2450-5109-51025-51110 - Regular Pay |  |  |  |  |  |  |  |  |  | 366.14
 | E 2450-5109-51025-52110 - Medicare Tax |  |  |  |  |  |  |  |  |  | 5.32
 | E 2450-5109-51025-52113 - Workers Compensation |  |  |  |  |  |  |  |  |  | 23.96
 | Employee: HARRISON, GEORGE |  |  |  |  |  |  |  |  |  |  |  | 172
 |  |  |  |  |  |  |  |  |  |  | 10366.76
 | Position Title: CASE MANAGER
 |  |  |  |  |  |  |  |  |  |  | 21452.57 |  | 341.5
Position Title: CLINICAL SUPERVISOR - 20505-002
 | E 1110-5109-51009-51110 - Regular Pay |  | 05034 |  |  | STARR, RINGO |  |  |  |  | 9110.76 |  | 160
 | E 1110-5109-51009-52110 - Medicare Tax |  |  |  |  |  |  |  |  |  | 113.45
 | E 1110-5109-51009-52111 - PERS |  |  |  |  |  |  |  |  |  | 887.04
 | E 1110-5109-51009-52112 - Health Insurance |  |  |  |  |  |  |  |  |  | 1516.5
 | E 1110-5109-51009-52113 - Workers Compensation |  |  |  |  |  |  |  |  |  | 595.84
 | E 1110-5109-51009-52114 - Deferred Compensation |  |  |  |  |  |  |  |  |  | 92.3
 | Employee: STARR, RINGO |  |  |  |  |  |  |  |  |  |  |  | 160
 |  |  |  |  |  |  |  |  |  |  | 12315.89
 | Position Title: CLINICAL SUPERVISOR
 |  |  |  |  |  |  |  |  |  |  | 12315.89 |  | 160
 |  |  |  |  |  |  |  |  |  |  |  | Page: 5