This page (revision-43) was last changed on 26-Nov-2021 10:22 by mmcfarland

This page was created on 26-Nov-2021 10:22 by jmyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
43 26-Nov-2021 10:22 528 bytes mmcfarland to previous
42 26-Nov-2021 10:22 527 bytes mmcfarland to previous | to last
41 26-Nov-2021 10:22 21 KB mmcfarland to previous | to last

Page References

Incoming links Outgoing links
W 2_PROCESS_GOVERNMENT_MEDIA_REPORTING...nobody
W2_PROCESS_GOVERNMENT_MEDIA_REPORTING

Version management

Difference between version and

At line 142 changed one line
265|Blank|
|265|Blank|
|266-274|Spouse’s SSN\\ \\Blank|
|275-285|Wages Subject to Puerto Rico Tax\\Stored as zeroes|
|286-296|Commissions Subject to Puerto Rico Tax\\Stored as zeroes|
|297-307|Allowances Subject to Puerto Rico Tax\\Stored as zeroes|
|308-318|Tips Subject to Puerto Rico Tax\\Stored as zeroes|
|319-329|Total Wages, commissions, tips, and allowances subject to Puerto Rico Tax\\Stored as zeroes|
|330-340|Puerto Rico Tax Withheld\\Stored as zeroes|
|341-351|Retirement Fund Subject to Puerto Rico Tax\\Stored as zeroes|
|352-362|Blank|
At line 144 removed 19 lines
266-274 - Spouse’s SSN
- blank
275-285 - Wages Subject to Puerto Rico Tax\\Stored as zeroes|
286-296 - Commissions Subject to Puerto Rico Tax\\Stored as zeroes|
297-307 - Allowances Subject to Puerto Rico Tax\\Stored as zeroes|
308-318 - Tips Subject to Puerto Rico Tax\\Stored as zeroes|
319-329 - Total Wages, commissions, tips, and allowances subject to Puerto Rico Tax\\Stored as zeroes|
330-340 - Puerto Rico Tax Withheld\\Stored as zeroes|
341-351 - Retirement Fund Subject to Puerto Rico Tax\\Stored as zeroes|
352-362|Blank|
At line 165 changed one line
363-373 - Total wages, tips and other compensation subject to Virgin Islands, … income tax\\Stored as zeroes|
|363-373|Total wages, tips and other compensation subject to Virgin Islands income tax\\Stored as zeroes|
|374-384|Virgin Islands Income Tax Withheld\\Stored as zeroes|
|385-512|Blank|
At line 167 removed 5 lines
374-384 - Virgin Islands, … etc Income Tax Withheld\\Stored as zeroes|
385-512|Blank|
At line 174 changed 2 lines
1-2 - Record Identifier
- Constant "RS"
|1-2|Record Identifier|Constant "RS"
|3-4|State code, appropriate FIPS postal numeric code|System Derived from the State being reported\\ \\e.g. California is code "06"
|5-9|Taxing Entity Code|If County, City or School district tax is reported, this field is derived from [IDGV] 'W2 TAXING ENTITY' field for the County, City or School district tax being reported
|10-18|Social Security Number|Derived from [IDFDV], Field Identifier: ‘W2-EE-SSN’\\ \\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’
|34-48|Employee Middle Name or Initial|Derived from [IDFDV], Field Identifier: ‘W2-EE-MIDDLE’
|49-68|Employee Last Name|Derived from [IDFDV], Field Identifier: ‘W2-EE-LAST-NAME’
|69-72|Employee Suffix|Derived from [IDFDV], Field Identifier: ‘W2-EE-SUFFIX’
|73-94|Employee Location Address|Derived from [IDFDV], Field Identifier: ‘W2-EE-LOCN-ADDR’
|95-116|Employee Delivery Address|Derived from [IDFDV], Field Identifier: ‘W2-EE-DELIV-ADDR’
|117-138|Employee City|Derived from [IDFDV], Field Identifier: ‘W2-EE-CITY’
|139-140|Employee State Abbreviation|Derived from [IDFDV], Field Identifier: ‘W2-EE-STATE’
|141-145|Employee ZIP Code|Derived from [IDFDV], Field Identifier: ‘W2-EE-ZIP’
|146-149|Employee ZIP Code Extension|Derived from [IDFDV], Field Identifier: ‘W2-EE-ZIP-EXT’
|150-154|Blank|
|155-177|Employee Foreign State/Province|Derived from [IDFDV], Field Identifier: ‘W2-EE-F-STATE’
|178-192|Employee Foreign Postal Code|Derived from [IDFDV], Field Identifier: ‘W2-EE-F-POSTAL’
|193-194|Employee Country Code|Derived from [IDFDV], Field Identifier: ‘W2-EE-COUNTRY’
At line 177 removed 39 lines
3-4 - State code, appropriate FIPS postal numeric code
- system Derived from the State being reported
- e.g. California is code "06"
5-9 - Taxing Entity Code
- if County, City or School district tax is reported, this field is derived from IDGV 'W2 TAXING ENTITY' field for the County, City or School district tax being reported
10-18 - Social Security Number|Derived from [IDFDV], Field Identifier: ‘W2-EE-SSN’
- 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’
34-48 - Employee Middle Name or Initial|Derived from [IDFDV], Field Identifier: ‘W2-EE-MIDDLE’
49-68 - Employee Last Name|Derived from [IDFDV], Field Identifier: ‘W2-EE-LAST-NAME’
69-72 - Employee Suffix|Derived from [IDFDV], Field Identifier: ‘W2-EE-SUFFIX’
73-94 - Employee Location Address|Derived from [IDFDV], Field Identifier: ‘W2-EE-LOCN-ADDR’
95-116 - Employee Delivery Address|Derived from [IDFDV], Field Identifier: ‘W2-EE-DELIV-ADDR’
117-138 - Employee City|Derived from [IDFDV], Field Identifier: ‘W2-EE-CITY’
139-140 - Employee State Abbreviation|Derived from [IDFDV], Field Identifier: ‘W2-EE-STATE’
141-145 - Employee ZIP Code|Derived from [IDFDV], Field Identifier: ‘W2-EE-ZIP’
146-149 - Employee ZIP Code Extension|Derived from [IDFDV], Field Identifier: ‘W2-EE-ZIP-EXT’
150-154|Blank|
155-177 - Employee Foreign State/Province|Derived from [IDFDV], Field Identifier: ‘W2-EE-F-STATE’
178-192 - Employee Foreign Postal Code|Derived from [IDFDV], Field Identifier: ‘W2-EE-F-POSTAL’
193-194 - Employee Country Code|Derived from [IDFDV], Field Identifier: ‘W2-EE-COUNTRY’
At line 181 added 3 lines
If ‘Period Type’ = ‘Quarter’ is specified, then Location 195 to 267 will be filled.
Please read document [US_Annual_Qtrly_Reporting_XX.doc] for the specific state where XX is the State code.
If the State document does not exist, please read [US_Annual_Qtrly_Reporting_GEN.doc] for quarterly reporting.
At line 218 removed 4 lines
If the user specified ‘Period Type’ = ‘Quarter’, then Location 195 to 267 will be filled.
Please read document US_Annual_Qtrly_Reporting_XX.doc for the specific State where XX is the State Code.
If the State document does not exist, please read US_Annual_Qtrly_Reporting_GEN.doc for quarterly reporting.
At line 223 changed 2 lines
195-196 - Optional code
- blank
|195-196|Optional code\\Blank|
|197-202|Reporting Period MMCCYY|From user specified Period End Date converted to MMCCYY for the quarter\\ \\e.g. Period End Date = ‘31-Dec-2007’, then reporting period is ‘122007’
|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]. Therefore for employees who exceed the maximum wage base, this identifier will contain no SUI Insurance wages, [RPYEU] would 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-224|State Quarterly Unemployment Insurance Taxable Wages|This amount is derived from State Quarterly Unemployment Insurance Total Wages and the SUI Maximum wage base as defined by the State government.\\ \\
Read document [US_Annual_Qtrly_Reporting_XX.doc] for detail for quarterly reporting.
|225-226|Number of Weeks Worked|From system derived number of Weeks Worked for the Reporting State\\ \\The system reads all Pay Headers with pay category = ‘Regular Pay’ that are not reversed with Pay Issue Date falls within the user specified Quarter begin and end date\\ \\If the Pay Header’s Work State or Home State is the same as the reporting state, then the Pay Header Tax Weeks is accumulated
|227-234|Date First Employed MMDDCCYY|From system derived latest Employment Hired Date
|235-242|Date of Separation MMDDCCYY|From system derived latest Employment Termination Date that is greater than the Employment Hired Date
|243-247|Blank|
|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-273|Blank|
At line 226 removed 30 lines
197-202 - Reporting Period MMCCYY
- From user specified Period End Date converted to MMCCYY for the quarter
- e.g. Period End Date = ‘31-Dec-2007’, then reporting period is ‘122007’
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, therefore RPYEU is 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-224 - State Quarterly Unemployment Insurance Taxable Wages
- this amount is derived from State Quarterly Unemployment Insurance Total Wages and the SUI Maximum wage base as defined by the State government
- please read document US_Annual_Qtrly_Reporting_XX.doc for detail for quarterly reporting
225-226 - Number of Weeks Worked
- From system derived number of Weeks Worked for the Reporting State
- the system reads all Pay Headers with pay category = ‘Regular Pay’ that are not reversed with Pay Issue Date falls within the user specified Quarter begin and end date
- if the Pay Header’s Work State or Home State is the same as the reporting State, then the Pay Header Tax Weeks is accumulated
227-234 - Date First Employed MMDDCCYY
- From system derived latest Employment Hired Date
235-242 - Date of Separation MMDDCCYY
- From system derived latest Employment Termination Date that is greater than the Employment Hired Date
243-247|Blank|
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 screen for the SUI Registration of the State
268-273|Blank|
At line 257 removed one line
This page (revision-43) was last changed on 26-Nov-2021 10:22 by mmcfarlandTop