Department of Labor and Training Wage
Last Update: March 27, 2019, 4:26 p.m.
| # | Field Name | Description |
|---|---|---|
| 1 | id | None |
| 2 | employer_name | Employer's organizational name. To be treated as confidential per state law. |
| 3 | address_street | Employer's mailing address (street). Number and street or PO Box. May reflect payroll or other administrative address rather than the location where an individual is employed. |
| 4 | address_city | Employer's mailing address (city). May reflect payroll or other administrative address rather than the location where an individual is employed. |
| 5 | address_state | Employer's mailing address (state). May reflect payroll or other administrative address rather than the location where an individual is employed. |
| 6 | address_zip | Employer's mailing address (zip). May reflect payroll or other administrative address rather than the location where an individual is employed. |
| 7 | wages | Empolyee's total quarterly wages (actual earned). May not reflect the product of hourly wages and hours: can include bonuses, may factor out unpaid leave etc. |
| 8 | weeks_worked | Number of weeks worked in the quarter by the employee |
| 9 | hours_worked | Number of hours worked in the quarter by the employee |
| 10 | year_quarter | Year and quarter of record. |
| 11 | ern | RI Employer Record Number. Should uniquely identify a given employer, appears to be stable over time. |
| 12 | naics | Employer industry code |
| 13 | extract_date | None |
| 14 | valid_ssn | None |
| 15 | row_id | None |
| 16 | wage_source_id | None |
