This page (revision-155) was last changed on 19-Oct-2022 21:04 by Karen Parrott

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
155 19-Oct-2022 21:04 1 KB Karen Parrott to previous
154 26-Nov-2021 10:22 1 KB kparrott to previous | to last
153 26-Nov-2021 10:22 1 KB mmcfarland to previous | to last
152 26-Nov-2021 10:22 2 KB mmcfarland to previous | to last
151 26-Nov-2021 10:22 2 KB kparrott to previous | to last
150 26-Nov-2021 10:22 2 KB kparrott to previous | to last
149 26-Nov-2021 10:22 2 KB kparrott to previous | to last
148 26-Nov-2021 10:22 2 KB kparrott to previous | to last
147 26-Nov-2021 10:22 2 KB kparrott to previous | to last
146 26-Nov-2021 10:22 2 KB rforbes to previous | to last
145 26-Nov-2021 10:22 2 KB eyeung to previous | to last
144 26-Nov-2021 10:22 2 KB eyeung to previous | to last
143 26-Nov-2021 10:22 2 KB rforbes to previous | to last Taxation W2 Process ==> W2 Process
142 26-Nov-2021 10:22 2 KB rforbes to previous | to last W2 Process ==> Taxation W2 Process
141 26-Nov-2021 10:22 2 KB jmyers to previous | to last

Page References

Incoming links Outgoing links
W 2 Process
W2 Process

Version management

Difference between version and

