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 |