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.
This dataset has the following 31 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Employer Number | employer_num | text | Employer number is a 7-digit number assigned by DCBS to identify each unique employer. Employer numbers fall within the range of 1000000 to 9999999. | 7389950 2821734 2907293 3827706 4230157 view top 100 |
Insured Status | insurer_status | number | The 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 | 1 12 4 3 view top 100 |
Insured Status Date | insurer_status_date | calendar_date | Date when the insured status code was assigned. Provided in the format mm/dd/yyyy. | 2012-01-05T00:00:00.000 2012-04-04T00:00:00.000 2012-10-16T00:00:00.000 2012-07-17T00:00:00.000 2012-02-02T00:00:00.000 view top 100 |
Legal Business Name | legal_business_name | text | The legal business name of the employer | FIRST BAPTIST CHURCH CHURCH OF THE NAZARENE FIRST CHRISTIAN CHURCH CHANG'S MONGOLIAN GRILL INC FIRST PRESBYTERIAN CHURCH view top 100 |
DBA Name | dba_name | text | The doing business as name of the employer | THEANAGEMENTRUSTORTHWEST DBA COLLEGE WORKS PAINTING SUBWAY EMPIREWORKS EPSG MANAGEMENT SERVICES view top 100 |
Ownership | ownership | number | Employer ownership code is a two-digit number identifying the type of ownership. 10 (Federal Government) 20 (State Government) 30 (Local Government) 50 (Private Ownership) | 50 30 20 10 view top 100 |
NAICS | naics | text | The North American Industry Classification System Code is a 6-digit code used to classify employers into industries based on similarity of production processes. | 722511 236115 541511 813110 425120 view top 100 |
NAICS Description | naics_description | text | NAICS code industry title | FULL-SERVICE RESTAURANTS NEW SINGLE-FAMILY HOUSING CONSTRUCTION (EXCEPT OPERATIVE BUILDERS) CUSTOM COMPUTER PROGRAMMING SERVICES SOFTWARE PUBLISHERS RELIGIOUS ORGANIZATIONS view top 100 |
Employees Range | employees_range | text | Employees 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: | 1-10 11-49 50-99 100-499 500 or more view top 100 |
PPB Address 1 | ppb_address1 | text | Attention, in care of, or other address info for employer’s principal place of business address | Y STE 200 STE 150 WY 3 view top 100 |
PPB Address 2 | ppb_address2 | text | Street address line of employer’s principal place of business address | NO LOC IN OR 7000 NE AIRPORT WAY 1500 SW 12TH AVE APT 402 5305 RIVER RD N STE B 650 NE HOLLADAY ST STE 1400 view top 100 |
PPB City | ppb_city | text | City of employer’s principle place of business | PORTLAND NA SALEM EUGENE BEND view top 100 |
PPB State | ppb_state | text | State of employer’s principle place of business | OR XX WA GA NE view top 100 |
PPB_Zip | ppb_zip | text | Zip code of employer’s principle place of business | 99999 97301 97702 97214 97401 view top 100 |
PPB Zip 4 | ppb_zip_4 | text | Zip code +4 for employer’s principle place of business | 5324 1009 0000 2096 3497 view top 100 |
County Code | county_code | number | County code for employer’s location | 99 51 67 5 47 view top 100 |
Insurer Num | insurer_num | number | Insurer number is a 1- to 4-digit number assigned by DCBS to identify insurance providers | 1 910 882 252 10 view top 100 |
Insurer Name | insurer_name | text | Name of insurer providing workers’ compensation insurance coverage | SAIF CORPORATION TWIN CITY FIRE INSURANCE COMPANY TRAVELERS PROPERTY CASUALTY COMPANY OF AMERICA FARMINGTON CASUALTY COMPANY TRAVELERS CASUALTY AND SURETY COMPANY view top 100 |
Liability Begin Date | liab_begin_date | calendar_date | Employer coverage liability begin date | 2024-01-01T00:00:00.000 2023-10-01T00:00:00.000 2024-04-01T00:00:00.000 2024-07-01T00:00:00.000 2024-03-01T00:00:00.000 view top 100 |
Liability End Date | liad_end_date | calendar_date | Employer coverage liability end date | 2025-01-01T00:00:00.000 2024-10-01T00:00:00.000 2025-04-01T00:00:00.000 2025-07-01T00:00:00.000 2025-03-01T00:00:00.000 view top 100 |
Entity Code | entity_code | text | Employer 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 | 2 B 1 0 5 view top 100 |
NCCI Code | ncci_code | text | NCCI insurance classification code | 8810 8742 9079 8832 8868 view top 100 |
Phone Area | phone_area | number | Area code for employer’s phone number | 503 541 971 360 800 view top 100 |
Phone | phone | text | Employer’s phone number | 9556051 3783156 6708111 9609000 2330300 view top 100 |
Mail Address 1 | mail_address1 | text | Attention, in care of, or other address info for employer’s mailing address | PMB VA2001 300 25115 SW PARKWAY AVE STE B 4800 S MACADAM AVE STE 245 200 view top 100 |
Mail Address 2 | mail_address2 | text | Street address line of employer’s mailing address | PO BOX 909 2950 N HOLLYWOOD WAY 10425 W NORTH AVE STE 345 2105 SE 9TH AVE 1880 CENTURY PARK E STE 1600 view top 100 |
Mail City | mail_city | text | City of employer’s mailing address | PORTLAND SALEM EUGENE BEND BEAVERTON view top 100 |
Mail State | mail_state | text | State of employer’s mailing address | OR CA WA TX NY view top 100 |
Mail Zip | mail_zip | text | Zip code of employer’s mailing address | 97301 97401 97402 97702 97223 view top 100 |
Mail Zip 4 | mail_zip_4 | text | Zip code +4 of employer’s mailing address | 0001 5401 0909 7105 1072 view top 100 |
Record Origin | record_origin | text | Employers 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. | PC1 PC2 view top 100 |