CODE RS - State Record
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 |