The following table lists the positions, lengths, field names, descriptions, and data sources or valid values for the Employer Total (T) Record of the Quarterly Wage report.
|
Position |
Length |
Field Name |
Description |
Data Source or Valid Values |
|---|---|---|---|---|
|
1 |
1 |
Record ID |
Identifies the record type. |
The valid value is T. |
|
2-8 |
7 |
Total Employees |
The total number of Employee Wage (S) records. |
Calculated during the electronic file creation process. The system counts the total number of Employee Wage (S) records processed during report generation. |
|
9-26 |
18 |
Filler |
Leave blank |
spaces |
|
27-40 |
14 |
Total Gross Wages |
The sum of the Gross Wages from all Employee Wage (S) records. |
Calculated during the electronic file creation process. The system sums the Gross Wages from all Employee Wage (S) records. Each individual employee's gross wages are retrieved from the Gross Wages field on the Quarterly Wage Data tab on the Employee Information form of the OH Quarterly Wage page. |
|
41-54 |
14 |
Total Excess Wages |
The sum of the UI Excess Wages from all Employee Wage (S) records. |
Calculated during the electronic file creation process. The system sums the UI Excess Wages from all Employee Wage (S) records. Each individual employee's UI excess wages are retrieved from the UI Excess Wages field on the Quarterly Wage Data tab on the Employee Information form of the OH Quarterly Wage page. |
|
55-68 |
14 |
Total Taxable Wages |
The sum of the Taxable UI Wages from all Employee Wage (S) records. |
Calculated during the electronic file creation process. The system sums the Taxable UI Wages from all Employee Wage (S) records. Each individual employee's taxable wages are retrieved from the Taxable UI Wages field on the Quarterly Wage Data tab on the Employee Information form of the OH Quarterly Wage page. |
|
69-81 |
13 |
Filler |
Leave blank |
spaces |
|
82-83 |
2 |
Month |
The last month of the quarter. |
Valid values:
Calculated during the electronic file creation process. The month value is derived from the Reporting Quarter field on the OH Quarterly Wage - Setup page using the following logic:
|
|
84-87 |
4 |
Year |
The reporting year for which quarterly wage data is being reported. |
Retrieved from the Reporting Year field on the OH Quarterly Wage - Setup page. |
|
88-226 |
139 |
Filler |
Leave blank |
spaces |
|
227-233 |
7 |
Month 1 Count |
The count of employees employed during the pay period that includes the 12th day of the first month of the quarter. |
Calculated during the electronic file creation process. The system counts the number of employees with Month 1 selected across all Employee Wage (S) records. Each employee's Month 1 value is retrieved from the Month 1 field on the Quarterly Wage Data tab on the Employee Information form of the OH Quarterly Wage page. |
|
234-240 |
7 |
Month 2 Count |
The count of employees employed during the pay period that includes the 12th day of the second month of the quarter. |
Calculated during the electronic file creation process. The system counts the number of employees with Month 2 selected across all Employee Wage (S) records. Each employee's Month 2 value is retrieved from the Month 2 field on the Quarterly Wage Data tab on the Employee Information form of the OH Quarterly Wage page. |
|
241-247 |
7 |
Month 3 Count |
The count of employees employed during the pay period that includes the 12th day of the third month of the quarter. |
Calculated during the electronic file creation process. The system counts the number of employees with Month 3 selected across all Employee Wage (S) records. Each employee's Month 3 value is retrieved from the Month 3 field on the Quarterly Wage Data tab on the Employee Information form of the OH Quarterly Wage page. |
|
248-275 |
28 |
Filler |
Leave blank |
spaces |