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) |