The following table lists the columns, field names, length, and comments for the State record.
|
Columns |
Field Name |
Length |
Comments |
|---|---|---|---|
|
1-2 |
Record Identifier |
2 |
Constant “RS” This field is required. |
|
3-4 |
State Code |
2 |
employee.state The value for Oregon is 41. This field is required. |
|
5-9 |
Taxing Entity Code |
5 |
blanks |
|
10-18 |
Social Security Number |
9 |
employee.ssn This field is required. |
|
19-33 |
Employee First Name |
15 |
employee.fname This field is required. |
|
34-48 |
Employee Middle Name |
15 |
employee.fname This field is required. |
|
49-68 |
Employee Last Name |
20 |
employee.lname This field is required. |
|
69-72 |
Suffix |
4 |
blanks |
|
73-94 |
Location Address |
22 |
blanks |
|
95-116 |
Delivery Address |
22 |
employee.street/Post Office box |
|
117-138 |
City |
22 |
employee.city |
|
139-140 |
State Abbreviation |
2 |
employee.state |
|
141-145 |
Zip Code |
5 |
employee.zip |
|
146-149 |
Zip Code Extension |
4 |
employee.zipext or blank fill |
|
150-194 |
Blank |
45 |
blanks |
|
195-196 |
Optional Code |
2 |
blanks |
|
197-202 |
Reporting Period |
6 |
End Month/yr of report <MMYYYYY> This field is required. |
|
203-213 |
State Quarterly Unemployment Insurance Total Wages |
11 |
sum(checkhi2.amt) * 100 minus mtd_sal for exempt paycodes No negative amounts right justify & zero fill This field is required. |
|
214-224 |
State Quarterly Unemployment Insurance Total Taxable Wages |
11 |
blanks |
|
225-226 |
Number of Weeks Worked |
2 |
blanks |
|
227-234 |
Date First Employed |
8 |
blanks |
|
235-242 |
Date of Separation |
8 |
blanks |
|
243-247 |
Blank |
5 |
blanks |
|
248-254 |
State Employer Account Number |
7 |
blanks |
|
*255-267 |
Business Identification Number |
13 |
This field is required. |
|
268-273 |
Blank |
6 |
blanks |
|
274-275 |
State Code |
2 |
blanks |
|
276-286 |
State Taxable Wages |
11 |
blanks |
|
287-297 |
State Income Tax Withheld |
11 |
blanks |
|
298-307 |
Other State Data |
10 |
blanks |
|
308 |
Tax Type Code |
1 |
blanks |
|
309-319 |
Local Taxable Wages |
11 |
blanks |
|
320-330 |
Local Income Tax Withheld |
11 |
blanks |
|
331-337 |
State Control # |
7 |
blanks |
|
338-340 |
Hours Worked |
3 |
NNN (sum(checkhi2.hours)) This field is required. |
|
*341-351 |
State Quarterly PFMLI Total Wages |
11 |
This field is required starting January 2023. |
|
*352-362 |
State Wide Transit Tax Subject Wages |
11 |
This field is required starting January 2023. |
|
*363-373 |
State Wide Transit Tax (STT) |
11 |
This field is required starting January 2023. |
|
374-412 |
Supplemental Data |
39 |
blanks |
|
413-487 |
Supplemental Data |
75 |
blanks |
|
488-512 |
Blank |
25 |
blanks |