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 1801257 2278141 2907293 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-02-02T00:00:00.000 2011-08-03T00:00:00.000 view top 100 |
Legal Business Name | legal_business_name | text | The legal business name of the employer | APOSTOLIC ASSEMBLY OF THE FAITH IN CHRIST JESUS FIRST BAPTIST CHURCH CHURCH OF THE NAZARENE FIRST CHRISTIAN CHURCH GRACE BAPTIST CHURCH view top 100 |
DBA Name | dba_name | text | The doing business as name of the employer | THEANAGEMENTRUSTORTHWEST DBA COLLEGE WORKS PAINTING SUBWAY EMPIREWORKS STATE FARM INSURANCE 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 RELIGIOUS ORGANIZATIONS WHOLESALE TRADE AGENTS AND BROKERS 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 | 2 STE 200 Y 0 STE 300 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 UNKNOWN 5305 RIVER RD N STE B 220 NW 8TH AVE 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 MD CA view top 100 |
PPB_Zip | ppb_zip | text | Zip code of employer’s principle place of business | 99999 97301 97702 97401 97223 view top 100 |
PPB Zip 4 | ppb_zip_4 | text | Zip code +4 for employer’s principle place of business | 0000 5324 1009 9601 9728 view top 100 |
County Code | county_code | number | County code for employer’s location | 51 99 67 5 39 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 10 509 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 TRAVELERS CASUALTY AND SURETY COMPANY LM INSURANCE CORPORATION view top 100 |
Liability Begin Date | liab_begin_date | calendar_date | Employer coverage liability begin date | 2022-01-01T00:00:00.000 2021-07-01T00:00:00.000 2021-10-01T00:00:00.000 2022-04-01T00:00:00.000 2022-03-01T00:00:00.000 view top 100 |
Liability End Date | liad_end_date | calendar_date | Employer coverage liability end date | 2023-01-01T00:00:00.000 2022-07-01T00:00:00.000 2022-10-01T00:00:00.000 2023-04-01T00:00:00.000 2023-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 | 2445810 9556051 3783156 6708111 7971830 view top 100 |
Mail Address 1 | mail_address1 | text | Attention, in care of, or other address info for employer’s mailing address | 10425 W NORTH AVE STE 345 ATTN: MICHELLE PENSE ATTN: HUMAN RESOURCES 4800 S MACADAM AVE STE 245 ATTN: ACCOUNTS PAYABLE view top 100 |
Mail Address 2 | mail_address2 | text | Street address line of employer’s mailing address | PREMIER-FMS 2950 N HOLLYWOOD WAY PO BOX 4398 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 | 97401 97402 97702 97301 97223 view top 100 |
Mail Zip 4 | mail_zip_4 | text | Zip code +4 of employer’s mailing address | 0001 2416 1072 0002 4398 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 |