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.

2022 Statewide Data Quality

Total Acknowledgment Records: 4,839,785. Total Unique JCN Acknowledgment Records: 1,805,522

Accept (TA) Accept with errors (TE) Reject (TR) Total Acknowledgment records*
FROI 1,716,025 225,586 29,856 1,971,467
SROI 2,535,799 222,241 110,278 2,868,318
FROI+SROI 4,251,824 447,827 140,134 4,839,785
         
FROI 87% 11% 2% 100%
SROI 88% 8% 4% 100%
FROI+SROI 88% 9% 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.

2022 Top 10 FROI DNs and Error Messages (TRs)

DN DN NAME ERROR MESSAGE 2022 REJECT (TR) (#)
2 Maintenance Type Code 048 Duplicate First Report (148) 5,863
52 Employee Date of Birth 029 Must be a valid date (CCYYMMDD) 4,478
5 Jurisdiction Claim Number 039 No match on database 3,104
2 Maintenance Type Code 061 Event Criteria not met 3,020
6 Insurer Fein 039 No match on database 3,016
3 Maintenance Type Code Date 001 Mandatory field not present 2,302
52 Employee Date of Birth 039 No match on database 1,929
14 Claim Administrator Postal Code 032 Must be valid on Zip Code Table 1,566
8 Third Party Administrator FEIN 001 Mandatory field not present 1,496
31 Date Of Injury 039 No match on database 1,003

2022 Top 10 FROI DNs and Error Messages (TEs)

DN DN NAME ERROR MESSAGE 2022 ACCEPT with ERRORS (TE) (#)
59 Class Code 014 Class Code (WCIRB) Invalid 52,105
33 Postal Code of Injury Site 032 Must be valid on Zip Code Table 43,631
25 Industry Code 015 Industry Code (SIC or NAICS) Invalid 30,403
16 Employer FEIN 028 Must be numeric (0-9) 15,002
60 Occupation Description 001 Mandatory field not present 12,942
37 Cause of Injury Code 008 WCIO Cause of Injury Code Invalid 9,813
16 Employer FEIN 064 Invalid data sequence/relationship 9,301
40 Date Reported to Employer 029 Must be a valid date (CCYYMMDD) 7,331
35 Nature of Injury Code 006 WCIO Nature Code Invalid 7,315
23 Employer Postal Code 032 Must be valid on Zip Code Table 6,828

2022 Top 10 SROI DNs and Error Messages (TRs)

DN DN NAME ERROR MESSAGE 2022 REJECT (TR) (#)
2 Maintenance Type Code 063 Invalid event sequence/relationship 38,584
85 Payment/Adjustment Code 061 Event Criteria not met 19,428
14 Claim Administrator Postal Code 032 Must be valid on Zip Code Table 12,225
6 Insurer Fein 039 No match on database 11,460
87 Payment/Adjustment Weekly Amount 028 Must be numeric (0-9) 9,597
15 Claim Administrator Claim Number 039 No match on database 4,159
31 Date Of Injury 039 No match on database 3,973
5 Jurisdiction Claim Number 001 Mandatory field not present 2,663
88 Payment/Adjustment Start Date 034 Must be >= Date of Injury 1,940
5 Jurisdiction Claim Number 039 No match on database 1,504

2022 Top 10 SROI DNs and Error Messages (TEs)

DN DN NAME ERROR MESSAGE ACCEPT with ERRORS (TE) (#)
78 Number of Permanent Impairments 62 Required segment not present 137,389
2 Maintenance Type Code 63 Invalid event sequence/relationship 45,133
56 Date Disability Began 37 Must be <= Maintenance Type Code date 10,696
62 Wage 28 Must be numeric (0-9) 8,656
63 Wage Period 11 Wage Period Code Invalid 8,557
71 Return to Work Qualifier 20 Return to Work Qualifier Code invalid 4,317
72 Date of Return/Release  to Work 29 Must be a valid date (CCYYMMDD) 3,753
56 Date Disability Began 29 Must be a valid date (CCYYMMDD) 3,106
56 Date Disability Began 34 Must be >= Date of Injury 300
57 Employee Date of Death 29 Must be a valid date (CCYYMMDD) 164
Report Year Report Group Table Number Table Name
2022 Annual Aggregate Data Quality Reports 8 Data quality - Acknowledgments by TA, TE and TR
2022 Annual Aggregate Data Quality Reports 8a Data quality - Acknowledgments by error message
2022 Annual Aggregate Data Quality Reports 8b Data quality - Acknowledgments by data element
2022 Annual Aggregate Data Quality Reports 8c Data quality - Acknowledgments by error message, data element
2022 Annual Aggregate Data Quality Reports 8d Data quality - Acknowledgments by data element, error message
2022 Annual Aggregate Data Quality Reports 8e Data quality - SROI sequencing transactions, 063 Error Code

October 2023