RPYEU needs to be run twice to generate Quarterly UI Wage Reporting for the state of Nevada:
Column | Description | Source |
---|---|---|
1-2 | Record Identifier | Constant "RA" |
3-11 | Submitter’s Employer ID number (EIN) | Numeric only Derived from IDFDV Field Identifier: ‘SUB-ER-EIN’ (seq 1000) |
12-216 NV | Not Required | |
217-273 | Submitter Name | Derived from IDFDV Field Identifier: ‘SUB-SUBM-NAME’ (seq 1150) |
274-295 | Submitter Location Address | Derived from IDFDV Field Identifier: ‘SUB-SUBM-LOCN’ (seq 1160) |
296-317 | Submitter Delivery Address | Derived from IDFDV Field Identifier: ‘SUB-SUBM-DELIV’ (seq 1170) |
318-339 | Submitter City | Derived from IDFDV Field Identifier: ‘SUB-SUBM-CITY’ (seq 1180) |
340-341 | Submitter State Abbreviation | Derived from IDFDV Field Identifier: ‘SUB-SUBM-STATE’ (seq 1190) |
342-346 | Submitter ZIP Code | Derived from IDFDV Field Identifier: ‘SUB-SUBM-ZIP’ (seq 1200) |
347-350 | Submitter ZIP Code Extension | Derived from IDFDV Field Identifier: ‘SUB-SUBM-ZIP-EXT’ (seq 1210) |
351-355 NV | Blanks | Not required |
356-378 | Submitter Foreign State/Province | Derived from IDFDV Field Identifier: ‘SUB-SUBM-F-STATE’ (seq 1220) |
379-393 | Submitter Foreign Postal Code | Derived from IDFDV Field Identifier: ‘SUB-SUBM-F-POST’ (seq 1230) |
394-395 | Submitter Country Code | Derived from IDFDV Field Identifier: ‘SUB-SUBM-COUNTRY’ (seq 1240) |
396-422 | Contact Name | Derived from IDFDV Field Identifier: ‘SUB-CONT-NAME’ (seq 1250) |
423-437 | Contact Phone Number | Derived from IDFDV Field Identifier: ‘SUB-CONT-TEL’ (seq 1260) |
438-442 | Contact Phone Extension | Derived from IDFDV Field Identifier: ‘SUB-CONT-TEL-EXT’ (seq 1270) |
443-445 NV | Blanks | Not required |
446-485 | Contact E-mail | Derived from IDFDV Field Identifier: ‘SUB-CONT-EMAIL’ (seq 1280) |
486-488 NV | Blanks | Not required |
489-498 | Contact FAX | Derived from IDFDV Field Identifier: ‘SUB-CONT-FAX’ (seq 1290) |
499-499 | Filler | |
500-500 | Preparer Code | Derived from IDFDV Field Identifier: ‘SUB-PREPARER’ (seq 1310) |
501-512 NV | Not Required |
Column | Description | Source |
---|---|---|
1-2 | Record Identifier | Constant "RE" |
3-25 NV | Not Required | |
26 | Terminating Business Indicator | Derived from IDFDV Field Identifier: ‘W2-ER-TERM-BUS’ (seq 1520) |
27-39 NV | Not Required | |
40-96 | Employer Name | Derived from IDFDV Field Identifier: ‘W2-ER-NAME’ (seq 2010) |
97-118 | Employer Location Address | Derived from IDFDV Field Identifier: ‘W2-ER-LOCN-ADDR’ (seq 2020) |
119-140 | Employer Delivery Address | Derived from IDFDV Field Identifier: ‘W2-ER-DELIV-ADDR’ (seq 2030) |
141-162 | Employer City | Derived from IDFDV Field Identifier: ‘W2-ER-CITY’ (seq 2040) |
163-164 | Employer State Abbreviation | Derived from IDFDV Field Identifier: ‘W2-ER-STATE’ (seq 2050) |
165-169 | Employer ZIP Code | Derived from IDFDV Field Identifier: ‘W2-ER-ZIP’ (seq 2060) |
170-173 | Employer ZIP Code Extension | Derived from IDFDV Field Identifier: ‘W2-ER-ZIP-EXT’ (seq 2070) |
174-178 NV | Not Required | |
179-201 | Employer Foreign State/Province | Derived from IDFDV Field Identifier: ‘W2-ER-F-STATE’ (seq 2080) |
202-216 | Employer Foreign Postal Code | Derived from IDFDV Field Identifier: ‘W2-ER-F-POSTAL’ (seq 2090) |
217-218 | Employer Country Code | Derived from IDFDV Field Identifier: ‘W2-ER-COUNTRY’ (seq 2100) |
219-512 NV | Not Required |
Column | Description | Source |
---|---|---|
1-2 | Record Identifier | Constant "RS" |
3-4 | State Code | Appropriate FIPS postal numeric code Derived from the State being reported, from IDFDV sequence 7000 e.g. Nevada is code "32" |
5-8 | Taxing Entity Code | Constant ‘WAGE’ |
9-9 | Blank | |
10-18 | Social Security Number | Derived from IDFDV Field Identifier: ‘W2-EE-SSN’ (seq 2500) If an invalid SSN is encountered, this field is entered with zeroes |
19-33 | Employee First Name | Derived from IDFDV Field Identifier: ‘W2-EE-FIRST-NAME’ (seq 2510) |
34-48 | Employee Middle Name or Initial | Derived from IDFDV Field Identifier: ‘W2-EE-MIDDLE’ (seq 2520) |
49-68 | Employee Last Name | Derived from IDFDV Field Identifier: ‘W2-EE-LAST-NAME’ (seq 2530) |
69-72 | Employee Suffix | Derived from IDFDV Field Identifier: ‘W2-EE-SUFFIX’ (seq 2540) |
73-196 NV | Not Required | |
197-202 | Reporting Period MMCCYY | From user specified Period End Date converted to MMCCYY for the quarter e.g. Period End Date = ‘31-Dec-2016’, then reporting period is ‘122016’ |
203-213 | State Quarterly Unemployment Insurance Total Wages | Derived from IDFDV Field Identifier: ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’ Note that the IDFDV Identifier ‘W2-SUI-WAGE-ER’ is not used to report this field because the value of Identifier ‘W2-SUI-WAGE-ER’ may already been capped by Vertex during the US Tax calculation in UPCALC and therefore for employees who exceed the maximum wage base, this Identifier will contain no SUI Insurance wages. RPYEU will then be using the State Taxable wages from Identifier ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’ that are related to the employee Home GEO and Work GEO code to report SUI Total Wages |
214-247 NV | Not Required | |
248-267 | State Employer Account Number | Derived from IDFDV Field Identifier: ‘W2-STATE-REGIST’ for the reporting state When RPYEU is run, if the Media Format = ‘State SUI File Format’, then this field contains the SUI Registration Number from IDGV for the SUI Registration of the state |
268-337 NV | Not Required | |
338-346 NV | Quarterly Tip Wages | State Specific Data If not used, enter blanks |
347-350 NV | Hours Paid | Optional, not currently required |
347-512 NV | Zip Code of Work Site | Optional, not currently required |
347-512 NV | Not Required |
Column | Description | Source |
---|---|---|
1-2 NV | Record Identifier | Constant ‘RS’ |
3-4 NV | State FIPS Code | Nevada = ‘32’ |
5-8 NV | State Record Type | Constant ‘SUMM‘ |
9-10 NV | Blank | |
11-19 NV | Federal Tax ID Number | State Registration Number stored in IDGV |
20-20 NV | Blank | |
21-29 NV | State Employer Account Number | Derived from IDFDV Field Identifier: ‘W2-STATE-REGIST’ for the reporting state When RPYEU is run, if the Media Format = ‘State SUI File Format’, then this field contains the SUI Registration Number from IDGV for the SUI Registration of the state |
30-30 NV | Blank | |
31-36 NV | Reporting Period (MMCCYY) | From user specified Period End Date converted to MMCCYY for the quarter e.g. Period End Date = ‘31-Dec-2016’, then reporting period is ‘122016’ |
37-37 NV | Blank | |
38-44 NV | Number of RS Wage Records | Total number of code "RS" wage records reported since last code "RE" record |
45-45 NV | Blank | |
46-59 NV | Total Wages, Tips and Other Compensation this Quarter | Total of all code ‘RS’ wage records since last ‘RE’ record |
60-60 NV | Blank | |
61-74 NV | Non-Taxable Wages | Wages in excess of the Taxable wages portion paid during this quarter Total of all code ‘RS’ wage records since last ‘RE’ record |
75-75 NV | Blank | |
76-89 NV | Taxable Wages Paid This Quarter | Total of all code ‘RS’ wage records since last ‘RE’ record |
90-103 NV | Blank | |
104-110 NV | Month-1 Employment for Employer | Total number of employee covered by UI worked or receive pay for the pay period including the 12th day of the first reporting month. Total of all ‘S’ records after the last ‘E’ record |
111-111 NV | Blank | |
112-118 NV | Month-2 Employment | Total number of employee covered by UI worked or receive pay for the pay period including the 12th day of the second reporting month Total of all ‘S’ records after the last ‘E’ record |
119-119 NV | Blank | |
120-126 NV | Month-3 Employment | Total number of employee covered by UI worked or receive pay for the pay period including the 12th day of the third reporting month Total of all ‘S’ records after the last ‘E’ record |
127-127 NV | Blank | |
128-128 NV | No Workers/No Wages Indicator | Enter a ‘Y’ if there were no workers/wages for the quarter being reported, otherwise leave blank |
129-512 NV | Not Required |
Column | Description | Source |
---|---|---|
1-2 | Record Identifier | Constant "RF" |
3-512 NV | Blanks | Not required |
Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation