Wage and Contribution Report - Employee (S) Record - Record Layout and Data Mapping

The following table lists the positions, lengths, field names, descriptions, and data sources or valid values for the Employee (S) record of the Wage and Contribution report.

Position	Length	Field Name	Description	Data Source or Valid Values
1	1	Record Identifier	Identifies the record type.	The valid value is S.
2–10	9	Social Security Number	The employee's Social Security number.	The field value is retrieved from the Social Security field on the Employee Information page.
11–30	20	Last Name	The employee's last name.	The field value is retrieved from the Last Name field on the Employee Information page.
31–42	12	First Name	The employee’s first name.	The field value is retrieved from the First Name field on the Employee Information page.
43	1	Middle Initial	The employee's middle initial.	The field value is retrieved from the Middle Name field on the Employee Information page.
44–45	2	State Code	The FIPS numeric code identifying the state.	The valid value is 50.
46–49	4	Report Quarter Year	The reporting quarter and year.	System-calculated. Derived from the Reporting Quarter and Reporting Year fields on the VT Quarterly Wage Report - Load page. The system converts the selected quarter to its last calendar month and appends the last two digits of the year (MMYY format).
50–63	14	Gross Wages	The total gross wages paid to the employee during the quarter.	System-calculated during the load process. Summed from payroll check history for the date range defined by the Check Issue Start Date and Check Issue End Date fields and the pay runs selected on the VT Quarterly Wage Report - Load page.
64–142	79	Filler	Leave blank	spaces
143–146	4	Taxing Entity Code	Identifies the taxing entity type.	The valid value is UTAX.
147–154	8	Filler	Leave blank	spaces
155–161	7	Employer Account Number	The seven-digit account number assigned to the employer by VDOL.	Retrieved from the Employer VDOL Account Number field on the VT Quarterly Wage Report - Setup - Employer page.
162–232	71	Filler	Leave blank	spaces
233	1	Hourly/Salaried Flag	Indicates whether the employee is paid on an Hourly or Salary basis.	Valid values: H = Hourly S = Salary System derived from the employee's primary Pay Method on the Pay Rate Information page. Employees with a pay method of H (hourly) or S (salary) are flagged as H; all others are flagged as S.
234	1	Gender	The employee's gender.	Valid values: M F The field value is retrieved from the Sex at Birth field on the Employee Information page.
235–238	4	Filler	Fill with zeros.	The valid value is 0000.
239–244	6	Hourly Wage	The hourly wages if the employee is hourly. For salaried employees, this field is left blank.	System-calculated for hourly employees only, by querying the employee's pay rate from payroll check history for the date range selected on the VT Quarterly Wage Report - Load page.
245–275	31	Filler	Leave blank	spaces