Trending Report, NCCSIF
Workers’ Compensation Trending Report for City of Placerville January 2018
Trending Report: City of Placerville 2012-2017
Claim Type by Fiscal Year 14 12 10 8 6 4 2 0
2012-2013
2013-2014
2014-2015
2015-2016
2016-2017
First Aid
0
2
2
2
1
Indemnity
3
3
3
3
2
Medical Only
5
7
6
8
5
Total
8
12
11
13
8
14 12 10 8 6 4 2 0
Total Paid and Incurred by Fiscal Year $70,000
14
$60,000
12
$50,000
10
$40,000
8
$30,000
6
$20,000
4
$10,000
2
$0
2012-2013
2013-2014
2014-2015
2015-2016
2016-2017
Total Paid
$14,033
$10,058
$13,309
$8,882
$29,581
Incurred
$61,511
$38,428
$28,563
$46,838
$56,765
8
12
11
13
8
Total Claims
0
2
Trending Report: City of Placerville 2012-2017
Total Paid During Fiscal Year Regardless of Date of Injury $350,000 $300,000 $250,000 $200,000 $150,000 $100,000 $50,000
$0
2012-2013
2013-2014
2014-2015
2015-2016
2016-2017
Medical Payment
$191,523
$14,916
$111,978
$114,557
$107,780
Indemnity Payment
$63,707
$28,113
$23,282
$128,608
$65,227
Expense Payment
$32,313
$28,643
$33,361
$17,157
$41,764
Total Recoveries During Fiscal Year Regardless of Date of Injury $300,000 $250,000 $200,000 $150,000 $100,000 $50,000 $0 Recoveries
2012-2013
2013-2014
2014-2015
2015-2016
2016-2017
$112,195
$15,096
$273,987
$45,138
$92,657
3
Trending Report: City of Placerville 2012-2017
Loss Days for Date of Injury within Fiscal Year 80 60 40 20
0
2012-2013
2013-2014
2014-2015
2015-2016
2016-2017
Loss Days
3
6
30
0
67
Total Claims
8
12
11
13
8
14 12 10 8 6 4 2 0
Closing Ratio by Fiscal Year 30
250%
25
200%
20
150%
15 100%
10
50%
5
0
2012-2013
2013-2014
2014-2015
2015-2016
2016-2017
Open
8
12
11
13
8
Closed
10
13
13
25
11
Ratio
125%
108%
118%
192%
138%
0%
4
Trending Report: City of Placerville 2012-2017
Top 6 Cause of Injury FY 2012-2017 7 6 5 4 3 2 1 0
Frequency Severity
$140,000 $120,000 $100,000 $80,000 $60,000 $40,000 $20,000 $0
CUT, PUNCTURED, SCRAPED
FELLOW WORKER, OTHER
ANIMAL OR INSECT
PERSON IN ACT OF CRIME
STRAIN
CUMULATIVE TRAUMA
6
6
5
4
4
4
$2,883
$1,567
$556
$25,315
$76,329
$114,801
Top 6 Part of Body Injured FY 2012-2017 9 8 7 6 5 4 3 2 1 0
Frequency Severity
$90,000 $80,000 $70,000 $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 $0
LOWER BACK
KNEE
MULTIPLE BODY PARTS
FINGER(S)
HAND
WRIST
8
5
4
4
4
1
$76,264
$77,372
$26,684
$1,065
$1,568
$49,741
5
Trending Report: City of Placerville 2012-2017
Top 5 Nature of Injury FY 2012-2017 20
$120,000
$100,000
15
$80,000
10
$60,000 $40,000
5
$20,000
0
Frequency Severity
STRAIN
CONTUSION
CUMULATIVE TRAUMA
LACERATION
CARPAL TUNNEL SYNDROME
18
5
4
3
1
$62,453
$73,248
$106,390
$1,291
$49,741
$0
Top 6 Occupation of Injury FY 2012-2017 20 18 16 14 12 10 8 6 4 2 0
Frequency Severity
$100,000 $90,000 $80,000 $70,000 $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 $0
Police Officer
Police Sgt
Lifeguard
Traffic Maint
Meter Repair Tech
Building Official
18
6
3
3
2
1
$88,411
$92,600
$1,368
$4,848
$27,820
$34,817
6
Trending Report: City of Placerville 2012-2017
Top 10 Claims 2012-2017 Claim
Department
DOI
Injury
Status
Paid
Incurred
NCWA-556918 POLICE
1/11/2016 Twisted right knee during O foot pursuit
$56,721
$67,275
NCWA-556942 POLICE
2/23/2016 Cumulative trauma to left O wrist 7/15/2016 Cumulative trauma to low O back
$25,664
$49,741
$24,725
$41,330
9/10/2013 Hearing loss from noise O exposure 9/17/2013 Cumulative trauma to low O back 9/12/2012 Left wrist/arm injured after C being dragged by a vehicle trying to escape 3/27/2014 Shoulder strain from C refilling jug of water 1/15/2015 Hit head while using a C crow bar 8/8/2016 Twisted knee while O patrolling bike path 1/13/2016 Stress C
$6,293
$34,817
$18,174
$27,084
$24,805
$24,805
$18,164
$18,164
$9,697
$9,697
$1660
$6,939
$6,329
$6,329
NCWA-557094 POLICE NCWA-556000 COMMUNITY DEVELOPMENT NCWA-556033 PUBLIC WORKS NCWA-555580 POLICE
NCWA-556238 POLICE NCWA-556533 PUBLIC WORKS NCWA-557124 POLICE NCWA-556899 ADMINISTRATIVE SERVICES
7
Trending Report: City of Placerville 2012-2017
Departments FY 2012-2017
Department
Frequency
Severity
Average
ADMINISTRATIVE SERVICES
4
$6,562
$1,641
COMMUNITY DEVELOPMENT
2
$37,090
$18,545
PARKS & RECREATION
12
$4,950
$413
POLICE
27
$221,348
$8,198
PUBLIC WORKS
9
$43,118
$4,791
WASTEWATER TREATMENT
2
$4,318
$2,159
SEWER
2
$5,109
$2,554
8
Trending Report: City of Placerville 2012-2017
NCCSIF Members FY 2012-2017
NCCSIF Member
Frequency
Severity
Average
City of Anderson
52
$1,191,513
$22,914
City of Auburn
64
$824,717
$12,886
City of Colusa
18
$166,871
$9,271
City of Corning
38
$76,910
$2,024
City of Dixon
68
$2,092,554
$30,773
City Of Elk Grove
204
$3,317,361
$16,262
City of Folsom
376
$4,584,519
$12,193
City of Galt
138
$1,497,372
$10,851
City of Gridley
23
$110,749
$4,815
City of Ione
13
$43,611
$3,355
City of Jackson
23
$1,043,607
$45,374
9
Trending Report: City of Placerville 2012-2017
NCCSIF Members FY 2012-2017
NCCSIF Member
Frequency
Severity
Average
City of Lincoln
80
$1,230,117
$15,376
City of Marysville
47
$919,837
$19,571
City of Nevada City
33
$496,491
$15,045
City of Oroville
63
$1,687,065
$26,779
City of Placerville
58
$322,495
$5,560
City of Red Bluff
81
$1,544,819
$19,072
City of Rio Vista
21
$195,102
$9,291
City of Rocklin
176
$2,396,628
$13,617
City of Willows
21
$583,023
$27,763
City of Yuba City
218
$4,082,750
$18,728
Town of Paradise
60
$1,502,521
$25,042
10
Trending Report: City of Placerville 2012-2017
Claim Type by Fiscal Year 14 12 10 8 6 4 2 0
2012-2013
2013-2014
2014-2015
2015-2016
2016-2017
First Aid
0
2
2
2
1
Indemnity
3
3
3
3
2
Medical Only
5
7
6
8
5
Total
8
12
11
13
8
14 12 10 8 6 4 2 0
Total Paid and Incurred by Fiscal Year $70,000
14
$60,000
12
$50,000
10
$40,000
8
$30,000
6
$20,000
4
$10,000
2
$0
2012-2013
2013-2014
2014-2015
2015-2016
2016-2017
Total Paid
$14,033
$10,058
$13,309
$8,882
$29,581
Incurred
$61,511
$38,428
$28,563
$46,838
$56,765
8
12
11
13
8
Total Claims
0
2
Trending Report: City of Placerville 2012-2017
Total Paid During Fiscal Year Regardless of Date of Injury $350,000 $300,000 $250,000 $200,000 $150,000 $100,000 $50,000
$0
2012-2013
2013-2014
2014-2015
2015-2016
2016-2017
Medical Payment
$191,523
$14,916
$111,978
$114,557
$107,780
Indemnity Payment
$63,707
$28,113
$23,282
$128,608
$65,227
Expense Payment
$32,313
$28,643
$33,361
$17,157
$41,764
Total Recoveries During Fiscal Year Regardless of Date of Injury $300,000 $250,000 $200,000 $150,000 $100,000 $50,000 $0 Recoveries
2012-2013
2013-2014
2014-2015
2015-2016
2016-2017
$112,195
$15,096
$273,987
$45,138
$92,657
3
Trending Report: City of Placerville 2012-2017
Loss Days for Date of Injury within Fiscal Year 80 60 40 20
0
2012-2013
2013-2014
2014-2015
2015-2016
2016-2017
Loss Days
3
6
30
0
67
Total Claims
8
12
11
13
8
14 12 10 8 6 4 2 0
Closing Ratio by Fiscal Year 30
250%
25
200%
20
150%
15 100%
10
50%
5
0
2012-2013
2013-2014
2014-2015
2015-2016
2016-2017
Open
8
12
11
13
8
Closed
10
13
13
25
11
Ratio
125%
108%
118%
192%
138%
0%
4
Trending Report: City of Placerville 2012-2017
Top 6 Cause of Injury FY 2012-2017 7 6 5 4 3 2 1 0
Frequency Severity
$140,000 $120,000 $100,000 $80,000 $60,000 $40,000 $20,000 $0
CUT, PUNCTURED, SCRAPED
FELLOW WORKER, OTHER
ANIMAL OR INSECT
PERSON IN ACT OF CRIME
STRAIN
CUMULATIVE TRAUMA
6
6
5
4
4
4
$2,883
$1,567
$556
$25,315
$76,329
$114,801
Top 6 Part of Body Injured FY 2012-2017 9 8 7 6 5 4 3 2 1 0
Frequency Severity
$90,000 $80,000 $70,000 $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 $0
LOWER BACK
KNEE
MULTIPLE BODY PARTS
FINGER(S)
HAND
WRIST
8
5
4
4
4
1
$76,264
$77,372
$26,684
$1,065
$1,568
$49,741
5
Trending Report: City of Placerville 2012-2017
Top 5 Nature of Injury FY 2012-2017 20
$120,000
$100,000
15
$80,000
10
$60,000 $40,000
5
$20,000
0
Frequency Severity
STRAIN
CONTUSION
CUMULATIVE TRAUMA
LACERATION
CARPAL TUNNEL SYNDROME
18
5
4
3
1
$62,453
$73,248
$106,390
$1,291
$49,741
$0
Top 6 Occupation of Injury FY 2012-2017 20 18 16 14 12 10 8 6 4 2 0
Frequency Severity
$100,000 $90,000 $80,000 $70,000 $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 $0
Police Officer
Police Sgt
Lifeguard
Traffic Maint
Meter Repair Tech
Building Official
18
6
3
3
2
1
$88,411
$92,600
$1,368
$4,848
$27,820
$34,817
6
Trending Report: City of Placerville 2012-2017
Top 10 Claims 2012-2017 Claim
Department
DOI
Injury
Status
Paid
Incurred
NCWA-556918 POLICE
1/11/2016 Twisted right knee during O foot pursuit
$56,721
$67,275
NCWA-556942 POLICE
2/23/2016 Cumulative trauma to left O wrist 7/15/2016 Cumulative trauma to low O back
$25,664
$49,741
$24,725
$41,330
9/10/2013 Hearing loss from noise O exposure 9/17/2013 Cumulative trauma to low O back 9/12/2012 Left wrist/arm injured after C being dragged by a vehicle trying to escape 3/27/2014 Shoulder strain from C refilling jug of water 1/15/2015 Hit head while using a C crow bar 8/8/2016 Twisted knee while O patrolling bike path 1/13/2016 Stress C
$6,293
$34,817
$18,174
$27,084
$24,805
$24,805
$18,164
$18,164
$9,697
$9,697
$1660
$6,939
$6,329
$6,329
NCWA-557094 POLICE NCWA-556000 COMMUNITY DEVELOPMENT NCWA-556033 PUBLIC WORKS NCWA-555580 POLICE
NCWA-556238 POLICE NCWA-556533 PUBLIC WORKS NCWA-557124 POLICE NCWA-556899 ADMINISTRATIVE SERVICES
7
Trending Report: City of Placerville 2012-2017
Departments FY 2012-2017
Department
Frequency
Severity
Average
ADMINISTRATIVE SERVICES
4
$6,562
$1,641
COMMUNITY DEVELOPMENT
2
$37,090
$18,545
PARKS & RECREATION
12
$4,950
$413
POLICE
27
$221,348
$8,198
PUBLIC WORKS
9
$43,118
$4,791
WASTEWATER TREATMENT
2
$4,318
$2,159
SEWER
2
$5,109
$2,554
8
Trending Report: City of Placerville 2012-2017
NCCSIF Members FY 2012-2017
NCCSIF Member
Frequency
Severity
Average
City of Anderson
52
$1,191,513
$22,914
City of Auburn
64
$824,717
$12,886
City of Colusa
18
$166,871
$9,271
City of Corning
38
$76,910
$2,024
City of Dixon
68
$2,092,554
$30,773
City Of Elk Grove
204
$3,317,361
$16,262
City of Folsom
376
$4,584,519
$12,193
City of Galt
138
$1,497,372
$10,851
City of Gridley
23
$110,749
$4,815
City of Ione
13
$43,611
$3,355
City of Jackson
23
$1,043,607
$45,374
9
Trending Report: City of Placerville 2012-2017
NCCSIF Members FY 2012-2017
NCCSIF Member
Frequency
Severity
Average
City of Lincoln
80
$1,230,117
$15,376
City of Marysville
47
$919,837
$19,571
City of Nevada City
33
$496,491
$15,045
City of Oroville
63
$1,687,065
$26,779
City of Placerville
58
$322,495
$5,560
City of Red Bluff
81
$1,544,819
$19,072
City of Rio Vista
21
$195,102
$9,291
City of Rocklin
176
$2,396,628
$13,617
City of Willows
21
$583,023
$27,763
City of Yuba City
218
$4,082,750
$18,728
Town of Paradise
60
$1,502,521
$25,042
10
