Workers' compensation information system (WCIS)

FROI and SROI Data Quality

The Workers’ Compensation Information System (WCIS) collects First Reports of Injury (FROI) and Subsequent Reports of Injury (SROI) submitted electronically by claims administrators and their trading partners.  

The business and technical standards for these transactions are determined by a combination of the International Association of Industrial Accident Boards and Commissions’ (IAIABC) IAIABC EDI Implementation Guide for First, Subsequent, Acknowledgment Detail, Header, & Trailer Records, Release 1 and the California EDI Implementation Guide for First and Subsequent Reports of Injury (FROI/SROI), Version 3.1

In accordance with the business rules and technical requirements in these two guides, WCIS records for analysis of data quality the transaction acknowledgments that are generated for each data submission.

In WCIS, every FROI/SROI transaction is acknowledged with one of three acknowledgments:

  • TA = Transaction Accepted
  • TE = Transaction Accepted with Error
  • TR = Transaction Rejected

If the transaction receives a TE or a TR, the acknowledgment also details which data element (DN) created the TE or TR, and what the error was.  The tables and reports below provide information on the overall WCIS FROI/SROI data quality by year.

2020 Statewide Data Quality

Total Acknowledgment Records: 4,353,327. Total Unique JCN Acknowledgment Records: 1,861,221

Accept (TA) Accept with errors (TE) Reject (TR) Total Acknowledgment
records*
FROI 1,487,437 293,192 57,510 1,838,139
SROI 2,386,006 381,304 85,309 2,852,619
FROI+SROI 3,873,443 674,496 142,819 4,690,758
         
FROI 81% 16% 3% 100%
SROI 84% 13% 3% 100%
FROI+SROI 83% 14% 3% 100%

Note: Totals and percentages may not always add up due to rounding.

* Acknowledgment Records represent total count of TA, TE, TR reported to the WCIS by all Trading Partners.
Each record of acceptance (TA, TE) or rejection (TR) is counted in the validation process.

2020 Top 10 FROI DNs and Error Messages (TRs)

DN DN NAME ERROR MESSAGE 2020 REJECT (TR) (#)
2 Maintenance Type Code 48 Duplicate First Report (148) 24,129
52 Employee Date of Birth 1 Mandatory field not present 10,224
6 Insurer Fein 39 No match on database 7,152
2 Maintenance Type Code 61 Event Criteria not met 6,044
31 Date Of Injury 39 No match on database 2,929
5 Jurisdiction Claim Number 39 No match on database 2,117
52 Employee Date of Birth 39 No match on database 2,086
5 Jurisdiction Claim Number 1 Mandatory field not present 1,243
6 Insurer Fein 28 Must be numeric (0-9) 999
14 Claim Administrator Postal Code 32 Must be valid on Zip Code Table 331

2020 Top 10 FROI DNs and Error Messages (TEs)

DN DN NAME ERROR MESSAGE 2020 ACCEPT with
ERRORS (TE) (#)
25 Industry Code 015 Industry Code (SIC or NAICS) Invalid 65,546
59 Class Code 014 Class Code (WCIRB) Invalid 61,217
33 Postal Code of Injury Site 032 Must be valid on Zip Code Table 31,311
16 Employer FEIN 064 Invalid data sequence/relationship 30,393
32 Time of Injury 001 Mandatory field not present 22,132
37 Cause of Injury Code 008 WCIO Cause of Injury Code Invalid 11,063
63 Wage Period 011 Wage Period Code Invalid 9,894
60 Occupation Description 001 Mandatory field not present 8,267
40 Date Reported to Employer 029 Must be a valid date (CCYYMMDD) 7,597
36 Part of Body Injured Code 007 WCIO Part of Body Code Invalid 7,199

2020 Top 10 SROI DNs and Error Messages (TRs)

DN DN NAME ERROR MESSAGE 2020 REJECT (TR) (#)
2 Maintenance Type Code 63 Invalid event sequence/relationship 20,963
85 Payment/Adjustment Code 61 Event Criteria not met 16,876
5 Jurisdiction Claim Number 1 Mandatory field not present 13,700
6 Insurer Fein 39 No match on database 8,386
31 Date Of Injury 39 No match on database 7,200
87 Payment/Adjustment Weekly Amount 28 Must be numeric (0-9) 4,359
15 Claim Administrator Claim Number 39 No match on database 4,164
85 Payment/Adjustment Code 24 Payment/Adjustment Code Invalid 2,423
5 Jurisdiction Claim Number 39 No match on database 2,047
73 Claim Status 17 Claim Status Code Invalid 975

2020 Top 10 SROI DNs and Error Messages (TEs)

DN DN NAME ERROR MESSAGE ACCEPT with
ERRORS (TE) (#)
78 Number of Permanent Impairments 63 Required segment not present 159,210
2 Maintenance Type Code 62 Invalid event sequence/relationship 75,522
63 Wage Period 11 Wage Period Code Invalid 59,719
62 Wage 28 Must be numeric (0-9) 58,262
56 Date Disability Began 37 Must be <= Maintenance Type Code date 10,207
72 Date of Return/Release to Work 29 Must be a valid date (CCYYMMDD) 6,473
71 Return to Work Qualifier 20 Return to Work Qualifier Code invalid 6,199
56 Date Disability Began 29 Must be a valid date (CCYYMMDD) 4,595
56 Date Disability Began 34 Must be >= Date of Injury 619
57 Employee Date of Death 29 Must be a valid date (CCYYMMDD) 181
Report
Year
Report
Group
Table
Number
Table
Name
2020 Annual Aggregate Data Quality Reports 8 Data quality - Acknowledgments by TA, TE and TR
2020 Annual Aggregate Data Quality Reports 8a Data quality - Acknowledgments by error message
2020 Annual Aggregate Data Quality Reports 8b Data quality - Acknowledgments by data element
2020 Annual Aggregate Data Quality Reports 8c Data quality - Acknowledgments by error message, data element
2020 Annual Aggregate Data Quality Reports 8d Data quality - Acknowledgments by data element, error message
2020 Annual Aggregate Data Quality Reports 8e Data quality - SROI sequencing transactions, 063 Error Code

July 2021