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.0

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.

2016 Statewide Data Quality

Total Acknowledgment Records: 5,826,145. Total Unique JCN Acknowledgment Records: 3,270,495

Accept (TA) Accept with errors (TE) Reject (TR) Total Acknowledgment
records*
FROI 1,687,162 324,518 81,648 2,093,328
SROI 3,628,231 36,456 68,130 3,732,817
FROI+SROI 5,315,393 360,974 149,778 5,826,145
         
FROI 81% 16% 4% 100%
SROI 97% 1% 2% 100%
FROI+SROI 91% 6% 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.

WCIS Data as of June 2017

2016 Top 4 FROI DNs and Error Messages (TRs)

DN DN NAME ERROR MESSAGE REJECT (TR) (#)
2 Maintenance Type Code 53 Duplicate First Report (148) 28,959
2 Maintenance Type Code 48 Duplicate First Report (148) 18,793
6 Insurer Fein 39 No match on database 17,007
2 Maintenance Type Code 61 Event Criteria not met 16,294

WCIS Data as of June 2017

2016 Top 10 FROI DNs and Error Messages (TEs)

DN DN NAME ERROR MESSAGE ACCEPT with
ERRORS (TE) (#)
25 Industry Code 015 Industry Code (SIC or NAICS) Invalid 72,970
63 Wage Period 014 Wage Period Code Invalid  
59 Class Code 032 Class Code (WCIRB) Invalid 33,791
33 Postal Code of Injury Site 064 Must be valid on Zip Code Table  
40 Date Reported to Employer 001 Must be a valid date (CCYYMMDD) 24,766
16 Employer FEIN 011 Invalid data sequence/relationship 21,207
60 Occupation Description 029 Mandatory field not present 13,426
41 Date Reported to Claim Administrator 100 Must be a valid date (CCYYMMDD) 11,191
28 Policy Number 029 No Leading/Embedded Spaces 10,974
28 Policy Number 030 Must be A-Z, 0-9, or spaces 10,784
66,664 12,526

WCIS Data as of June 2017

2016 Top 10 SROI DNs and Error Messages (TRs)

DN DN NAME ERROR MESSAGE REJECT (TR) (#)
85 Payment/Adjustment Code 024 Payment/Adjustment Code Invalid 20,208
2 Maintenance Type Code 063 Invalid event sequence/relationship 16,100
85 Payment/Adjustment Code 061 Event Criteria not met 7,189
2 Maintenance Type Code  053 Event Criteria not met 6,138
2 Maintenance Type Code  029 No matching FROI (148) 4,838
87 Payment/Adjustment Weekly Amount 024 Must be numeric (0-9) 4,338
95 Paid to Date/Reduced Earnings/Recoveries Code 026 PTD/RE/Recovery Code Invalid 1,635
89 Payment/Adjustment End Date 028 Must be >= Start date 1,553
89 Payment/Adjustment End Date 029 Must be a valid date (CCYYMMDD) 1,491
70 Date of Maximum Medical Improvement 029 Must be a valid date (CCYYMMDD) 1,303

WCIS Data as of June 2017

2016 Top 10 SROI DNs and Error Messages (TEs)

DN DN NAME ERROR MESSAGE ACCEPT with
ERRORS (TE) (#)
78 Number of Permanent Impairments 062 Required segment not present 4,819
56 Date Disability Began 029 Must be a valid date (CCYYMMDD) 17,569
71 Return to Work Qualifier 020 Return to Work Qualifier Code invalid 4,110
72 Date of Return/ReleaseĀ  to Work 029 Must be a valid date (CCYYMMDD) 3,135
70 Date of Maximum Medical Improvement 035 Must be >= Date Disability Began 1,043
63 Wage period wge Period 011 Wage Period Code Invalid 2,075
56 Date Disability Began 037 Must be <= Maintenance Type Code date 760
62 Wage 028 Must be numeric (0-9) 2,039
72 Date of Return/ReleaseĀ  to Work 035 Must be >= Date Disability Began 239
83 Permanent Impairment Body Part Code 007 WCIO Part of Body Code Invalid 320

WCIS Data as of June 2017

Annual Aggregate Reports

2016 Annual Aggregate Data Quality Reports

Report
Year
Report
Group
Table
Number
Table
Name

Format

2016 Annual Aggregate Data Quality Reports 8 Data quality - Acknowledgments by TA, TE and TR version version
2016 Annual Aggregate Data Quality Reports 8a Data quality - Acknowledgments by error message version version
2016 Annual Aggregate Data Quality Reports 8b Data quality - Acknowledgments by data element version version
2016 Annual Aggregate Data Quality Reports 8c Data quality - Acknowledgments by error message, data element version version
2016 Annual Aggregate Data Quality Reports 8d Data quality - Acknowledgments by data element, error message version version
2016 Annual Aggregate Data Quality Reports 8e Data quality - SROI sequencing transactions, 063 Error Code version version

WCIS Report archive

FROI & SROI reports, tables and papers

July 2017