At line 23 changed 2 lines
*‘DD’ in Box 12 (optional for 2011) used to report the Cost of Employer-Sponsored Health Coverage
*‘EE’ in Box 12 used to report the Designated Roth Contributions under a governmental section 457(b) plan%%
*‘DD’ in Box 12 (optional for 2011) used to report the Cost of Employer-Sponsored Health Coverage
*‘EE’ in Box 12 used to report the Designated Roth Contributions under a governmental section 457(b) plan%%
At line 26 changed one line
%%warning Important: For Oracle reports, RPW2/RP1099R must be run and the report sent to the PDF file instead of to the previewer. RPW2/RP1099R aligns the W2/1099R government forms in PDF format and allows the user to adjust the parameters of 'Adjust Top Margin' and ‘Between Form Space’ fields when generating the PDF file. Once the PDF file is generated, the Page set up does not need to be adjusted when printing.\\ \\For Windward report, RPW2 supports the 2-on-a-page form only.%%
%%warning Important: For Oracle reports, RPW2/RP1099R must be run and the report sent to the PDF file instead of to the previewer. RPW2/RP1099R aligns the W2/1099R government forms in PDF format and allows the user to adjust the parameters of 'Adjust Top Margin' and ‘Between Form Space’ fields when generating the PDF file. Once the PDF file is generated, the Page set up does not need to be adjusted when printing.\\ \\For Windward report, RPW2 supports the 2-on-a-page form only.%%
At line 35 changed one line
For 2011-2012 reporting, [IDFD] Form Code ‘HL$US-W2-2012’ is used.
For 2011-2012 reporting, [IDFD] Form Code ‘HL$US-W2-2012’ is used.
At line 37 changed 2 lines
!IDFD – Store Option
For 2011-2012 reporting, [IDFD] Form Code ‘HL$US-W2-2012’ has supplied the ‘Store Option’ starting from Seq# 2000 in order for [RPYEU] to store the Employer Name / Addresses, Employee Name / Addresses in the Government Remittance tables.
!IDFD – Store Option
For 2011-2012 reporting, [IDFD] Form Code ‘HL$US-W2-2012’ has supplied the ‘Store Option’ starting from Seq# 2000 in order for [RPYEU] to store the Employer Name / Addresses, Employee Name / Addresses in the Government Remittance tables.
At line 40 changed one line
%%warning Important:[RPYEU] must be run with the new [IDFD] Form Code ‘HL$US-W2-2012’ or a copy of this Form Code that has the ‘Store Option’ set up to store the Names / Addresses and the Amounts in the Government Remittance Tables.\\ \\Any prior year’s Form Codes do not supply this option and therefore will not turn on the Store feature for [RPYEU].%%
%%warning Important:[RPYEU] must be run with the new [IDFD] Form Code ‘HL$US-W2-2012’ or a copy of this Form Code that has the ‘Store Option’ set up to store the Names / Addresses and the Amounts in the Government Remittance Tables.\\ \\Any prior year’s Form Codes do not supply this option and therefore will not turn on the Store feature for [RPYEU].%%
At line 42 changed one line
!RPYEU – New Capabilities
!RPYEU – New Capabilities
At line 46 changed one line
#[RPYEU] parameter ‘Sort by Active/Inactive’ has been enhanced from a [X_YES_NO] toggle to use the lexicon value [X_W2_SORT_ACTIVE].\\This allows sorting of terminated employees to be before or after the ‘Sort Level’ that is defined in the prompt. Read the [RPYEU Sort Level|W2 Process#RPYEUSortLevel] section below.
#[RPYEU] parameter ‘Sort by Active/Inactive’ has been enhanced from a [X_YES_NO] toggle to use the lexicon value [X_W2_SORT_ACTIVE].\\This allows sorting of terminated employees to be before or after the ‘Sort Level’ that is defined in the prompt. Read the [RPYEU Sort Level|W2 Process#RPYEUSortLevel] section below.
At line 52 changed one line
|2|Print Control Number as defined from RPYEU ‘Sort Level By’ prompt
|2|Print Control Number as defined from RPYEU ‘Sort Level By’ prompt
At line 54 changed 3 lines
|4|Print ‘Sort Level By’ prompt and Person Code
|5|Print ‘Sort Level By’ prompt and W2-CONTROL-NUM Identifier
|6|Print ‘Sort Level By’ prompt and W2-CONTROL-NUM Identifier and Person Code
|4|Print ‘Sort Level By’ prompt and Person Code
|5|Print ‘Sort Level By’ prompt and W2-CONTROL-NUM Identifier
|6|Print ‘Sort Level By’ prompt and W2-CONTROL-NUM Identifier and Person Code
At line 58 changed one line
!RPW2 – capabilities (Oracle Report Only)
!RPW2 – capabilities (Oracle Report Only)
At line 64 changed one line
*W2 Form Copy A, 1, B, C, 2, D and instructions are taken directly from the government link above, however, it is the user’s responsibility to ensure these Employee copies are acceptable by the government as substitute for the pre-printed forms prior to distributing to the employees.
*W2 Form Copy A, 1, B, C, 2, D and instructions are taken directly from the government link above, however, it is the user’s responsibility to ensure these Employee copies are acceptable by the government as substitute for the pre-printed forms prior to distributing to the employees.
At line 125 changed one line
!IMUF – Define User Fields for [IDGV]
!IMUF – Define User Fields for [IDGV]
At line 140 changed one line
For Quarterly reporting, these UDF's are used when ‘HL$US-QTR-2004’ Form Code is being used:
For Quarterly reporting, these UDF's are used when ‘HL$US-QTR-2004’ Form Code is being used:
At line 142 changed one line
!IMUF – Define User Fields for [IDDP]
!IMUF – Define User Fields for [IDDP]
At line 150 changed one line
!IMUF – Define User Fields for [IEID]
!IMUF – Define User Fields for [IEID]
At line 159 changed one line
!IMUF – Define User Fields for [IDCO]
!IMUF – Define User Fields for [IDCO]
At line 164 changed one line
!IDCO – Define ISO Country Code for Foreign Countries
!IDCO – Define ISO Country Code for Foreign Countries
At line 178 changed 3 lines
!IDDP – Department Screen
*The State of Minnesota requires a quarterly file report by MN State Unemployment Insurance Account Number and MN Employer Unit Number. These two numbers are defined at the department level, therefore, the UDF ‘SUI ER Number’ must be set up for each department. (e.g. For Department ‘Planning & Zoning’, the MN number is ‘7977999-004’, UDF ‘SUI ER Number’ = 7977999-004 should be entered on [IDDP])
*If the ‘SUI ER Number’ is not set up for a department, then the SUI ER Number from [IDGV] is used.
!IDDP – Department Screen
*The State of Minnesota requires a quarterly file report by MN State Unemployment Insurance Account Number and MN Employer Unit Number. These two numbers are defined at the department level, therefore, the UDF ‘SUI ER Number’ must be set up for each department. (e.g. For Department ‘Planning & Zoning’, the MN number is ‘7977999-004’, UDF ‘SUI ER Number’ = 7977999-004 should be entered on [IDDP])
*If the ‘SUI ER Number’ is not set up for a department, then the SUI ER Number from [IDGV] is used.
At line 182 changed one line
*For all other states, ‘W2 Destination’ may be entered for distributing the W2 forms by department.
*For all other states, ‘W2 Destination’ may be entered for distributing the W2 forms by department.
At line 184 changed 3 lines
!IEID – Employee Identity Screen User Field
[IEID] is used to enter the ‘W2 Destination’, ‘MMREF Officer Code’ for the employee
*‘W2 Destination’ may be entered for distributing the W2 forms for this employee
!IEID – Employee Identity Screen User Field
[IEID] is used to enter the ‘W2 Destination’, ‘MMREF Officer Code’ for the employee
*‘W2 Destination’ may be entered for distributing the W2 forms for this employee
At line 188 changed one line
!IDGR – Define Group for Govt Registration
!IDGR – Define Group for Govt Registration
At line 191 changed one line
For each group at the Federal level, the Federal Registration number is retrieved according to the ‘Fed Regist Set’ and ‘Fed Regist Type’ from [IDGV] and then displayed on [IDGR].
For each group at the Federal level, the Federal Registration number is retrieved according to the ‘Fed Regist Set’ and ‘Fed Regist Type’ from [IDGV] and then displayed on [IDGR].
At line 193 changed one line
For each group at the State/Prov/Local level, a ‘State/Prov Set’ and ‘State/Prov Type’ can be pointed to. Since each group can be paid in many different states, the State/Prov Registration number cannot be displayed on [IDGR]. For each employee belongs to this group, the State Registration Number is retrieved from [IDGV] by ‘State/Prov Set’ and ‘State/Prov Type’ and the Pay Header State/Prov of this employee.
For each group at the State/Prov/Local level, a ‘State/Prov Set’ and ‘State/Prov Type’ can be pointed to. Since each group can be paid in many different states, the State/Prov Registration number cannot be displayed on [IDGR]. For each employee belongs to this group, the State Registration Number is retrieved from [IDGV] by ‘State/Prov Set’ and ‘State/Prov Type’ and the Pay Header State/Prov of this employee.
At line 195 changed one line
At the local level, the Local Registration Number is retrieved from [IDGV] by ‘Local Regist Set’ and ‘Local Regist Type’ and the GEO Local of this employee
At the local level, the Local Registration Number is retrieved from [IDGV] by ‘Local Regist Set’ and ‘Local Regist Type’ and the GEO Local of this employee
At line 197 changed one line
Each group must define one of the following ‘W2 Employment Type’ for W2 reporting purpose:
Each group must define one of the following ‘W2 Employment Type’ for W2 reporting purpose:
At line 199 changed one line
*F – Form 944 filer
*F – Form 944 filer
At line 202 changed 2 lines
*Q – Medicare Qualified Government Employment (MQGE)
*R – Regular (All others)
*Q – Medicare Qualified Government Employment (MQGE)
*R – Regular (All others)
At line 206 changed one line
%%information Note:For the ‘Q - MQGE' type employment, it is not required to group all employees under one group. The MQGE employees can belong to a group with ‘R’ type employment, [IPRLU] can specify the proper MEDICARE and FICA method to classify MQGE employees (see below for detail)%%
%%information Note:For the ‘Q - MQGE' type employment, it is not required to group all employees under one group. The MQGE employees can belong to a group with ‘R’ type employment, [IPRLU] can specify the proper MEDICARE and FICA method to classify MQGE employees (see below for detail)%%
At line 208 changed one line
!IDSP – Define States
!IDSP – Define States
At line 210 changed one line
*An entry must exist on [IDGV] for a state with a ‘State Registration’ in order for the state to be reported.
*An entry must exist on [IDGV] for a state with a ‘State Registration’ in order for the state to be reported.
At line 214 changed one line
!IDCN – Define Counties
!IDCN – Define Counties
At line 216 changed one line
*The County Code is the first two segments of the GEO code. (e.g. In Indiana, GEO code ‘15-097-0670’ is for the city of ‘Indianapolis’, the County Code ‘15-097-0000’ is for County of ‘Marion’, therefore, set up County Code ‘15-097-0000’ ‘Marion’ on (IDCN).
*The County Code is the first two segments of the GEO code. (e.g. In Indiana, GEO code ‘15-097-0670’ is for the city of ‘Indianapolis’, the County Code ‘15-097-0000’ is for County of ‘Marion’, therefore, set up County Code ‘15-097-0000’ ‘Marion’ on (IDCN).
At line 218 changed one line
*An entry must exist on [IDGV] with ‘Local Registration’ for a County in order for the County tax to be reported.
*An entry must exist on [IDGV] with ‘Local Registration’ for a County in order for the County tax to be reported.
At line 220 changed 3 lines
!IDTX – Define Tax Jurisdictions
*An entry must exist at the ‘City level’ for a tax jurisdiction in order for the city tax to be reported.
*An entry must exist on [IDGV] with ‘Local Registration’ for a city in order for the city tax to be reported.
!IDTX – Define Tax Jurisdictions
*An entry must exist at the ‘City level’ for a tax jurisdiction in order for the city tax to be reported.
*An entry must exist on [IDGV] with ‘Local Registration’ for a city in order for the city tax to be reported.
At line 224 changed one line
!IDSD – Define School Districts
!IDSD – Define School Districts
At line 227 changed 2 lines
!IDGV – One or Multiple Government Registrations
For each Entity on [IDGV], the Government Registration Set that is used to collect Federal, State and Local Registrations must first be defined. Under the Registration Set, ‘Federal Registration’ must be set up for Country ‘USA with valid ‘Employer Identification Number’. Then State, Local Registrations may be set up for each State or Local under the same Registration Set.
!IDGV – One or Multiple Government Registrations
For each Entity on [IDGV], the Government Registration Set that is used to collect Federal, State and Local Registrations must first be defined. Under the Registration Set, ‘Federal Registration’ must be set up for Country ‘USA with valid ‘Employer Identification Number’. Then State, Local Registrations may be set up for each State or Local under the same Registration Set.
At line 232 changed one line
*Then within this set of Government Registrations, set up Federal/State/Local Registrations on [IDGV] for this set. (For example, on [IDGV], the user should set up Federal Registration with Registration Type = ‘US Fed Regist 1’.
*Then within this set of Government Registrations, set up Federal/State/Local Registrations on [IDGV] for this set. (For example, on [IDGV], the user should set up Federal Registration with Registration Type = ‘US Fed Regist 1’.
At line 234 changed one line
%%information Note:If Registration Type ‘US Fed Regist 1’ is used, then the FICA registration should be defined using Registration Type = ‘US FICA Regist 1’, for MEDICARE registration, the Registration Type should = ‘US MEDI Regist 1’ etc. The last digit of the Registration Type must be matched.%%
%%information Note:If Registration Type ‘US Fed Regist 1’ is used, then the FICA registration should be defined using Registration Type = ‘US FICA Regist 1’, for MEDICARE registration, the Registration Type should = ‘US MEDI Regist 1’ etc. The last digit of the Registration Type must be matched.%%
At line 238 changed 2 lines
#One "Main Registration Set" can be used, then Registration Type ‘Fed Regist 1’, ‘Fed Regist 2’ up to ‘Fed Regist 9’ can be set up. This allows up to nine Federal Registrations.
#Multiple "Registration Sets" can be used, then set up Registration Type ‘Fed Regist 1’, ‘Fed Regist 2’ up to ‘Fed Regist 9’. This allows for an unlimited number of Federal Registrations.
#One "Main Registration Set" can be used, then Registration Type ‘Fed Regist 1’, ‘Fed Regist 2’ up to ‘Fed Regist 9’ can be set up. This allows up to nine Federal Registrations.
#Multiple "Registration Sets" can be used, then set up Registration Type ‘Fed Regist 1’, ‘Fed Regist 2’ up to ‘Fed Regist 9’. This allows for an unlimited number of Federal Registrations.
At line 241 changed one line
“Govt Registration Set” may be used to group similar Registrations together.
“Govt Registration Set” may be used to group similar Registrations together.
At line 256 changed one line
The [IDGV] “Govt Registration Set” and Registration Types are used on the [IDGR Registration|IDGR#RegistrationTab] tab for each of the Federal, State and Local level set up.
The [IDGV] “Govt Registration Set” and Registration Types are used on the [IDGR Registration|IDGR#RegistrationTab] tab for each of the Federal, State and Local level set up.
At line 261 changed 6 lines
If Registration Type = ‘US Fed Regist 1’ is used, then
*FICA Registration Type must = ‘US FICA Regist 1’
*MEDI Registration Type must = ‘US MEDI Regist 1’
If Registration Type = ‘US State Regist 1’ is used, then
*SUI Registration Type must = ‘US SUI Regist 1’
*SDI Registration Type must = ‘US SDI Regist 1’
If Registration Type = ‘US Fed Regist 1’ is used, then
*FICA Registration Type must = ‘US FICA Regist 1’
*MEDI Registration Type must = ‘US MEDI Regist 1’
If Registration Type = ‘US State Regist 1’ is used, then
*SUI Registration Type must = ‘US SUI Regist 1’
*SDI Registration Type must = ‘US SDI Regist 1’
At line 269 changed 6 lines
If Registration Type = ‘US Fed Regist 2’ is used, then
*FICA Registration Type must = ‘US FICA Regist 2’
*MEDI Registration Type must = ‘US MEDI Regist 2’
If Registration Type = ‘US State Regist 2’ is used, then
*SUI Registration Type must = ‘US SUI Regist 2’
*SDI Registration Type must = ‘US SDI Regist 2’
If Registration Type = ‘US Fed Regist 2’ is used, then
*FICA Registration Type must = ‘US FICA Regist 2’
*MEDI Registration Type must = ‘US MEDI Regist 2’
If Registration Type = ‘US State Regist 2’ is used, then
*SUI Registration Type must = ‘US SUI Regist 2’
*SDI Registration Type must = ‘US SDI Regist 2’
At line 276 changed one line
On the [IDGR Registration|IDGR#RegistrationTab] tab, when the user specifies to use State/Prov Type = ‘US State Regist 1’, this implies all State level registrations with the last digit matching ‘Regist 1’ should be used, thus ‘US SUI Regist 1’ will be used.
On the [IDGR Registration|IDGR#RegistrationTab] tab, when the user specifies to use State/Prov Type = ‘US State Regist 1’, this implies all State level registrations with the last digit matching ‘Regist 1’ should be used, thus ‘US SUI Regist 1’ will be used.
At line 278 changed 2 lines
!IDGV – Override Employer Name and Address by EIN
On the [IDGV Variables|IDGV#VariablesTab] tab, there is the option to define an override for the Employer’s Name and Address.
!IDGV – Override Employer Name and Address by EIN
On the [IDGV Variables|IDGV#VariablesTab] tab, there is the option to define an override for the Employer’s Name and Address.
At line 284 changed one line
!IDGV – Levels of Government Registrations
!IDGV – Levels of Government Registrations
At line 288 changed one line
*One or multiple Federal Registrations must exist for each entity with each Govt Regist Set for Registration Type ‘US Fed Regist 1’, etc.
*One or multiple Federal Registrations must exist for each entity with each Govt Regist Set for Registration Type ‘US Fed Regist 1’, etc.
At line 291 changed 2 lines
*An entry must exist for each state for an entity with ‘State Registration’ by Govt Regist Set and Registration Type
*When the ‘State Registration’ are being defined, , the ‘Variables’ tab must also be set up.
*An entry must exist for each state for an entity with ‘State Registration’ by Govt Regist Set and Registration Type
*When the ‘State Registration’ are being defined, , the ‘Variables’ tab must also be set up.
At line 294 changed 6 lines
*On the [IDGV Variables|IDGR#VariablesTab] tab, the variable ‘W2 State Media Filing’ must be set up to indicate if this state is required to produce a W2 File for the state.
*The ‘W2 State Media Filing’ values are:
**00 – Not required to file magnetic media to the state
**01 – Include State Code RS record in the Federal file, the federal file can be sent to the state
**02 – State requires its own file, do not include other state information in the State file
*If the State file layout is conforming to the standard federal SSA code RS format and the state accepts a copy of the federal file that includes the code RW records, ‘W2 State Media Filing’ variable = ‘01’ should be set up
*On the [IDGV Variables|IDGR#VariablesTab] tab, the variable ‘W2 State Media Filing’ must be set up to indicate if this state is required to produce a W2 File for the state.
*The ‘W2 State Media Filing’ values are:
**00 – Not required to file magnetic media to the state
**01 – Include State Code RS record in the Federal file, the federal file can be sent to the state
**02 – State requires its own file, do not include other state information in the State file
*If the State file layout is conforming to the standard federal SSA code RS format and the state accepts a copy of the federal file that includes the code RW records, ‘W2 State Media Filing’ variable = ‘01’ should be set up
At line 301 changed 2 lines
*If the state does not accept other state’s information in their State file, ‘W2 State Media Filing’ variable = ‘02’ should be set up.
*When [RPYEU] is run, it should be set to run by one State only and the Media Format = ‘State File Format’ should be selected.
*If the state does not accept other state’s information in their State file, ‘W2 State Media Filing’ variable = ‘02’ should be set up.
*When [RPYEU] is run, it should be set to run by one State only and the Media Format = ‘State File Format’ should be selected.
At line 307 changed 3 lines
*An entry must exist for each County for an Entity with ‘Local Registration’ in order for the County tax to be reported.
*An entry must exist for each City for an Entity with ‘Local Registration’ in order for the City tax to be reported.
*When the ‘Local Registration’ is defined, the ‘Variables’ tab can optionally be set up in order to indicate if this Local requires to be filed via magnetic media on a W2 file:
*An entry must exist for each County for an Entity with ‘Local Registration’ in order for the County tax to be reported.
*An entry must exist for each City for an Entity with ‘Local Registration’ in order for the City tax to be reported.
*When the ‘Local Registration’ is defined, the ‘Variables’ tab can optionally be set up in order to indicate if this Local requires to be filed via magnetic media on a W2 file:
At line 313 changed 6 lines
*The ‘W2 State Media Filing’ values are:
**00 – Not Required to file magnetic media
**01 – Include Local Information in Code RS record for Federal File format
**02 – Include Local Information in Code RS record for the State File format
**03 – Local requires its own File, do not include other Local information in the File
*If the Local information is to be reported along with the Federal File Code RS information, set up ‘W2 State Media Filing’ variable = ‘01’ for this local.
*The ‘W2 State Media Filing’ values are:
**00 – Not Required to file magnetic media
**01 – Include Local Information in Code RS record for Federal File format
**02 – Include Local Information in Code RS record for the State File format
**03 – Local requires its own File, do not include other Local information in the File
*If the Local information is to be reported along with the Federal File Code RS information, set up ‘W2 State Media Filing’ variable = ‘01’ for this local.
At line 320 changed one line
*If the Local information is to be reported along with the State File Code RS information, then set up the ‘W2 State Media Filing’ variable = ‘02’ for this local.
*If the Local information is to be reported along with the State File Code RS information, then set up the ‘W2 State Media Filing’ variable = ‘02’ for this local.
At line 322 changed 2 lines
*If the Local requires its own format, set up ‘W2 State Media Filing’ variable = ‘03’
*When [RPYEU] is run and ‘Local File format’ has been selected to be generated, then the specific City or County also needs to be selected, then the Local file format will be generated.
*If the Local requires its own format, set up ‘W2 State Media Filing’ variable = ‘03’
*When [RPYEU] is run and ‘Local File format’ has been selected to be generated, then the specific City or County also needs to be selected, then the Local file format will be generated.
At line 325 changed 7 lines
*If ‘W2 State Media Filing’ is set up for a Local, then the [IDGV Variables|IDGR#VariablesTab] tab must also be set up for:
**‘W2 TAX TYPE CODE’ - to contain one of the following values:
***C – City Income Tax
***D – County Income Tax
***E – School District Income Tax
**‘W2 TAXING ENTITY’ - to define the five character Taxing Entity Code for each local:
***e.g. Ohio Cleveland would be ‘200’, refer to Cleveland filing requirement
*If ‘W2 State Media Filing’ is set up for a Local, then the [IDGV Variables|IDGR#VariablesTab] tab must also be set up for:
**‘W2 TAX TYPE CODE’ - to contain one of the following values:
***C – City Income Tax
***D – County Income Tax
***E – School District Income Tax
**‘W2 TAXING ENTITY’ - to define the five character Taxing Entity Code for each local:
***e.g. Ohio Cleveland would be ‘200’, refer to Cleveland filing requirement
At line 335 changed 2 lines
*An entry must exist for each school district for an Entity with ‘School Registration’ for the school tax to be reported.
*When the ‘School Registration’ is defined, the [IDGV Variables|IDGR#VariablesTab] tab must be set up for:
*An entry must exist for each school district for an Entity with ‘School Registration’ for the school tax to be reported.
*When the ‘School Registration’ is defined, the [IDGV Variables|IDGR#VariablesTab] tab must be set up for:
At line 340 changed 6 lines
*The ‘W2 State Media Filing’ values are:
**00 – Not Required to file magnetic media
**01 – Include School Information in Code RS record for Federal File format
**02 – Include School Information in Code RS record for the State for State File format
**03 – Include School Information in Code RS record for the Local File format
*If the School information is to be reported along with the Federal File Code RS information, set up the ‘W2 State Media Filing’ variable = ‘01’ for this Local.
*The ‘W2 State Media Filing’ values are:
**00 – Not Required to file magnetic media
**01 – Include School Information in Code RS record for Federal File format
**02 – Include School Information in Code RS record for the State for State File format
**03 – Include School Information in Code RS record for the Local File format
*If the School information is to be reported along with the Federal File Code RS information, set up the ‘W2 State Media Filing’ variable = ‘01’ for this Local.
At line 347 changed one line
*If the School information is to be reported along with the State File Code RS information, set up the ‘W2 State Media Filing’ variable = ‘02’ for this Local.
*If the School information is to be reported along with the State File Code RS information, set up the ‘W2 State Media Filing’ variable = ‘02’ for this Local.
At line 349 changed one line
*If the School requires its own format, set up ‘W2 State Media Filing’ variable = ‘03’
*If the School requires its own format, set up ‘W2 State Media Filing’ variable = ‘03’
At line 351 changed 3 lines
*If ‘W2 State Media Filing’ is set up for a School, then IDGV Variables Tab must also be set up:
**‘W2 TAX TYPE CODE’ to contain the following value: E – School District Income Tax
**‘W2 TAXING ENTITY’ to define the five character School District code
*If ‘W2 State Media Filing’ is set up for a School, then IDGV Variables Tab must also be set up:
**‘W2 TAX TYPE CODE’ to contain the following value: E – School District Income Tax
**‘W2 TAXING ENTITY’ to define the five character School District code
At line 355 changed 2 lines
!IDGV – Define State SUI Registrations for Quarterly Filing
When running [RPYEU] with Calendar Type = ‘Q’ for a quarter, each state must set up with ‘US SUI Regist’. The last digit of ‘US SUI Regist’ Registration type must match the last digit of ‘US State Regist’ Registration type, i.e. ‘US State Regist 1’ should also define ‘US SUI Regist 1’, ‘US State Regist 2’ should also define ‘US SUI Regist 2’, etc,
!IDGV – Define State SUI Registrations for Quarterly Filing
When running [RPYEU] with Calendar Type = ‘Q’ for a quarter, each state must set up with ‘US SUI Regist’. The last digit of ‘US SUI Regist’ Registration type must match the last digit of ‘US State Regist’ Registration type, i.e. ‘US State Regist 1’ should also define ‘US SUI Regist 1’, ‘US State Regist 2’ should also define ‘US SUI Regist 2’, etc,
At line 358 changed one line
According to each state’s quarterly filing format, some state may require to submit Taxes Due, Previous Underpayment etc. For each quarter, define the [IDGV Variables|IDGR#VariablesTab] tab for these quarterly amount for the proper ‘US SUI Regist’ prior to running [RPYEU].
According to each state’s quarterly filing format, some state may require to submit Taxes Due, Previous Underpayment etc. For each quarter, define the [IDGV Variables|IDGR#VariablesTab] tab for these quarterly amount for the proper ‘US SUI Regist’ prior to running [RPYEU].
At line 360 changed one line
Please note each QTR field’s decimal point and enter in the above format.
Please note each QTR field’s decimal point and enter in the above format.
At line 362 changed 2 lines
!IDFD – Define Form Code
*Define Form Code ‘HL$US-W2-2012’ for EFW2 format (Year 2011-2012 reporting)
!IDFD – Define Form Code
*Define Form Code ‘HL$US-W2-2012’ for EFW2 format (Year 2011-2012 reporting)
At line 366 changed one line
!IDFD – Starter Scripts
!IDFD – Starter Scripts
At line 368 changed one line
‘HL$US-W2-2012’: SEED_IDFD_HL$US_W2_2012.sql
‘HL$US-W2-2012’: SEED_IDFD_HL$US_W2_2012.sql
At line 370 changed 2 lines
**If Form Code ‘HL$US-W2-2012’ does not exist, the script loads all new identifiers for Form Code ‘HL$US-W2-2012’.
**If Form Code ‘HL$US-W2-2012’ already exists, the script will update Form Code ‘HL$US-W2-2012’ existing identifiers from [IDFD] and leaving the client’s [IDFDV] set up untouched for existing identifiers.
**If Form Code ‘HL$US-W2-2012’ does not exist, the script loads all new identifiers for Form Code ‘HL$US-W2-2012’.
**If Form Code ‘HL$US-W2-2012’ already exists, the script will update Form Code ‘HL$US-W2-2012’ existing identifiers from [IDFD] and leaving the client’s [IDFDV] set up untouched for existing identifiers.
At line 374 changed 2 lines
!IDFD – Store Option
Since 2010-tax year reporting, [IDFD] Form Code ‘HL$US-W2-2011’ has supplied the ‘Store Option’ starting from Seq# 2000 in order for [RPYEU] to store the Employer Name / Addresses, Employee Name / Addresses and the Amounts of the Seq# in the Government Remittance Tables.
!IDFD – Store Option
Since 2010-tax year reporting, [IDFD] Form Code ‘HL$US-W2-2011’ has supplied the ‘Store Option’ starting from Seq# 2000 in order for [RPYEU] to store the Employer Name / Addresses, Employee Name / Addresses and the Amounts of the Seq# in the Government Remittance Tables.
At line 377 changed 2 lines
%%warning Important: [RPYEU] must be run with the new [IDFD] Form Code ‘HL$US-W2-2012’ or a copy of this Form Code that has the ‘Store Option’ set up to store the Addresses and the Amounts in the Government Remittance Tables.
Any prior year’s Form Codes do not supply this option and therefore will not turn on the store feature for [RPYEU].%%
%%warning Important: [RPYEU] must be run with the new [IDFD] Form Code ‘HL$US-W2-2012’ or a copy of this Form Code that has the ‘Store Option’ set up to store the Addresses and the Amounts in the Government Remittance Tables.
Any prior year’s Form Codes do not supply this option and therefore will not turn on the store feature for [RPYEU].%%
At line 380 changed 3 lines
!IDFDV – Copy Last Year’s Definition to Current Year
*After the script is loaded for ‘HL$US-W2-2012’, the [IDFDV] Variable definition may be copied from last year to current year. Go to [IDFDV] and use the COPY button to copy from last year’s definition as follows:
**On [IDFDV], select last year’s Form Code: ‘HL$US-W2-2011’
!IDFDV – Copy Last Year’s Definition to Current Year
*After the script is loaded for ‘HL$US-W2-2012’, the [IDFDV] Variable definition may be copied from last year to current year. Go to [IDFDV] and use the COPY button to copy from last year’s definition as follows:
**On [IDFDV], select last year’s Form Code: ‘HL$US-W2-2011’
At line 384 changed 2 lines
**The Copying dialog box is displayed, within the box, enter the current year New Form Code: ‘HL$US-W2-2012’
**Press the 'Copy Definition with Variables' button, this will copy the variables set up from ‘HL$US-W2-2011’ to ‘HL$US-W2-2012’ for the same Field Identifier name
**The Copying dialog box is displayed, within the box, enter the current year New Form Code: ‘HL$US-W2-2012’
**Press the 'Copy Definition with Variables' button, this will copy the variables set up from ‘HL$US-W2-2011’ to ‘HL$US-W2-2012’ for the same Field Identifier name
At line 387 changed one line
!IDFDV – Form Definition Variables
!IDFDV – Form Definition Variables
At line 393 changed one line
;Form Code ‘HL$US-W2-2012’ Identifiers:
;Form Code ‘HL$US-W2-2012’ Identifiers:
At line 395 changed one line
|SUB-ER-EIN|Submitter’s Employer EIN|Constant|9 characters EIN
|SUB-ER-EIN|Submitter’s Employer EIN|Constant|9 characters EIN
At line 402 changed 9 lines
|SUB-COMP-LOCN|Company Location Address|Constant|Enter company’s location address\\ \\i.e. Attention, Suite, Room # etc
|SUB-COMP-DELIV|Company Delivery Address|Constant|Enter company’s delivery address\\ \\i.e. Street or Post Office Box
|SUB-COMP-CITY|Company’s City|Constant|Enter company’s city
|SUB-COMP-STATE|Company’s State Abbrev|Constant|Enter company’s State Abbreviation
|SUB-COMP-ZIP|Company’s ZIP Code|Constant|Enter company’s ZIP code
|SUB-COMP-ZIP-EXT|Company’s ZIP Code Extension|Constant|Enter company’s ZIP code extn
|SUB-COMP-F-STATE|Company’s foreign State/province|Constant|Enter company’s foreign state/province
|SUB-COMP-F-POST|Company’s foreign postal code|Constant|Enter company’s foreign postal code
|SUB-COMP-COUNTRY|Company’s country if applicable|Constant|Enter company’s country if applicable
|SUB-COMP-LOCN|Company Location Address|Constant|Enter company’s location address\\ \\i.e. Attention, Suite, Room # etc
|SUB-COMP-DELIV|Company Delivery Address|Constant|Enter company’s delivery address\\ \\i.e. Street or Post Office Box
|SUB-COMP-CITY|Company’s City|Constant|Enter company’s city
|SUB-COMP-STATE|Company’s State Abbrev|Constant|Enter company’s State Abbreviation
|SUB-COMP-ZIP|Company’s ZIP Code|Constant|Enter company’s ZIP code
|SUB-COMP-ZIP-EXT|Company’s ZIP Code Extension|Constant|Enter company’s ZIP code extn
|SUB-COMP-F-STATE|Company’s foreign State/province|Constant|Enter company’s foreign state/province
|SUB-COMP-F-POST|Company’s foreign postal code|Constant|Enter company’s foreign postal code
|SUB-COMP-COUNTRY|Company’s country if applicable|Constant|Enter company’s country if applicable
At line 438 changed 6 lines
|W2-ER-LOCN-ADDR|Employer Location Address|Constant|Employer’s location address\\ \\i.e. Attention, Suite, Room # etc.\\DLN.ADDRESS_LINE_2 or DLN.MAIL_ADDRESS_LINE_2\\ \\Enter the word MAIL or blank\\To use Primary address, leave this blank\\To use Mailing address, enter the word MAIL\\System will derive the complete primary or mailing address and store in the Address Identifiers.
|W2-ER-DELIV-ADDR|Employer Delivery Address|Constant|Employer’s delivery address\\ \\i.e. Street or Post Office Box\\DLN.ADDRESS_LINE_1 or DLN.MAIL_ADDRESS_LINE_1\\ \\Enter blank, system derived
|W2-ER-CITY|Employer City|Constant|Employer’s city\\DLN.LOCALITY or DLN.MAIL_LOCALITY\\ \\Enter blank, system derived
|W2-ER-STATE|Employer State Abbrev|Constant|Employer’s State abbreviation\\DSP.STATE_PROVINCE_CODE\\ \\Enter blank, system derived
|W2-ER-ZIP|Employer ZIP Code|Constant|Employer’s ZIP Code\\DLN.ZIP_POSTAL or DLN.MAIL_ZIP_POSTAL\\ \\Enter blank, system derived
|W2-ER-ZIP-EXT|Employer ZIP Extension|Constant|Employer’s ZIP Code\\DLN.ZIP_POSTAL or DLN.MAIL_ZIP_POSTAL\\ \\Enter blank, system derived
|W2-ER-LOCN-ADDR|Employer Location Address|Constant|Employer’s location address\\ \\i.e. Attention, Suite, Room # etc.\\DLN.ADDRESS_LINE_2 or DLN.MAIL_ADDRESS_LINE_2\\ \\Enter the word MAIL or blank\\To use Primary address, leave this blank\\To use Mailing address, enter the word MAIL\\System will derive the complete primary or mailing address and store in the Address Identifiers.
|W2-ER-DELIV-ADDR|Employer Delivery Address|Constant|Employer’s delivery address\\ \\i.e. Street or Post Office Box\\DLN.ADDRESS_LINE_1 or DLN.MAIL_ADDRESS_LINE_1\\ \\Enter blank, system derived
|W2-ER-CITY|Employer City|Constant|Employer’s city\\DLN.LOCALITY or DLN.MAIL_LOCALITY\\ \\Enter blank, system derived
|W2-ER-STATE|Employer State Abbrev|Constant|Employer’s State abbreviation\\DSP.STATE_PROVINCE_CODE\\ \\Enter blank, system derived
|W2-ER-ZIP|Employer ZIP Code|Constant|Employer’s ZIP Code\\DLN.ZIP_POSTAL or DLN.MAIL_ZIP_POSTAL\\ \\Enter blank, system derived
|W2-ER-ZIP-EXT|Employer ZIP Extension|Constant|Employer’s ZIP Code\\DLN.ZIP_POSTAL or DLN.MAIL_ZIP_POSTAL\\ \\Enter blank, system derived
At line 455 changed 28 lines
|W2-EE-SUFFIX|Employee Suffix Name|Data Base Column|EID.RANK with derivation expression\\ \\Decode(~,’01’,’JR’,’02’,’SR’,NULL)
|W2-EE-LOCN-ADDR|Employee Location Address|Constant|Employee’s location address\\ \\i.e. Attention, Suite, Room # etc\\ \\EPS.ADDRESS_LINE_2\\EPS.MAIL_ADDRESS_LINE_2\\\ \\Enter the word MAIL or blank\\To use Primary address, leave this blank.\\To use Mailing address, enter the word MAIL.\\System will derive the complete primary or mailing address and store in the Address Identifiers.
|W2-EE-DELIV-ADDR|Employee Delivery Address|Constant|Employee’s delivery address\\ \\i.e. Street or Post Office Box\\ \\EPS.ADDRESS_LINE_2 or EPS.MAIL_ADDRESS_LINE_2\\ \\Enter blank, system derived
|W2-EE-CITY|Employee City|Constant|Employee’s city\\ \\EPS.LOCALITY or EPS.MAIL_LOCALITY\\ \\Enter blank, system derived
|W2-EE-STATE|Employee State Abbrev|Constant|Employee’s State abbreviation\\ \\DSP.STATE_PROVINCE_CODE\\ \\Enter blank, system derived
|W2-EE-ZIP|Employee ZIP Code|Constant|Employee’s ZIP Code\\ \\EPS.ZIP_POSTAL or EPS.MAIL_ZIP_POSTAL\\ \\Enter blank, system derived
|W2-EE-ZIP-EXT|Employee ZIP Extension|Constant|Enter employee’s ZIP Code\\ \\EPS.ZIP_POSTAL or EPS.MAIL_ZIP_POSTAL\\ \\Use derivation expression substr(~,6) for ZIP extension
|W2-EE-F-STATE|Employee foreign State/province|Constant|Employee foreign state/province or Constant\\ \\Enter the word NAME or blank
|W2-EE-F-POSTAL|Employee foreign postal code|Constant|Employee foreign postal code\\ \\Enter blank, system derived
|W2-EE-COUNTRY|Employee country if applicable|Constant|Enter Employee country\\ \\Enter blank, system derived
|W2-EE-F-COUNTRY|Employer foreign Country|Constant|Enter the word NAME or the word ISO or blank
|W2-CONTROL-PRT|Print Control Number on Form|Constant|Null, 0, 1, 2, 3, 4, 5, 6\\ \\Null, 0 – Do not print Control Number on W2 Form\\1 - Print Control Number as defined in W2-CONTROL-NUM Identifier\\2- Print Control Number as defined from RPYEU ‘Sort Level By’ prompt\\3 - Print W2-CONTROL-NUM Identifier and Person Code\\4 - Print ‘Sort Level By’ prompt and Person Code\\5 - Print ‘Sort Level By’ prompt and W2-CONTROL-NUM Identifier\\6 - Print ‘Sort Level By’ prompt and W2-CONTROL-NUM Identifier and Person Code
|W2-CONTROL-NUM|Control Number on Form|Data Base Column|Enter your company data
|W2-EXCLUDE-EE|Exclude Employee|Data Base Column|Enter your company data
|| || || ||
|W2-FIT-WAGE|Wages, Tips, Other Compensation|Element|W2-BOX-01
|W2-FIT-TAX|Federal Income Tax Withheld|Element|W2-BOX-02
|W2-SSN-WAGE|Social Security Wages|Element|W2-BOX-03\\ \\Derivation expression LEAST(~,94200.00) may be used for year 2006 max\\ \\System verify Box 3 + Box 7 does not exceed annual max, otherwise issue msg
|W2-SSN-TAX|Social Security Tax Withheld|Element|W2-BOX-04\\ \\Derivation expression LEAST(~,5840.40) may be used for year 2006 max
|W2-MEDI-WAGE|Medicare Wages and Tips|Element|W2-BOX-05
|W2-MEDI-TAX|Medicare Tax Withheld|Element|W2-BOX-06
|W2-SSN-TIP|Social Security Tips|Element|W2-BOX-07
|W2-ALLOC-TIP|Allocated Tips|Element|W2-BOX-08
|W2-EIC|Advanced EIC Credit|Element|W2-BOX-09
|W2-DEP-CARE|Dependent Care Benefit|Element|W2-BOX-10
|W2-NQUAL|Non Qualified Plans|Element|W2-BOX-11
|W2-NQUAL-457|Non Qualified Plans Sect 457|Element|W2-BOX-11-457
|W2-NQUAL-N457|Non Qualified Plans Not Sect 457|Element|W2-BOX-11-N457
|W2-EE-SUFFIX|Employee Suffix Name|Data Base Column|EID.RANK with derivation expression\\ \\Decode(~,’01’,’JR’,’02’,’SR’,NULL)
|W2-EE-LOCN-ADDR|Employee Location Address|Constant|Employee’s location address\\ \\i.e. Attention, Suite, Room # etc\\ \\EPS.ADDRESS_LINE_2\\EPS.MAIL_ADDRESS_LINE_2\\\ \\Enter the word MAIL or blank\\To use Primary address, leave this blank.\\To use Mailing address, enter the word MAIL.\\System will derive the complete primary or mailing address and store in the Address Identifiers.
|W2-EE-DELIV-ADDR|Employee Delivery Address|Constant|Employee’s delivery address\\ \\i.e. Street or Post Office Box\\ \\EPS.ADDRESS_LINE_2 or EPS.MAIL_ADDRESS_LINE_2\\ \\Enter blank, system derived
|W2-EE-CITY|Employee City|Constant|Employee’s city\\ \\EPS.LOCALITY or EPS.MAIL_LOCALITY\\ \\Enter blank, system derived
|W2-EE-STATE|Employee State Abbrev|Constant|Employee’s State abbreviation\\ \\DSP.STATE_PROVINCE_CODE\\ \\Enter blank, system derived
|W2-EE-ZIP|Employee ZIP Code|Constant|Employee’s ZIP Code\\ \\EPS.ZIP_POSTAL or EPS.MAIL_ZIP_POSTAL\\ \\Enter blank, system derived
|W2-EE-ZIP-EXT|Employee ZIP Extension|Constant|Enter employee’s ZIP Code\\ \\EPS.ZIP_POSTAL or EPS.MAIL_ZIP_POSTAL\\ \\Use derivation expression substr(~,6) for ZIP extension
W2-EE-F-STATE Employee foreign State/province Constant Employee foreign
state/province or Constant
enter the word NAME or blank
W2-EE-F-POSTAL Employee foreign postal code Constant Employee foreign postal code
- enter blank, system derived
W2-EE-COUNTRY Employee country if applicable Constant Enter Employee country
- enter blank, system derived
W2-EE-F-COUNTRY Employer foreign Country Constant Enter the word NAME or
the word ISO or blank
W2-CONTROL-PRT Print Control Number on Form Constant Null, 0, 1, 2, 3, 4, 5, 6
Null, 0 – Do not print Control Number on W2 Form
1 - Print Control Number as defined in W2-CONTROL-NUM Identifier
2 - Print Control Number as defined from RPYEU ‘Sort Level By’ prompt
3 - Print W2-CONTROL-NUM Identifier and Person Code
4 - Print ‘Sort Level By’ prompt and Person Code
5 - Print ‘Sort Level By’ prompt and W2-CONTROL-NUM Identifier
6 - Print ‘Sort Level By’ prompt and W2-CONTROL-NUM Identifier and Person Code
W2-CONTROL-NUM Control Number on Form Data Base Column Enter your company data
W2-EXCLUDE-EE Exclude Employee Data Base Column Enter your company data
W2-FIT-WAGE Wages, Tips, Other Compensation Element W2-BOX-01
W2-FIT-TAX Federal Income Tax Withheld Element W2-BOX-02
W2-SSN-WAGE Social Security Wages Element W2-BOX-03
- user may use derivation expression LEAST(~,94200.00) for year 2006 max
- system verify Box 3 + Box 7 does not
exceed annual max, otherwise issue msg
W2-SSN-TAX Social Security Tax Withheld Element W2-BOX-04
- user may use derivation expression
LEAST(~,5840.40) for year 2006 max
W2-MEDI-WAGE Medicare Wages and Tips Element W2-BOX-05
W2-MEDI-TAX Medicare Tax Withheld Element W2-BOX-06
W2-SSN-TIP Social Security Tips Element W2-BOX-07
W2-ALLOC-TIP Allocated Tips Element W2-BOX-08
W2-EIC Advanced EIC Credit Element W2-BOX-09
W2-DEP-CARE Dependent Care Benefit Element W2-BOX-10
W2-NQUAL Non Qualified Plans Element W2-BOX-11
W2-NQUAL-457 Non Qualified Plans Sect 457 Element W2-BOX-11-457
W2-NQUAL-N457 Non Qualified Plans Not Sect 457 Element W2-BOX-11-N457
At line 584 changed one line
(1) - For California, if IDFDV Identifier Seq 7260 W2-SDI-TAX-EE is not zero, then Box 19 will print the employee SDI contribution and Box 20 will print the description ‘CASDI’
(1) - For California, if IDFDV Identifier Seq 7260 W2-SDI-TAX-EE is not zero, then Box 19 will print the employee SDI contribution and Box 20 will print the description ‘CASDI’
At line 586 changed one line
(2) - For California, if IDFDV Identifier Seq 7260 W2-SDI-TAX-EE is not set up, the user may set up Box 14 to print ‘CASDI’ and the SDI amount
(2) - For California, if IDFDV Identifier Seq 7260 W2-SDI-TAX-EE is not set up, the user may set up Box 14 to print ‘CASDI’ and the SDI amount
At line 593 changed one line
!IDFDV – Employer Primary Address and Mailing Address
!IDFDV – Employer Primary Address and Mailing Address
At line 596 changed one line
- if the user wants to use the Employer Primary Address, the user does not need to set up Identifiers 2020 – 2070, just leave these Identifiers blank, the system will use the Primary Address as default
- if the user wants to use the Employer Primary Address, the user does not need to set up Identifiers 2020 – 2070, just leave these Identifiers blank, the system will use the Primary Address as default
At line 620 changed one line
- if the user has previous Address set up prior to 2006, if the word ‘MAIL’ is defined, the mailing address will be used, otherwise the primary address will be used
- if the user has previous Address set up prior to 2006, if the word ‘MAIL’ is defined, the mailing address will be used, otherwise the primary address will be used
At line 629 changed one line
- if ‘NAME’ is entered, the State name is used, otherwise the State code is used
- if ‘NAME’ is entered, the State name is used, otherwise the State code is used
At line 633 changed 2 lines
- if ‘NAME’ is entered, the Country name is used
- if ‘ISO’ is entered, the ISO Country code from IDCO screen UDF ‘ISO COUNTRY CODE’ is used, otherwise the IDCO Country code is used
- if ‘NAME’ is entered, the Country name is used
- if ‘ISO’ is entered, the ISO Country code from IDCO screen UDF ‘ISO COUNTRY CODE’ is used, otherwise the IDCO Country code is used
At line 638 changed one line
!IDFDV – Employee Primary Address and Mailing Address
!IDFDV – Employee Primary Address and Mailing Address
At line 641 changed one line
- if the user wants to use the Primary Address, the user does not need to set up Identifiers 2600 – 2650, just leave these Identifiers blank, the system will use the Primary Address as default
- if the user wants to use the Primary Address, the user does not need to set up Identifiers 2600 – 2650, just leave these Identifiers blank, the system will use the Primary Address as default
At line 664 changed one line
- if the user has previous Address set up prior to 2006, if the word ‘MAIL’ is defined, then the mailing address will be used, otherwise the primary address will be used
- if the user has previous Address set up prior to 2006, if the word ‘MAIL’ is defined, then the mailing address will be used, otherwise the primary address will be used
At line 673 changed one line
- if ‘NAME’ is entered, the State name is used, otherwise the State code is used
- if ‘NAME’ is entered, the State name is used, otherwise the State code is used
At line 677 changed 2 lines
- if ‘NAME’ is entered, the Country name is used
- if ‘ISO’ is entered, the ISO Country code from IDCO screen UDF ‘ISO COUNTRY CODE’ is used, otherwise the IDCO Country code is used
- if ‘NAME’ is entered, the Country name is used
- if ‘ISO’ is entered, the ISO Country code from IDCO screen UDF ‘ISO COUNTRY CODE’ is used, otherwise the IDCO Country code is used
At line 719 changed one line
- on IDGR screen, the user must define ‘W2 Employment Type’ on the ‘Registrations’ Tab for each group
- on IDGR screen, the user must define ‘W2 Employment Type’ on the ‘Registrations’ Tab for each group
At line 721 changed one line
F – Form 944 filer
F – Form 944 filer
At line 724 changed 2 lines
Q – Medicare Qualified Government Employment
R – Regular (All others)
Q – Medicare Qualified Government Employment
R – Regular (All others)
At line 728 changed one line
- the ‘W2 Employment Type’ for a Group MUST NOT BE CHANGED even if there are multiple effective date records for a group
- the ‘W2 Employment Type’ for a Group MUST NOT BE CHANGED even if there are multiple effective date records for a group
At line 730 changed one line
- if the ‘W2 Employment Type’ is changed for a Group for different effective date, then the W2 reporting will be incorrect because it cannot qualify the YTD information under the proper ‘W2 Employment Type’
- if the ‘W2 Employment Type’ is changed for a Group for different effective date, then the W2 reporting will be incorrect because it cannot qualify the YTD information under the proper ‘W2 Employment Type’
At line 732 changed one line
- an employee may work for multiple ‘Types of Employment’ during a year, e.g. an employee is a ‘Regular employment’ employee during the year who also works under ‘Agriculture employment’ during the summer, in this case, the Agriculture Employment requires to report earnings on 943 and the agriculture earnings to be separate from the regular reporting of W2, the user should set up different Group for Agriculture and the employees should be paid under the Agriculture Group
- an employee may work for multiple ‘Types of Employment’ during a year, e.g. an employee is a ‘Regular employment’ employee during the year who also works under ‘Agriculture employment’ during the summer, in this case, the Agriculture Employment requires to report earnings on 943 and the agriculture earnings to be separate from the regular reporting of W2, the user should set up different Group for Agriculture and the employees should be paid under the Agriculture Group
At line 734 changed one line
- when RPYEU is run, the employee will automatically be reported under the proper ‘W2 Type of Employment’ from IDGR screen
- when RPYEU is run, the employee will automatically be reported under the proper ‘W2 Type of Employment’ from IDGR screen
At line 736 changed one line
- for Medicare Qualified Government Employees, the user does not need to set up a specific Group with ‘W2 Type of Employment’ = ‘Q’ in order for the employees to be reported with ‘Q’ type employment, the employee is classified as MQGE by the FICA and Medicare tax method on IPRLU screen
- for Medicare Qualified Government Employees, the user does not need to set up a specific Group with ‘W2 Type of Employment’ = ‘Q’ in order for the employees to be reported with ‘Q’ type employment, the employee is classified as MQGE by the FICA and Medicare tax method on IPRLU screen
At line 738 changed one line
- if IPRLU FICA method = ‘Do not Calculate’ and the Medicare method is set up, this employee is qualified as MQGE employee and will be reported under ‘W2 Type of Employment’ ‘Q’ regardless of which Group he belongs to
- if IPRLU FICA method = ‘Do not Calculate’ and the Medicare method is set up, this employee is qualified as MQGE employee and will be reported under ‘W2 Type of Employment’ ‘Q’ regardless of which Group he belongs to
At line 748 changed one line
- the user may also attach the RPYEU Execution ID to the file name by specifying the word ‘mex’ in the file name
- the user may also attach the RPYEU Execution ID to the file name by specifying the word ‘mex’ in the file name
At line 761 changed one line
- RPYEU attaches the ‘.xml’ extension to the specified Media File name for the XML file:
- RPYEU attaches the ‘.xml’ extension to the specified Media File name for the XML file:
At line 778 changed one line
- user should always run RPYEU with Trace Level = ‘Exceptions only’ for all employees
- user should always run RPYEU with Trace Level = ‘Exceptions only’ for all employees
At line 780 changed one line
- if there is problem in RPYEU and the user need to determine which employee has the problem, the user should run RPYEU with Trace Level = ‘Program Trace’, this will print a list of processed employees to determine which employee has the problem
- if there is problem in RPYEU and the user need to determine which employee has the problem, the user should run RPYEU with Trace Level = ‘Program Trace’, this will print a list of processed employees to determine which employee has the problem
At line 782 changed one line
- when Trace Level = ‘Program Trace’, the SQL SELECT Statements for Federal, State and Local levels are written as Trace messages
- when Trace Level = ‘Program Trace’, the SQL SELECT Statements for Federal, State and Local levels are written as Trace messages
At line 784 changed one line
- when Trace Level = ‘Program Trace’, after each employee is processed, the estimated performance time for this employee is displayed
- when Trace Level = ‘Program Trace’, after each employee is processed, the estimated performance time for this employee is displayed
At line 786 changed 2 lines
- after determining which employee has the problem, the user should run RPYEU for one employee with Trace Level = ‘Utility Trace’ to determine the problem in detail
- when RPYEU is run with any Trace level, all trace messages are also written to a ‘_trace.csv’ file so user can open with Excel for investigation, the dynamic SQL SELECT statement is written to ‘_select.txt’ file
- after determining which employee has the problem, the user should run RPYEU for one employee with Trace Level = ‘Utility Trace’ to determine the problem in detail
- when RPYEU is run with any Trace level, all trace messages are also written to a ‘_trace.csv’ file so user can open with Excel for investigation, the dynamic SQL SELECT statement is written to ‘_select.txt’ file
At line 789 changed one line
- when the parameter ‘Create Data Dump’ toggle is checked, RPYEU will generate data dump files with .csv extension for Federal, State, Local, School information if the information is available. The user can open these data dump files with excel spreadsheet for debugging and balancing purposes.
- when the parameter ‘Create Data Dump’ toggle is checked, RPYEU will generate data dump files with .csv extension for Federal, State, Local, School information if the information is available. The user can open these data dump files with excel spreadsheet for debugging and balancing purposes.
At line 809 changed one line
!Government Media File – Code RW, RS when Select by State
!Government Media File – Code RW, RS when Select by State
At line 813 changed one line
- When RPYEU is run and user selects one State, then RPYEU will be processed for that specific State only, code RW and RS records will be generated according the State government requirement and IDGV Variables tab ‘W2 State Media Filing’ set up
- When RPYEU is run and user selects one State, then RPYEU will be processed for that specific State only, code RW and RS records will be generated according the State government requirement and IDGV Variables tab ‘W2 State Media Filing’ set up
At line 818 changed one line
- the user may exclude certain employees from reporting the W2 by setting up IDFDV Identifier ‘W2-EXCLUDE-EE’
- the user may exclude certain employees from reporting the W2 by setting up IDFDV Identifier ‘W2-EXCLUDE-EE’
At line 820 changed 3 lines
- if the value of this ‘W2-EXCLUDE-EE’ Identifier is evaluated to ‘Y’, then the employee is bypassed
e.g. – if user does not want to report employees whose Assignment Title = ‘Election Worker’ or ‘Self Employed’, then:
- for Identifier ‘W2-EXCLUDE-EE’, set up the following:
- if the value of this ‘W2-EXCLUDE-EE’ Identifier is evaluated to ‘Y’, then the employee is bypassed
e.g. – if user does not want to report employees whose Assignment Title = ‘Election Worker’ or ‘Self Employed’, then:
- for Identifier ‘W2-EXCLUDE-EE’, set up the following:
At line 824 changed one line
- Derivation Expression = decode(UPPER(~),’ELECTION WORKER','Y',‘SELF EMPLOYED’,'Y','N')
- Derivation Expression = decode(UPPER(~),’ELECTION WORKER','Y',‘SELF EMPLOYED’,'Y','N')
At line 831 changed one line
- then on IDFDV for Identifier ‘W2-EXCLUDE-EE’, set up the following:
- then on IDFDV for Identifier ‘W2-EXCLUDE-EE’, set up the following:
At line 843 changed one line
- in this situation, that means if the election worker’s earnings is less than $600 and there is no social security and medicare tax withheld, then the payment should not be reported on W2
- in this situation, that means if the election worker’s earnings is less than $600 and there is no social security and medicare tax withheld, then the payment should not be reported on W2
At line 850 changed one line
2) - if the employee is paid with election worker payment and FICA and Medicare tax are withheld, then determine if the employee should be excluded or not. If employee is excluded, the user may set up a STAT CODE for IDFDV Identifier ‘W2-EXCLUDE-EE’ to exclude the employee from reporting on W2 form
2) - if the employee is paid with election worker payment and FICA and Medicare tax are withheld, then determine if the employee should be excluded or not. If employee is excluded, the user may set up a STAT CODE for IDFDV Identifier ‘W2-EXCLUDE-EE’ to exclude the employee from reporting on W2 form
At line 852 changed 2 lines
3) - the user may exclude all Election Workers by using the EASD.ASSIGNMENT_TITLE = ‘ELECTION WORKER’
- then the user should use Identifier ‘W2-EXCLUDE-EE’ to exclude EASD.ASSIGNMENT_TITLE = ‘’ELECTION WORKER’
3) - the user may exclude all Election Workers by using the EASD.ASSIGNMENT_TITLE = ‘ELECTION WORKER’
- then the user should use Identifier ‘W2-EXCLUDE-EE’ to exclude EASD.ASSIGNMENT_TITLE = ‘’ELECTION WORKER’
At line 867 changed one line
2) - user may locate the existing GVT Run number that the employee’s W2 was originally issued
2) - user may locate the existing GVT Run number that the employee’s W2 was originally issued
At line 869 changed one line
- when RPW2 is run, the user should enter the word ‘REISSUED’ or ‘CORRECTED’ for the prompt ‘Reissued/Corrected:’, then the W2 Form will be printed with word specified
- when RPW2 is run, the user should enter the word ‘REISSUED’ or ‘CORRECTED’ for the prompt ‘Reissued/Corrected:’, then the W2 Form will be printed with word specified
At line 886 changed 5 lines
- this prompt is validated from lexicon ‘X_PRINT_AND_RUN’
00 – Do not print, run
01 – Print, do not run
02 – Print and Run
03 – Excp and Run
- this prompt is validated from lexicon ‘X_PRINT_AND_RUN’
00 – Do not print, run
01 – Print, do not run
02 – Print and Run
03 – Excp and Run
At line 892 changed one line
- ‘00 – Do not print, run’
- ‘00 – Do not print, run’
At line 896 changed one line
- ‘01 – Print, do not run’
- ‘01 – Print, do not run’
At line 901 changed one line
- ‘02 – Print and Run’
- ‘02 – Print and Run’
At line 906 changed one line
- ‘03 – Excp and Run’
- ‘03 – Excp and Run’
At line 915 changed one line
- the following Set Up exception messages are highlighted if the user choose to print ‘Set Up Exceptions’:
- the following Set Up exception messages are highlighted if the user choose to print ‘Set Up Exceptions’:
At line 923 changed one line
IDGV Variables – State: State name W2 STATE MEDIA FILING = xx is invalid, value must be 00,01,02,03
IDGV Variables – State: State name W2 STATE MEDIA FILING = xx is invalid, value must be 00,01,02,03
At line 925 changed one line
IDGV Variables – County: county name W2 STATE MEDIA FILING = xx is invalid, value must be 00,01,02,03
IDGV Variables – County: county name W2 STATE MEDIA FILING = xx is invalid, value must be 00,01,02,03
At line 927 changed one line
IDGV Variables – City: city name W2 STATE MEDIA FILING = xx is invalid, value must be 00,01,02,03
IDGV Variables – City: city name W2 STATE MEDIA FILING = xx is invalid, value must be 00,01,02,03
At line 958 changed 2 lines
- the user MUST correct this situation because Oracle will report ‘#######’ in the field and the government will reject this file
- the ‘#######’ is not corrected to report zero in the file because this will result in an incorrect reporting situation for the W2 between the W2 form print and the W2 file
- the user MUST correct this situation because Oracle will report ‘#######’ in the field and the government will reject this file
- the ‘#######’ is not corrected to report zero in the file because this will result in an incorrect reporting situation for the W2 between the W2 form print and the W2 file
At line 977 changed one line
- the user may suppress the printing of ‘Set up exceptions’ for IDFDV, IDGV etc, however, the employee level of exception are always printed as error or warning situations are encountered for each employee
- the user may suppress the printing of ‘Set up exceptions’ for IDFDV, IDGV etc, however, the employee level of exception are always printed as error or warning situations are encountered for each employee
At line 992 changed 2 lines
- the lexicon ‘X_W2_SORT_LEVEL’ is used for this prompt, the values are:
00 – N/A
- the lexicon ‘X_W2_SORT_LEVEL’ is used for this prompt, the values are:
00 – N/A
At line 1,001 changed 3 lines
- the department is the prime assignment details’ department that is effective as of the user specified ‘As of date’
- user may define a special ‘W2 Destination’ at the department level or employee level for W2 distribution purpose
- user may also specify to ‘Provide Sort Level Totals’ if the user has specified a ‘Sort Level By’ level
- the department is the prime assignment details’ department that is effective as of the user specified ‘As of date’
- user may define a special ‘W2 Destination’ at the department level or employee level for W2 distribution purpose
- user may also specify to ‘Provide Sort Level Totals’ if the user has specified a ‘Sort Level By’ level
At line 1,010 changed one line
- the lexicon ‘X_W2_SORT_ACTIVE’ is used for this prompt, the values are:
- the lexicon ‘X_W2_SORT_ACTIVE’ is used for this prompt, the values are:
At line 1,058 changed 5 lines
- the lexicon ‘X_W2_SORT_PERSON’ is used for this prompt, the values are:
01 – Person Code
02 – Last Name/First Name
03 – Destin/Last/First
04 – Dept/Last/First
- the lexicon ‘X_W2_SORT_PERSON’ is used for this prompt, the values are:
01 – Person Code
02 – Last Name/First Name
03 – Destin/Last/First
04 – Dept/Last/First
At line 1,064 changed one line
- this prompt is sort within the ‘Sort Level By’ and ‘Sort by Active / Inactive’ prompt
- this prompt is sort within the ‘Sort Level By’ and ‘Sort by Active / Inactive’ prompt
At line 1,074 changed one line
F – Form 944 filer
F – Form 944 filer
At line 1,077 changed 2 lines
Q – Medicare Qualified Government Employment
R – Regular (All others)
Q – Medicare Qualified Government Employment
R – Regular (All others)
At line 1,081 changed one line
- the Employment Code is retrieved from IDGR ‘W2 Employment Type’ or employee’s IPRLU screen FICA and Medicare method
- the Employment Code is retrieved from IDGR ‘W2 Employment Type’ or employee’s IPRLU screen FICA and Medicare method
At line 1,085 changed one line
- if IPRLU FICA method = ‘Do not calculate’ and MEDICARE method is NOT ‘Do not calculate’, then this employee is classified as Employment Type ‘Q’ for W2 reporting
- if IPRLU FICA method = ‘Do not calculate’ and MEDICARE method is NOT ‘Do not calculate’, then this employee is classified as Employment Type ‘Q’ for W2 reporting
At line 1,087 changed one line
- otherwise the W2 Type of Employment is derived from IDGR ‘W2 Employment Type’ field
- otherwise the W2 Type of Employment is derived from IDGR ‘W2 Employment Type’ field
At line 1,092 changed one line
- the default should be ‘No’ for most RPYEU file reporting, however, if the State filing does not require to file by ‘Types of employment’, then the user may change this to ‘Yes’ to combine all Types of Employment under one Code RE record
- the default should be ‘No’ for most RPYEU file reporting, however, if the State filing does not require to file by ‘Types of employment’, then the user may change this to ‘Yes’ to combine all Types of Employment under one Code RE record
At line 1,094 changed one line
- if the user only have ‘Regular’ Types of Employment, then the user can ignore this prompt and default to ‘No’ all the time
- if the user only have ‘Regular’ Types of Employment, then the user can ignore this prompt and default to ‘No’ all the time
At line 1,104 changed one line
Null, 0 – Do not print Control Number on W2 Form
Null, 0 – Do not print Control Number on W2 Form
At line 1,106 changed one line
2 - Print Control Number as defined from RPYEU ‘Sort Level By’ prompt
2 - Print Control Number as defined from RPYEU ‘Sort Level By’ prompt
At line 1,108 changed 3 lines
4 - Print ‘Sort Level By’ prompt and Person Code
5 - Print ‘Sort Level By’ prompt and W2-CONTROL-NUM Identifier
6 - Print ‘Sort Level By’ prompt and W2-CONTROL-NUM Identifier and Person Code
4 - Print ‘Sort Level By’ prompt and Person Code
5 - Print ‘Sort Level By’ prompt and W2-CONTROL-NUM Identifier
6 - Print ‘Sort Level By’ prompt and W2-CONTROL-NUM Identifier and Person Code
At line 1,115 changed one line
e.g. ‘EID.PERSON_CODE’, or ‘DLN.LOCALITY’, or ‘PPA.PAYROLL_CODE’ etc
e.g. ‘EID.PERSON_CODE’, or ‘DLN.LOCALITY’, or ‘PPA.PAYROLL_CODE’ etc
At line 1,117 changed one line
- if Seq 2810 W2-CONTROL-NUM specifies a Data Base Column e.g. ‘PPA.PAYROLL_CODE’, and within this year the employee has been paid by more than one entry of this data base column, e.g. employee is paid under 2 Payroll Codes, if the Government Registrations are the same, the YTD values will be accumulated together, and W2 Form Box d Control Number will be printed with one PAYROLL_CODE only, usually the PAYROLL_CODE with the name that is sorted last is printed
- if Seq 2810 W2-CONTROL-NUM specifies a Data Base Column e.g. ‘PPA.PAYROLL_CODE’, and within this year the employee has been paid by more than one entry of this data base column, e.g. employee is paid under 2 Payroll Codes, if the Government Registrations are the same, the YTD values will be accumulated together, and W2 Form Box d Control Number will be printed with one PAYROLL_CODE only, usually the PAYROLL_CODE with the name that is sorted last is printed
At line 1,122 changed one line
Then ‘US WEST BW’ will be printed
Then ‘US WEST BW’ will be printed
At line 1,125 changed 2 lines
!!RPREGT – Pay Totals Register
!RPREGT – Selection Criteria
!!RPREGT – Pay Totals Register
!RPREGT – Selection Criteria
At line 1,137 changed 2 lines
!!RPYEU – US Year End Summary Report
!RPYEU – Selection Criteria – Annual Reporting
!!RPYEU – US Year End Summary Report
!RPYEU – Selection Criteria – Annual Reporting
At line 1,157 changed 2 lines
- NOTE: always use the most current year form code ‘HL$US-W2-2011’
- please enter the most current year’s Form Code because RPYEU is programmed with Identifiers from the most current year information, prior year’s Form Code should not be used because prior year’s Identifiers may be obsolete
- NOTE: always use the most current year form code ‘HL$US-W2-2011’
- please enter the most current year’s Form Code because RPYEU is programmed with Identifiers from the most current year information, prior year’s Form Code should not be used because prior year’s Identifiers may be obsolete
At line 1,160 changed one line
- for 2011-2012 reporting, Form Code from current year ‘HL$US-W2-2012’ contains the STORE OPTION field to store the Employer Addresses, Employee Addresses and Amounts in the Government Remittance Tables to be viewed on IPGR/IPGH screens
- for 2011-2012 reporting, Form Code from current year ‘HL$US-W2-2012’ contains the STORE OPTION field to store the Employer Addresses, Employee Addresses and Amounts in the Government Remittance Tables to be viewed on IPGR/IPGH screens
At line 1,165 changed one line
Period Type: - enter ‘Year’ for Annual reporting
Period Type: - enter ‘Year’ for Annual reporting
At line 1,169 changed 2 lines
Combine Employment Type: - Check this toggle to combine ‘Regular’, ‘Agriculture’ employment etc
Combine Fed Regist - Check this toggle to combine all selected ‘Federal Regist’ for State/Local reporting
Combine Employment Type: - Check this toggle to combine ‘Regular’, ‘Agriculture’ employment etc
Combine Fed Regist - Check this toggle to combine all selected ‘Federal Regist’ for State/Local reporting
At line 1,174 changed one line
Media Format: - Enter ‘Federal File Format’ for SSA reporting
Media Format: - Enter ‘Federal File Format’ for SSA reporting
At line 1,181 changed 4 lines
00 – Do not print,run
01 – Print,do not run
02 – Print and Run
03 – Excp and Run
00 – Do not print,run
01 – Print,do not run
02 – Print and Run
03 – Excp and Run
At line 1,188 changed one line
Federal Regist Set - optional, enter only if you want to select by different ‘Federal Regist Set’
Federal Regist Set - optional, enter only if you want to select by different ‘Federal Regist Set’
At line 1,209 changed one line
Sort by Level: - enter ‘Sort by Level’ if necessary
Sort by Level: - enter ‘Sort by Level’ if necessary
At line 1,211 changed 2 lines
Sort People by - enter ‘Sort People by’ if necessary
Provide Sort Level Totals: - optional, if the toggle is ON, the total is generated for ‘Sort by Level’
Sort People by - enter ‘Sort People by’ if necessary
Provide Sort Level Totals: - optional, if the toggle is ON, the total is generated for ‘Sort by Level’
At line 1,214 changed 5 lines
Federal Level Print - enter ‘Federal Level Print’ to show the amount detail for Federal level
State Level Print - enter ‘State Level Print’ to show the amount detail for State level
SUI Level Print - enter ‘SUI Level Print’ to show the amount detail for SUI level
Local Level Print - enter ‘Local Level Print’ to show the amount detail for County and City level
School Level Print - enter ‘School Level Print’ to show the amount detail for School level
Federal Level Print - enter ‘Federal Level Print’ to show the amount detail for Federal level
State Level Print - enter ‘State Level Print’ to show the amount detail for State level
SUI Level Print - enter ‘SUI Level Print’ to show the amount detail for SUI level
Local Level Print - enter ‘Local Level Print’ to show the amount detail for County and City level
School Level Print - enter ‘School Level Print’ to show the amount detail for School level
At line 1,222 changed one line
!RPYEU – Selection Criteria – Quarterly Reporting
!RPYEU – Selection Criteria – Quarterly Reporting
At line 1,225 changed one line
Federal Regist Set - optional, enter only if you want to select by different ‘Federal Regist Set’
Federal Regist Set - optional, enter only if you want to select by different ‘Federal Regist Set’
At line 1,227 changed 2 lines
Select State: - mandatory for Quarterly State Filing, if State is not entered, then it’s a Federal run
State Regist Set: - optional, enter only if you want to select by different ‘State Regist Set’
Select State: - mandatory for Quarterly State Filing, if State is not entered, then it’s a Federal run
State Regist Set: - optional, enter only if you want to select by different ‘State Regist Set’
At line 1,233 changed 2 lines
- if the State is using the format such as the ICESA, TIB-4 and special format for quarterly reporting, enter ‘HL$US-QTR-2012.
- ‘HL$US-QTR-2012’ may not be updated after 2012 because this format code is only used for prior year format ICESA and TIB-4, most States are converted to EFW2
- if the State is using the format such as the ICESA, TIB-4 and special format for quarterly reporting, enter ‘HL$US-QTR-2012.
- ‘HL$US-QTR-2012’ may not be updated after 2012 because this format code is only used for prior year format ICESA and TIB-4, most States are converted to EFW2
At line 1,237 changed one line
Period Type: - enter ‘Quarter’ for Quarterly reporting
Period Type: - enter ‘Quarter’ for Quarterly reporting
At line 1,240 changed 4 lines
Combine Employment Type: - Check this toggle to combine ‘Regular’, ‘Agriculture’ employment etc
Combine Fed Regist - Check this toggle to combine all selected ‘Federal Regist’ for State/Local reporting
Media Format: - Enter ‘State File Format’ or ‘SUI File Format’ for State reporting
- for ‘SUI File Format’, the IDGV ‘SUI Registration’ number is used
Combine Employment Type: - Check this toggle to combine ‘Regular’, ‘Agriculture’ employment etc
Combine Fed Regist - Check this toggle to combine all selected ‘Federal Regist’ for State/Local reporting
Media Format: - Enter ‘State File Format’ or ‘SUI File Format’ for State reporting
- for ‘SUI File Format’, the IDGV ‘SUI Registration’ number is used
At line 1,248 changed one line
!RPYEU – Quarterly Form Code set up
!RPYEU – Quarterly Form Code set up
At line 1,250 changed one line
For quarterly filing, the user must set up IDFDV Annual Form Code ‘HL$US-W2-2012’ for all Federal and State identifiers, including SUI/SDI, respecting the Work and Home State pay components. The user may also need to set up Form Code ‘HL$US-QTR-2012’ depending on each State.
For quarterly filing, the user must set up IDFDV Annual Form Code ‘HL$US-W2-2012’ for all Federal and State identifiers, including SUI/SDI, respecting the Work and Home State pay components. The user may also need to set up Form Code ‘HL$US-QTR-2012’ depending on each State.
At line 1,252 changed one line
- Annual Form code ‘HL$US-W2-2012’ is used to report the Federal File and W2 Form Information for 2011 year end, this Form Code information is also used to report quarterly information for the States for 2012
- Annual Form code ‘HL$US-W2-2012’ is used to report the Federal File and W2 Form Information for 2011 year end, this Form Code information is also used to report quarterly information for the States for 2012
At line 1,256 changed one line
- prior to Jan 1, 2004, if the State is using ICESA, TIB4 or specific State Format, RPQTR program was used to report the quarterly file with Form Code ‘HL$US-QTR-2012’
- prior to Jan 1, 2004, if the State is using ICESA, TIB4 or specific State Format, RPQTR program was used to report the quarterly file with Form Code ‘HL$US-QTR-2012’
At line 1,260 changed one line
- the quarterly Form Code ‘HL$US-QTR-2012’ is being used and may not be changed because it contains all necessary Identifiers to support the ICESA, TIB-4 and State specific format, however all main processing are derived from Annual Form Code ‘HL$US-W2-2012’
- the quarterly Form Code ‘HL$US-QTR-2012’ is being used and may not be changed because it contains all necessary Identifiers to support the ICESA, TIB-4 and State specific format, however all main processing are derived from Annual Form Code ‘HL$US-W2-2012’
At line 1,262 changed one line
- when RPYEU is run for quarterly reporting, user MUST enter the Annual Form Code and then optionally enter the Quarterly Form Code to use ‘HL$US-QTR-2012’ or to default to EFW2 ‘HL$US-W2-2012’ format
- when RPYEU is run for quarterly reporting, user MUST enter the Annual Form Code and then optionally enter the Quarterly Form Code to use ‘HL$US-QTR-2012’ or to default to EFW2 ‘HL$US-W2-2012’ format
At line 1,264 changed one line
- all Identifiers from ‘HL$US-QTR-2012’ fields 3100, 3110 etc will be calculated by RPYEU by retrieving values from HL$US-W2-2012 sequence #'s 7010, 7020 etc., the user may enter any values on ‘HL$US-QTR-2012’ sequence 3100, 3110 etc and it will not be used
- all Identifiers from ‘HL$US-QTR-2012’ fields 3100, 3110 etc will be calculated by RPYEU by retrieving values from HL$US-W2-2012 sequence #'s 7010, 7020 etc., the user may enter any values on ‘HL$US-QTR-2012’ sequence 3100, 3110 etc and it will not be used
At line 1,266 changed one line
- HL uses ‘HL$US-QTR-2012’ identifiers to obtain values that are applicable for ICESA, TIB4 formats
- HL uses ‘HL$US-QTR-2012’ identifiers to obtain values that are applicable for ICESA, TIB4 formats
At line 1,275 changed one line
!RPYEU – Sample Run
!RPYEU – Sample Run
At line 1,286 changed one line
- from IPGR (Government Run) screen, the user can then go into the employee’s detail government reporting information on IPGH (Government Header) inquiry screen
- from IPGR (Government Run) screen, the user can then go into the employee’s detail government reporting information on IPGH (Government Header) inquiry screen
At line 1,292 changed one line
- in subsequent RPYEU run, the employee’s Government Header (PGH) information are re-generated, the same PGH information will be removed automatically when the new PGH is re-generated
- in subsequent RPYEU run, the employee’s Government Header (PGH) information are re-generated, the same PGH information will be removed automatically when the new PGH is re-generated
At line 1,303 changed 2 lines
!!IPGR – Government Reporting Screen
!IPGR – GVT Run tab
!!IPGR – Government Reporting Screen
!IPGR – GVT Run tab
At line 1,314 changed one line
- the user can click the ‘Gvt Run’ column in order to Sort this column in ascending or descending order of the Gvt Run #
- the user can click the ‘Gvt Run’ column in order to Sort this column in ascending or descending order of the Gvt Run #
At line 1,316 changed one line
- the user can Drag and Slide the ‘Type’ column or any other columns to display the desired sequence of display
- the user can Drag and Slide the ‘Type’ column or any other columns to display the desired sequence of display
At line 1,320 changed one line
- the ‘GVT RUN’ tab displays general information for the GVT Run
- the ‘GVT RUN’ tab displays general information for the GVT Run
At line 1,326 changed one line
!IPGR – Header Tab
!IPGR – Header Tab
At line 1,333 changed one line
- the ‘Tax Info’ is displayed from GVT Headers taxation_level_suffix or State/Province, this Taxation Level Suffix is the ‘Type of Employment’ from IDGR screen
- the ‘Tax Info’ is displayed from GVT Headers taxation_level_suffix or State/Province, this Taxation Level Suffix is the ‘Type of Employment’ from IDGR screen
At line 1,335 changed one line
- the ‘Employee Remittance’ line stores the Federal Govt Registration information with the Employer’s name and addresses along the Total Amounts, these Employer’s name and address information will be printed on W2 Form by the Windward version of RPW2
- the ‘Employee Remittance’ line stores the Federal Govt Registration information with the Employer’s name and addresses along the Total Amounts, these Employer’s name and address information will be printed on W2 Form by the Windward version of RPW2
At line 1,337 changed one line
- the user can click the ‘Govt Reg – Tax Suffix’ column or ‘Employee Name’ column or ‘Tax Info’ column in order to Sort these columns in ascending or descending order
- the user can click the ‘Govt Reg – Tax Suffix’ column or ‘Employee Name’ column or ‘Tax Info’ column in order to Sort these columns in ascending or descending order
At line 1,340 changed 3 lines
e.g. user may display: Tax Info , Govt Reg – Tax Suffix, Employee Name
Employee Name, Tax Info, Govt Reg – Tax Suffix,
Employee Name, Govt Reg – Tax Suffix, Tax Info
e.g. user may display: Tax Info , Govt Reg – Tax Suffix, Employee Name
Employee Name, Tax Info, Govt Reg – Tax Suffix,
Employee Name, Govt Reg – Tax Suffix, Tax Info
At line 1,345 changed 2 lines
!!IPGH – Employee Government Reporting Screen
!IPGH – Header tab
!!IPGH – Employee Government Reporting Screen
!IPGH – Header tab
At line 1,353 changed one line
- the user can click the ‘Tax Level’ column or ‘Type’ column or ‘Period’ column or the ‘Govt Registration’ column in order to Sort these columns in ascending or descending order
- the user can click the ‘Tax Level’ column or ‘Type’ column or ‘Period’ column or the ‘Govt Registration’ column in order to Sort these columns in ascending or descending order
At line 1,360 changed one line
!IPGH – Amount tab
!IPGH – Amount tab
At line 1,372 changed one line
- the employee’s name and address information are stored for historical reference purpose, these name and address information will be printed on W2 Form by the Windward version of RPW2
- the employee’s name and address information are stored for historical reference purpose, these name and address information will be printed on W2 Form by the Windward version of RPW2
At line 1,375 changed one line
!!UPGRUNDO – Undo GVT Run
!!UPGRUNDO – Undo GVT Run
At line 1,377 changed one line
!UPGRUNDO – Selection Criteria
!UPGRUNDO – Selection Criteria
At line 1,394 changed one line
!UPGRUNDO – Sample Run
!UPGRUNDO – Sample Run
At line 1,398 changed one line
!!RPW2 – W2 Form Print
!!RPW2 – W2 Form Print
At line 1,400 changed one line
!RPW2 – W2 Form Print Selection Criteria
!RPW2 – W2 Form Print Selection Criteria
At line 1,408 changed one line
For Oracle version RPW2, the user must run RPW2 and send the report to PDF file instead of to the Previewer. RPW2 aligned the W2 government forms in PDF format with user ability to adjust the parameters for ‘Top Margin’ and the ‘Between Form Space’ when generating the PDF file. Once after the PDF file is generated, the users do not need to adjust the Page Set up when printing.
For Oracle version RPW2, the user must run RPW2 and send the report to PDF file instead of to the Previewer. RPW2 aligned the W2 government forms in PDF format with user ability to adjust the parameters for ‘Top Margin’ and the ‘Between Form Space’ when generating the PDF file. Once after the PDF file is generated, the users do not need to adjust the Page Set up when printing.
At line 1,415 changed 6 lines
01 – Employer Copy - on one page, print multiple Employees W2 info
- for ‘2 on 1 page’, print 2 employees on one page
- for ‘4 on 1 page’, print 4 employees on one page
02 – Employee Copy - on one page, print one Employee W2 info
- for ‘2 on 1 page’, print 1 employee 2 times
- for ‘4 on 1 page’, print 1 employee 4 times
01 – Employer Copy - on one page, print multiple Employees W2 info
- for ‘2 on 1 page’, print 2 employees on one page
- for ‘4 on 1 page’, print 4 employees on one page
02 – Employee Copy - on one page, print one Employee W2 info
- for ‘2 on 1 page’, print 1 employee 2 times
- for ‘4 on 1 page’, print 1 employee 4 times
At line 1,423 changed one line
- this option is for ‘2 On 1 Page’ only, there is no Form image for ‘4 On 1 Page’ from the government
- this option is for ‘2 On 1 Page’ only, there is no Form image for ‘4 On 1 Page’ from the government
At line 1,426 changed one line
00 – Not Specified - do not show W2 Form image
00 – Not Specified - do not show W2 Form image
At line 1,428 changed one line
01 – Copy A, SSA copy - this Copy A option is for viewing purpose only
01 – Copy A, SSA copy - this Copy A option is for viewing purpose only
At line 1,430 changed 8 lines
02 – Copy 1, State,Local copy
03 – Copy B, EE Federal copy
04 – Copy C, EE Record copy
05 – Copy 2, EE State,Local copy
06 – Copy D, ER copy
20 – Copy B + C (1 Pg) - Show Copy B and Copy C on one Page
21 – Copy C + 2 (1 Pg) - Show Copy C and Copy 2 on one Page
22 – Copy B + C + 2 (2 Pg) - Show Copy B and Copy C on one Page follow by
02 – Copy 1, State,Local copy
03 – Copy B, EE Federal copy
04 – Copy C, EE Record copy
05 – Copy 2, EE State,Local copy
06 – Copy D, ER copy
20 – Copy B + C (1 Pg) - Show Copy B and Copy C on one Page
21 – Copy C + 2 (1 Pg) - Show Copy C and Copy 2 on one Page
22 – Copy B + C + 2 (2 Pg) - Show Copy B and Copy C on one Page follow by
At line 1,441 changed 2 lines
- only ‘2-on-1-page’ Format is supported, the 4-on-1-page Format is not available
- only option ‘01 – Copy A, SSA copy’ is supported, the other options are not available
- only ‘2-on-1-page’ Format is supported, the 4-on-1-page Format is not available
- only option ‘01 – Copy A, SSA copy’ is supported, the other options are not available
At line 1,453 changed one line
- if employees lost their W2 Forms and requested to have a replacement copy, user should run RPW2 by specifying the ‘Person Code’ and enter the word ‘REISSUED’ or ‘CORRECTED’ for this prompt, then RPW2 will print the W2 Form with the exact wording ‘REISSUED’ or ‘CORRECTED’ as entered on the W2 form
- if employees lost their W2 Forms and requested to have a replacement copy, user should run RPW2 by specifying the ‘Person Code’ and enter the word ‘REISSUED’ or ‘CORRECTED’ for this prompt, then RPW2 will print the W2 Form with the exact wording ‘REISSUED’ or ‘CORRECTED’ as entered on the W2 form
At line 1,458 changed 2 lines
- all users should test their Printer with this ‘Form Set Up’ toggle to find out the correct Page Set Up for ‘Top Margin Adjustment’ and ‘Between Form Space’ adjustment prior to printing the actual W2 Forms.
- since each Printer’s Page Set Up margin varies differently, each time when the user is printing the W2 forms on a different Printer, the user should do a Printer Set up test
- all users should test their Printer with this ‘Form Set Up’ toggle to find out the correct Page Set Up for ‘Top Margin Adjustment’ and ‘Between Form Space’ adjustment prior to printing the actual W2 Forms.
- since each Printer’s Page Set Up margin varies differently, each time when the user is printing the W2 forms on a different Printer, the user should do a Printer Set up test
At line 1,476 changed 3 lines
01 – 2 On 1 Page - ‘2 On 1 page’ W2 format is used
02 – 4 Corner Form - ‘4 Corners Form’ W2 format is used
03 – 4 Corner, Addr. Back - ‘4 Corners Form’ W2 format is used with Address printed on the back of form
01 – 2 On 1 Page - ‘2 On 1 page’ W2 format is used
02 – 4 Corner Form - ‘4 Corners Form’ W2 format is used
03 – 4 Corner, Addr. Back - ‘4 Corners Form’ W2 format is used with Address printed on the back of form
At line 1,480 changed one line
04 – 4 On 1 Page (Top-bottom) - ‘4 On 1 Page’ W2 Top to Bottom format is used
04 – 4 On 1 Page (Top-bottom) - ‘4 On 1 Page’ W2 Top to Bottom format is used
At line 1,482 changed one line
EE Instruction on back - when the ‘Show Form (2 on 1 pg)’ parameter is selected to print on the Employee’s Copy, (i.e. Copy B, C, 2), the user can also print the associated Employee Instruction on the back of these W2 Forms
EE Instruction on back - when the ‘Show Form (2 on 1 pg)’ parameter is selected to print on the Employee’s Copy, (i.e. Copy B, C, 2), the user can also print the associated Employee Instruction on the back of these W2 Forms
At line 1,486 changed 2 lines
- if the user wants to print a complete set of all Employee’s W2 Copies and Instructions, the user can select:
22 – Copy B + C + 2 (2 Pg) - Show Copy B and Copy C on one Page follow by
- if the user wants to print a complete set of all Employee’s W2 Copies and Instructions, the user can select:
22 – Copy B + C + 2 (2 Pg) - Show Copy B and Copy C on one Page follow by
At line 1,491 changed one line
- the user should default to NULL or ‘00 – 0 line’ adjustment to begin testing
- the user should default to NULL or ‘00 – 0 line’ adjustment to begin testing
At line 1,496 changed 7 lines
00 – 0 line
11 – Up 1/5 line
12 – Up 2/5 line
13 – Up 3/5 line
21 – Down 1/5 line
22 – Down 2/5 line
23 – Down 3/5 line
00 – 0 line
11 – Up 1/5 line
12 – Up 2/5 line
13 – Up 3/5 line
21 – Down 1/5 line
22 – Down 2/5 line
23 – Down 3/5 line
At line 1,505 changed one line
- the user should default to NULL or ‘0 – 0 line space’ to begin testing
- the user should default to NULL or ‘0 – 0 line space’ to begin testing
At line 1,507 changed one line
- if adjustment is needed, then re-run RPW2 by entering the ‘Between Form Space’
- if adjustment is needed, then re-run RPW2 by entering the ‘Between Form Space’
At line 1,510 changed 6 lines
0 – 0 line space
1 – 1/5 line space
2 – 2/5 line space
3 – 3/5 line space
4 – 4/5 line space
5 – 1 line space
0 – 0 line space
1 – 1/5 line space
2 – 2/5 line space
3 – 3/5 line space
4 – 4/5 line space
5 – 1 line space
At line 1,534 changed one line
If the combination of ‘Top Margin Adjustment’ and ‘Between Form Space’ pushes the Form to go over to the next page, the user should check the alignment with the actual pre-printed form and re-run RPW2 with different ‘Top Margin’ and ‘Between Form Space’ again.
If the combination of ‘Top Margin Adjustment’ and ‘Between Form Space’ pushes the Form to go over to the next page, the user should check the alignment with the actual pre-printed form and re-run RPW2 with different ‘Top Margin’ and ‘Between Form Space’ again.
At line 1,536 changed one line
When user is running RPW2 for pre-printed Forms, please do not toggle the ‘Show W2 Form’, ‘Show Frame’ parameters.
When user is running RPW2 for pre-printed Forms, please do not toggle the ‘Show W2 Form’, ‘Show Frame’ parameters.
At line 1,545 changed one line
For Top Margin adjustment, on the top form, the darker Red line above the top form is between several Green lines and it is in the center of these Green lines, the user can adjust Up or Down from the ‘Adjust Top Margin’ parameter.
For Top Margin adjustment, on the top form, the darker Red line above the top form is between several Green lines and it is in the center of these Green lines, the user can adjust Up or Down from the ‘Adjust Top Margin’ parameter.
At line 1,547 changed one line
For ‘Between Form Space’, the Blue line in the middle is the bottom of the Top form, user can increase the space increment for the Bottom form from the ‘Between Form Space’ parameter.
For ‘Between Form Space’, the Blue line in the middle is the bottom of the Top form, user can increase the space increment for the Bottom form from the ‘Between Form Space’ parameter.
At line 1,560 changed one line
!RPW2 – Printer Set Up
!RPW2 – Printer Set Up
At line 1,565 changed one line
When printing from the pdf file, user must set the Page Scaling option to ‘None’ to avoid re-sizing of the Form on a page.
When printing from the pdf file, user must set the Page Scaling option to ‘None’ to avoid re-sizing of the Form on a page.
At line 1,571 changed one line
!RPW2 – Form Print Processing
!RPW2 – Form Print Processing
At line 1,586 changed one line
- for Box 12 ‘Code Information’ and Box 14 ‘Other Information’, since the printing on W2 Forms are free format, RPW2 will not total these boxes, RPYEU Summary Report contains the totals for these boxes for user reference
- for Box 12 ‘Code Information’ and Box 14 ‘Other Information’, since the printing on W2 Forms are free format, RPW2 will not total these boxes, RPYEU Summary Report contains the totals for these boxes for user reference
At line 1,596 changed one line
- RPW2 provides options from Selection criteria parameter ‘Show Form (2 on 1 pg)’ to print different copies of the W2 forms and the Employee Instructions on the back
- RPW2 provides options from Selection criteria parameter ‘Show Form (2 on 1 pg)’ to print different copies of the W2 forms and the Employee Instructions on the back
At line 1,600 changed one line
- W2 Form Copy A, 1, B, C, 2, D and Instructions are taken directly from the government link above, however, it is the user’s responsibility to ensure these Employee Copies are accepted by the government as substitute of the pre-printed forms prior to distributing to the employees
- W2 Form Copy A, 1, B, C, 2, D and Instructions are taken directly from the government link above, however, it is the user’s responsibility to ensure these Employee Copies are accepted by the government as substitute of the pre-printed forms prior to distributing to the employees
At line 1,604 changed one line
!W-2 Wage Form Descriptions (2011 Format – reporting in 2011)
!W-2 Wage Form Descriptions (2011 Format – reporting in 2011)
At line 1,610 changed one line
- Field Identifier: W2-EE-SSN - suggested Field Variable: ‘EID.GOVERNMENT_CODE’
- Field Identifier: W2-EE-SSN - suggested Field Variable: ‘EID.GOVERNMENT_CODE’
At line 1,613 changed 2 lines
- Field Identifier: ‘W2-ER-EIN - suggested Field Variable:
‘DGV.GOVT_REGIST_NUMBER’
- Field Identifier: ‘W2-ER-EIN - suggested Field Variable:
‘DGV.GOVT_REGIST_NUMBER’
At line 1,616 changed 2 lines
- Field Identifier: W2-ER-NAME’ - suggested Field Variable: ‘DED.ENTITY_NAME’
- Field Identifier: W2-ER-LOCN-ADDR - suggested Field Variable: blank or constant ‘MAIL’
- Field Identifier: W2-ER-NAME’ - suggested Field Variable: ‘DED.ENTITY_NAME’
- Field Identifier: W2-ER-LOCN-ADDR - suggested Field Variable: blank or constant ‘MAIL’
At line 1,625 changed 2 lines
“CITYbbSTbbZIPCD-nnnn”
where b = one space, ST = State Abbreviated Code, ZIPCD = ZIP code, ‘-nnnn’ = ZIP extension
“CITYbbSTbbZIPCD-nnnn”
where b = one space, ST = State Abbreviated Code, ZIPCD = ZIP code, ‘-nnnn’ = ZIP extension
At line 1,629 changed 3 lines
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-COUNTRY’
- if Field Identifier: ‘W2-ER-COUNTRY’ = ‘USA’, then this country Identifier field value is changed to blank
- otherwise Field Identifier: ‘W2-ER-COUNTRY’ will be retrieved from IDCO screen UDF ‘ISO COUNTRY CODE’ with the 2 character ISO Country Code
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-COUNTRY’
- if Field Identifier: ‘W2-ER-COUNTRY’ = ‘USA’, then this country Identifier field value is changed to blank
- otherwise Field Identifier: ‘W2-ER-COUNTRY’ will be retrieved from IDCO screen UDF ‘ISO COUNTRY CODE’ with the 2 character ISO Country Code
At line 1,633 changed 4 lines
- note that Field Identifier: ‘W2-ER-F-COUNTRY’ is used for printing on W2 Form and EFW2 file, this identifier can specify to use the Country NAME or ISO Country code or leave blank to use the default
- if Field Identifier: ‘W2-ER-F-COUNTRY’ = ‘NAME’, then the Country Name is printed
- if Field Identifier: ‘W2-ER-F-COUNTRY’ = ‘ISO’, then the ISO Country Code is printed from IDCO UDF
- if Field Identifier: ‘W2-ER-F-COUNTRY’ = blank, then the IDCO Screen Country Code is printed
- note that Field Identifier: ‘W2-ER-F-COUNTRY’ is used for printing on W2 Form and EFW2 file, this identifier can specify to use the Country NAME or ISO Country code or leave blank to use the default
- if Field Identifier: ‘W2-ER-F-COUNTRY’ = ‘NAME’, then the Country Name is printed
- if Field Identifier: ‘W2-ER-F-COUNTRY’ = ‘ISO’, then the ISO Country Code is printed from IDCO UDF
- if Field Identifier: ‘W2-ER-F-COUNTRY’ = blank, then the IDCO Screen Country Code is printed
At line 1,641 changed one line
Null, 0 – Do not print Control Number on W2 Form
Null, 0 – Do not print Control Number on W2 Form
At line 1,643 changed one line
2 - Print Control Number as defined from RPYEU ‘Sort Level By’ prompt
2 - Print Control Number as defined from RPYEU ‘Sort Level By’ prompt
At line 1,645 changed 3 lines
4 - Print ‘Sort Level By’ prompt and Person Code
5 - Print ‘Sort Level By’ prompt and W2-CONTROL-NUM Identifier
6 - Print ‘Sort Level By’ prompt and W2-CONTROL-NUM Identifier and Person Code
4 - Print ‘Sort Level By’ prompt and Person Code
5 - Print ‘Sort Level By’ prompt and W2-CONTROL-NUM Identifier
6 - Print ‘Sort Level By’ prompt and W2-CONTROL-NUM Identifier and Person Code
At line 1,651 changed one line
e.g. ‘EID.PERSON_CODE’
e.g. ‘EID.PERSON_CODE’
At line 1,653 changed one line
- if ‘W2-CONTROL-PRT’ value is specified, then the value of ‘W2-CONTROL-NUM’ is printed on W2 Form Control Number field
- if ‘W2-CONTROL-PRT’ value is specified, then the value of ‘W2-CONTROL-NUM’ is printed on W2 Form Control Number field
At line 1,657 changed 4 lines
- Field Identifier: W2-EE-FIRST-NAME - suggested Field Variable: ‘EID.FIRST_NAME’
- Field Identifier: W2-EE-MIDDLE - suggested Field Variable: ‘EID.MIDDLE_NAME’
- Field Identifier: W2-EE-LAST-NAME - suggested Field Variable: ‘EID.LAST_NAME’
- Field Identifier: W2-EE-SUFFIX - suggested Field Variable: ‘EID.RANK’
- Field Identifier: W2-EE-FIRST-NAME - suggested Field Variable: ‘EID.FIRST_NAME’
- Field Identifier: W2-EE-MIDDLE - suggested Field Variable: ‘EID.MIDDLE_NAME’
- Field Identifier: W2-EE-LAST-NAME - suggested Field Variable: ‘EID.LAST_NAME’
- Field Identifier: W2-EE-SUFFIX - suggested Field Variable: ‘EID.RANK’
At line 1,664 changed one line
- Field Identifier: W2-EE-LOCN-ADDR - suggested Field Variable: blank or constant ‘MAIL’
- Field Identifier: W2-EE-LOCN-ADDR - suggested Field Variable: blank or constant ‘MAIL’
At line 1,672 changed 2 lines
“CITYbbSTbbZIPCD-nnnn”
where b = one space, ST = State Abbreviated Code, ZIPCD = ZIP code, ‘-nnnn’ = ZIP extension
“CITYbbSTbbZIPCD-nnnn”
where b = one space, ST = State Abbreviated Code, ZIPCD = ZIP code, ‘-nnnn’ = ZIP extension
At line 1,676 changed 3 lines
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-COUNTRY’
- if Field Identifier: ‘W2-EE-COUNTRY’ = ‘USA’, then this country field value is blank
- otherwise Field Identifier: ‘W2-EE-COUNTRY’ is already retrieved from IDCO screen UDF ‘ISO COUNTRY CODE’ with the 2 character ISO Country Code
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-COUNTRY’
- if Field Identifier: ‘W2-EE-COUNTRY’ = ‘USA’, then this country field value is blank
- otherwise Field Identifier: ‘W2-EE-COUNTRY’ is already retrieved from IDCO screen UDF ‘ISO COUNTRY CODE’ with the 2 character ISO Country Code
At line 1,680 changed 4 lines
- note that Field Identifier: ‘W2-EE-F-COUNTRY’ is used for printing on W2 Form and EFW2 file, this identifier can specify to use the country NAME or ISO code or leave blank to use the default
- if Field Identifier: ‘W2-EE-F-COUNTRY’ = ‘NAME’, then the Country Name is printed
- if Field Identifier: ‘W2-EE-F-COUNTRY’ = ‘ISO’, then the ISO Country Code is printed from IDCO UDF
- if Field Identifier: ‘W2-EE-F-COUNTRY’ = blank, then the IDCO Screen Country Code is printed
- note that Field Identifier: ‘W2-EE-F-COUNTRY’ is used for printing on W2 Form and EFW2 file, this identifier can specify to use the country NAME or ISO code or leave blank to use the default
- if Field Identifier: ‘W2-EE-F-COUNTRY’ = ‘NAME’, then the Country Name is printed
- if Field Identifier: ‘W2-EE-F-COUNTRY’ = ‘ISO’, then the ISO Country Code is printed from IDCO UDF
- if Field Identifier: ‘W2-EE-F-COUNTRY’ = blank, then the IDCO Screen Country Code is printed
At line 1,686 changed one line
- Field Identifier: W2-FIT-WAGE - suggested Field Variable (Element): ‘W2-BOX-01’
- Field Identifier: W2-FIT-WAGE - suggested Field Variable (Element): ‘W2-BOX-01’
At line 1,692 changed one line
- Field Identifier: W2-FIT-TAX - suggested Field Variable (Element): ‘W2-BOX-02’
- Field Identifier: W2-FIT-TAX - suggested Field Variable (Element): ‘W2-BOX-02’
At line 1,696 changed one line
- Field Identifier: W2-SSN-WAGE - suggested Field Variable (Element): ‘W2-BOX-03’
- Field Identifier: W2-SSN-WAGE - suggested Field Variable (Element): ‘W2-BOX-03’
At line 1,698 changed one line
- The total of Box 3 and 7 cannot exceed the Annual maximum social security wage base specified by the government. RPYEU will automatically supply the annual maximum when the government publish the maximum amount every year. The user does not need to set up on IDGV screen with Registration Type ‘US FICA Registration’ and ‘Govt Rate Type’ = ‘US FICA Max Base Amt’. RPYEU program checks the maximum and an exception message is issued if the wage base is exceeded.
- The total of Box 3 and 7 cannot exceed the Annual maximum social security wage base specified by the government. RPYEU will automatically supply the annual maximum when the government publish the maximum amount every year. The user does not need to set up on IDGV screen with Registration Type ‘US FICA Registration’ and ‘Govt Rate Type’ = ‘US FICA Max Base Amt’. RPYEU program checks the maximum and an exception message is issued if the wage base is exceeded.
At line 1,702 changed one line
- Field Identifier: W2-SSN-TAX - suggested Field Variable (Element): ‘W2-BOX-04’
- Field Identifier: W2-SSN-TAX - suggested Field Variable (Element): ‘W2-BOX-04’
At line 1,706 changed one line
- Field Identifier: W2-MEDI-WAGE - suggested Field Variable (Element): ‘W2-BOX-05’
- Field Identifier: W2-MEDI-WAGE - suggested Field Variable (Element): ‘W2-BOX-05’
At line 1,710 changed one line
- Field Identifier: W2-MEDI-TAX - suggested Field Variable (Element): ‘W2-BOX-06’
- Field Identifier: W2-MEDI-TAX - suggested Field Variable (Element): ‘W2-BOX-06’
At line 1,714 changed one line
- Field Identifier: W2-SSN-TIP - suggested Field Variable (Element): ‘W2-BOX-07’
- Field Identifier: W2-SSN-TIP - suggested Field Variable (Element): ‘W2-BOX-07’
At line 1,716 changed one line
- The total of Box 3 and 7 cannot exceed the Annual maximum social security wage base specified by the government. RPYEU will automatically supply the annual maximum when the government publish the maximum amount every year. The user does not need to set up n IDGV screen with Registration Type ‘US FICA Registration’ and ‘Govt Rate Type’ = ‘US FICA Max Base Amt’. RPYEU program checks the maximum and an exception message is issued if the wage base is exceeded.
- The total of Box 3 and 7 cannot exceed the Annual maximum social security wage base specified by the government. RPYEU will automatically supply the annual maximum when the government publish the maximum amount every year. The user does not need to set up n IDGV screen with Registration Type ‘US FICA Registration’ and ‘Govt Rate Type’ = ‘US FICA Max Base Amt’. RPYEU program checks the maximum and an exception message is issued if the wage base is exceeded.
At line 1,720 changed one line
- Field Identifier: W2-ALLOC-TIP - suggested Field Variable (Element): ‘W2-BOX-08’
- Field Identifier: W2-ALLOC-TIP - suggested Field Variable (Element): ‘W2-BOX-08’
At line 1,726 changed one line
- Field Identifier: W2-DEP-CARE - suggested Field Variable (Element): ‘W2-BOX-10’
- Field Identifier: W2-DEP-CARE - suggested Field Variable (Element): ‘W2-BOX-10’
At line 1,730 changed 3 lines
- Field Identifier: W2-NQUAL - suggested Field Variable (Element): ‘W2-BOX-11’
- the value for ‘W2-NQUAL’ should include amounts for Identifier ‘W2-NQUAL-457’ and ‘W2-NQUAL-N457’
- the magnetic media file will report amount from ‘W2-NQUAL-457’ and ‘W2-NQUAL-N457’ while the W2 form will print amount from ‘W2-NQUAL’
- Field Identifier: W2-NQUAL - suggested Field Variable (Element): ‘W2-BOX-11’
- the value for ‘W2-NQUAL’ should include amounts for Identifier ‘W2-NQUAL-457’ and ‘W2-NQUAL-N457’
- the magnetic media file will report amount from ‘W2-NQUAL-457’ and ‘W2-NQUAL-N457’ while the W2 form will print amount from ‘W2-NQUAL’
At line 1,736 changed 27 lines
- Field Identifier: ‘W2-CODE-A’
- Field Identifier: ‘W2-CODE-B’
- Field Identifier: ‘W2-CODE-C’
- Field Identifier: ‘W2-CODE-D’
- Field Identifier: ‘W2-CODE-E’
- Field Identifier: ‘W2-CODE-F’
- Field Identifier: ‘W2-CODE-G’
- Field Identifier: ‘W2-CODE-H’
- Field Identifier: ‘W2-CODE-J’
- Field Identifier: ‘W2-CODE-K’
- Field Identifier: ‘W2-CODE-L’
- Field Identifier: ‘W2-CODE-M’
- Field Identifier: ‘W2-CODE-N’
- Field Identifier: ‘W2-CODE-P’
- Field Identifier: ‘W2-CODE-Q’
- Field Identifier: ‘W2-CODE-R’
- Field Identifier: ‘W2-CODE-S’
- Field Identifier: ‘W2-CODE-T’
- Field Identifier: ‘W2-CODE-V’
- Field Identifier: ‘W2-CODE-W’
- Field Identifier: ‘W2-CODE-Y’
- Field Identifier: ‘W2-CODE-Z’
- Field Identifier: ‘W2-CODE-AA’
- Field Identifier: ‘W2-CODE-BB’
- Field Identifier: ‘W2-CODE-CC’
- Field Identifier: ‘W2-CODE-DD’
- Field Identifier: ‘W2-CODE-EE’
- Field Identifier: ‘W2-CODE-A’
- Field Identifier: ‘W2-CODE-B’
- Field Identifier: ‘W2-CODE-C’
- Field Identifier: ‘W2-CODE-D’
- Field Identifier: ‘W2-CODE-E’
- Field Identifier: ‘W2-CODE-F’
- Field Identifier: ‘W2-CODE-G’
- Field Identifier: ‘W2-CODE-H’
- Field Identifier: ‘W2-CODE-J’
- Field Identifier: ‘W2-CODE-K’
- Field Identifier: ‘W2-CODE-L’
- Field Identifier: ‘W2-CODE-M’
- Field Identifier: ‘W2-CODE-N’
- Field Identifier: ‘W2-CODE-P’
- Field Identifier: ‘W2-CODE-Q’
- Field Identifier: ‘W2-CODE-R’
- Field Identifier: ‘W2-CODE-S’
- Field Identifier: ‘W2-CODE-T’
- Field Identifier: ‘W2-CODE-V’
- Field Identifier: ‘W2-CODE-W’
- Field Identifier: ‘W2-CODE-Y’
- Field Identifier: ‘W2-CODE-Z’
- Field Identifier: ‘W2-CODE-AA’
- Field Identifier: ‘W2-CODE-BB’
- Field Identifier: ‘W2-CODE-CC’
- Field Identifier: ‘W2-CODE-DD’
- Field Identifier: ‘W2-CODE-EE’
At line 1,772 changed one line
- IDFDV Field Identifier: ‘W2-STAT-EE’
- IDFDV Field Identifier: ‘W2-STAT-EE’
At line 1,776 changed one line
- IDFDV Field Identifier: ‘W2-RETIRE-PLAN’
- IDFDV Field Identifier: ‘W2-RETIRE-PLAN’
At line 1,780 changed one line
- IDFDV Field Identifier: ‘W2-3PARTY-SICK’
- IDFDV Field Identifier: ‘W2-3PARTY-SICK’
At line 1,786 changed one line
- Field Identifier: ‘W2-OTHER-01’, ‘W2-OTHER-02’, …. up to ‘W2-OTHER-20’
- Field Identifier: ‘W2-OTHER-01’, ‘W2-OTHER-02’, …. up to ‘W2-OTHER-20’
At line 1,788 changed 2 lines
- Field Identifier: ‘W2-SCHL-WAGE’, for school district taxable wages
- Field Identifier: ‘W2-SCHL-TAX’, for school district tax
- Field Identifier: ‘W2-SCHL-WAGE’, for school district taxable wages
- Field Identifier: ‘W2-SCHL-TAX’, for school district tax
At line 1,791 changed 2 lines
- for W2 form ‘2 on 1 page’ format, up to 4 lines (2 Box 14 items) can be printed
- for W2 form ‘4 Corner Form’ format, up to 2 lines (2 Box 14 items) can be printed
- for W2 form ‘2 on 1 page’ format, up to 4 lines (2 Box 14 items) can be printed
- for W2 form ‘4 Corner Form’ format, up to 2 lines (2 Box 14 items) can be printed
At line 1,806 changed one line
- the IDFDV ‘W2-SCHL-TAX’ entry should specify an element that contains all the school district tax pay components
- the IDFDV ‘W2-SCHL-TAX’ entry should specify an element that contains all the school district tax pay components
At line 1,810 changed one line
- the IDFDV ‘W2-SCHL-WAGE’ entry should specify an element that contains all the school district wages pay components
- the IDFDV ‘W2-SCHL-WAGE’ entry should specify an element that contains all the school district wages pay components
At line 1,815 changed 2 lines
- IDFDV Field Identifier: ‘W2-STATE-CODE’
- IDFDV Field Variable: ‘DSP.STATE_PROVINCE_CODE’
- IDFDV Field Identifier: ‘W2-STATE-CODE’
- IDFDV Field Variable: ‘DSP.STATE_PROVINCE_CODE’
At line 1,820 changed 2 lines
- IDFDV Field Identifier: ‘W2-STATE-REGIST’
- IDFDV Field Variable: ‘DGV.GOVT_REGIST_NUMBER’
- IDFDV Field Identifier: ‘W2-STATE-REGIST’
- IDFDV Field Variable: ‘DGV.GOVT_REGIST_NUMBER’
At line 1,823 changed one line
- the IDGV screen must have an entry exist with ‘State Registration’ for the State to be reported
- the IDGV screen must have an entry exist with ‘State Registration’ for the State to be reported
At line 1,826 changed 2 lines
- IDFDV Field Identifier: ‘W2-ST-WAGE-HOME’ - suggested Field Variable (Element): ‘W2-BOX-16-H’
- IDFDV Field Identifier: ‘W2-ST-WAGE-WORK’ - suggested Field Variable (Element): ‘W2-BOX-16-W’
- IDFDV Field Identifier: ‘W2-ST-WAGE-HOME’ - suggested Field Variable (Element): ‘W2-BOX-16-H’
- IDFDV Field Identifier: ‘W2-ST-WAGE-WORK’ - suggested Field Variable (Element): ‘W2-BOX-16-W’
At line 1,837 changed one line
- IDFDV Field Identifier ‘W2-ST-WAGE-WORK’ is used to set up the WORK State wage information
- IDFDV Field Identifier ‘W2-ST-WAGE-WORK’ is used to set up the WORK State wage information
At line 1,841 changed one line
- IDFDV Field Identifier ‘W2-ST-WAGE-HOME’ is used to set up the Residence State wage information
- IDFDV Field Identifier ‘W2-ST-WAGE-HOME’ is used to set up the Residence State wage information
At line 1,845 changed one line
- if the user has never withheld State tax according to Residence State, then the IDFDV ‘W2-ST-WAGE-HOME’ entry does not need to be set up, thus this ‘W2-ST-WAGE-HOME’ entry is optional and will be used only when an employee has Residence State tax applicable to the State
- if the user has never withheld State tax according to Residence State, then the IDFDV ‘W2-ST-WAGE-HOME’ entry does not need to be set up, thus this ‘W2-ST-WAGE-HOME’ entry is optional and will be used only when an employee has Residence State tax applicable to the State
At line 1,848 changed 2 lines
- IDFDV Field Identifier: ‘W2-ST-TAX-HOME’ - suggested Field Variable (Element): ‘W2-BOX-17-H’
- IDFDV Field Identifier: ‘W2-ST-TAX-WORK’ - suggested Field Variable (Element): ‘W2-BOX-17-W’
- IDFDV Field Identifier: ‘W2-ST-TAX-HOME’ - suggested Field Variable (Element): ‘W2-BOX-17-H’
- IDFDV Field Identifier: ‘W2-ST-TAX-WORK’ - suggested Field Variable (Element): ‘W2-BOX-17-W’
At line 1,857 changed one line
- IDFDV Field Identifier ‘W2-ST-TAX-WORK’ is used to set up the WORK State tax information
- IDFDV Field Identifier ‘W2-ST-TAX-WORK’ is used to set up the WORK State tax information
At line 1,861 changed one line
- IDFDV Field Identifier ‘W2-ST-TAX-HOME’ is used to set up the Residence State tax information
- IDFDV Field Identifier ‘W2-ST-TAX-HOME’ is used to set up the Residence State tax information
At line 1,865 changed one line
- if the user has never withheld State tax according to Residence State, then the IDFDV ‘W2-ST-TAX-HOME’ entry does not need to be set up, thus this ‘W2-ST-TAX-HOME’ entry is optional and will be used only when an employee has Residence State tax applicable to the State
- if the user has never withheld State tax according to Residence State, then the IDFDV ‘W2-ST-TAX-HOME’ entry does not need to be set up, thus this ‘W2-ST-TAX-HOME’ entry is optional and will be used only when an employee has Residence State tax applicable to the State
At line 1,869 changed 4 lines
- IDFDV Field Identifier: ‘W2-CN-WAGE-HOME’ - suggested Field Variable (Element): ‘W2-BOX-18-CN-H’
- IDFDV Field Identifier: ‘W2-CN-WAGE-WORK’ - suggested Field Variable (Element): ‘W2-BOX-18-CN-W’
- IDFDV Field Identifier: ‘W2-CI-WAGE-HOME’ - suggested Field Variable (Element): ‘W2-BOX-18-CI-H’
- IDFDV Field Identifier: ‘W2-CI-WAGE-WORK’ - suggested Field Variable (Element): ‘W2-BOX-18-CI-W’
- IDFDV Field Identifier: ‘W2-CN-WAGE-HOME’ - suggested Field Variable (Element): ‘W2-BOX-18-CN-H’
- IDFDV Field Identifier: ‘W2-CN-WAGE-WORK’ - suggested Field Variable (Element): ‘W2-BOX-18-CN-W’
- IDFDV Field Identifier: ‘W2-CI-WAGE-HOME’ - suggested Field Variable (Element): ‘W2-BOX-18-CI-H’
- IDFDV Field Identifier: ‘W2-CI-WAGE-WORK’ - suggested Field Variable (Element): ‘W2-BOX-18-CI-W’
At line 1,881 changed one line
- IDFDV Field Identifier ‘W2-CI-WAGE-WORK’ is used to set up the WORK City wage information
- IDFDV Field Identifier ‘W2-CI-WAGE-WORK’ is used to set up the WORK City wage information
At line 1,885 changed one line
- IDFDV Field Identifier ‘W2-CN-WAGE-WORK’ is used to set up the WORK County wage information
- IDFDV Field Identifier ‘W2-CN-WAGE-WORK’ is used to set up the WORK County wage information
At line 1,889 changed one line
- IDFDV Field Identifier ‘W2-CI-WAGE-HOME’ is used to set up the Residence City wage information
- IDFDV Field Identifier ‘W2-CI-WAGE-HOME’ is used to set up the Residence City wage information
At line 1,893 changed one line
- IDFDV Field Identifier ‘W2-CN-WAGE-HOME’ is used to set up the Residence County wage information
- IDFDV Field Identifier ‘W2-CN-WAGE-HOME’ is used to set up the Residence County wage information
At line 1,898 changed 4 lines
- IDFDV Field Identifier: ‘W2-CN-TAX-HOME’ - suggested Field Variable (Element): ‘W2-BOX-19-CN-H’
- IDFDV Field Identifier: ‘W2-CN-TAX -WORK’ - suggested Field Variable (Element): ‘W2-BOX-19-CN-W’
- IDFDV Field Identifier: ‘W2-CI-TAX -HOME’ - suggested Field Variable (Element): ‘W2-BOX-19-CI-H’
- IDFDV Field Identifier: ‘W2-CI-TAX -WORK’ - suggested Field Variable (Element): ‘W2-BOX-19-CI-W’
- IDFDV Field Identifier: ‘W2-CN-TAX-HOME’ - suggested Field Variable (Element): ‘W2-BOX-19-CN-H’
- IDFDV Field Identifier: ‘W2-CN-TAX -WORK’ - suggested Field Variable (Element): ‘W2-BOX-19-CN-W’
- IDFDV Field Identifier: ‘W2-CI-TAX -HOME’ - suggested Field Variable (Element): ‘W2-BOX-19-CI-H’
- IDFDV Field Identifier: ‘W2-CI-TAX -WORK’ - suggested Field Variable (Element): ‘W2-BOX-19-CI-W’
At line 1,907 changed one line
- IDFDV Field Identifier ‘W2-CI-TAX -WORK’ is used to set up the WORK City tax information
- IDFDV Field Identifier ‘W2-CI-TAX -WORK’ is used to set up the WORK City tax information
At line 1,911 changed one line
- IDFDV Field Identifier ‘W2-CN-TAX -WORK’ is used to set up the WORK County tax information
- IDFDV Field Identifier ‘W2-CN-TAX -WORK’ is used to set up the WORK County tax information
At line 1,915 changed one line
- IDFDV Field Identifier ‘W2-CI-TAX -HOME’ is used to set up the Residence City tax information
- IDFDV Field Identifier ‘W2-CI-TAX -HOME’ is used to set up the Residence City tax information
At line 1,919 changed one line
- IDFDV Field Identifier ‘W2-CN-TAX -HOME’ is used to set up the Residence County tax information
- IDFDV Field Identifier ‘W2-CN-TAX -HOME’ is used to set up the Residence County tax information
At line 1,925 changed one line
(1) - For California, if IDFDV Identifier Seq 7260 W2-SDI-TAX-EE is not zero, then Box 19 will print the employee SDI contribution and Box 20 will print the description ‘CASDI’
(1) - For California, if IDFDV Identifier Seq 7260 W2-SDI-TAX-EE is not zero, then Box 19 will print the employee SDI contribution and Box 20 will print the description ‘CASDI’
At line 1,927 changed one line
(2) - For California, if IDFDV Identifier Seq 7260 W2-SDI-TAX-EE is not set up, the user may set up Box 14 to print ‘CASDI’ and the SDI amount
(2) - For California, if IDFDV Identifier Seq 7260 W2-SDI-TAX-EE is not set up, the user may set up Box 14 to print ‘CASDI’ and the SDI amount
At line 1,931 changed 4 lines
- IDFDV Field Identifier: ‘W2-CNTY-NAME’
- IDFDV Field Variable: ‘DCN.COUNTY_NAME’
- IDFDV Field Identifier: ‘W2-CITY-NAME’
- IDFDV Field Variable: ‘DTX.JURISDICTION_NAME’
- IDFDV Field Identifier: ‘W2-CNTY-NAME’
- IDFDV Field Variable: ‘DCN.COUNTY_NAME’
- IDFDV Field Identifier: ‘W2-CITY-NAME’
- IDFDV Field Variable: ‘DTX.JURISDICTION_NAME’
At line 1,937 changed 2 lines
- if County tax is reported, the County name is retrieved from the IDCN County screen with GEO code = ‘xx-xxx-0000’
- e.g. In Indiana, GEO code ‘15-097-0670’ is for the city of ‘Indianapolis’, then use County Code ‘15-097-0000’ to retrieve the County name of ‘Marion’ for reporting
- if County tax is reported, the County name is retrieved from the IDCN County screen with GEO code = ‘xx-xxx-0000’
- e.g. In Indiana, GEO code ‘15-097-0670’ is for the city of ‘Indianapolis’, then use County Code ‘15-097-0000’ to retrieve the County name of ‘Marion’ for reporting
At line 1,940 changed one line
- an entry must also exist on IDGV screen with ‘Local Registration’ for a County or City in order for the County or City tax to be reported
- an entry must also exist on IDGV screen with ‘Local Registration’ for a County or City in order for the County or City tax to be reported
At line 1,949 changed one line
!Record Name: Code RA – Submitter Record
!Record Name: Code RA – Submitter Record
At line 1,954 changed one line
3-11 - Submitter’s Employer ID number (EIN)
3-11 - Submitter’s Employer ID number (EIN)
At line 1,956 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-ER-EIN’
- Derived from IDFDV screen, Field Identifier: ‘SUB-ER-EIN’
At line 1,959 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-USER-ID’
- Derived from IDFDV screen, Field Identifier: ‘SUB-USER-ID’
At line 1,962 changed one line
- Derived from IDFDV Seq# 1035 Field Identifier: ‘SUB-VENDOR’
- Derived from IDFDV Seq# 1035 Field Identifier: ‘SUB-VENDOR’
At line 1,968 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-RESUB-IND’
- Derived from IDFDV screen, Field Identifier: ‘SUB-RESUB-IND’
At line 1,971 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-RESUB-WFID’
- Derived from IDFDV screen, Field Identifier: ‘SUB-RESUB-WFID’
At line 1,974 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-SOFTWARE’
- Derived from IDFDV screen, Field Identifier: ‘SUB-SOFTWARE’
At line 1,977 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-NAME’
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-NAME’
At line 1,980 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-LOCN’
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-LOCN’
At line 1,983 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-DELIV’
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-DELIV’
At line 1,986 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-CITY’
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-CITY’
At line 1,989 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-STATE’
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-STATE’
At line 1,992 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-ZIP’
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-ZIP’
At line 1,995 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-ZIP-EXT’
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-ZIP-EXT’
At line 2,000 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-F-STATE’
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-F-STATE’
At line 2,003 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-F-POST’
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-F-POST’
At line 2,006 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-COUNTRY’
- Derived from IDFDV screen, Field Identifier: ‘SUB-COMP-COUNTRY’
At line 2,009 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-NAME’
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-NAME’
At line 2,012 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-LOCN’
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-LOCN’
At line 2,015 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-DELIV’
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-DELIV’
At line 2,018 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-CITY’
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-CITY’
At line 2,021 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-STATE’
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-STATE’
At line 2,024 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-ZIP’
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-ZIP’
At line 2,027 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-ZIP-EXT’
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-ZIP-EXT’
At line 2,032 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-F-STATE’
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-F-STATE’
At line 2,035 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-F-POST’
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-F-POST’
At line 2,038 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-COUNTRY’
- Derived from IDFDV screen, Field Identifier: ‘SUB-SUBM-COUNTRY’
At line 2,041 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-NAME’
- Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-NAME’
At line 2,044 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-TEL’
- Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-TEL’
At line 2,047 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-TEL-EXT’
- Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-TEL-EXT’
At line 2,052 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-EMAIL’
- Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-EMAIL’
At line 2,057 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-FAX’
- Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-FAX’
At line 2,060 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-METH’
- Derived from IDFDV screen, Field Identifier: ‘SUB-CONT-METH’
At line 2,063 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-PREPARER’
- Derived from IDFDV screen, Field Identifier: ‘SUB-PREPARER’
At line 2,068 changed one line
!Record Name: Code RE – Employer Record
!Record Name: Code RE – Employer Record
At line 2,077 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-AGENT-IND’
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-AGENT-IND’
At line 2,081 changed one line
- If on RPYEU selection screen the ‘Combined Fed Regist#’ toggle is ‘checked’, then this Employer/Agent EIN is retrieved from IDFDV screen, Field Identifier: ‘W2-ER-EIN’, otherwise the EIN is derived for every Code RE record
- If on RPYEU selection screen the ‘Combined Fed Regist#’ toggle is ‘checked’, then this Employer/Agent EIN is retrieved from IDFDV screen, Field Identifier: ‘W2-ER-EIN’, otherwise the EIN is derived for every Code RE record
At line 2,084 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-FOR-EIN’
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-FOR-EIN’
At line 2,087 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-TERM-BUS’
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-TERM-BUS’
At line 2,090 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-ESTAB’
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-ESTAB’
At line 2,093 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-OTHER-EIN’
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-OTHER-EIN’
At line 2,096 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-NAME’
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-NAME’
At line 2,099 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-LOCN-ADDR’
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-LOCN-ADDR’
At line 2,102 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-DELIV-ADDR’
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-DELIV-ADDR’
At line 2,105 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-CITY’
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-CITY’
At line 2,108 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-STATE’
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-STATE’
At line 2,111 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-ZIP’
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-ZIP’
At line 2,114 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-ZIP-EXT’
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-ZIP-EXT’
At line 2,116 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-KIND-OF-EMPLOYER’ (seq 2120)
- Derived from IDFDV screen, Field Identifier: ‘W2-KIND-OF-EMPLOYER’ (seq 2120)
At line 2,121 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-F-STATE’
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-F-STATE’
At line 2,124 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-F-POSTAL’
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-F-POSTAL’
At line 2,127 changed 3 lines
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-COUNTRY’
- if Field Identifier: ‘W2-ER-COUNTRY’ = ‘USA’, then this field is blank
- otherwise this is a Foreign Country Code and the Field Identifier: ‘W2-ER-COUNTRY’ is already retrieved from IDCO screen UDF ‘ISO COUNTRY CODE’ with the 2 character ISO Country Code
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-COUNTRY’
- if Field Identifier: ‘W2-ER-COUNTRY’ = ‘USA’, then this field is blank
- otherwise this is a Foreign Country Code and the Field Identifier: ‘W2-ER-COUNTRY’ is already retrieved from IDCO screen UDF ‘ISO COUNTRY CODE’ with the 2 character ISO Country Code
At line 2,131 changed 4 lines
- note that Field Identifier: ‘W2-ER-F-COUNTRY’ is used for printing on W2 Form, this identifier can specify to use the NAME or ISO or leave blank
- if Field Identifier: ‘W2-ER-F-COUNTRY’ = ‘NAME’, then the Country Name is printed
- if Field Identifier: ‘W2-ER-F-COUNTRY’ = ‘ISO’, then the ISO Country Code is printed
- if Field Identifier: ‘W2-ER-F-COUNTRY’ = blank, then the IDCO Screen Country Code is printed
- note that Field Identifier: ‘W2-ER-F-COUNTRY’ is used for printing on W2 Form, this identifier can specify to use the NAME or ISO or leave blank
- if Field Identifier: ‘W2-ER-F-COUNTRY’ = ‘NAME’, then the Country Name is printed
- if Field Identifier: ‘W2-ER-F-COUNTRY’ = ‘ISO’, then the ISO Country Code is printed
- if Field Identifier: ‘W2-ER-F-COUNTRY’ = blank, then the IDCO Screen Country Code is printed
At line 2,137 changed 3 lines
- from IDGR ‘W2 Employment Type’ or IPRLU FICA and Medicare method
- If IPRLU.FICA method = "Do not calculate" and MEDICARE method is NOT "Do Not Calculate" then the employee is classified as Employment Type ‘Q’ for W2 reporting
- otherwise the W2 Type of employment is derived from IDGR screen Registration tab ‘W2 Emp Type’
- from IDGR ‘W2 Employment Type’ or IPRLU FICA and Medicare method
- If IPRLU.FICA method = "Do not calculate" and MEDICARE method is NOT "Do Not Calculate" then the employee is classified as Employment Type ‘Q’ for W2 reporting
- otherwise the W2 Type of employment is derived from IDGR screen Registration tab ‘W2 Emp Type’
At line 2,144 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-TAX-JURIS’
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-TAX-JURIS’
At line 2,147 changed one line
- Derived from IDFDV screen, Field Identifier: ‘SUB-3RD-PARTY-SICK’
- Derived from IDFDV screen, Field Identifier: ‘SUB-3RD-PARTY-SICK’
At line 2,151 changed one line
!Record Name: Code RW – Employee Wage Record
!Record Name: Code RW – Employee Wage Record
At line 2,157 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-SSN’
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-SSN’
At line 2,161 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-FIRST-NAME’
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-FIRST-NAME’
At line 2,164 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-MIDDLE’
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-MIDDLE’
At line 2,167 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-LAST-NAME’
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-LAST-NAME’
At line 2,170 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-SUFFIX’
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-SUFFIX’
At line 2,173 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-LOCN-ADDR’
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-LOCN-ADDR’
At line 2,176 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-DELIV-ADDR’
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-DELIV-ADDR’
At line 2,179 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-CITY’
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-CITY’
At line 2,182 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-STATE’
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-STATE’
At line 2,185 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-ZIP’
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-ZIP’
At line 2,188 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-ZIP-EXT’
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-ZIP-EXT’
At line 2,193 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-F-STATE’
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-F-STATE’
At line 2,196 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-F-POSTAL’
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-F-POSTAL’
At line 2,199 changed 3 lines
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-COUNTRY’
- if Field Identifier: ‘W2-EE-COUNTRY’ = ‘USA’, then this field is blank
- otherwise this is a Foreign Country Code and the Field Identifier: ‘W2-EE-COUNTRY’ is already retrieved from IDCO screen UDF ‘ISO COUNTRY CODE’ with the 2 character ISO Country Code
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-COUNTRY’
- if Field Identifier: ‘W2-EE-COUNTRY’ = ‘USA’, then this field is blank
- otherwise this is a Foreign Country Code and the Field Identifier: ‘W2-EE-COUNTRY’ is already retrieved from IDCO screen UDF ‘ISO COUNTRY CODE’ with the 2 character ISO Country Code
At line 2,203 changed 4 lines
- note that Field Identifier: ‘W2-EE-F-COUNTRY’ is used for printing on W2 Form, this identifier can specify to use the NAME or ISO or leave blank
- if Field Identifier: ‘W2-EE-F-COUNTRY’ = ‘NAME’, then the Country Name is printed
- if Field Identifier: ‘W2-EE-F-COUNTRY’ = ‘ISO’, then the ISO Country Code is printed
- if Field Identifier: ‘W2-EE-F-COUNTRY’ = blank, then the IDCO Screen Country Code is printed
- note that Field Identifier: ‘W2-EE-F-COUNTRY’ is used for printing on W2 Form, this identifier can specify to use the NAME or ISO or leave blank
- if Field Identifier: ‘W2-EE-F-COUNTRY’ = ‘NAME’, then the Country Name is printed
- if Field Identifier: ‘W2-EE-F-COUNTRY’ = ‘ISO’, then the ISO Country Code is printed
- if Field Identifier: ‘W2-EE-F-COUNTRY’ = blank, then the IDCO Screen Country Code is printed
At line 2,209 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-FIT-WAGE’
- Derived from IDFDV screen, Field Identifier: ‘W2-FIT-WAGE’
At line 2,212 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-FIT-TAX’
- Derived from IDFDV screen, Field Identifier: ‘W2-FIT-TAX’
At line 2,215 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-SSN-WAGE’
- Derived from IDFDV screen, Field Identifier: ‘W2-SSN-WAGE’
At line 2,218 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-SSN-TAX’
- Derived from IDFDV screen, Field Identifier: ‘W2-SSN-TAX’
At line 2,221 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-MEDI-WAGE’
- Derived from IDFDV screen, Field Identifier: ‘W2-MEDI-WAGE’
At line 2,224 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-MEDI-TAX’
- Derived from IDFDV screen, Field Identifier: ‘W2-MEDI-TAX’
At line 2,227 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-SSN-TIP’
- Derived from IDFDV screen, Field Identifier: ‘W2-SSN-TIP’
At line 2,230 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-EIC’
- Derived from IDFDV screen, Field Identifier: ‘W2-EIC’
At line 2,233 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-DEP-CARE’
- Derived from IDFDV screen, Field Identifier: ‘W2-DEP-CARE’
At line 2,236 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-D’
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-D’
At line 2,239 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-E’
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-E’
At line 2,242 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-F’
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-F’
At line 2,245 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-G’
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-G’
At line 2,248 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-H’
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-H’
At line 2,251 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-Q’
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-Q’
At line 2,255 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-NQUAL-457’
- Derived from IDFDV screen, Field Identifier: ‘W2-NQUAL-457’
At line 2,258 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-W’
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-W’
At line 2,261 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-NQUAL-N457’
- Derived from IDFDV screen, Field Identifier: ‘W2-NQUAL-N457’
At line 2,264 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-Q’
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-Q’
At line 2,269 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-C’
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-C’
At line 2,272 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-V’
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-V’
At line 2,275 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-DD’ (seq 4250)
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-DD’ (seq 4250)
At line 2,279 changed 2 lines
- Derived from IDFDV screen, Field Identifier: ‘W2-STAT-EE’
- if the amount is non zero, then ‘1’ is entered, otherwise ‘0’ is entered
- Derived from IDFDV screen, Field Identifier: ‘W2-STAT-EE’
- if the amount is non zero, then ‘1’ is entered, otherwise ‘0’ is entered
At line 2,285 changed 2 lines
- Derived from IDFDV screen, Field Identifier: ‘W2-RETIRE-PLAN’
- if the amount is non zero, then ‘1’ is entered, otherwise ‘0’ is entered
- Derived from IDFDV screen, Field Identifier: ‘W2-RETIRE-PLAN’
- if the amount is non zero, then ‘1’ is entered, otherwise ‘0’ is entered
At line 2,289 changed 2 lines
- Derived from IDFDV screen, Field Identifier: ‘W2-3PARTY-SICK’
- if the amount is non zero, then ‘1’ is entered, otherwise ‘0’ is entered
- Derived from IDFDV screen, Field Identifier: ‘W2-3PARTY-SICK’
- if the amount is non zero, then ‘1’ is entered, otherwise ‘0’ is entered
At line 2,295 changed one line
!Record Name: Code RO – Employee Wage Record
!Record Name: Code RO – Employee Wage Record
At line 2,303 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-ALLOC-TIP’
- Derived from IDFDV screen, Field Identifier: ‘W2-ALLOC-TIP’
At line 2,307 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-A’ + Field Identifier: ‘W2-CODE-B’
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-A’ + Field Identifier: ‘W2-CODE-B’
At line 2,310 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-R’
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-R’
At line 2,313 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-S’
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-S’
At line 2,316 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-T’
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-T’
At line 2,319 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-M’
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-M’
At line 2,322 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-N’
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-N’
At line 2,325 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-EE’ (seq 4260)
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-EE’ (seq 4260)
At line 2,332 changed one line
266-274 - Spouse’s SSN
266-274 - Spouse’s SSN
At line 2,360 changed one line
363-373 - Total wages, tips and other compensation subject to Virgin Islands, … income tax
363-373 - Total wages, tips and other compensation subject to Virgin Islands, … income tax
At line 2,363 changed one line
374-384 - Virgin Islands, … etc Income Tax Withheld
374-384 - Virgin Islands, … etc Income Tax Withheld
At line 2,369 changed one line
!Record Name: Code RS – Supplemental Record
!Record Name: Code RS – Supplemental Record
At line 2,382 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-SSN’
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-SSN’
At line 2,386 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-FIRST-NAME’
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-FIRST-NAME’
At line 2,389 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-MIDDLE’
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-MIDDLE’
At line 2,392 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-LAST-NAME’
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-LAST-NAME’
At line 2,395 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-SUFFIX’
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-SUFFIX’
At line 2,398 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-LOCN-ADDR’
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-LOCN-ADDR’
At line 2,401 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-DELIV-ADDR’
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-DELIV-ADDR’
At line 2,404 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-CITY’
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-CITY’
At line 2,407 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-STATE’
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-STATE’
At line 2,410 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-ZIP’
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-ZIP’
At line 2,413 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-ZIP-EXT’
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-ZIP-EXT’
At line 2,418 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-F-STATE’
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-F-STATE’
At line 2,421 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-F-POSTAL’
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-F-POSTAL’
At line 2,424 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-COUNTRY’
- Derived from IDFDV screen, Field Identifier: ‘W2-EE-COUNTRY’
At line 2,429 changed one line
If the user specified ‘Period Type’ = ‘Quarter’, then Location 195 to 267 will be filled.
If the user specified ‘Period Type’ = ‘Quarter’, then Location 195 to 267 will be filled.
At line 2,439 changed one line
- e.g. Period End Date = ‘31-Dec-2007’, then reporting period is ‘122007’
- e.g. Period End Date = ‘31-Dec-2007’, then reporting period is ‘122007’
At line 2,442 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’
- Derived from IDFDV screen, Field Identifier: ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’
At line 2,444 changed one line
- 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
- 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
At line 2,452 changed 2 lines
- 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
- 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
At line 2,464 changed 2 lines
- Derived from IDFDV screen, 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
- Derived from IDFDV screen, 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
At line 2,471 changed one line
If the user specified ‘Period Type’ = ‘Quarter’ or ‘Year’, then Location 274 to 337 will be filled.
If the user specified ‘Period Type’ = ‘Quarter’ or ‘Year’, then Location 274 to 337 will be filled.
At line 2,478 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’
- Derived from IDFDV screen, Field Identifier: ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’
At line 2,481 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-ST-TAX-HOME’ and ‘W2-ST-TAX-WORK’
- Derived from IDFDV screen, Field Identifier: ‘W2-ST-TAX-HOME’ and ‘W2-ST-TAX-WORK’
At line 2,487 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-SUI-TAX-ER’
- Derived from IDFDV screen, Field Identifier: ‘W2-SUI-TAX-ER’
At line 2,490 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-SDI-TAX-EE’
- Derived from IDFDV screen, Field Identifier: ‘W2-SDI-TAX-EE’
At line 2,496 changed 4 lines
C – City Income Tax
D – County Income Tax
E – School District Income Tax
F – Other Income Tax
C – City Income Tax
D – County Income Tax
E – School District Income Tax
F – Other Income Tax
At line 2,513 changed one line
- if School Tax is reported, this field is derived from Identifier ‘W2-SCHL-WAGE’
- if School Tax is reported, this field is derived from Identifier ‘W2-SCHL-WAGE’
At line 2,515 changed one line
‘W2-CN-WAGE-HOME’ and ‘W2-CN-WAGE-WORK’
‘W2-CN-WAGE-HOME’ and ‘W2-CN-WAGE-WORK’
At line 2,517 changed one line
‘W2-CI-WAGE-HOME’ and ‘W2-CI-WAGE-WORK’
‘W2-CI-WAGE-HOME’ and ‘W2-CI-WAGE-WORK’
At line 2,520 changed one line
- if School Tax is reported, this field is derived from Identifier ‘W2-SCHL-TAX’
- if School Tax is reported, this field is derived from Identifier ‘W2-SCHL-TAX’
At line 2,522 changed one line
‘W2-CN-TAX-HOME’ and ‘W2-CN-TAX-WORK’
‘W2-CN-TAX-HOME’ and ‘W2-CN-TAX-WORK’
At line 2,524 changed one line
‘W2-CI-TAX-HOME’ and ‘W2-CI-TAX-WORK’
‘W2-CI-TAX-HOME’ and ‘W2-CI-TAX-WORK’
At line 2,540 changed one line
!Record Name: Code RT – Total Record
!Record Name: Code RT – Total Record
At line 2,549 changed one line
- Derived from IDFDV screen, Identifier: ‘W2-FIT-WAGE’, total of all code "RW" records since last "RE" record
- Derived from IDFDV screen, Identifier: ‘W2-FIT-WAGE’, total of all code "RW" records since last "RE" record
At line 2,552 changed one line
- Derived from IDFDV screen, Identifier: ‘W2-FIT-TAX’, total of all code "RW" records since last "RE" record
- Derived from IDFDV screen, Identifier: ‘W2-FIT-TAX’, total of all code "RW" records since last "RE" record
At line 2,555 changed one line
- Derived from IDFDV screen, Identifier: ‘W2-SSN-WAGE’, total of all code "RW" records since last "RE" record
- Derived from IDFDV screen, Identifier: ‘W2-SSN-WAGE’, total of all code "RW" records since last "RE" record
At line 2,558 changed one line
- Derived from IDFDV screen, Identifier: ‘W2-SSN-TAX’, total of all code "RW" records since last "RE" record
- Derived from IDFDV screen, Identifier: ‘W2-SSN-TAX’, total of all code "RW" records since last "RE" record
At line 2,561 changed one line
- Derived from IDFDV screen, Identifier: ‘W2-MEDI-WAGE’, total of all code "RW" records since last "RE" record
- Derived from IDFDV screen, Identifier: ‘W2-MEDI-WAGE’, total of all code "RW" records since last "RE" record
At line 2,564 changed one line
- Derived from IDFDV screen, Identifier: ‘W2-MEDI-TAX’, total of all code "RW" records since last "RE" record
- Derived from IDFDV screen, Identifier: ‘W2-MEDI-TAX’, total of all code "RW" records since last "RE" record
At line 2,567 changed one line
- Derived from IDFDV screen, Identifier: ‘W2-SSN-TIP’, total of all code "RW" records since last "RE" record
- Derived from IDFDV screen, Identifier: ‘W2-SSN-TIP’, total of all code "RW" records since last "RE" record
At line 2,570 changed one line
- Derived from IDFDV screen, Identifier: ‘W2-EIC’, total of all code "RW" records since last "RE" record
- Derived from IDFDV screen, Identifier: ‘W2-EIC’, total of all code "RW" records since last "RE" record
At line 2,573 changed one line
- Derived from IDFDV screen, Identifier: ‘W2-DEP-CARE’, total of all code "RW" records since last "RE" record
- Derived from IDFDV screen, Identifier: ‘W2-DEP-CARE’, total of all code "RW" records since last "RE" record
At line 2,576 changed one line
- Derived from IDFDV screen, Field Identifier ‘W2-CODE-D’, total of all code "RW" records since last "RE" record
- Derived from IDFDV screen, Field Identifier ‘W2-CODE-D’, total of all code "RW" records since last "RE" record
At line 2,579 changed one line
- Derived from IDFDV screen, Field Identifier ‘W2-CODE-E’, total of all code "RW" records since last "RE" record
- Derived from IDFDV screen, Field Identifier ‘W2-CODE-E’, total of all code "RW" records since last "RE" record
At line 2,582 changed one line
- Derived from IDFDV screen, Field Identifier ‘W2-CODE-F’, total of all code "RW" records since last "RE" record
- Derived from IDFDV screen, Field Identifier ‘W2-CODE-F’, total of all code "RW" records since last "RE" record
At line 2,585 changed one line
- Derived from IDFDV screen, Field Identifier ‘W2-CODE-G’, total of all code "RW" records since last "RE" record
- Derived from IDFDV screen, Field Identifier ‘W2-CODE-G’, total of all code "RW" records since last "RE" record
At line 2,588 changed one line
- Derived from IDFDV screen, Field Identifier ‘W2-CODE-H’, total of all code "RW" records since last "RE" record
- Derived from IDFDV screen, Field Identifier ‘W2-CODE-H’, total of all code "RW" records since last "RE" record
At line 2,591 changed one line
- Derived from IDFDV screen, Field Identifier ‘W2-CODE-Q’, total of all code "RW" records since last "RE" record
- Derived from IDFDV screen, Field Identifier ‘W2-CODE-Q’, total of all code "RW" records since last "RE" record
At line 2,595 changed one line
- Derived from IDFDV Identifier ‘W2-NQUAL-457’, total of all code "RW" records since last "RE" record
- Derived from IDFDV Identifier ‘W2-NQUAL-457’, total of all code "RW" records since last "RE" record
At line 2,598 changed one line
- Derived from IDFDV screen, Field Identifier ‘W2-CODE-W’, total of all code "RW" records since last "RE" record
- Derived from IDFDV screen, Field Identifier ‘W2-CODE-W’, total of all code "RW" records since last "RE" record
At line 2,601 changed one line
- Derived from IDFDV Identifier ‘W2-NQUAL-N457’, total of all code "RW" records since last "RE" record
- Derived from IDFDV Identifier ‘W2-NQUAL-N457’, total of all code "RW" records since last "RE" record
At line 2,605 changed one line
- Derived from IDFDV screen, Field Identifier ‘W2-CODE-DD’, total of all code "RW" records since last "RE" record
- Derived from IDFDV screen, Field Identifier ‘W2-CODE-DD’, total of all code "RW" records since last "RE" record
At line 2,608 changed one line
- Derived from IDFDV screen, Field Identifier ‘W2-CODE-C’, total of all code "RW" records since last "RE" record
- Derived from IDFDV screen, Field Identifier ‘W2-CODE-C’, total of all code "RW" records since last "RE" record
At line 2,611 changed one line
- Derived from IDFDV Identifier ‘SUB-3RD-PARTY-TAX’, total of all code "RW" records since last "RE" record
- Derived from IDFDV Identifier ‘SUB-3RD-PARTY-TAX’, total of all code "RW" records since last "RE" record
At line 2,614 changed one line
- Derived from IDFDV screen, Field Identifier ‘W2-CODE-V’, total of all code "RW" records since last "RE" record
- Derived from IDFDV screen, Field Identifier ‘W2-CODE-V’, total of all code "RW" records since last "RE" record
At line 2,617 changed one line
- Derived from IDFDV screen, Field Identifier ‘W2-CODE-Y’, total of all code "RW" records since last "RE" record
- Derived from IDFDV screen, Field Identifier ‘W2-CODE-Y’, total of all code "RW" records since last "RE" record
At line 2,620 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-AA’, total of all code "RW" records since last "RE" record
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-AA’, total of all code "RW" records since last "RE" record
At line 2,623 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-BB’, total of all code "RW" records since last "RE" record
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-BB’, total of all code "RW" records since last "RE" record
At line 2,628 changed one line
!Record Name: Code RU – Total Record
!Record Name: Code RU – Total Record
At line 2,638 changed one line
- Derived from IDFDV screen, Identifier: ‘W2-ALLOC-TIP’, total of all code "RO" records since last "RE" record
- Derived from IDFDV screen, Identifier: ‘W2-ALLOC-TIP’, total of all code "RO" records since last "RE" record
At line 2,641 changed one line
- Derived from IDFDV ‘W2-CODE-A’ and ‘W2-CODE-B’, total of all code "RO" records since last "RE" record
- Derived from IDFDV ‘W2-CODE-A’ and ‘W2-CODE-B’, total of all code "RO" records since last "RE" record
At line 2,644 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-R’, total of all code "RO" records since last "RE" record
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-R’, total of all code "RO" records since last "RE" record
At line 2,647 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-S’, total of all code "RO" records since last "RE" record
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-S’, total of all code "RO" records since last "RE" record
At line 2,650 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-T’, total of all code "RO" records since last "RE" record
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-T’, total of all code "RO" records since last "RE" record
At line 2,653 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-M’, total of all code "RO" records since last "RE" record
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-M’, total of all code "RO" records since last "RE" record
At line 2,656 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-N’, total of all code "RO" records since last "RE" record
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-N’, total of all code "RO" records since last "RE" record
At line 2,659 changed one line
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-EE’, total of all code "RO" records since last "RE" record
- Derived from IDFDV screen, Field Identifier: ‘W2-CODE-EE’, total of all code "RO" records since last "RE" record
At line 2,683 changed one line
460-474 - Total wages, tips and other compensation subject to Virgin Islands, … income tax
460-474 - Total wages, tips and other compensation subject to Virgin Islands, … income tax
At line 2,686 changed one line
475-489 - Virgin Islands, … etc Income Tax Withheld
475-489 - Virgin Islands, … etc Income Tax Withheld
At line 2,691 changed one line
!Record Name: Code RV – State Total Record
!Record Name: Code RV – State Total Record
At line 2,703 changed one line
!Record Name: Code RF – Final Record
!Record Name: Code RF – Final Record
This page (revision-155) was last changed on 19-Oct-2022 21:04 by Karen ParrottTop