Oregon Active Workers’ Compensation Employer Database

data.oregon.gov | Last Updated 2 May 2022

The Employer Database System is a database of all Oregon employers and their history of workers’ compensation (WC) insurance coverage. The system produces a snapshot of current employers with active workers’ compensation insurance policies. The most current data are updated monthly during the first week of the month.

Tags: workers compensation, employer database, active workers compensation, oregon

This dataset has the following 31 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Employer Numberemployer_numtextEmployer number is a 7-digit number assigned by DCBS to identify each unique employer. Employer numbers fall within the range of 1000000 to 9999999.
Insured Statusinsurer_statusnumberThe insured status code is a two-digit number identifying the employer’s current coverage status. 01 = Active Coverage 03 = Double Coverage 04 = Pending Coverage 12 = Pending Investigation
Insured Status Dateinsurer_status_datecalendar_dateDate when the insured status code was assigned. Provided in the format mm/dd/yyyy.
Legal Business Namelegal_business_nametextThe legal business name of the employer
DBA Namedba_nametextThe doing business as name of the employer
OwnershipownershipnumberEmployer ownership code is a two-digit number identifying the type of ownership. 10 (Federal Government) 20 (State Government) 30 (Local Government) 50 (Private Ownership)
NAICSnaicstextThe North American Industry Classification System Code is a 6-digit code used to classify employers into industries based on similarity of production processes.
NAICS Descriptionnaics_descriptiontextNAICS code industry title
Employees Rangeemployees_rangetextEmployees range categorizes employers into one of five groups based on the number of employees reported. Actual employment numbers are suppressed for confidentiality. The five size categories:
PPB Address 1ppb_address1textAttention, in care of, or other address info for employer’s principal place of business address
PPB Address 2ppb_address2textStreet address line of employer’s principal place of business address
PPB Cityppb_citytextCity of employer’s principle place of business
PPB Stateppb_statetextState of employer’s principle place of business
PPB_Zipppb_ziptextZip code of employer’s principle place of business
PPB Zip 4ppb_zip_4textZip code +4 for employer’s principle place of business
County Codecounty_codenumberCounty code for employer’s location
Insurer Numinsurer_numnumberInsurer number is a 1- to 4-digit number assigned by DCBS to identify insurance providers
Insurer Nameinsurer_nametextName of insurer providing workers’ compensation insurance coverage
Liability Begin Dateliab_begin_datecalendar_dateEmployer coverage liability begin date
Liability End Dateliad_end_datecalendar_dateEmployer coverage liability end date
Entity Codeentity_codetextEmployer entity codes consist of a single alphanumeric character classifying employers by entity type. 0 = Other 1 = Individual 2 = Corporation 3 = Political Subd 4 = Husband/Wife Partnership 5 = Partnership 6 = Joint Venture 7 = Association 8 = Labor Union 9 = Limited Partner A = LLP B = LLC C = Trust D = Estate
NCCI Codencci_codetextNCCI insurance classification code
Phone Areaphone_areanumberArea code for employer’s phone number
PhonephonetextEmployer’s phone number
Mail Address 1mail_address1textAttention, in care of, or other address info for employer’s mailing address
Mail Address 2mail_address2textStreet address line of employer’s mailing address
Mail Citymail_citytextCity of employer’s mailing address
Mail Statemail_statetextState of employer’s mailing address
Mail Zipmail_ziptextZip code of employer’s mailing address
Mail Zip 4mail_zip_4textZip code +4 of employer’s mailing address
Record Originrecord_origintextEmployers are assigned a PC1 or PC2 code based on the primary entity being insured. A missing value in this field means that the employer is self-insured. PC1: Employer is the insured on the policy. PC2: Employer is a covered entity on the policy and the Federal ID Number (FEIN) reported for this entity is different than the FEIN of the insured.