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