Skip to Content

Data Reporting

Print page

Unit Statistical Reporting Guidelines

This page contains information regarding reporting requirements and practices for submitting USR data. 

USR Record Requirements by Report Type

The chart below lists the WCSTAT records that are required for each USR type (e.g., first report, subsequent report, correction report, etc.). 

USR Type Header Record
(Type 1)
Name Record
(Type 2)
Address Record
(Type 3)
Exposure Record
(Type 4)
Loss Record
(Type 5)
Unit Totals Record
(Type 6)

First Report

Required. 
Must have only one.

Required. 
Must have only one.

Optional.
If reported, must have only one.

Required.
Must have at least one; no maximum.

Optional.  Report if appropriate.  No maximum.

Required.  Must have only one.

On first reports, all CA-required fields on this record must be reported.

Subsequent Report

Required. 
Must have only one.

Required. 
Must have only one.

Optional.
If reported, must have only one.

None allowed.

Required.
Must have at least one; no maximum.

Required.  Must have only one.

On subsequent reports, all CA-required fields on this record must be reported EXCEPT Exposure – Payroll Total and Standard Premium Total, which can be zero-filled.

Correction Report Type H - Header

Required. 
Must have only one.

Optional. 
If reported, must have only one.

Optional.
If reported, must have only one.

None allowed.

None allowed.

None allowed.

Correction Report Type E – Exposure

Required. 
Must have only one.

Required. 
Must have only one.

Optional.
If reported, must have only one.

Required.
Must have at least one; no maximum.

None allowed.

Required.  Must have only one.

On exposure corrections, all CA-required fields on this record must be reported EXCEPT Claim Count Total, Incurred Indemnity Amount Total, and Incurred Medical Amount Total, which can be zero-filled.

Correction Report Type L – Loss

Required. 
Must have only one.

Required. 
Must have only one.

Optional.
If reported, must have only one.

None allowed.

Required.
Must have at least one; no maximum.

Required.  Must have only one.

On loss corrections, all CA-required fields on this record must be reported EXCEPT Exposure – Payroll Total and Standard Premium Total, which can be zero-filled.

Correction Report Type T – Total

Required. 
Must have only one.

Required. 
Must have only one.

Optional.
If reported, must have only one.

  None allowed.

 None allowed.

Required.  Must have only one.

If reporting a totals correction on the first report level, then all CA-required fields on this record must be reported.

If reporting a totals correction on a subsequent report level, then all CA-required fields on this record must be reported EXCEPT Exposure – Payroll Total and Standard Premium Total, which can be zero-filled.

Correction Report Type M – Multiple

Required. 
Must have only one.

Required. 
Must have only one.

Optional.
If reported, must have only one.

Optional.  Report if appropriate.  No maximum.

Optional.  Report if appropriate.  No maximum.

Required.  Must have only one.

On multiple corrections, all CA-required fields on this record must be reported.

Reporting Methods for Exposure and Loss Records (Previous/Revised and Add/Change/Delete)

Insurers must report unit statistical report (USR) data to the WCIRB using the WCSTAT specifications outlined by the Workers Compensation Insurance Organizations (WCIO).

The specification provides two methods for reporting USR exposure and loss records: the Previous/Revised method and the Add/Change/Delete method. The code reported in the Update Type Code field (position 121 on both the exposure and loss records) identifies which method is being used.

  • The Previous/Revised (P/R) method, which requires the codes “P” or “R” to be reported as appropriate in the Update Type Code field on all exposure or loss records;

Or

  • the Add/Change/Delete (A/C/D) method, which requires the codes “A,” “C,” or “D” to be reported as appropriate in the Update Type Code field on all exposure or loss records. (Note: Restrictions apply on the use of the “C” (Change) update type; see below for more details.)

The Previous/Revised method is recommended by the WCIRB because of its greater accuracy in matching incoming data to the data already in its system; however, the use of either method is permitted. (Note: While the use of the Change update type in the A/C/D method carries the greatest risk of matching problems, using the Delete and Add update types is identical to the use of the Previous/Revised method.) Incorrect use of these reporting methods may result in improperly processed unit statistical data.

See an overview of both reporting methods in a table format here:

Reporting New Exposure or Loss Data

New exposure or loss records are reported as follows:

  • P/R method: Report one “R” record with the new data. All reported data will be added to our system.
     
  • A/C/D method: Report one “A” record with the new data. All reported data will be added to our system.

All new exposure or loss data must be reported with an Update Type Code field value of “R” or “A.” The same instructions apply whether you are submitting an original first report level, adding a new exposure record on a first report correction, or adding a new claim on a subsequent report or a correction report.

Changing or Deleting Existing Exposure or Loss Data

To change or delete previously reported exposure or loss data, you must report some elements of the old data (so the WCIRB’s system can locate the existing record) along with the new changes. These elements, known as key data, are reported on either "P" or "D" records and are used only for matching. The key data must match exactly the data previously reported or the change/deletion will not be processed and an error will result. The key data elements are shown below:

Type of Data

Key Data for Matching

Exposure Records

  • Classification Code
  • Exposure Act / Exposure Coverage Code
  • Exposure Amount
  • Rate Effective Date

Loss Records – Individual Claims

  • Claim Number

Loss Records – Grouped Claims

  • Classification Code
  • Injury Type
  • Loss Coverage Act
  • Incurred Indemnity Amount and Incurred Medical Amount are used if a match fails based on the above criteria.

 

 

Deletions of existing data are reported as follows:

  • P/R method: Report one “P” record that includes the key data for matching. The key data on the “P” record must match the data in the WCIRB system or an error will result. If a match is successful, the existing data will be deleted from the WCIRB system. (Note: You can report data on the “P” record in addition to the key data. Our system will disregard the non-key data since it is not used for matching.)
     
  • A/C/D method: Report one “D” record that includes the key data for matching. The key data on the “D” record must match the data in the WCIRB system or an error will result. If a match is successful, the existing data will be deleted from the WCIRB system. (Note: You can report data on the “D” record in addition to the key data. Our system will disregard the non-key data since it is not used for matching.)

Changes to existing data are reported as follows:

  • P/R method: Report two records (on both correction reports and subsequent reports): a “P” record that includes the key data for matching, and an “R” record with the revised data. The key data on the “P” record must match exactly the data in the WCIRB system or an error will result. (Note: You can report data on the “P” record in addition to the key data. The WCIRB system will disregard the non-key data since it is not used for matching.) The revisions in the “R” record will be applied in our system.

  • A/C/D method: There are two distinct ways to change data using this method:

    • Report two records (on both correction reports and subsequent reports): a “D” record that includes the key data for matching, and an “A” record with the revised data. The key data on the “D” record must match exactly the data in the WCIRB system or an error will result. (Note: You can report data on the “D” record in addition to the key data. Our system will disregard the non-key data since it is not used for matching.) The revisions in the “A” record will be applied in our system.

    • Report one “C” (Change) record. The “C” update type offers the benefit of requiring a single record to report a change; however, its use is restricted. “C” can ONLY be used to change individual claims. The “C” record must not be used for changes to exposure records or grouped claims. Additionally, the “C” record must not be used to change the Claim Number field on individual claims since this is the key data for individual claim records. To change exposure records, grouped claims, or the Claim Number on an individual loss record, use “A” and “D” (or “P” and “R”) records instead.