Quarterly Wage - Employee Wage (S) Record - File Layout and Data Mapping

The following table lists the positions, lengths, field names, descriptions, and data sources or valid values for the Employee Wage (S) 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 S.
2-10	9	SSN	The employee's Social Security number.	Retrieved from the Social Security field on the Quarterly Wage Employee Information tab on the Employee Information form of the OH Quarterly Wage page.
11-30	20	Last Name	The employee's last name.	Retrieved from the Last Name field on the Quarterly Wage Employee Information tab on the Employee Information form of the OH Quarterly Wage page.
31-42	12	First Name	The employee’s first name.	Retrieved from the First Name field on the Quarterly Wage Employee Information tab on the Employee Information form of the OH Quarterly Wage page.
43	1	Middle Initial	The employee's middle initial.	Retrieved from the Middle Initial field on the Quarterly Wage Employee Information tab on the Employee Information form of the OH Quarterly Wage page.
44-45	2	State Code Number	The employee's state FIPS code.	Calculated during the electronic file creation process. The FIPS state code is derived from the State field on the OH Quarterly Wage - Setup page using a state code conversion function.
46-63	18	Filler	Leave blank	spaces
64-77	14	Gross Wages	The total gross wages paid to the employee during the reporting quarter.	Retrieved from the Gross Wages field on the Quarterly Wage Data tab on the Employee Information form of the OH Quarterly Wage page.
78-132	55	Filler	Leave blank	spaces
133-134	2	Weeks Paid	The number of weeks the employee was paid during the reporting quarter.	Retrieved from the Weeks Paid Total field on the Quarterly Wage Data tab on the Employee Information form of the OH Quarterly Wage page.
135-141	7	SOC Code	The Standard Occupational Classification (SOC) code that identifies the employee's occupation.	Retrieved from the SOC Code field on the Quarterly Wage Employee Information tab on the Employee Information form of the OH Quarterly Wage page.
142-146	5	Filler	Leave blank	spaces
147-161	15	Site Info		Retrieved from the State ID Code field on the OH Quarterly Wage - Setup page.
162-164	3	Worksite Code	The work location code assigned by the state for the employee.	Retrieved from the Worksite Code field on the Quarterly Wage Data tab on the Employee Information form of the OH Quarterly Wage page.
165-209	45	Filler	Leave blank	spaces
210	1	Employee Type	Indicates whether the employee is an owner or officer.	Valid values: 0 = Employee 1 = Owner/Officer Retrieved from the Owner/Officer field on the Quarterly Wage Employee Information tab on the Employee Information form of the OH Quarterly Wage page.
211	1	Filler	Leave blank	spaces
212	1	Month 1 Employment	Indicates whether the employee was employed during the pay period that includes the 12th day of the first month of the quarter.	Valid values: 1 = Yes 0 = No Retrieved from the Month 1 field on the Quarterly Wage Data tab on the Employee Information form of the OH Quarterly Wage page.
213	1	Month 2 Employment	Indicates whether the employee was employed during the pay period that includes the 12th day of the second month of the quarter.	Valid values: 1 = Yes 0 = No Retrieved from the Month 2 field on the Quarterly Wage Data tab on the Employee Information form of the OH Quarterly Wage page.
214	1	Month 3 Employment	Indicates whether the employee was employed during the pay period that includes the 12th day of the third month of the quarter.	Valid values: 1 = Yes 0 = No Retrieved from the Month 3 field on the Quarterly Wage Data tab on the Employee Information form of the OH Quarterly Wage page.
215-216	2	Month	The last month of the quarter.	Valid values: 03 06 09 12 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: 1 = 03 2 = 06 3 = 09 4 = 12
217-220	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.
221-226	6	Hire Date	The employee's date of hire.	Retrieved from the Original Hire field on the Employment tab of the Employee Information page.
227-232	6	Term Date	The employee's termination date.	Retrieved from the Last Date to Pay field on the Terminate Employee page.
233-247	15	Out-of-State UI Wages	The wages earned by the employee in states other than Ohio that are subject to UI tax.	Retrieved from the Out-Of-State UI Taxable Wages field on the Quarterly Wage Data tab on the Employee Information form of the OH Quarterly Wage page.
248-249	2	Adjustment Reason	The reason for the wage record submission.	Valid values: 00 = Original filing 01 = Correction to clerical error of gross wages/weeks worked 02 = Social Security Number corrected 03 = Employee name corrected 04 = Add Employee to original return 05 = Out-of-state employee 06 = Employee did not work in Ohio 07 = Excluded-Owner (sole-proprietor, partner/Member) 08 = Excluded-Family Exclusion (sole-proprietor, partner/Member) 09 = Excluded - Non-immigrant Alien visas Retrieved from the Adjustment Reason field on the Quarterly Wage Data tab on the Employee Information form of the OH Quarterly Wage page.
250-275	26	Filler	Leave blank	spaces