QUIR - Data Definitions
Multiple Worksite Report
The following table lists the data items, description, database fields, type, size, and from where the data is retrieved.
Data Item | Description | Loaded Into (Table.Field) | Type | Size | Location |
|---|---|---|---|---|---|
Report Quarter | The quarter to be reported. | mdqtrwage.quarter | Character | 1 | Quarter entered when loading data. |
Report Year | The year to be reported. | mdqtrwage.yr | Character | 4 | Year entered when loading data. |
Employee Number | The employee number. | mdqtrwage.empl_no | Integer | Not Applicable | employee.empl_no |
Social Security | The employee’s social security number. | mdqtrwage.ssn | Character | 11 | employee.ssn |
Last Name | The employee’s last name. | mdqtrwage.l_name | Character | 30 | employee.l_name |
First Name | The employee’s first name. | mdqtrwage.f_name | Character | 30 | employee.f_name |
Earnings | The employee’s earnings. | mdqtrwage.qtr_wage | Integer | Not Applicable | checkhis.amt (or the sum of checkhis.amt if the employee has multiple employee numbers) |