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 12 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. | 6612915 1786862 5486592 7866866 5076062 view top 100 |
| Legal Business Name | legal_business_name | text | The legal business name of the employer | VERDANT ENTERPRISES, LLC O-I GLASS INC PROVIDENCE OREGON MANAGEMENT CORPORATION MARRIOTT INTERNATIONAL ADMINISTRATIVE SERVICES INC NATIONAL FROZEN FOODS CORPORATION view top 100 |
| DBA Name | dba_name | text | The doing business as name of the employer | MCDONALD'S AMPCO SYSTEM PARKING INC CASCADES DBA CENTER FOR OCCUPATIONAL HEALTH CHEVRON EXTRA MILE 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 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. | 722513 622110 921140 484121 611310 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: | 500 or more 1-10 100-499 11-49 50-99 view top 100 |
| PPB City | ppb_city | text | City of employer’s principle place of business | PORTLAND NA SALEM EUGENE BEAVERTON view top 100 |
| PPB State | ppb_state | text | State of employer’s principle place of business | OR XX WA GA MN view top 100 |
| Insurer Num | insurer_num | number | Insurer number is a 1- to 4-digit number assigned by DCBS to identify insurance providers | 1731 1429 1641 1511 1567 view top 100 |
| Insurer Name | insurer_name | text | Name of insurer providing workers’ compensation insurance coverage | OREGON OPERATORS SELF-INSURERS FUND KIEWIT CORPORATION LEGACY HEALTH OREGON EDUCATIONAL EMPLOYERS WORKERS COMPENSATION TRUST PORTLAND GENERAL ELECTRIC COMPANY view top 100 |
| Liability Begin Date | liab_begin_date | calendar_date | Employer coverage liability begin date | 1995-04-01T00:00:00.000 2005-06-01T00:00:00.000 1978-07-01T00:00:00.000 1985-07-01T00:00:00.000 2017-01-01T00:00:00.000 view top 100 |
| Liability End Date | liad_end_date | calendar_date | Employer coverage liability end date | 2049-01-01T00:00:00.000 view top 100 |