S Record - Wage Report Details
The following table lists the field name, description, format, length, position, and from where the data is retrieved.
Field Name | Description | Format | Length | Position | Location |
|---|---|---|---|---|---|
Record ID | "S" | Text | 1 | 1-1 | Not Applicable |
SSN | The employee's social security number. | Number | 9 | 2-10 | employee.ssn[1,3], employee.ssn[5,6], employee.ssn[8,11] |
Employee Last Name | The employee's last name. | Text | 20 | 11-30 | employee.l_name |
Employee First Name | The employee's first name. | Text | 12 | 31-42 | employee.f_name |
Employee Middle Initial | The employee's middle initial. | Text | 1 | 43 | employee.m_name |
State Code | 09 | Number | 2 | 44-45 | 09 |
Reporting Quarter and Year | Indicates the reporting month and year of the calendar quarter. For example, the first quarter of 2022 is 032022. | Number | 6 | 46-51 | Reporting Year and Reporting Quarter entered by the user. |
Reserved | Blank | Not Applicable | 12 | 52-63 | Blank |
Total Wages Paid This Quarter | The sum of the employee's gross wages for the quarter. | Number | 14 | 64-77 | payroll.tearn_q x 100 |
Reserved | Blank | Not Applicable | 65 | 78-142 | Blank |
Taxing Entity Code | Wage | Text | 4 | 143-146 | Wage |
Employer Account Number | The ten-digit Employer Account Number. | Number | 10 | 147-156 | Retrieved from the Employer Account Number field on the CT Quarterly Wage Report - Employer Information page. |
Reserved | Blank | Not Applicable | 65 | 157-276 | Blank |