This page (revision-96) was last changed on 26-Nov-2021 10:22 by Meg McFarland

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
96 26-Nov-2021 10:22 66 KB Meg McFarland to previous
95 26-Nov-2021 10:22 66 KB Meg McFarland to previous | to last
94 26-Nov-2021 10:22 66 KB Meg McFarland to previous | to last
93 26-Nov-2021 10:22 65 KB mmcfarland to previous | to last
92 26-Nov-2021 10:22 81 KB mmcfarland to previous | to last
91 26-Nov-2021 10:22 102 KB mmcfarland to previous | to last
90 26-Nov-2021 10:22 102 KB mmcfarland to previous | to last
89 26-Nov-2021 10:22 102 KB mmcfarland to previous | to last
88 26-Nov-2021 10:22 102 KB mmcfarland to previous | to last
87 26-Nov-2021 10:22 105 KB mmcfarland to previous | to last
86 26-Nov-2021 10:22 105 KB mmcfarland to previous | to last
85 26-Nov-2021 10:22 105 KB eyeung to previous | to last
84 26-Nov-2021 10:22 105 KB eyeung to previous | to last
83 26-Nov-2021 10:22 102 KB eyeung to previous | to last
82 26-Nov-2021 10:22 100 KB eyeung to previous | to last
81 26-Nov-2021 10:22 100 KB eyeung to previous | to last

Page References

Incoming links Outgoing links
Tax Reporting - US General
Tax Reporting - US General

Version management

Difference between version and

At line 4 changed one line
W2 Annual and Quarterly Processing reports from the employees' QTD information according to the user defined selection criteria to produce Quarterly Wage Reports for individual State filing. Most states accept either the EFW2 or the [ICESA] wage reporting format.
W2 Annual and Quarterly Processing reports from the employees' QTD information according to the user defined selection criteria to produce Quarterly Wage Reports for individual State filing. Most States accept either the EFW2 or the [ICESA] wage reporting format.
At line 6 changed one line
For additional information and detailed field descriptions of the [RPYEU] process, please refer to [W2 Year End procedure document|W2 Process].
For additional information and detailed field descriptions of the [RPYEU] process, please refer to the [W2 Process] document.
At line 9 changed one line
The following steps outline the sequence of events to produce the Quarterly Wage Report File: \\ \\
The following steps outline the sequence of events to produce the Quarterly Wage Report File. \\ \\
At line 15 changed one line
*Do NOT alter this information in any way without the guidance and permission of High Line Support or a Cconsultant. \\ \\
*Do NOT alter this information in any way without the permission and guidance of High Line Support or a Consultant. \\ \\
At line 18 changed 3 lines
*Organizations must enter the [IDFDV] variables for the supplied script file ‘HL$US-W2-YYYY’ (YYYY denotes the tax year and IS updated each year) must be entered, where applicable.
*In addition, for organizations who report quarterly wages in the [ICESA]/NASWA format, the [IDFDV] variables for the second quarterly supplied script file ‘HL$US-QTR-20YY’
*Note the name of this file remains the same for year 2004 onwards, is also required to be entered, where applicable. \\ \\
*Organizations must enter the [IDFDV] variables for the supplied script file ‘HL$US-W2-YYYY’ (YYYY denotes the tax year and is updated each year), where applicable.
*In addition, for organizations who report quarterly wages in the [ICESA] format, the [IDFDV] variables for the second quarterly supplied script file ‘HL$US-QTR-2014’ . Note: The name of this file remains the same for year 2004 onwards, is also required to be entered, where applicable. \\ \\
At line 30 changed 2 lines
*Each state may have its own requirements. Users must check with High Line to confirm if the State is supported, prior to running [RPYEU] for a specific State file
*Generate the XML file to feed into the RPW2 program to print W2 forms for year end reporting
*Each State may have its own requirements. Users must check with High Line to confirm if the State is supported, prior to running [RPYEU] for a specific State file
*Generate the XML file to feed into the RPW2XX programs to print W2 forms for year end reporting
At line 69 added 2 lines
\\
Some States require the SUI ER Number by department. In this case, the [IDDP] User Field ‘SUI ER Number’ may be required.
At line 71 removed 2 lines
Some states require the SUI ER Number by department. In this case, the [IDDP] User Field ‘SUI ER Number’ may be required.
At line 77 changed one line
*Note that on [IDDP], users must click on the detail section of the form first, then click the UDF button to get to the UDF screen.
*Note: On [IDDP], users must click on the detail section of the form first, then click the UDF button to get to the UDF screen.
At line 98 changed one line
\\ \\
\\
At line 101 changed one line
If your organization has one Federal registration, users must define one Government Registration Set, such as a Main Registration Set. \\ \\
If your organization has one Federal registration, users must define one Government Registration Set, such as a Main Registration Set. \\
At line 106 changed 3 lines
%%information __NOTE:__ If Registration Type US Fed Regist 1 is used, then:\\*The FICA registration should be defined using the Registration Type US FICA Regist 1\\*The MEDICARE registration should be defined using Registration Type US MEDI Regist 1, etc. The last digit of the Registration Type must match each type of registration. \\ \\For each Group, at the Federal level, the Federal Registration number is retrieved according to the Fed Regist Set and Fed Regist Type from the IDGV form and is displayed on the IDGR form.%%
__NOTE:__ If Registration Type US Fed Regist 1 is used, then:\\*The FICA registration should be defined using the Registration Type US FICA Regist 1\\*The MEDICARE registration should be defined using Registration Type US MEDI Regist 1, etc. The last digit of the Registration Type must match each type of registration. \\ \\For each Group, at the Federal level, the Federal Registration number is retrieved according to the Fed Regist Set and Fed Regist Type from the IDGV form and is displayed on the IDGR form.
At line 117 changed one line
%%information Note: If the Registration Type ‘US Fed Regist 1’ is used, then the FICA registration should be defined using Registration Type = ‘US FICA Regist 1’. \\If ‘US Fed Regist 2’ is used, then use ‘US FICA Regist 2’. \\If ‘US Fed Regist 3’ is used, then use ‘US FICA Regist 3’, etc.\\ \\Example: At the Federal level, always match the last digit of the registration type. This is similar to ‘Regist Type’ at State/Local Registration levels.%%
NOTE: If the Registration Type ‘US Fed Regist 1’ is used, then the FICA registration should be defined using Registration Type = ‘US FICA Regist 1’. \\If ‘US Fed Regist 2’ is used, then use ‘US FICA Regist 2’. \\If ‘US Fed Regist 3’ is used, then use ‘US FICA Regist 3’, etc.\\ \\Example: At the Federal level, always match the last digit of the registration type. This is similar to ‘Regist Type’ at State/Local Registration levels.
At line 160 changed 2 lines
%%warning IMPORTANT: Federal/State/Local Registration MUST not be changed for a Group for different effective date records.\\
The [UPCLOZ] process will __not__ cut new YTD records if the group changes effective date. Therefore, if a group requires a change to the registration numbers, either a new group should be created or all the effective records should be changed to the same registration number.%%
%%warning IMPORTANT: Federal/State/Local Registration MUST not be changed for a Group for different effective date records.%%\\
The [UPCLOZ] process will __not__ cut new YTD records if the group changes effective date. Therefore, if a group requires a change to the registration numbers, either a new group should be created or all the effective records should be changed to the same registration number.
At line 165 changed one line
For each group, at State/Prov level, a ‘State/Prov Set’ and ‘State/Prov Type’ can be pointed to. Since each group can be paid in many different states or provinces, the State/Prov Registration number cannot be displayed on [IDGR]. For each employee belonging to this group, the State/Prov Registration Number is retrieved from [IDGV] by ‘State/Prov Set’, ‘State/Prov Type’ and the 'State/Prov' of the employee.
For each group, at State/Prov level, a ‘State/Prov Set’ and ‘State/Prov Type’ can be pointed to. Since each group can be paid in many different States or Provinces, the State/Prov Registration number cannot be displayed on [IDGR]. For each employee belonging to this group, the State/Prov Registration Number is retrieved from [IDGV] by ‘State/Prov Set’, ‘State/Prov Type’ and the 'State/Prov' of the employee.
At line 174 changed 2 lines
*A State must be defined on IDGV for an Entity with the State Registration by Govt Regist Set and Registration Type in order for the State to be reported.
*If a state is missing on [IDGV], [RPYEU] will create a default entry for that State with the Registration Number set to '0' and issue a warning. The correct State Registration Number must be defined for that State in order to file to the State government.
*A State must be defined on [IDGV] for an Entity with the State Registration by Govt Regist Set and Registration Type in order for the State to be reported.
*If a State is missing on [IDGV], [RPYEU] will create a default entry for that State with the Registration Number set to '0' and issue a warning. The correct State Registration Number must be defined for that State in order to file to the State government.
At line 177 changed one line
*The RPYEU process automatically uses the UDF defined on the IDGV Variables tab for P2K_CM_GOVT_REGISTRATIONS.\\ \\
*The RPYEU process automatically uses the UDF defined on the [IDGV] Variables tab for P2K_CM_GOVT_REGISTRATIONS.\\ \\
At line 186 changed one line
*If County tax is applicable for a State, the County must be defined on the Define Counties (IDCN) form in order for the county tax to be reported.
*If County tax is applicable for a State, the County must be defined on the Define Counties (IDCN) form in order for the County tax to be reported.
At line 189 changed one line
*A County Tax Jurisdiction must be defined on the IDGV form with the Local Registration in order for the County tax to be reported.\\ \\
*A County Tax Jurisdiction must be defined on [IDGV] with the Local Registration in order for the County tax to be reported.\\ \\
At line 198 changed one line
The School Registration must be defined on the IDGV form in order for the School District tax to be reported.
The School Registration must be defined on [IDGV] in order for the School District tax to be reported.
At line 207 changed 3 lines
*Each State must be defined in order for the State tax to be reported. Note: The ‘State Level’ GEO code entry must end with ‘000-0000’, such as 05-000-000 for the state of California.
*A City’s Tax Jurisdiction must be defined on the IDTX form in order for the City tax to be reported.
*A County Tax Jurisdiction must be defined on the IDGV form with the Local Registration in order for the County tax to be reported.
*Each State must be defined in order for the State tax to be reported. Note: The ‘State Level’ GEO code entry must end with ‘000-0000’, such as 05-000-000 for the State of California.
*A City’s Tax Jurisdiction must be defined [IDTX] in order for the City tax to be reported.
*A County Tax Jurisdiction must be defined [IDGV] with the Local Registration in order for the County tax to be reported.
At line 222 changed one line
One or multiple Federal Government Registrations must exist for each entity with ‘Govt Regist Set’, ‘US Fed Regist 1’, etc.\\ \\
One or multiple Federal Government Registrations must exist for each entity with ‘Govt Regist Set’, ‘US Fed Regist 1’, etc.\\
At line 224 changed 2 lines
__State Level:__\\
A State must be defined on IDGV for an Entity with the State Registration by Govt Regist Set and Registration Type in order for the State to be reported.\\ \\
__State Level__\\
A State must be defined on IDGV for an Entity with the State Registration by Govt Regist Set and Registration Type in order for the State to be reported.\\
At line 227 changed one line
When the State Registration is defined, the Variables tab must also be set up. \\ \\
When the State Registration is defined, the Variables tab must also be set up. \\
At line 230 changed one line
*The RPYEU process automatically uses the UDF defined on the IDGV Variables tab for P2K_CM_GOVT_REGISTRATIONS. \\ \\
*The RPYEU process automatically uses the UDF defined on the IDGV Variables tab for P2K_CM_GOVT_REGISTRATIONS. \\
At line 232 changed one line
Many fields on the [IDGV Variables|IDGV#VariablesTab] tab apply to different States at the State level and/or Local level. These variables must be defined at the State/Local levels, whenever applicable. \\ \\
Many fields on the [IDGV Variables|IDGV#VariablesTab] tab apply to different States at the State level and/or Local level. These variables must be defined at the State/Local levels, whenever applicable. \\
At line 234 changed one line
On [IDGV Variables|IDGV#VariablesTab] tab, the ‘W2 State Media Filing’ variable must be defined if a State requires to produce a W2 File (or Quarterly File) for the State. \\ \\
On [IDGV Variables|IDGV#VariablesTab] tab, the ‘W2 State Media Filing’ variable must be defined if a State requires to produce a W2 File (or Quarterly File) for the State. \\
At line 239 changed one line
|01|Include State Code RS Records in the Federal File. Users can send the federal file to the State. \\ \\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, users should set the W2 State Media Filing variable to ‘01’. \\ \\When the RPYEU process is run, the State Code RS record will automatically be generated in the federal file. Users only need to send a copy of the federal file to the state.
|01|Include State Code RS Records in the Federal File. Users can send the federal file to the State. \\ \\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, users should set the W2 State Media Filing variable to ‘01’. \\ \\When the RPYEU process is run, the State Code RS record will automatically be generated in the federal file. Users only need to send a copy of the federal file to the State.
At line 243 changed 2 lines
__Local Level:__\\
A County Tax Jurisdiction must be defined on the IDGV form with the Local Registration in order for the County tax to be reported. \\ \\
__Local Level__\\
A County Tax Jurisdiction must be defined on [IDGV] with the Local Registration in order for the County tax to be reported. \\
At line 246 changed one line
A City Tax Jurisdiction must be defined on the IDGV form with the Local Registration in order for the City tax to be reported. \\ \\
A City Tax Jurisdiction must be defined on [IDGV] with the Local Registration in order for the City tax to be reported. \\
At line 248 changed one line
When users are defining the Local Registration, users should also set up the Variables tab. See the section on 'State Media for Local Filing' for more details. \\ \\
When users are defining the Local Registration, users should also set up the Variables tab. See the section on 'State Media for Local Filing' for more details. \\
At line 251 changed one line
On the IDGV form, Variables tab, the W2 State Media Filing variable can be defined (optional) to indicate if this Local requires to be filed with Magnetic Media on the W2 File.
On the IDGV form, Variables tab, the W2 State Media Filing variable can be defined (optional) to indicate if this Local requires to be filed with magnetic media on the W2 File.
At line 259 changed 3 lines
|01|Include Local Federal Code RS records in the Federal File format. \\ \\If the Local information is to be reported along with the Federal Code RS information, users should set the W2 State Media Filing variable to ‘01’ for this Local. \\ \\When RPYEU is run, the State Code RS records will be generated along with the Local information.
|02|Include Local State Code RS records in the State File format. \\ \\If the Local information is to be reported along with the State Code RS information, users should set the W2 State Media Filing variable to ‘02’ for this Local.\\ \\When RPYEU is run, the State Code RS records will be generated along with the Local information.
|03|Local requires its own File, do not include other Local information in the File. \\ \\If the Local requires its own format, users should set the W2 State Media Filing variable to ‘03’ for this Local. \\ \\When the RPYEU process is run and a user selects to generate Local File format, the users must also select the specific City or County and the Local file format will be generated. \\ \\__NOTE:__ This feature requires specific program logic for each Local. Please check with High Line to ensure the Local is supported.
|01|Include Local Federal Code RS records in the Federal File format. \\ If the Local information is to be reported along with the Federal Code RS information, users should set the W2 State Media Filing variable to ‘01’ for this Local. \\When RPYEU is run, the State Code RS records will be generated along with the Local information.
|02|Include Local State Code RS records in the State File format. \\ If the Local information is to be reported along with the State Code RS information, users should set the W2 State Media Filing variable to ‘02’ for this Local.\\ When RPYEU is run, the State Code RS records will be generated along with the Local information.
|03|Local requires its own File, do not include other Local information in the File. \\If the Local requires its own format, users should set the W2 State Media Filing variable to ‘03’ for this Local. \\ When the RPYEU process is run and a user selects to generate the Local File format, users must also select the specific City or County and the Local file format will be generated. \\ __NOTE:__ This feature requires specific program logic for each Local. Please check with High Line to ensure the Local is supported.
At line 274 changed 2 lines
__School Level:__\\
The School Registration must be defined on the IDGV form for the School in order for the school tax to be reported. \\ \\
__School Level__\\
The School Registration must be defined on [IDGV] for the School in order for the school tax to be reported. \\
At line 286 changed 3 lines
|01|Include School Code RS records in the Federal File format. \\ \\If the School information is to be reported along with the Federal Code RS information, users should set the W2 State Media Filing variable to ‘01’ for this Local.\\ \\When RPYEU is run, the State Code RS records will be generated along with the School information.
|02|Include School Code RS record in the State File format. \\ \\If the School information is to be reported along with the State Code RS information, users should set the W2 State Media Filing variable to ‘02’ for this Local.\\ \\Then when RPYEU is run, the State Code RS records will be generated along with the School information.
|03|School requires its own File, do not include other Local information in the File.\\ \\If the School requires its own format, users should set the W2 State Media Filing variable to ‘03’ for this Local. \\ \\NOTE: This feature requires specific program logic for each Local. Please check with High Line to ensure the Local is supported.
|01|Include School Code RS records in the Federal File format. \\If the School information is to be reported along with the Federal Code RS information, users should set the W2 State Media Filing variable to ‘01’ for this Local.\\When RPYEU is run, the State Code RS records will be generated along with the School information.
|02|Include School Code RS record in the State File format. \\ If the School information is to be reported along with the State Code RS information, users should set the W2 State Media Filing variable to ‘02’ for this Local.\\Then when RPYEU is run, the State Code RS records will be generated along with the School information.
|03|School requires its own File, do not include other Local information in the File.\\ If the School requires its own format, users should set the W2 State Media Filing variable to ‘03’ for this Local. \\ NOTE: This feature requires specific program logic for each Local. Please check with High Line to ensure the Local is supported.
At line 306 changed one line
Example: If the QTR Penalty is $590.26; then enter ‘590.26’ in the 'QTR Penalty' field on the [IDGV Variables|IDGV#VariablesTab] tab.
Example: If the QTR Penalty is $590.26; then enter ‘590.26’ in the 'QTR Penalty' field on the [IDGV Variables|IDGV#VariablesTab] tab. \\
At line 308 changed one line
%%information Please note each QTR field’s decimal point and enter in the above format. Also note that each applicable ‘Govt Rate Type’ in the bottom part of the form must also be setup, including the SUI maximum base amount, SUI ER rate, etc..%%
%%information Please note each QTR field’s decimal point and enter in the above format. Also note that each applicable ‘Govt Rate Type’ in the bottom part of the form must also be setup, including the SUI maximum base amount, SUI ER rate, etc.%% \\
At line 325 changed one line
To report the Ohio City tax, [IDGV] The [IDGV Variables|IDGV#VariablesTab] tab must be set up for ‘US Local Registration 1’ for each city, in the Jurisdiction field:
To report the Ohio City tax, the [IDGV] [IDGV Variables|IDGV#VariablesTab] tab must be set up for ‘US Local Registration 1’ for each city, in the Jurisdiction field:
At line 328 changed one line
|W2 STATE MEDIA FILING|Must be set to ‘03’ to generate City tax information in the ocal File format
|W2 STATE MEDIA FILING|Must be set to ‘03’ to generate City tax information in the Local File format
At line 381 changed 2 lines
;IDFD FORM:HL$US-W2-YYYY: Supplied, where ‘YYYY’ denotes the tax reporting year
;IDFD FORM TYPE:US EFW2 definition: Defines the W2 definition is for the EFW2 filing format
|IDFD FORM|HL$US-W2-YYYY|System supplied. ‘YYYY’ denotes the tax reporting year
|IDFD FORM TYPE|US EFW2 definition|Defines the W2 definition for EFW2 filing format
\\
At line 384 changed 3 lines
__NOTE: Fields marked with an asterisk (*) are mandatory.__\\
IDFD FORM: HL$US-W2-2016 - system supplied\\
IDFD FORM TYPE: US W2 EFW2 - defines the W2 definition for EFW2 filing format\\
[{InsertPage page='IDFDV_Form_Definitions'}]
At line 388 changed 180 lines
;Form Code ‘HL$US-W2-2016’ Identifiers:
||Field Identifier||Description||Suggested Field Source||Suggested Variable
|* SUB-ER-EIN|Submitter’s Employer EIN|Constant|9 character EIN
|* SUB-USER-ID|Submitter User Identification|Constant|8 character User ID assigned to the employee who is attesting to the accuracy of the file
|SUB-RESUB-IND|Resubmitt Indicator|Constant|Enter 1 if file is resubmitted, otherwise 0
|SUB-RESUB-WFID|Resubmitt SSA WFID from notice|Constant|If resubmitted, enter SSA WFID from notice
|SUB-VENDOR|Software Vendor Code|Constant|Enter your company data
|SUB-SOFTWARE|Submitter Software Code|Constant|Enter your company data
|SUB-COMP-NAME|Company Name receive EFW2|Constant|Enter Company name who receives EFW2
|SUB-COMP-LOCN|Company Location Address|Constant|Enter company’s location address\\ such as Attention, Suite, Room # etc
|SUB-COMP-DELIV|Company Delivery Address|Constant|Enter company’s delivery address\\such as 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 extension
|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-SUBM-NAME|Submitter Organization Name|Constant|Organization Name to receive unprocessed data
|* SUB-SUBM-LOCN|Submitter Location Address|Constant|Enter submitter location address\\ such as Attention, Suite, Room # etc
|* SUB-SUBM-DELIV|Submitter Delivery Address|Constant|Enter submitter delivery address\\such as Street or Post Office Box
|* SUB-SUBM-CITY|Submitter City|Constant|Enter submitter city
|* SUB-SUBM-STATE|Submitter State Abbrev|Constant|Enter submitter State Abbreviation
|* SUB-SUBM-ZIP|Submitter ZIP Code|Constant|Enter submitter ZIP code
|SUB-SUBM-ZIP-EXT|Submitter ZIP Code Extension|Constant|Enter submitter ZIP code extension
|SUB-SUBM-F-STATE|Submitter foreign State/province|Constant|Enter submitter foreign State/Province
|SUB-SUBM-F-POST|Submitter foreign postal code|Constant|Enter submitter foreign postal code
|SUB-SUBM-COUNTRY|Submitter country if applicable|Constant|Enter submitter Country, if applicable
|* SUB-CONT-NAME|Contact name for SSA|Constant|Enter your company data
|* SUB-CONT-TEL|Contact telephone # for SSA|Constant|Enter your company data
|SUB-CONT-TEL-EXT|Contact telephone extension|Constant|Enter your company data
|* SUB-CONT-EMAIL|Contact e-mail address for SSA|Constant|Enter your company data
|SUB-CONT-FAX|Contact FAX phone # for SSA|Constant|Enter your company data
|SUB-CONT-METH|Preferred Contact method|Constant|MUST be BLANK
|SUB-PREPARER|Preparer Code|Constant|Enter your company data
|SUB-3RD-PARTY-SICK|Third-Party Sick Pay Indicator|Constant|Enter your company data
|SUB-3RD-PARTY-TAX|Income Tax Withheld by 3rd Party|Constant|Enter your company data
|W2-ER-AGENT-IND|Agent Indicator Code|Constant|Enter appropriate code, if applicable
|W2-ER-FOR-EIN|Agent for which EIN|Constant|If you are an agent, enter the EIN for which you are an agent for
|W2-ER-TERM-BUS|Terminating business indicator|Constant|Enter appropriate code from SSA
|W2-ER-ESTAB|Establishment Number|Constant|Further identify within EIN
|W2-ER-OTHER-EIN|Other EIN|Constant|Other EIN used
|* W2-ER-EIN|Employer Identification Number|Data Base Column|DGV.GOVT_REGIST_NUMBER
|* W2-ER-NAME|Employer Name|Data Base Column|DED.ENTITY_NAME
|W2-ER-LOCN-ADDR|Employer Location Address|Constant|Employer’s location address\\such as 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\\such as 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-F-STATE|Employer foreign State/province|Constant|Employer foreign state/province or Constant\\Enter the word NAME or blank
|W2-ER-F-POSTAL|Employer foreign postal code|Constant|Enter Employer foreign postal code or Constant
|W2-ER-COUNTRY|Employer country if applicable|Constant|Enter Employer country\\Enter blank, system derived
|W2-ER-F-COUNTRY|Employer foreign country|Constant|Enter the word NAME, ISO or blank
|W2-ER-TAX-JURIS|Tax Jurisdiction Code|Constant |Enter appropriate code or null
|W2-EE-SSN|Employee Social Security Number|Data Base Column|EID.GOVERNMENT_CODE
|W2-EE-FIRST-NAME|Employee First Name|Data Base Column|EID.FIRST_NAME
|W2-EE-MIDDLE|Employee Middle Name|Data Base Column|EID.MIDDLE_NAME
|W2-EE-LAST-NAME|Employee Last Name|Data Base Column|EID.LAST_NAME
|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\\such as 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\\such as 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 – 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(~,113700.00) may be used for year 2013 max\\ \\System verify Box 3 + Box 7 does not exceed annual max, otherwise issue message
|W2-SSN-TAX|Social Security Tax Withheld|Element|W2-BOX-04\\Derivation expression LEAST(~,7049.40)may be used for year 2013 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-CODE-A|Uncollect SSA/RRTA tax on tips|Pay Component|Enter your company data
|W2-CODE-B|Uncollect Medicare tax on tips|Pay Component|Enter your company data
|W2-CODE-C|Group Term Life Ins > 50000|Pay Component|Enter your company data
|W2-CODE-D|Deferred 401(k) cash|Pay Component|Enter your company data
|W2-CODE-E|Deferred 401(b) Salary reduction|Pay Component|Enter your company data
|W2-CODE-F|Deferred 408(k)(6) Salary reduct|Pay Component|Enter your company data
|W2-CODE-G|Deferred 457(b) compensation|Pay Component|Enter your company data
|W2-CODE-H|Deferred 501(c)18(D) tax exempt|Pay Component|Enter your company data
|W2-CODE-J|Non taxable sick pay|Pay Component|Enter your company data
|W2-CODE-K|20% excise parachute payment|Pay Component|Enter your company data
|W2-CODE-L|Employee business expense reimburse|Pay Component|Enter your company data
|W2-CODE-M|Uncollect SSA/RRTA group ins|Pay Component|Enter your company data
|W2-CODE-N|Uncollect medicare group ins|Pay Component|Enter your company data
|W2-CODE-P|Moving expense|Pay Component|Enter your company data
|W2-CODE-Q|Nontaxable combat pay|Pay Component|Enter your company data (obsoleted since Tax Year 2012)
|W2-CODE-R|Employer Contrib to MSA|Pay Component|Enter your company data
|W2-CODE-S|Salary reduction to 408(p)|Pay Component|Enter your company data
|W2-CODE-T|Adoption benefits|Pay Component|Enter your company data
|W2-CODE-V|Income of nonstat stock opt|Pay Component|Enter your company data
|W2-CODE-W|ER contrib Health Saving Account|Pay Component|Enter your company data
|W2-CODE-Y|Deferrals 409A Nonqual plan|Pay Component|Enter your company data
|W2-CODE-Z|Income 409A Nonqual plan|Pay Component|Enter your company data
|W2-CODE-AA|Roth contrib 401(k)|Pay Component|Enter your company data
|W2-CODE-BB|Roth contrib 403(b)|Pay Component|Enter your company data
|W2-CODE-CC|HIRE exempt wages|Pay Component|Enter your company data
|W2-CODE-DD|ER sponsored Health Coverage|Pay Component|Enter your company data
|W2-CODE-EE|Roth Contribution 457(b)|Pay Component|Enter your company data
The values from W2-OTHER-01 to W2-OTHER-20 are printed on W2 Form Box 14.
||Field Identifier||Description||Suggested Field Source||Suggested Variable
|W2-OTHER-01|Your company description|Pay Component|Enter your company data
|W2-OTHER-nn|Your company description|Pay Component|Enter your company data
|W2-OTHER-20|Your company description|Pay Component|Enter your company data
Please enter Box 14 Description in the Prompt field in format of 14-xxxxxxx.
The values from W2-USER-01 to W2-USER-20 are used by CLIENTS only, the values are not printed on the W2 form or file. These identifiers are used to obtain amounts to show on the RPYEU Summary report. Example: 125 plan, 401 plan, benefit amounts, or employer portion of certain employee contribution etc.
||Field Identifier||Description||Suggested Field Source||Suggested Variable
|W2-USER-01|Your company description|Pay Component|Enter your company data
|W2-USER-nn|Your company description|Pay Component|Enter your company data
|W2-USER-20|Your company description|Pay Component|Enter your company data
The values from W2-HL-01 to W2-HL-10 are used by High Line only. These identifiers are used to obtain amounts to show on RPYEU Summary report or for other purposes. These are reserved areas for High Line to define additional new variables that are not available or defined when the programming is done. If needed, High Line will give instructions for users to set these up.
||Field Identifier||Description||Suggested Field Source||Suggested Variable
|W2-HL-01|High Line defined description|Pay Component|Enter your company data
|W2-HL-nn|High Line defined description|Pay Component|Enter your company data
|W2-HL-10|High Line defined description|Pay Component|Enter your company data
|| || || ||
|W2-STAT-EE|Statutory employee|Statistics|Enter your company data
|W2-RETIRE-PLAN|Retirement plan employee|Statistics|Enter your company data
|W2-3PARTY-SICK|Third-party sick pay|Statistics|Enter your company data
|| || || ||
|W2-SCHL-WAGE|School Taxable Wages|Element|W2-SCHL-WAGE
|W2-SCHL-TAX|School Tax|Element |W2-SCHL-TAX
|| || || ||
|W2-STATE-CODE|State Code|Data Base Column|DSP.STATE_PROVINCE_CODE
|W2-STATE-REGIST|State Registration I.D. No|Data Base Column|DGV.GOVT_REGIST_NUMBER
|W2-STATE-WAGE-HOME|State Wages and Tips (Home State)|Element|W2-STATE-WAGE-H
|W2-STATE-WAGE-WORK|State Wages and Tips (Work State)|Element|W2-STATE-WAGE-W
|W2-STATE-TAX-HOME|State Income Tax (Home State)|Element|W2-STATE-TAX-H
|W2-STATE-TAX-WORK|State Income Tax (Work State)|Element|W2-STATE-TAX-W
|| || || ||
|W2-SUI-WAGE-EE|State SUI Wages (Employee)|Element|W2-SUI-WAGE-EE
|W2-SUI-WAGE-ER|State SUI Wages (Employer)|Element|W2-SUI-WAGE-ER
|W2-SUI-TAX-EE|State SUI Tax (Employee contribution)|Element|W2-SUI-TAX-EE
|W2-SUI-TAX-ER|State SUI Tax (Employer contribution)|Element|W2-SUI-TAX-ER
|W2-SDI-WAGE-EE|State SDI Wages (Employee)|Element|W2-SDI-WAGE-EE
|W2-SDI-WAGE-ER|State SDI Wages (Employer)|Element|W2-SDI-WAGE-ER
|W2-SDI-TAX-EE|State SDI Tax (Employee contribution)|Element|W2-SDI-TAX-EE
|W2-SDI-TAX-ER|State SDI Tax (Employer contribution)|Element|W2-SDI-TAX-ER
|W2-SUI-HRS-WRK|SUI Hours Worked|Element|W2-SUI-HRS-WORK
|W2-SUI-WK-WRK|SUI Weeks Worked (From User)|Element|W2-SUI-WK-WORK
|W2-SUI-WEEKS-WRK|SUI Weeks Worked (Derived)|Not specified|System Derived, no need to set up
|W2-SUI-TAXABLE-WAGES|SUI Taxable Wages|Not specified|System Derived, no need to set up
|W2-SUI-EXCESS-WAGES|SUI Excess Wages|Not specified|System Derived, no need to set up
|W2-SUI-MTH1-WORK|SUI Worked on 12th day of mth 1|Not specified|System Derived, no need to set up
|W2-SUI-MTH2-WORK|SUI Worked on 12th day of mth 2|Not specified|System Derived, no need to set up
|W2-SUI-MTH3-WORK|SUI Worked on 12th day of mth 3|Not specified|System Derived, no need to set up
|W2-TIP-WAGE-WORK|Work State Tips Wages |Element|Tips Wages for each State
|W2-ST-TIP-WORK|Work State Tips|Pay Component|Tips for each State
|W2-WC-WORK|Workers Compensation Contribution|Element|W2-WC-WORK
|| || || ||
|W2-CNTY-NAME|County Name|Data Base Column|DCN.COUNTY_NAME
|W2-CN-WAGE-HOME|County Wages (Home County)|Element|W2-CNTY-WAGE-H
|W2-CN-WAGE-WORK|County Wages (Work County)|Element|W2-CNTY-WAGE-W
|W2-CN-TAX-HOME|County Tax (Home County)|Element|W2-CNTY-TAX-H
|W2-CN-TAX-WORK|County Tax (Work County)|Element|W2-CNTY-TAX-W
|| || || ||
|W2-CITY-NAME|City Name |Data Base Column|DTX.JURISDICTION_NAME
|W2-CI-WAGE-HOME|City Wages (Home City)|Element|W2-CITY-WAGE-H
|W2-CI-WAGE-WORK|City Wages (Work City)|Element|W2-CITY-WAGE-W
|W2-CI-TAX-HOME|City Tax (Home City)|Element|W2-CITY-TAX-H
|W2-CI-TAX-WORK|City Tax (Work City)|Element|W2-CITY-TAX-W
\\
At line 569 changed one line
#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’ (This option is only available to clients who are running the W2 report in Oracle, it is not available to clients running W2 in the Windard platform).
#For California, if [IDFDV] Identifier Seq 7260 W2-SDI-TAX-EE is not zero, then Box 19 will print the employee's SDI contribution and Box 20 will print the description ‘CASDI’ (This option is only available to clients who are running the W2 report in Oracle, it is not available to clients running W2 in the Windard platform).
At line 588 changed one line
\\
At line 610 changed one line
\\
At line 616 changed one line
\\ \\
\\
At line 688 changed one line
Most states accept quarterly filing information via Magnetic Media using either the EFW2 or the [ICESA] format. The record codes that generally required for the EFW2 reporting are RA, RE, RS, RT, and RF, however, some record codes may be optional for some States. The record codes generally required for the [ICESA] reporting are A, B, E, S, T, and F. \\ \\
Most States accept quarterly filing information via magnetic media using either the EFW2 or the [ICESA] format. The record codes that are generally required for the EFW2 reporting are RA, RE, RS, RT, and RF, however, some record codes may be optional for some States. The record codes generally required for the [ICESA] reporting are A, B, E, S, T, and F. \\
At line 690 changed one line
When running [RPYEU] (the Year End Wage Report and File Formatter program), the EFW2 reporting format is automatically triggered when the values in both the ‘Annual Form Code’ column and the’ Quarterly Form Code’ column are identical (or the ‘Quarterly Form Code’ column is left blank). To create a State Reporting format other than the EFW2 format, the ‘Quarterly Form Code’ MUST be entered, and it MUST be different than that of the ‘Annual Form Code’. \\ \\
When running [RPYEU] (the Year End Wage Report and File Formatter program), the EFW2 reporting format is automatically triggered when the values in both the ‘Annual Form Code’ column and the’ Quarterly Form Code’ column are identical (or the ‘Quarterly Form Code’ column is left blank). To create a State Reporting format other than the EFW2 format, the ‘Quarterly Form Code’ MUST be entered, and it MUST be different than that of the ‘Annual Form Code’. \\
At line 692 changed one line
In addition to the EFW2/ICESA reporting formats, many States also accept other reporting formats. The reporting formats that are supported for each State are listed in Section II. Please note that the supported State information is informational only and is current at the time this document was prepared. It is subject to change without notice by each of the State governments. \\ \\
In addition to the EFW2/ICESA reporting formats, many States also accept other reporting formats. The reporting formats that are supported for each State are listed in Section II. Please note that the supported State information is informational only and is current at the time this document was prepared. It is subject to change without notice by each of the State governments. \\
At line 694 changed one line
In addition to the State Magnetic Media filing, employers may be required to manually fill in the State form to report additional information for SUI. \\ \\
In addition to the State magnetic media filing, employers may be required to manually fill in the State form to report additional information for SUI. \\
At line 696 changed one line
The ‘Total Wages Paid’, ‘Wages in Excess of SUI Wage Base’, ‘SUI Taxable Wages’ and/or also the 'Employee Count' information may be required to be filled in for employees who have been paid on the 12th day of each month of the quarter. When [RPYEU] is run for quarterly information, it produces a report at the ‘SUI Registration’ level that contains this information. The required information can then be manually entered on the Form to file for the State. \\ \\
The ‘Total Wages Paid’, ‘Wages in Excess of SUI Wage Base’, ‘SUI Taxable Wages’ and/or the 'Employee Count' information may be required to be filled in for employees who have been paid on the 12th day of each month of the quarter. When [RPYEU] is run for quarterly information, it produces a report at the ‘SUI Registration’ level that contains this information. The required information can then be manually entered on the Form to file for the State. \\
At line 699 changed one line
For quarterly reporting, depending on the State, some states accept the EFW2 format and other states accept [ICESA] format.
For quarterly reporting, depending on the State, some states accept the EFW2 format and other states accept [ICESA] format.\\
At line 705 changed one line
%%information Note: Do not enter HL$US-QTR-2012 in this code field, or the program will produce the quarterly wage report file in the [ICESA] format, regardless of the State selected.%%
%%information Note: Do not enter HL$US-QTR-YYYY in this code field, or the program will produce the quarterly wage report file in the [ICESA] format, regardless of the State selected.%%
At line 709 changed one line
*Enter the Quarterly Form Code: HL$US-QTR-2012
*Enter the Quarterly Form Code: HL$US-QTR-YYYY
At line 711 changed one line
%%information Note: Leaving this code field blank will trigger the program to generate the quarterly wage report file in the EFW2 format, regardless of the State selected).%%
%%information Note: Leaving this code field blank will trigger the program to generate the quarterly wage report file in the EFW2 format, regardless of the State selected.%% \\
At line 721 changed one line
|As of Date:|This date is used to retrieve employee information such as name, address, etc.
|As of Date:|Defines the start date of the reporting period
At line 723 changed one line
|Provide Sort Level Totals:|Optional. when set to YES, the total is generated by ‘DEPT SUI ER Number’
|Provide Sort Level Totals:|Optional. When set to YES, the totals are generated by ‘DEPT SUI ER Number’
At line 727 changed one line
Please enter other prompts accordingly.
Please enter other prompts accordingly. \\
At line 735 changed 2 lines
|Media Format:|Local File Format
|Select State:|Ohio, USA
|Media Format: Local File Format
|Select State: Ohio, USA
At line 739 changed one line
%%warning The information contained in this section is for information only, is current at the time this document is prepared and is subject to change without notice, by each State. For the latest State UI wage report information, please contact the Unemployment Insurance department of each respective state.%%
%%warning The information contained in this section is for information only, is current at the time this document is prepared and is subject to change without notice, by each State. For the latest State UI wage report information, please contact the Unemployment Insurance department of each respective State.%% \\
At line 744 changed 2 lines
*To minimize inconsistencies for all States, the program will compare the State specific format to the Standard SSA supplied format. As long as all the State required columns are present, and in the same positions, in the same record type as defined in the Standard SSA format, then a record with the Standard SSA format will be created for that State. Other columns that are not required by the State may or may not be blank, or zero filled. Consequently, these columns may contain some left over data that is specified in the Standard SSA format but is not used by the State.
*For states where a file column is different than those of the Standard SSA format, those columns will be highlighted with the State abbreviated code for easy identification.
*To minimize inconsistencies for all States, the program will compare the State specific format to the Standard SSA supplied format. As long as all the State required columns are present, and in the same positions, in the same record type as defined in the Standard SSA format, then a record with the Standard SSA format will be created for that State.
*Other columns that are not required by the State may or may not be blank, or zero filled. Consequently, these columns may contain some data that is defined in the Standard SSA format but is not used by the State.
*For States where a file column is different than those of the Standard SSA format, those columns will be highlighted with the State abbreviated code for easy identification.
At line 747 changed 2 lines
*Refer to the [EFW2 Formatting|Tax Reporting - US General#StandardEFW2FormerlyMMREF1MagneticFormatForQuarterlyWageReporting] for a more detailed description of each record type and the values required for each column, for States that accept the EFW2 wage reporting format.
*Unless there are marked differences in the setup procedure required for running quarterly wage report for any particular states, refer to the [General Set Up Procedure|Tax Reporting - US General#GeneralSetUp] for further information.
*Refer to the [EFW2 Formatting|Tax Reporting - US General#StandardEFW2FormerlyMMREF1MagneticFormatForQuarterlyWageReporting] section for a more detailed description of each record type and the values required for each column, for States that accept the EFW2 wage reporting format.
*Unless there are marked differences in the setup procedure required for running quarterly wage report for any particular State, refer to the [General Set Up Procedure|Tax Reporting - US General#GeneralSetUp] for further information.
At line 568 added 39 lines
\\
!!State Media Magnetic Media Reporting - SSA EFW2 File Format
!Code RA - Submitter Record
[{InsertPage page='W2_EFW2_RECORD_RA'}]
\\ \\
!Code RE - Employer Record
[{InsertPage page='W2_EFW2_RECORD_RE}]
\\ \\
!Code RW - Employee Wage Record (Optional for State Quarterly Reporting)
[{InsertPage page='W2_EFW2_RECORD_RW}]
\\ \\
!Code RO - Employee Wage Record (Optional for State Quarterly Reporting)
[{InsertPage page='W2_EFW2_RECORD_RO}]
\\ \\
!Code RS - Supplemental Record (Use for State Wage Reporting)
[{InsertPage page='W2_EFW2_RECORD_RS}]
\\ \\
__Multiple Code RS records:__ \\Multiple code RS records are generated for an employee if there are applicable county, city or school district tax information to be reported for a State. In this case, the State wages and tax will be zero for the subsequent code RS records.
\\ \\
!Code RT - Total Record
[{InsertPage page='W2_EFW2_RECORD_RT}]
\\ \\
!Code RU - Total Record (Optional for State Quarterly Reporting)
[{InsertPage page='W2_EFW2_RECORD_RU}]
\\ \\
!Code RF - Final Record
[{InsertPage page='W2_EFW2_RECORD_RF}]
\\ \\
At line 754 changed 2 lines
|2-5|Payment Year. \\Defines the year this report is being prepared for.|From the user defined FROM-TO period, converted to YYYY
|6-14|Transmitter’s Federal EIN. \\Enter only numeric characters, omit hyphens, prefixes and suffixes.|Derived from [IDFDV] 'TRAN EIN’ Field Identifier.
|2-5|Payment Year|Defines the year this report is being prepared for. \\Derived from the user defined FROM-TO period, converted to YYYY
|6-14|Transmitter’s Federal EIN|Enter only numeric characters. Omit hyphens, prefixes and suffixes. \\Derived from [IDFDV] 'TRAN EIN’ Field Identifier.
At line 757 changed 21 lines
|19-23|Blank|
|24-73|Transmitter Name. \\The transmitter name of the organization submitting the file.|Derived from [IDFDV] ‘TRAN NAME’ Field Identifier.
|74-113|Transmitter Street Address. \\The street address of the organization submitting the file.|Derived from [IDFDV] ‘TRAN ADDRESS’ Field Identifier.
|114-138|Transmitter City.\\The City of the organization submitting the file.|Derived from [IDFDV] ‘TRAN CITY’ Field Identifier.
|139-140|Transmitter State. \\The standard two character FIPS postal abbreviation|Derived from [IDFDV] ‘TRAN STATE’ Field Identifier.
|141-153|Blank|
|154-158|Transmitter ZIP Code. \\Enter a valid ZIP Code|Derived from [IDFDV] ‘TRAN ZIP CODE’ Field Identifier.
|159-163|Transmitter ZIP Code extension. \\Defines the four digit extension of ZIP code, if applicable. \\Includes a hyphen in position 159|Derived from [IDFDV] ‘TRAN ZIP EXTN’ Field Identifier (include ‘-‘ in position 159).
|164-193|Transmitter Contact. \\Title of individual from transmitter organization responsible for the accuracy of the wage report.|Derived from [IDFDV] ‘TRAN CONTACT’ Field Identifier.
|194-203|Transmitter Contact Telephone Number. \\Telephone number for the transmitter contact.|Derived from [IDFDV] ‘TRAN CONTACT PHONE’ Field Identifier.
|204-207|Telephone Extension/Box. \\The transmitter telephone extension or message box|Derived from [IDFDV] ‘TRAN CONTACT EXTN’ Field Identifier.
|208-213|Media Transmitter/Authorization Number. \\Identifier assigned to the entity transmitting the media.|Derived from [IDFDV] ‘TRAN MEDIA NUMBER’ Field Identifier.
|214-214|C-3 Data.|State Specific Data. If not used, enter blanks
|215-219|Suffix Code.|State Specific Data. If not used, enter blanks
|220-220|Allocation Lists.|State Specific Data. If not used, enter blanks
|221-229|Service Agent ID.|State Specific Data. If not used, enter blanks
|230-242|Total Remittance Amount.|State Specific Data. If not used, enter blanks
|243-250|Media Creation Date.\\Enter the date in the MMDDYYYY format|Derived from the System Date
|251-275|Blank|
|276-276|Blank. Used only for systems that cannot produce an odd number record length file.|
\\ \\
|19-23|Blank|Fill with blanks
|24-73|Transmitter Name|Enter the transmitter name of the organization submitting the file. \\Derived from [IDFDV] ‘TRAN NAME’ Field Identifier.
|74-113|Transmitter Street Address|Enter the street address of the organization submitting the file. \\Derived from [IDFDV] ‘TRAN ADDRESS’ Field Identifier.
|114-138|Transmitter City|Enter the City of the organization submitting the file. \\Derived from [IDFDV] ‘TRAN CITY’ Field Identifier.
|139-140|Transmitter State|Enter the standard two character FIPS postal abbreviation. \\Derived from [IDFDV] ‘TRAN STATE’ Field Identifier.
|141-153|Blank|Fill with blanks
|154-158|Transmitter ZIP Code|Enter a valid ZIP Code \\Derived from [IDFDV] ‘TRAN ZIP CODE’ Field Identifier.
|159-163|Transmitter ZIP Code extension|Enter the four digit extension of ZIP code, if applicable. \\Include a hyphen in position 159. \\Derived from [IDFDV] ‘TRAN ZIP EXTN’ Field Identifier
|164-193|Transmitter Contact|Enter the name of the individual from transmitter's organization responsible for the accuracy of the wage report. \\Derived from [IDFDV] ‘TRAN CONTACT’ Field Identifier.
|194-203|Transmitter Contact Telephone Number|Enter telephone number for the transmitter's contact. \\Derived from [IDFDV] ‘TRAN CONTACT PHONE’ Field Identifier.
|204-207|Telephone Extension|Enter the transmitter's contact telephone extension. \\Derived from [IDFDV] ‘TRAN CONTACT EXTN’ Field Identifier.
|208-213|Media Transmitter/Authorization Number|Enter the Identifier assigned to the entity transmitting the media. \\Derived from [IDFDV] ‘TRAN MEDIA NUMBER’ Field Identifier.
|214-214|C-3 Data|State Specific Data. If not used, fill with blanks
|215-219|Suffix Code|State Specific Data. If not used, fill with blanks
|220-220|Allocation Lists|State Specific Data. If not used, fill with blanks
|221-229|Service Agent ID|State Specific Data. If not used, fill with blanks
|230-242|Total Remittance Amount|State Specific Data. If not used, fill with blanks
|243-250|Media Creation Date|Enter the date in the MMDDYYYY format. \\Derived from the System Date
|251-275|Blank|Fill with blanks
|276-276|Blank|Used only for systems that cannot produce an odd number record length file.
\\
At line 782 changed 9 lines
|2-5|Payment Year. \\ Enter the year for which this report is being prepared|
|6-14|Transmitter’s Federal EIN. \\Enter only numeric characters|Derived from [IDFDV] 'BASIC EIN' Field Identifier.
|15-22|Computer. \\Enter the manufacturer’s name|Derived from [IDFDV] ‘BASIC COMPUTER’ Field Identifier.
|23-24|Internal Label. \\SL, NS, NL or AL|Derived from [IDFDV] ‘BASIC INTERNAL LABEL’ Field Identifier.
|25-25|Blank|
|26-27|Density. \\16, 62 or 38|Derived from [IDFDV] ‘BASIC DESITY’ Field Identifier.
|28-30|Recording Code (Character Set). \\EBC.|Derived from [IDFDV] ‘BASIC RECOEDING MODE’ Field Identifier.
|31-32|Number of Tracks. \\09 or 18|Derived from [IDFDV] ‘BASIC RECORDING MODE’ Field Identifier.
|33-34|Blocking Factor. \\Enter the blocking factor of the file, not to exceed 85.|Derived from [IDFDV] ‘BLOCKING FACTOR’ Field Identifier.
|2-5|Payment Year|Enter the year this report is being prepared for
|6-14|Transmitter’s Federal EIN|Enter only numeric characters. Omit hyphens, prefixes and suffixes. \\Derived from [IDFDV] 'BASIC EIN' Field Identifier.
|15-22|Computer|Enter the manufacturer’s name \\Derived from [IDFDV] ‘BASIC COMPUTER’ Field Identifier.
|23-24|Internal Label|Enter SL, NS, NL or AL \\Derived from [IDFDV] ‘BASIC INTERNAL LABEL’ Field Identifier.
|25-25|Blank|Fill with blanks
|26-27|Density|Enter 16, 62 or 38 \\Derived from [IDFDV] ‘BASIC DESITY’ Field Identifier.
|28-30|Recording Code (Character Set)|Enter EBC \\Derived from [IDFDV] ‘BASIC RECOEDING MODE’ Field Identifier.
|31-32|Number of Tracks|Enter 09 or 18 \\Derived from [IDFDV] ‘BASIC RECORDING MODE’ Field Identifier.
|33-34|Blocking Factor|Enter the blocking factor of the file. Not to exceed 85. \\Derived from [IDFDV] ‘BLOCKING FACTOR’ Field Identifier.
At line 792 changed 11 lines
|39-146|Blank|
|147-190|Organization Name. \\The name of the organization the media should be returned to|Derived from [IDFDV] ‘BASIC NAME’ Field Identifier.
|191-225|Street Address. \\The street address of the organization the media should be returned to|Derived from [IDFDV] ‘BASIC ADDRESS’ Field Identifier.
|226-245|City. \\The City of the organization the media should be returned to|Derived from [IDFDV] ‘BASIC CITY’ Field Identifier.
|246-247|State. \\Enter the standard two character FIPS postal abbreviation|Derived from [IDFDV] ‘BASIC STATE’ Field Identifier.
|248-252|Blank|
|253-257|ZIP Code. \\Enter a valid ZIP code|Derived from [IDFDV] ‘BASIC ZIP CODE’ Field Identifier.
|258-262|ZIP Code extension. \\Enter the four digit ZIP code extension, including the hyphen in position 258.\\The hyphen (‘-‘) must be included when defining the BASIC ZIP EXTN’ Field Identifier on IDFDV.|Derived from [IDFDV] ‘BASIC ZIP EXTN’ Field Identifier.
|263-275|Blank|
|276-276|Blank. \\Used only for systems that cannot produce an odd number record length file.|
\\ \\
|39-146|Blank|Fill with blanks
|147-190|Organization Name|The name of the organization the media should be returned to \\Derived from [IDFDV] ‘BASIC NAME’ Field Identifier.
|191-225|Street Address|Enter the street address of the organization the media should be returned to \\Derived from [IDFDV] ‘BASIC ADDRESS’ Field Identifier.
|226-245|City|The City of the organization the media should be returned to \\Derived from [IDFDV] ‘BASIC CITY’ Field Identifier.
|246-247|State|Enter the standard two character FIPS postal abbreviation \\Derived from [IDFDV] ‘BASIC STATE’ Field Identifier.
|248-252|Blank|Fill with blanks
|253-257|ZIP Code|Enter a valid ZIP code \\Derived from [IDFDV] ‘BASIC ZIP CODE’ Field Identifier.
|258-262|ZIP Code extension|Enter the four digit ZIP code extension, if applicable. Include the hyphen in position 258.\\The hyphen (‘-‘) must be included when defining the BASIC ZIP EXTN’ Field Identifier on IDFDV. \\Derived from [IDFDV] ‘BASIC ZIP EXTN’ Field Identifier.
|263-275|Blank|Fill with blanks
|276-276|Blank|Used only for systems that cannot produce an odd number record length file.
\\
At line 807 changed 14 lines
|2-5|Payment Year. \\The year for which the report is being prepared|
|6-14|Federal EIN. \\Enter only numeric characters of the Federal EIN|
|15-23|Blank|
|24-73|Employer Name. \\Enter the first 50 positions of the employer’s name exactly as registered with the State UI agency.|Derived from the entity.
|74-113|Employer Street Address. \\The street address of the employer|Derived from the Entity Location.
|114-138|Employer City. \\The city of employer’s mailing address|Derived from the Entity Location.
|139-140|Employer State. \\Enter the standard two character FIPS postal abbreviation of the employer’s address|Derived from the Entity Location.
|141-148|Blank|
|149-153|ZIP Code Extension. \\Enter four digit ZIP code extension, including the hyphen in position 149|Derived from the Entity Location.
|154-158|ZIP code. \\Enter a valid ZIP code|Derived from the Entity Location.
|159-159|Blank|
|160-160|Type of Employment.\\A: Agriculture \\F: Federal \\H: Household \\M: Military \\Q: Medicare Qualified Government Employees \\R: Regular, all others \\X: Railroad|Derived from [IDFDV] ‘TYPE OF EMPLOYMENT’ Field Identifier.
|161-162|Blocking Factor. \\Blocking factor of the file, not to exceed 85. Enter blanks for diskette|Derived from [IDFDV] ‘BLOCKING FACTOR’ Field Identifier.
|163-166|Establishment Number or Coverage Group/PRU. \\Enter either the establishment number of the coverage group/PRU, or Blank|Derived from [IDFDV] ‘ESTABLISHMENT NUMBER’ Field Identifier.
|2-5|Payment Year|Enter the year the report is being prepared for
|6-14|Federal EIN|Enter only numeric characters. Omit hyphens, prefixes and suffixes. \\Derived from [IDFDV] 'BASIC EIN' Field Identifier.
|15-23|Blank|Fill with blanks
|24-73|Employer Name|Enter the first 50 positions of the employer’s name exactly as registered with the State UI agency. \\Derived from the entity.
|74-113|Employer Street Address|Enter the street address of the employer \\Derived from the Entity Location.
|114-138|Employer City|Enter the city of the employer’s mailing address \\Derived from the Entity Location.
|139-140|Employer State|\Enter the standard two character FIPS postal abbreviation of the employer’s address \\Derived from the Entity Location.
|141-148|Blank|Fill with blanks
|149-153|ZIP Code Extension|Enter the four digit ZIP code extension, if applicable. Include the hyphen in position 149 \\Derived from the Entity Location.
|154-158|ZIP code|Enter a valid ZIP code \\|Derived from the Entity Location.
|159-159|Blank|Fill with blanks
|160-160|Type of Employment|Enter the type of employment. Options are: \\A: Agriculture \\F: Federal \\H: Household \\M: Military \\Q: Medicare Qualified Government Employees \\R: Regular, all others \\X: Railroad|Derived from [IDFDV] ‘TYPE OF EMPLOYMENT’ Field Identifier.
|161-162|Blocking Factor|Enter the blocking factor of the file. Not to exceed 85. \\Enter blanks for diskette \\Derived from [IDFDV] ‘BLOCKING FACTOR’ Field Identifier.
|163-166|Establishment Number or Coverage Group/PRU|Enter either the establishment number of the coverage group/PRU, or fill with blanks \\Derived from [IDFDV] ‘ESTABLISHMENT NUMBER’ Field Identifier.
At line 822 changed 15 lines
|171-172|State Identifier Code. \\Enter the State FIPS postal numeric code for the State that is being reported|
|173-187|State Unemployment Insurance Account Number. \\State UI employer account number|Derived from the IDGV State SUI Registration.
|188-189|Reporting Period. \\03, 06, 09 or 12|
|190-190|No Workers/No Wages. \\Enter ‘0’ to indicate that the ‘E’ record will not be followed by the ‘S’ record. Enter ‘1’ to indicate otherwise|
|191-191|Tax Type Code.|State Specific Data. If not used, enter blanks
|192-196|Taxing Entity Code.|State Specific Data. If not used, enter blanks
|197-203|State Control Number.|State Specific Data. If not used, enter blanks
|204-208|Unit Number.|State Specific Data. If not used, enter blanks
|209-255|Blank|
|256-256|Foreign Indicator. \\If data in positions 74-158 is for a foreign address, enter the letter ‘X’, otherwise, leave it blank|Derived from [IDFDV] ‘FOREIGN ADDR INDICATOR’ Field Identifier.
|257-257|Blank|
|258-266|Other EIN. \\Enter blanks if no other EIN was used|Derived from [IDFDV] ‘OTHER EIN’ Field Identifier.
|267-275|Blank|
|276-276|Blank. \\Used only for systems that cannot produce an odd number record length file.|
\\ \\
|171-172|State Identifier Code|Enter the State FIPS postal numeric code for the State that is being reported
|173-187|State Unemployment Insurance Account Number|Enter the State UI employer account number \\Derived from the IDGV State SUI Registration.
|188-189|Reporting Period|Etner 03, 06, 09 or 12
|190-190|No Workers/No Wages|Enter ‘0’ to indicate that the ‘E’ record will not be followed by the ‘S’ record. \\Enter ‘1’ to indicate otherwise
|191-191|Tax Type Code|State Specific Data. If not used, fill with blanks
|192-196|Taxing Entity Code|State Specific Data. If not used, fill with blanks
|197-203|State Control Number|State Specific Data. If not used, fill with blanks
|204-208|Unit Number|State Specific Data. If not used, fill with blanks
|209-255|Blank|Fill with blanks
|256-256|Foreign Indicator|If data in positions 74-158 is for a foreign address, enter the letter ‘X’, otherwise, leave it blank \\Derived from [IDFDV] ‘FOREIGN ADDR INDICATOR’ Field Identifier.
|257-257|Blank|Fill with blanks
|258-266|Other EIN|Enter blanks if no other EIN was used \\Derived from [IDFDV] ‘OTHER EIN’ Field Identifier.
|267-275|Blank|Fill with blanks
|276-276|Blank|Used only for systems that cannot produce an odd number record length file.
\\
At line 841 changed 15 lines
|2-10|Social Security Number. \\Employee’s social security number. If not known, enter ‘I’ in position 2 and blanks in position 3-10|
|11-30|Employee Last Name|
|31-42|Employee First Name|
|43-43|Employee Middle Initial. \\Leave blank if no middle initial.|
|44-45|State Code. \\The state FIPS postal numeric code for the State being reported.|
|46-49|Blank|
|50-63|State QTR Total Gross Wages. \\Quarterly wages subject to all taxes.|Derived from [IDFDV] 'TOTAL GROSS WAGES' Field Identifier.
|64-77|State QTR Unemployment Insurance Total Wages. \\Quarterly wages subject to unemployment taxes.|Derived from [IDFDV] Field Identifier: Sequence 7200
|78-91|State QTR Unemployment Insurance Excess Wages. \\Quarterly wages in excess of the State UI taxable wage base.
|92-105|State QTR Unemployment Insurance Taxable Wages. \\State QTR UI total wages less State QTR UI excess wages.|
|106-120|Quarterly State Disability Insurance Taxable Wages.|Sate Specific Data. If not used, enter zero.
|121-129|Quarterly Tip Wages. \\Include all tip wages|
|130-131|Number of Weeks Worked. \\The number of weeks worked in the reporting period|Derived from [IDFDV] 'NUMBER OF WEEKS' Field Identifier. \\This can either be defined as a constant, be picked up from a pay component that was previously populated by a UserCalc, or, if left null, the system will compute the value.
|132-134|Number of Hours Worked.\\The number of hours worked in the reporting period|Derived from [IDFDV] 'HOURS ELEMENT' Field Identifier.
|135-142|Blank|
|2-10|Social Security Number|Enter the Employee’s social security number. If not known, enter ‘I’ in position 2 and blanks in position 3-10
|11-30|Employee Last Name|Enter the employee's last name
|31-42|Employee First Name|Enter the employee's first name
|43-43|Employee Middle Initial|Enter the employee's middle initial, if applicable. \\Leave blank if no middle initial.
|44-45|State Code|Enter the state FIPS postal numeric code for the State being reported.
|46-49|Blank|Fill with blanks
|50-63|State QTR Total Gross Wages|Quarterly wages subject to all taxes. \\Derived from [IDFDV] 'TOTAL GROSS WAGES' Field Identifier.
|64-77|State QTR Unemployment Insurance Total Wages|Quarterly wages subject to unemployment taxes. \\Derived from [IDFDV] Field Identifier: Sequence 7200
|78-91|State QTR Unemployment Insurance Excess Wages|Quarterly wages in excess of the State UI taxable wage base.
|92-105|State QTR Unemployment Insurance Taxable Wages|State QTR UI total wages less State QTR UI excess wages.
|106-120|Quarterly State Disability Insurance Taxable Wages|Sate Specific Data. If not used, fill with zeroes.
|121-129|Quarterly Tip Wages|Include all tip wages
|130-131|Number of Weeks Worked|Enter the number of weeks worked in the reporting period \\This can either be defined as a constant, be picked up from a pay component that was previously populated by a UserCalc, or, if left null, the system will compute the value. \\Derived from [IDFDV] 'NUMBER OF WEEKS' Field Identifier.
|132-134|Number of Hours Worked|Enter the number of hours worked in the reporting period \\Derived from [IDFDV] 'HOURS ELEMENT' Field Identifier.
|135-142|Blank|Fill with blanks
At line 857 changed 18 lines
|147-161|State Unemployment Insurance Account Number|SUI Registration Number from [IDGV]
|162-176|Unit/Division Location/Plant Code. \\The ID assigned to identify wages by work site.|
|177-190|State Taxable Wages. \\Enter wages subject to State income tax.|
|191-204|State Income Tax withheld. \\Enter wages subject to State income tax.|
|205-206|Seasonal Indicator.|State Specific Data. If not used, enter blanks. \\Derived from [IDFDV] 'SEASONAL INDICATOR' Field Identifier.
|207-207|Employer Health Insurance Code.|State Specific Data. If not used, enter blanks.
|208-208|Employee Health Insurance Code.|State Specific Data. If not used, enter blanks.
|209-209|Probationary Code.|State Specific Data. If not used, enter blanks.
|210-210|Officer Code. \\Enter ‘1’ for Officers of the corporation. Otherwise enter ‘0’.|
|211-211|Wage Plan Code.|State Specific Data. If not used, enter blanks.
|212-212|Month-1 Employment. \\Enter ‘1’ if the employee is covered by UI, worked or received pay for the pay period including the 12th day of the first reporting month. Otherwise enter ‘0’.|
|213-213|Month-2 Employment. \\Enter ‘1’ if the employee is covered by UI, worked or received pay for the pay period including the 12th day of the second reporting month. Otherwise enter ‘0’.|
|214-214|Month-3 Employment. \\Enter ‘1’ if the employee is covered by UI, worked or received pay for the pay period including the 12th day of the third reporting month. Otherwise enter ‘0’.|
|215-220|Reporting Quarter and Year. \\Enter the last month and year for the calendar period for the reporting period. Example: 062018 for Apr-June 2018)|
|221-226|Date First Employed. \\Enter the month and year the employee was first employed, such as 072017|
|227-232|Date of Separation. \\Enter the month and year the employee separated, such as 112017|
|233-275|Blank|
|276-276|Blank. \\Used only for systems that cannot produce an odd number record length file.|
|147-161|State Unemployment Insurance Account Number|The SUI Registration Number from [IDGV]
|162-176|Unit/Division Location/Plant Code|The ID assigned to identify wages by work site.
|177-190|State Taxable Wages|Enter wages subject to State income tax.
|191-204|State Income Tax withheld|Enter wages subject to State income tax.
|205-206|Seasonal Indicator|State Specific Data. If not used, fill with blanks. \\Derived from [IDFDV] 'SEASONAL INDICATOR' Field Identifier.
|207-207|Employer Health Insurance Code|State Specific Data. If not used, fill with blanks.
|208-208|Employee Health Insurance Code|State Specific Data. If not used, fill with blanks.
|209-209|Probationary Code|State Specific Data. If not used, fill with blanks.
|210-210|Officer Code|Enter ‘1’ for Officers of the corporation. Otherwise enter ‘0’.
|211-211|Wage Plan Code|State Specific Data. If not used, fill with blanks.
|212-212|Month-1 Employment|Enter ‘1’ if the employee is covered by UI, worked or received pay for the pay period including the 12th day of the first reporting month. Otherwise enter ‘0’.|
|213-213|Month-2 Employment|Enter ‘1’ if the employee is covered by UI, worked or received pay for the pay period including the 12th day of the second reporting month. Otherwise enter ‘0’.|
|214-214|Month-3 Employment|Enter ‘1’ if the employee is covered by UI, worked or received pay for the pay period including the 12th day of the third reporting month. Otherwise enter ‘0’.|
|215-220|Reporting Quarter and Year|Enter the last month and year for the calendar period for the reporting period, in MMYYYY format. Example: 0620YY for Apr-June 20YY
|221-226|Date First Employed|Enter the month and year the employee was first employed, in DDYYYY format
|227-232|Date of Separation|Enter the month and year the employee separated, in DDYYYY format
|233-275|Blank|Fill with blanks
|276-276|Blank|Used only for systems that cannot produce an odd number record length file.
At line 879 changed one line
|2-8|Total Number of Employees. \\The total number of ‘S’ records since the last ‘E’ record.|
|2-8|Total Number of Employees|The total number of ‘S’ records since the last ‘E’ record.
At line 881 changed 28 lines
|13-26|State QTR Total Gross Wages for employer. \\QTR gross wages subject to all taxes. \\Total of this field on all ‘S’ records since the last ‘E’ record.|
|27-40|State QTR Unemployment Insurance Total Wages for employer. \\QTR wages subject to state unemployment taxes. \\Total of this field on all ‘S’ records since the last ‘E’ record.|
|41-54|State QTR Unemployment Insurance Excess Wages for employer. \\QTR wages in excess of the State UI taxable wage base. \\Total of all ‘S’ records since the last ‘E’ record.|
|55-68|State QTR Unemployment Insurance Taxable Wages for employer. \\QTR UI total wages less State QTR UI excess wages. \\Total of all ‘S’ records since the last ‘E’ record.|
|69-81|Quarterly tip wages for employer. \\Enter all tip income. \\Total of this field on all ‘S’ records since the last ‘E’ record.|
|82-87|UI tax rate this quarter. \\The employer UI rate for this reporting period. One decimal point followed by 5 digits, such as 2.8% =.02800|
|88-100|State QTR UI taxes due. \\UI taxes due. QTR State UI taxable wages multiplied by the UI tax rate|
|101-111|Previous Quarter(s) underpayment.|State Specific Data. If not used, enter blanks.
|112-122|Interest.|State Specific Data. If not used, enter blanks.
|123-133|Penalty.|State Specific Data. If not used, enter blanks.
|134-144|Credit/Overpayment.|State Specific Data. If not used, enter blanks.
|145-148|Employer Assessment Rate.|State Specific Data. If not used, enter blanks.
|149-159|Employer Assessment Amount.|State Specific Data. If not used, enter blanks.
|160-163|Employee Assessment Rate.|State Specific Data. If not used, enter blanks.
|164-174|Employee Assessment Amount.|State Specific Data. If not used, enter blanks.
|175-185|Total Payment Due.|State Specific Data. If not used, enter blanks.
|186-198|Allocation Amount.|State Specific Data. If not used, enter blanks.
|199-212|Wages subject to State Income Tax.|State Specific Data. If not used, enter blanks.
|213-226|State Income Tax withheld.|State Specific Data. If not used, enter blanks.
|227-233|Month-1 Employment for employer. \\Total number of employees covered by UI who worked or received pay for the pay period including the 12th day of the first reporting month. \\Total for all ‘S’ records after the last ‘E’ record.|
|234-240|Month-2 Employment. \\Total number of employees covered by UI who worked or received pay for the pay period including the 12th day of the second reporting month. \\Total for all ‘S’ records after the last ‘E’ record.|
|241-247|Month-3 Employment. \\Total number of employees covered by UI who worked or received pay for the pay period including the 12th day of the third reporting month. \\Total for all ‘S’ records after the last ‘E’ record.|
|248-250|Country Code.|State Specific Data. If not used, enter blanks.
|251-257|Outside Country Employees.|State Specific Data. If not used, enter blanks.
|258-267|Document Control Number.|State Specific Data. If not used, enter blanks.
|268-275|Blank|
|276-276|Blank. \\Used only for systems that cannot produce an odd number record length file.|
\\ \\
|13-26|State QTR Total Gross Wages for employer|QTR gross wages subject to all taxes. \\Total of this field on all ‘S’ records since the last ‘E’ record.
|27-40|State QTR Unemployment Insurance Total Wages for employer|QTR wages subject to state unemployment taxes. \\Total of this field on all ‘S’ records since the last ‘E’ record.
|41-54|State QTR Unemployment Insurance Excess Wages for employer|QTR wages in excess of the State UI taxable wage base. \\Total of all ‘S’ records since the last ‘E’ record.
|55-68|State QTR Unemployment Insurance Taxable Wages for employer|QTR UI total wages less State QTR UI excess wages. \\Total of all ‘S’ records since the last ‘E’ record.
|69-81|Quarterly tip wages for employer|Enter all tip income. \\Total of this field on all ‘S’ records since the last ‘E’ record.
|82-87|UI tax rate this quarter|Enter the employer UI rate for this reporting period. Format: One decimal point followed by 5 digits, such as 2.8% =.02800
|88-100|State QTR UI taxes due|UI taxes due|QTR State UI taxable wages multiplied by the UI tax rate
|101-111|Previous Quarter(s) underpayment|State Specific Data. If not used, fill with blanks.
|112-122|Interest|State Specific Data. If not used, fill with blanks.
|123-133|Penalty|State Specific Data. If not used, fill with blanks.
|134-144|Credit/Overpayment|State Specific Data. If not used, fill with blanks.
|145-148|Employer Assessment Rate|State Specific Data. If not used, fill with blanks.
|149-159|Employer Assessment Amount|State Specific Data. If not used, fill with blanks.
|160-163|Employee Assessment Rate|State Specific Data. If not used, fill with blanks.
|164-174|Employee Assessment Amount|State Specific Data. If not used, fill with blanks.
|175-185|Total Payment Due|State Specific Data. If not used, fill with blanks.
|186-198|Allocation Amount|State Specific Data. If not used, fill with blanks.
|199-212|Wages subject to State Income Tax|State Specific Data. If not used, fill with blanks.
|213-226|State Income Tax withheld|State Specific Data. If not used, fill with blanks.
|227-233|Month-1 Employment|Total number of employees covered by UI who worked or received pay for the pay period including the 12th day of the first reporting month. \\Total for all ‘S’ records after the last ‘E’ record.
|234-240|Month-2 Employment \\Total number of employees covered by UI who worked or received pay for the pay period including the 12th day of the second reporting month. \\Total for all ‘S’ records after the last ‘E’ record.
|241-247|Month-3 Employment \\Total number of employees covered by UI who worked or received pay for the pay period including the 12th day of the third reporting month. \\Total for all ‘S’ records after the last ‘E’ record.
|248-250|Country Code|State Specific Data. If not used, fill with blanks.
|251-257|Outside Country Employees|State Specific Data. If not used, fill with blanks.
|258-267|Document Control Number|State Specific Data. If not used, fill withh blanks.
|268-275|Blank| Fill with blanks
|276-276|Blank|Used only for systems that cannot produce an odd number record length file.
\\
At line 913 changed 2 lines
|2-11|Total Number of Employees in File. \\The total number of ‘S’ records in the entire file.|
|12-21|Total Number of Employers in File. \\Enter the total number of ‘E’ records in the entire file.|
|2-11|Total Number of Employees in File.|The total number of ‘S’ records in the entire file.
|12-21|Total Number of Employers in File.|Enter the total number of ‘E’ records in the entire file.
At line 916 changed 11 lines
|26-40|Quarterly Total Gross Wages in File. \\QTR gross wages subject to all taxes. \\Total of this field for all ‘S’ records in the file.|
|41-55|Quarterly State Unemployment Insurance Total Wages in File. \\QTR wages subject to State UI tax. \\Total of this field for all ‘S’ records in the file.|
|56-70|Quarterly State Unemployment Insurance Excess Wages in File. \\QTR wages in excess of the State UI taxable wage base. \\Total of this field for all ‘S’ records in the file.|
|71-85|Quarterly State Unemployment Insurance Taxable Wages in File. \\State UI gross/total wage less quarterly State UI excess wages. \\Total of this field for all ‘S’ records in the file.|
|86-100|Quarterly State Disability Insurance Taxable Wages in File.|State Specific Data. If not used, enter zero.
|101-115|Quarterly Tip Wages in File. \\All tip income. \\Total of this field on all ‘S’ records in the file.|
|116-123|Month-1 Employment for employers in File. \\Total number of employees covered by UI who worked or received pay for the pay period including the 12th day of the first reporting month. \\Total of this field on all ‘S’ records in the file.|
|124-131|Month-2 Employment for employers in File. \\Total number of employees covered by UI who worked or received pay for the pay period including the 12th day of the second reporting month. \\Total of this field on all ‘S’ records in the file.|
|132-139|Month-3 Employment for employers in File. \\Total number of employees covered by UI who worked or received pay for the pay period including the 12th day of the third reporting month. \\Total of this field on all ‘S’ records in the file.|
|140-275|Blank|
|276-276|Blank. \\Used only systems that cannot produce an odd number record length file.|
|26-40|Quarterly Total Gross Wages in File|QTR gross wages subject to all taxes. \\Total of this field for all ‘S’ records in the file.
|41-55|Quarterly State Unemployment Insurance Total Wages in File|QTR wages subject to State UI tax. \\Total of this field for all ‘S’ records in the file.
|56-70|Quarterly State Unemployment Insurance Excess Wages in File|QTR wages in excess of the State UI taxable wage base. \\Total of this field for all ‘S’ records in the file.
|71-85|Quarterly State Unemployment Insurance Taxable Wages in File|State UI gross/total wage less quarterly State UI excess wages. \\Total of this field for all ‘S’ records in the file.
|86-100|Quarterly State Disability Insurance Taxable Wages in File|State Specific Data. If not used, fill with zeroes.
|101-115|Quarterly Tip Wages in File|All tip income. \\Total of this field on all ‘S’ records in the file.
|116-123|Month-1 Employment|Total number of employees covered by UI who worked or received pay for the pay period including the 12th day of the first reporting month. \\Total of this field on all ‘S’ records in the file.
|124-131|Month-2 Employment|Total number of employees covered by UI who worked or received pay for the pay period including the 12th day of the second reporting month. \\Total of this field on all ‘S’ records in the file.
|132-139|Month-3 Employment|Total number of employees covered by UI who worked or received pay for the pay period including the 12th day of the third reporting month. \\Total of this field on all ‘S’ records in the file.
|140-275|Blank|Fill with blanks
|276-276|Blank|Used only systems that cannot produce an odd number record length file.
At line 928 removed 42 lines
\\ \\
!!Standard EFW2 (formerly MMREF-1) Magnetic Media Format for Quarterly Wage Reporting
!Record Name: Code RA - Transmitter Record
||Column||Description||Source
|1-2|Record Identifier|Constant "RA"
|3-11|Submitter’s Employer ID number (EIN) Numeric only|Derived from [IDFDV] 'SUB-ER-EIN’ Field Identifier.
|12-28|Personal Identification Number (PIN)|Derived from [IDFDV] ‘SUB-PIN-NUMBER’ Field Identifier.
|29|Resub Indicator|Derived from [IDFDV] ‘SUB-RESUB-IND’ Field Identifier.
|30-35|Resub WFID|Derived from [IDFDV] ‘SUB-RESUB-WFID’ Field Identifier.
|36-37|Software Code|Derived from [IDFDV] ‘SUB-SOFTWARE’ Field Identifier.
|38-94|Company Name|Derived from [IDFDV] ‘SUB-COMP-NAME’ Field Identifier.
|95-116|Location Address|Derived from [IDFDV] ‘SUB-COMP-LOCN’ Field Identifier.
|117-138|Delivery Address|Derived from [IDFDV] ‘SUB-COMP-DELIV’ Field Identifier.
|139-160|Company City|Derived from [IDFDV] ‘SUB-COMP-CITY’ Field Identifier.
|161-162|Company State Abbreviation|Derived from [IDFDV] ‘SUB-COMP-STATE’ Field Identifier.
|163-167|Company ZIP Code|Derived from [IDFDV] ‘SUB-COMP-ZIP’ Field Identifier.
|168-171|Company ZIP Code Extension|Derived from [IDFDV] ‘SUB-COMP-ZIP-EXT’ Field Identifier.
|172-176|Blank|
|177-199|Company Foreign State/Province|Derived from [IDFDV] ‘SUB-COMP-F-STATE’ Field Identifier.
|200-214|Company Foreign Postal Code|Derived from [IDFDV] ‘SUB-COMP-F-POST’ Field Identifier.
|215-216|Company Country Code|Derived from [IDFDV] ‘SUB-COMP-COUNTRY’ Field Identifier.
|217-273|Submitter Name|Derived from [IDFDV] ‘SUB-SUBM-NAME’ Field Identifier.
|274-295|Submitter Location Address|Derived from [IDFDV] ‘SUB-SUBM-LOCN’ Field Identifier.
|296-317|Submitter Delivery Address|Derived from [IDFDV] ‘SUB-SUBM-DELIV’ Field Identifier.
|318-339|Submitter City|Derived from [IDFDV] ‘SUB-SUBM-CITY’ Field Identifier.
|340-341|Submitter State Abbreviation|Derived from [IDFDV] ‘SUB-SUBM-STATE’ Field Identifier.
|342-346|Submitter ZIP Code|Derived from [IDFDV] ‘SUB-SUBM-ZIP’ Field Identifier.
|347-350|Submitter ZIP Code Extension|Derived from [IDFDV] ‘SUB-SUBM-ZIP-EXT’ Field Identifier.
|351-355|Blank|
|356-378|Submitter Foreign State/Province|Derived from [IDFDV] ‘SUB-SUBM-F-STATE’ Field Identifier.
|379-393|Submitter Foreign Postal Code|Derived from [IDFDV] ‘SUB-SUBM-F-POST’ Field Identifier.
|394-395|Submitter Country Code|Derived from [IDFDV] ‘SUB-SUBM-COUNTRY’ Field Identifier.
|396-422|Contact Name|Derived from [IDFDV] ‘SUB-CONT-NAME’ Field Identifier.
|423-437|Contact Phone Number|Derived from [IDFDV] ‘SUB-CONT-TEL’ Field Identifier.
|438-442|Contact Phone Extension|Derived from [IDFDV] ‘SUB-CONT-TEL-EXT’ Field Identifier.
|443-445|Blank|
|446-485|Contact E-mail|Derived from [IDFDV] ‘SUB-CONT-EMAIL’ Field Identifier.
|486-488|Blank|
|489-498|Contact FAX|Derived from [IDFDV] ‘SUB-CONT-FAX’ Field Identifier.
|499-499|Preferred Method of Problem Notification Code|Derived from [IDFDV] ‘SUB-CONT-METH’ Field Identifier.
|500-500|Preparer Code|Derived from [IDFDV] ‘SUB-PREPARER’ Field Identifier.
|501-512|Blank|
At line 971 changed one line
\\ \\
!!Appendix: State Reporting documents
At line 973 changed 26 lines
!Record Name: Code RE - Employer Record
||Column||Description||Source
|1-2|Record Identifier|Constant "RE"
|3-6|Tax year CCYY|From the user defined FROM-TO period converted to YYYY
|7|Agent Indicator Code|Derived from [IDFDV] ‘W2-ER-AGENT-IND’ Field Identifier.
|8-16|Employer/Agent EIN|System derived from the applicable Federal reporting EIN, from [IDGV] or [IDGR]
|17-25|Agent for EIN|Derived from [IDFDV] ‘W2-ER-FOR-EIN’ Field Identifier.
|26|Terminating Business Indicator|Derived from [IDFDV] ‘W2-ER-TERM-BUS’ Field Identifier.
|27-30|Establishment Number|Derived from [IDFDV] ‘W2-ER-ESTAB’ Field Identifier.
|31-39|Other EIN|Derived from [IDFDV] ‘W2-ER-OTHER-EIN’ Field Identifier.
|40-96|Employer Name|Derived from [IDFDV] ‘W2-ER-NAME’ Field Identifier.
|97-118|Employer Location Address|Derived from [IDFDV] ‘W2-ER-LOCN-ADDR’ Field Identifier.
|119-140|Employer Delivery Address|Derived from [IDFDV] ‘W2-ER-DELIV-ADDR’ Field Identifier.
|141-162|Employer City|Derived from [IDFDV] ‘W2-ER-CITY’ Field Identifier.
|163-164|Employer State Abbreviation|Derived from [IDFDV] ‘W2-ER-STATE’ Field Identifier.
|165-169|Employer ZIP Code|Derived from [IDFDV] ‘W2-ER-ZIP’ Field Identifier.
|170-173|Employer ZIP Code Extension|Derived from [IDFDV] ‘W2-ER-ZIP-EXT’ Field Identifier.
|174-174|Kind of Employer|Derived from [IDFDV] 'W2-KIND-OF-EMPLOYER’ Field Identifier.
|175-178|Blank|
|179-201|Employer Foreign State/Province|Derived from [IDFDV] ‘W2-ER-F-STATE’ Field Identifier.
|202-216|Employer Foreign Postal Code|Derived from [IDFDV] ‘W2-ER-F-POSTAL’ Field Identifier.
|217-218|Employer Country Code|Derived from [IDFDV] ‘W2-ER-COUNTRY’ Field Identifier.
|219|Employment Code|From [IDGR] ‘W2 Employment Type’ or IPRLU FICA and Medicare method\\If the IPRLU.FICA method is set to "Do not calculate" and the 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]\\A set of code RE, RW, RO, RS, RT and RU records will be generated for the different types of employment.
|220|Tax Jurisdiction Code|Derived from [IDFDV] ‘W2-ER-TAX-JURIS’ Field Identifier.
|221|Third-Party Sick Pay Indicator|Derived from [IDFDV] ‘SUB-3RD-PARTY-SICK’ Field Identifier.
|222-512|Blank|
|Alabama|Wage File Due Date is January-31|State FIPS code is 01|[Tax Reporting - AL]
|Alaska| |State FIPS code is 02|[Tax Reporting - AK]
|American Samoa| |State FIPS code is 03 \\(FIPS 5-1 Reserved Code)
|Arizona|Wage File Due Date is February-28|State FIPS code is 04|[Tax Reporting - AZ]
|Arkansas|Wage File Due Date is February-28|State FIPS code is 05|[Tax Reporting - AR]
|California|Wage File Due Date is January-31|State FIPS code is 06|[Tax Reporting - CA]
|Canal Zone| |State FIPS code is 07 \\(FIPS 5-1 Reserved Code)
|Colorado|Wage File Due Date is March-31|State FIPS code is 08|[Tax Reporting - CO]
|Connecticut|Wage File Due Date is January-31|State FIPS code is 09|[Tax Reporting - CT]
|Delaware|Wage File Due Date is January-31|State FIPS code is 10|[Tax Reporting - DE]
|District of Columbia|Wage File Due Date is January-31|State FIPS code is 11|[Tax Reporting - DC]
|Florida| |State FIPS code is 12|[Tax Reporting - FL]
|Georgia|Wage File Due Date is January-31|State FIPS code is 13|[Tax Reporting - GA]
|Guam| |State FIPS code is 14 \\(FIPS 5-1 Reserved Code)
|Hawaii|Wage File Due Date is February-28|State FIPS code is 15|[Tax Reporting - HI]
|Idaho|Wage File Due Date is January-31|State FIPS code is 16|[Tax Reporting - ID]
|Illinois|Wage File Due Date is February-15|State FIPS code is 17|[Tax Reporting - IL]
|Indiana|Wage File Due Date is January-31|State FIPS code is 18|[Tax Reporting - IN]
|Iowa|Wage File Due Date is January-31|State FIPS code is 19|[Tax Reporting - IA]
|Kansas|Wage File Due Date is February-28|State FIPS code is 20|[Tax Reporting - KS]
|Kentucky|Wage File Due Date is January-31|State FIPS code is 21|[Tax Reporting - KY]
|Louisiana|Wage File Due Date is February-28|State FIPS code is 22|[Tax Reporting - LA]
|Maine|Wage File Due Date is January-31|State FIPS code is 23|[Tax Reporting - ME]
|Maryland|Wage File Due Date is January-31|State FIPS code is 24|[Tax Reporting - MD]
|Massachusetts|Wage File Due Date is January-31|State FIPS code is 25|[Tax Reporting - MA]
|Michigan|Wage File Due Date is February-28|State FIPS code is 26|[Tax Reporting - MI]
|Minnesota|Wage File Due Date is January-31|State FIPS code is 27|[Tax Reporting - MN]
|Mississippi|Wage File Due Date is January-31|State FIPS code is 28|[Tax Reporting - MS]
|Missouri|Wage File Due Date is January-31|State FIPS code is 29|[Tax Reporting - MO]
|Montana|Wage File Due Date is February-28|State FIPS code is 30|[Tax Reporting - MT]
|Nebraska|Wage File Due Date is January-31|State FIPS code is 31|[Tax Reporting - NE]
|Nevada| |State FIPS code is 32|[Tax Reporting - NV]
|New Hampshire| |State FIPS code is 33|[Tax Reporting - NH]
|New Jersey|Wage File Due Date is February-28|State FIPS code is 34|[Tax Reporting - NJ]
|New Mexico|Wage File Due Date is February-28|State FIPS code is 35|[Tax Reporting - NM]
|New York|Wage File Due Date is February-28|State FIPS code is 36|[Tax Reporting - NY]
|North Carolina|Wage File Due Date is January-31|State FIPS code is 37|[Tax Reporting - NC]
|North Dakota|Wage File Due Date is January-31|State FIPS code is 38|[Tax Reporting - ND]
|Ohio|Wage File Due Date is January-31|State FIPS code is 39|[Tax Reporting - OH]
|Okalahoma|Wage File Due Date is February-28|State FIPS code is 40|[Tax Reporting - OK]
|Oregon|Wsge File Due Date is January-31|State FIPS code is 41|[Tax Reporting - OR]
|Pennsylvania|Wage File Due Date is January-31|State FIPS code is 42|[Tax Reporting - PA]
|Puerto Rico|Wage File Due Date is January-31|State FIPS code is 72|[Tax Reporting - PR]
|Rhode Island|Wage File Due Date is January-31|State FIPS code is 44|[Tax Reporting - RI]
|South Carolina|Wage File Due Date is January-31|State FIPS code is 45|[Tax Reporting - SC]
|South Dakota| |State FIPS code is 46|[Tax Reporting - SD]
|Tennessee| |State FIPS code is 47|[Tax Reporting - TN]
|Texas| |State FIPS code is 48|[Tax Reporting - TX]
|Utah|Wage File Due Date is January-31|State FIPS code is 49|[Tax Reporting - UT]
|Vermont|Wage File Due Date is January-31|State FIPS code is 50|[Tax Reporting - VT]
|Virginia|Wage File Due Date is January-31|State FIPS code is 51|[Tax Reporting - VA]
|Virgin Islands| |State FIPS code is 52 \\(FIPS 5-1 Reserved Code)
|Washington| |State FIPS code is 53|[Tax Reporting - WA]
|West Virginia|Wage File Due Date is February-28|State FIPS code is 54|[Tax Reporting - WV]
|Wisconsin|Wage File Due Date is January-31|State FIPS code is 55|[Tax Reporting - WI]
|Wyoming| |State FIPS code is 56|[Tax Reporting - WY]
At line 1,000 removed 228 lines
\\ \\
!Record Name: Code RW - Employee Wage Record (Optional for State Quarterly Reporting)
||Column||Description||Source
|1-2|Record Identifier|Constant "RW"
|3-11|Social Security Number|Derived from [IDFDV] ‘W2-EE-SSN’ Field Identifier.\\If an invalid SSN is encountered, this field is entered with zeroes.
|12-26|Employee First Name|Derived from [IDFDV] ‘W2-EE-FIRST-NAME’ Field Identifier.
|27-41|Employee Middle Name or Initial|Derived from [IDFDV] ‘W2-EE-MIDDLE’ Field Identifier.
|42-61|Employee Last Name|Derived from [IDFDV] ‘W2-EE-LAST-NAME’ Field Identifier.
|62-65|Employee Suffix|Derived from [IDFDV] ‘W2-EE-SUFFIX’ Field Identifier.
|66-87|Employee Location Address|Derived from [IDFDV] ‘W2-EE-LOCN-ADDR’ Field Identifier.
|88-109|Employee Delivery Address|Derived from [IDFDV] ‘W2-EE-DELIV-ADDR’ Field Identifier.
|110-131|Employee City|Derived from [IDFDV] ‘W2-EE-CITY’ Field Identifier.
|132-133|Employee State Abbreviation|Derived from [IDFDV] ‘W2-EE-STATE’ Field Identifier.
|134-138|Employee ZIP Code|Derived from [IDFDV] ‘W2-EE-ZIP’ Field Identifier.
|139-142|Employee ZIP Code Extension|Derived from [IDFDV] ‘W2-EE-ZIP-EXT’ Field Identifier.
|143-147|Blank|
|148-170| Employee Foreign State/Province|Derived from [IDFDV] ‘W2-EE-F-STATE’ Field Identifier.
|171-185|Employee Foreign Postal Code|Derived from [IDFDV] ‘W2-EE-F-POSTAL’ Field Identifier.
|186-187|Employee Country Code|Derived from [IDFDV] ‘W2-EE-COUNTRY’ Field Identifier.
|188-198|Wages, Tips and Other Compensation|Derived from [IDFDV] ‘W2-FIT-WAGE’ Field Identifier.
|199-209|Federal Income Tax Withheld|Derived from [IDFDV] ‘W2-FIT-TAX’ Field Identifier.
|210-220|Social Security Wages|Derived from [IDFDV] ‘W2-SSN-WAGE’ Field Identifier.
|221-231|Social Security Tax Withheld|Derived from [IDFDV] ‘W2-SSN-TAX’ Field Identifier.
|232-242|Medicare Wages & Tips|Derived from [IDFDV] ‘W2-MEDI-WAGE’ Field Identifier.
|243-253|Medicare Tax Withheld|Derived from [IDFDV] ‘W2-MEDI-TAX’ Field Identifier.
|254-264|Social Security Tips|Derived from [IDFDV] ‘W2-SSN-TIP’ Field Identifier.
|265-275|Advanced Earned Income Credit|Derived from [IDFDV] ‘W2-EIC’ Field Identifier.
|276-286|Dependent Care Benefits|Derived from [IDFDV] ‘W2-DEP-CARE’ Field Identifier.
|287-297|Deferred Compensation contribution to Section 401(k)|Derived from [IDFDV] ‘W2-CODE-D’ Field Identifier.
|298-308|Deferred Compensation contribution to Section 403(b)|Derived from [IDFDV] ‘W2-CODE-E’ Field Identifier.
|309-319|Deferred Compensation contribution to Section 408(k)(6)|Derived from [IDFDV] ‘W2-CODE-F’ Field Identifier.
|320-330|Deferred Compensation contribution to Section 457(b)|Derived from [IDFDV] ‘W2-CODE-G’ Field Identifier.
|331-341|Deferred Compensation contribution to Section 501(c)(18)(D)|Derived from [IDFDV] ‘W2-CODE-H’ Field Identifier.
|342-352|Military Employee’s Basic Quarters and Combat Pay|Derived from [IDFDV] ‘W2-CODE-Q’ Field Identifier.
|353-363|Non-qualified Plan section 457|Derived from [IDFDV] ‘W2-NQUAL-457’ Field Identifier.
|364-374|Employer Contribution to a Health Savings Account|Derived from [IDFDV] ‘W2-CODE-W’ Field Identifier.
|375-385|Non-qualified Plan Not section 457|Derived from [IDFDV] ‘W2-NQUAL-N457’ Field Identifier.
|386-407|Blank|
|408-418|Employer cost of premiums for Group Term Life insurance over $50000|Derived from [IDFDV] ‘W2-CODE-C’ Field Identifier.
|419-429|Income from Non-statutory Stock Options|Derived from [IDFDV] ‘W2-CODE-V’ Field Identifier.
|430-462|Blank|
|463-473|Cost of Employer-Sponsored Health Coverage|Derived from [IDFDV] ‘W2-CODE-DD’ Field Identifier.
|474-485|Blank|
|486|Statutory Employee Indicator|Derived from [IDFDV] ‘W2-STAT-EE’ Field Identifier.\\If the amount is greater than zero, then ‘1’ is entered. Otherwise ‘0’ is entered.
|487|Blank|
|488|Retirement Plan Indicator|Derived from [IDFDV] ‘W2-RETIRE-PLAN’ Field Identifier.\\If the amount is greater than zero, then ‘1’ is entered. Otherwise ‘0’ is entered.
|489|Third-Party Sick Pay Indicator|Derived from [IDFDV] F‘W2-3PARTY-SICK’ Field Identifier.\\If the amount is greater than zero, then ‘1’ is entered. Otherwise ‘0’ is entered.
|490-512 |Blank|
!Record Name: Code RO - Employee Wage Record (Optional for State Quarterly Reporting)
||Column||Description||Source
|1-2 |Record Identifier|Constant ‘RO’
|3-11|Blank|
__Location 12 to 264:__ \\Not applicable to Puerto Rico, Virgin Islands, American Samoa, Guam, or Northern Mariana Islands employees.
||Column||Description||Source
|12-22|Allocated Tips|Derived from [IDFDV] ‘W2-ALLOC-TIP’ Field Identifier.
|23-33|Uncollected Employee Tax on Tips\\A combination of the uncollected social security tax and the uncollected medicare tax|Derived from [IDFDV] ‘W2-CODE-A’ + ‘W2-CODE-B’ Field Identifiers.
|34-44|Medical Savings Account|Derived from [IDFDV] ‘W2-CODE-R’ Field Identifier.
|45-55|Simple Retirement Account|Derived from [IDFDV] ‘W2-CODE-S’ Field Identifier.
|56-66|Qualified Adoption Expenses|Derived from [IDFDV] ‘W2-CODE-T’ Field Identifier.
|67-77|Uncollected SSA tax on Group Ins > 50000|Derived from [IDFDV] ‘W2-CODE-M’ Field Identifier.
|78-88|Uncollected Medicare tax on Group Ins > 50000|Derived from [IDFDV] ‘W2-CODE-N’ Field Identifier.
|89-110|Blank|
|111-121|Designated Roth Contribution under section 457(b)|Derived from [IDFDV] ‘W2-CODE-EE’ Field Identifier.
|122-264|Blank|
__Location 265 to 362:__ \\For Puerto Rico employees only.
||Column||Description||Source
|265|Civil Status|
|266-274|Spouse’s SSN|Blank|
|275-285|Wages Subject to Puerto Rico Tax.|Stored as zeroes
|286-296|Commissions Subject to Puerto Rico Tax|Stored as zeroes
|297-307|Allowances Subject to Puerto Rico Tax|Stored as zeroes
|308-318|Tips Subject to Puerto Rico Tax|Stored as zeroes
|319-329|Total Wages, commissions, tips, and allowances subject to Puerto Rico Tax|Stored as zeroes
|330-340|Puerto Rico Tax Withheld|Stored as zeroes
|341-351|Retirement Fund Subject to Puerto Rico Tax|Stored as zeroes
|352-362|Blank|
__Location 363 to 384:__ \\For Virgin Islands, American Samoa, Guam, or Northern Mariana Islands employees.
||Column||Description||Source
|363-373|Total wages, tips and other compensation subject to Virgin Islands, income tax|Stored as zeroes
|374-384|Virgin Islands, etc… Income Tax Withheld|Stored as zeroes
|385-512|Blank|
\\ \\
!Record Name: Code RS - Supplemental Record (Use for State Wage Reporting)
||Column||Description||Source
|1-2|Record Identifier|Constant "RS"
|3-4|State code. Appropriate FIPS postal numeric code|Derived from the State being reported, from [IDFDV] sequence 7000. Example: California is code "06".
|5-9|Taxing Entity Code|If County, City or School district tax is reported, this field is derived from [IDGV] 'W2 TAXING ENTITY' field for the County, City or School district tax being reported.
|10-18|Social Security Number|Derived from [IDFDV] ‘W2-EE-SSN’ Field Identifier. If an invalid SSN is encountered, this field is entered with zeroes.
|19-33|Employee First Name|Derived from [IDFDV] ‘W2-EE-FIRST-NAME’ Field Identifier.
|34-48|Employee Middle Name or Initial|Derived from [IDFDV] ‘W2-EE-MIDDLE’ Field Identifier.
|49-68|Employee Last Name|Derived from [IDFDV] ‘W2-EE-LAST-NAME’ Field Identifier.
|69-72|Employee Suffix|Derived from [IDFDV] ‘W2-EE-SUFFIX’ Field Identifier.
|73-94|Employee Location Address|Derived from [IDFDV] ‘W2-EE-LOCN-ADDR’ Field Identifier.
|95-116|Employee Delivery Address|Derived from [IDFDV] ‘W2-EE-DELIV-ADDR’ Field Identifier.
|117-138|Employee City|Derived from [IDFDV] ‘W2-EE-CITY’ Field Identifier.
|139-140|Employee State Abbreviation|Derived from [IDFDV] ‘W2-EE-STATE’ Field Identifier.
|141-145|Employee ZIP Code|Derived from [IDFDV] ‘W2-EE-ZIP’ Field Identifier.
|146-149|Employee ZIP Code Extension|Derived from [IDFDV] ‘W2-EE-ZIP-EXT’ Field Identifier.
|150-154|Blank|
|155-177|Employee Foreign State/Province|Derived from [IDFDV] ‘W2-EE-F-STATE’ Field Identifier.
|178-192|Employee Foreign Postal Code|Derived from [IDFDV] ‘W2-EE-F-POSTAL’ Field Identifier.
|193-194|Employee Country Code|Derived from [IDFDV] ‘W2-EE-COUNTRY’ Field Identifier.
\\
__Location 195 to 267:__ \\Applicable to Quarterly Unemployment Reporting. \\If the user defined ‘Period Type’ is ‘Quarter’, then locations 195 to 267 will be filled in.
||Column||Description||Source
|195-196|Optional Code.|State Specific Data. If not used, enter blanks
|197-202|Reporting Period MMYYYY|From the user defined Period End Date converted to MMYYYY for the quarter. \\Example: Period End Date = ‘31-Dec-2017’, then reporting period is ‘122017’
|203-213|State Quarterly Unemployment Insurance Total Wages|Derived from [IDFDV] ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’ Field Identifiers. \\ \\Note that the [IDFDV] Identifier ‘W2-SUI-WAGE-ER’ is not used to report this field because the value may already been capped by Symmetry during the US Tax calculation in [UPCALC]. Therefore for employees who exceed the maximum wage base, this Identifier will contain no SUI Insurance wages. \\ \\ [RPYEU] would then use the State Taxable wages from the ‘W2-ST-WAGE-HOME’ and ‘W2-ST-WAGE-WORK’ Field Identifier that are related to the employee's Home GEO and Work GEO code to report SUI Total Wages.
|214-224|State Quarterly Unemployment Insurance Taxable Wages|This amount is derived from State Quarterly Unemployment Insurance Total Wages and the SUI Maximum wage base, as defined by the state government.
|225-226|Number of Weeks Worked|From system derived # of Weeks Worked for the Reporting State. \\The system reads all pay headers with the pay category defined as ‘Regular Pay’, that are not reversed, and the Pay Issue Date falls within the user defined Quarter start and end dates.\\ \\If the Pay Header’s Work State or Home State is the same as the reporting State, then the Pay Header 'Tax Weeks' is accumulated.
|227-234|Date First Employed MMDDYYYY|From the system derived latest Employment Hired Date
|235-242|Date of Separation MMDDYYYY|From the system derived latest Employment Termination Date, that is greater than the Employment Hired Date.
|243-247|Blank|
|248-267|State Employer Account Number|Derived from [IDFDV] ‘W2-STATE-REGIST’ Field Identifier for the reporting State.\\ \\When [RPYEU] is run, if the Media Format is defined as ‘State SUI File Format’, then this field contains the SUI Registration Number from the IDGV form for the SUI Registration of the State.
|268-273|Blank|
\\
__Location 274 to 337:__\\Applicable to INCOME TAX REPORTING. \\If the user defined ‘Period Type’ is set to ‘Quarter’ or ‘Year’, then locations 274 to 337 will be filled in.
||Column||Description||Source
|274-275|State code. Appropriate FIPS postal numeric code|Derived from the State being reported. Example: California is code "06"
|276-286|State Taxable Wages|Derived from [IDFDV] ‘W2-ST-WAGE-HOME’(7020) and ‘W2-ST-WAGE-WORK’ Field Identifiers.
|287-297|State Income Tax Withheld|Derived from [IDFDV] ‘W2-ST-TAX-HOME’ and ‘W2-ST-TAX-WORK’ Field Identifiers.
|298-307|Other State Data. \\To be defined by each State. \\Example: State: California|
|298-302|State data SUI Tax|Derived from [IDFDV] ‘W2-SUI-TAX-ER’ Field Identifier.
|303-307|State data SDI Tax|Derived from [IDFDV] ‘W2-SDI-TAX-EE’ Field Identifier.
|308|Tax Type Code. This field is used to report County, City or School district tax. \\ \\If the County, City or School district requires to report taxes with the State Tax information, then the following values are used for this field:\\C – City Income Tax\\D – County Income Tax\\E – School District Income Tax\\F – Other Income Tax\\ \\[IDGV] must be set up for the Local or School Registration by County/City or School district for the following fields on the Variables Tab:\\ \\ W2 STATE MEDIA FILING: defines whether the County/City or School should report taxes with the State or not. \\ \\ W2 TAX TYPE CODE: must contain the valid Tax Type Code, as defined above. \\ \\ W2 TAXING ENTITY: Contains the Taxing Entity code supplied by the County/City or School government booklet.\\ \\|If County, City or School district tax is reported, this field is derived from [IDGV] 'W2 TAX TYPE CODE' Field Identifier.
|309-319|Local Taxable Wages|If School Tax is reported, this field is derived from ‘W2-SCHL-WAGE’ Field Identifier.\\ \\If County Tax is reported, this field is derived from ‘W2-CN-WAGE-HOME’ and ‘W2-CN-WAGE-WORK’ Field Identifiers.\\ \\If City Tax is reported, this field is derived from: ‘W2-CI-WAGE-HOME’ and ‘W2-CI-WAGE-WORK’ Field Identifiers.
|320-330|Local Income Tax Withheld|If School Tax is reported, this field is derived from ‘W2-SCHL-TAX’ Field Identifier.\\ \\If County Tax is reported, this field is derived from ‘W2-CN-TAX-HOME’ and ‘W2-CN-TAX-WORK’ Field Identifiers.\\ \\If City Tax is reported, this field is derived from: ‘W2-CI-TAX-HOME’ and ‘W2-CI-TAX-WORK’ Field Identifiers.
|331-337|State Control Number. Optional.|Blank
|338-412|Supplemental Data 1.|State Specific Data. If not used, enter blanks
|413-487|Supplemental Data 2.|State Specific Data. If not used, enter blanks
|488-512|Blank|
\\ \\
__Multiple Code RS records:__ \\Multiple code RS records are generated for an employee if there are applicable county, city or school district tax information to be reported for a State. In this case, the state wages and tax will be zero for the subsequent code RS records.
!Record Name: Code RT - Total Record
||Column||Description||Source
|1-2|Record Identifier|Constant "RT"
|3-9|Number of RW Records. \\Total number of code "RW" records reported since last code "RE" record.|
|10-24|Wages, Tips and Other Compensation. \\Total of all code "RW" records since last "RE" record.|Derived from [IDFDV] ‘W2-FIT-WAGE’ Field Identifier.
|25-39|Federal Income Tax Withheld. \\Total of all code "RW" records since last "RE" record|Derived from [IDFDV] ‘W2-FIT-TAX’ Field Identifier.
|40-54|Social Security Wages. \\Total of all code "RW" records since last "RE" record.|Derived from [IDFDV] ‘W2-SSN-WAGE’ Field Identifier.
|55-69|Social Security Tax Withheld. \\Total of all code "RW" records since last "RE" record.|Derived from [IDFDV] ‘W2-SSN-TAX’ Field Identifier.
|70-84|Medicare Wages and Tips. \\Total of all code "RW" records since last "RE" record.|Derived from [IDFDV] ‘W2-MEDI-WAGE’ Field Identifier.
|85-99|Medicare Tax Withheld. \\Total of all code "RW" records since last "RE" record.|Derived from [IDFDV] ‘W2-MEDI-TAX’ Field Identifier.
|100-114|Social Security Tips. \\Total of all code "RW" records since last "RE" record.|Derived from [IDFDV] ‘W2-SSN-TIP’ Field Identifier.
|115-129|Advanced Earned Income Credit. \\Total of all code "RW" records since last "RE" record.|Derived from [IDFDV] ‘W2-EIC’ Field Identifier.
|130-144|Dependent Care Benefits. \\Total of all code "RW" records since last "RE" record.|Derived from [IDFDV] W2-DEP-CARE’ Field Identifier.
|145-159|Deferred Compensation Contributions to Section 401(k). \\Total of all code "RW" records since last "RE" record.|Derived from [IDFDV] ‘W2-CODE-D’ Field Identifier.
|160-174|Deferred Compensation Contributions to Section 403(b). \\Total of all code "RW" records since last "RE" record.|Derived from [IDFDV] ‘W2-CODE-E’ Field Identifier.
|175-189|Deferred Compensation Contributions to Section 408(k)(6). \\Total of all code "RW" records since last "RE" record.|Derived from [IDFDV] ‘W2-CODE-F’ Field Identifier.
|190-204|Deferred Compensation Contributions to Section 457(b). \\Total of all code "RW" records since last "RE" record.|Derived from [IDFDV] ‘W2-CODE-G’ Field Identifier.
|205-219|Deferred Compensation Contributions to Section 501(c)(18)(D). \\Total of all code "RW" records since last "RE" record.|Derived from [IDFDV] ‘W2-CODE-H’ Field Identifier.
|235-249|Non-Qualified Plan Section 457. \\Total of all code "RW" records since last "RE" record.|Derived from [IDFDV] ‘W2-NQUAL-457’ Field Identifier.
|250-264|Employer Contribution to a Health Savings Account. \\Total of all code "RW" records since last "RE" record.|Derived from [IDFDV] ‘W2-CODE-W’ Field Identifier.
|265-279|Non-Qualified Plan Not Section 457. \\Total of all code "RW" records since last "RE" record.|Derived from [IDFDV] ‘W2-NQUAL-N457’ Field Identifier.
|280-294|Blank|
|295-309|Cost of Employer-Sponsored Health Coverage. \\Total of all code "RW" records since last "RE" record.|Derived from [IDFDV] ‘W2-CODE-DD’ Field Identifier.
|310-324|Employer Cost of Premiums for Group Term Life Insurance over $50000. \\Total of all code "RW" records since last "RE" record.|Derived from [IDFDV] ‘W2-CODE-C’ Field Identifier.
|325-339|Income Tax Withheld by Third-Party Payer. \\Total of all code "RW" records since last "RE" record.|Derived from [IDFDV] ‘SUB-3RD-PARTY-TAX’ Field Identifier.
|340-354|Income from Non-statutory Stock options. \\Total of all code "RW" records since last "RE" record.|Derived from [IDFDV] ‘W2-CODE-V’ Field Identifier.
|355-512|Blank|
\\ \\
!Record Name: Code RU - Total Record (Optional for State Quarterly Reporting)
||Column||Description||Source
|1-2|Record Identifier|Constant "RU"
|3-9|Number of RO Records. \\Total number of code "RO" records reported since last code "RE" record|
|10-24|Allocated Tips. \\Total of all code "RO" records since last "RE" record.|Derived from [IDFDV] Field Identifier: ‘W2-ALLOC-TIP’
|25-39|Uncollected Employee Tax on Tips. \\Total of all code "RO" records since last "RE" record.|Derived from [IDFDV] Field Identifier: ‘W2-CODE-A’ and ‘W2-CODE-B’
|40-54|Medical Savings Account. \\Total of all code "RO" records since last "RE" record.|Derived from [IDFDV] Field Identifier: ‘W2-CODE-R’
|55-69|Simple Retirement Account. \\Total of all code "RO" records since last "RE" record.|Derived from [IDFDV] Field Identifier: ‘W2-CODE-S’
|70-84|Qualified Adoption Expenses. \\Total of all code "RO" records since last "RE" record.|Derived from [IDFDV] Field Identifier: ‘W2-CODE-T’
|85-99|Uncollected SSA tax on Group Ins > 50000. \\Total of all code "RO" records since last "RE" record.|Derived from [IDFDV] Field Identifier: ‘W2-CODE-M’
|100-114|Uncollected Medicare tax on Group Ins > 50000. \\Total of all code "RO" records since last "RE" record.|Derived from [IDFDV] Field Identifier: ‘W2-CODE-N’
|145-159|Designated Roth Contribution under section 457(b). \\Total of all code "RO" records since last "RE" record.|Derived from [IDFDV] Field Identifier: ‘W2-CODE-EE’
|355-369|Wages Subject to Puerto Rico Tax|Stored as zeroes
|370-384|Commissions Subject to Puerto Rico Tax|Stored as zeroes
|385-399|Allowances Subject to Puerto Rico Tax|Stored as zeroes
|400-414|Tips Subject to Puerto Rico Tax|Stored as zeroes
|415-429|Total Wages, commissions, tips, and allowances subject to Puerto Rico Tax|Stored as zeroes
|430-444|Puerto Rico Tax Withheld|Stored as zeroes
|445-459|Retirement Fund Subject to Puerto Rico Tax|Stored as zeroes
|460-474|Total wages, tips and other compensation subject to Virgin Islands, income tax|Stored as zeroes
|475-489|Virgin Islands, or Guam, or American Samoa, or Northern Mariana Islands Income Tax Withheld|Stored as zeroes
|490-512|Blank|
\\ \\
!Record Name: Code RF - Final Record
||Column||Description||Source
|1-2|Record Identifier|Constant "RF"
|3-7|Blank|
|8-16| Number of RW Records. \\Total number of code "RW" records on file|
|17-512|Blank|
\\ \\
!!Appendix: State Reporting documents:
\\ \\
|Alabama|Wage File Due Date is January-31|state FIPS code is 01|[tax reporting - AL]
|Alaska| |state FIPS code is 02|[tax reporting - AK]
|Arizona|Wage File Due Date is February-28|state FIPS code is 04|[tax reporting - AZ]
|Arkansas|Wage File Due Date is February-28|state FIPS code is 05|[tax reporting - AR]
|California|Wage File Due Date is January-31|state FIPS code is 06|[tax reporting - CA]
|Colorado|Wage File Due Date is March-31|state FIPS code is 08|[tax reporting - CO]
|Connecticut|Wage File Due Date is January-31|state FIPS code is 09|[tax reporting - CT]
|Delaware|Wage File Due Date is January-31|state FIPS code is 10|[tax reporting - DE]
|District of Columbia|Wage File Due Date is January-31|state FIPS code is 11|[tax reporting - DC]
|Florida| |state FIPS code is 12|[tax reporting - FL]
|Georgia|Wage File Due Date is January-31|state FIPS code is 13|[tax reporting - GA]
|Hawaii|Wage File Due Date is February-28|state FIPS code is 15|[tax reporting - HI]
|Idaho|Wage File Due Date is January-31|state FIPS code is 16|[tax reporting - ID]
|Illinois|Wage File Due Date is February-15|state FIPS code is 17|[tax reporting - IL]
|Indiana|Wage File Due Date is January-31|state FIPS code is 18|[tax reporting - IN]
|Iowa|Wage File Due Date is January-31|state FIPS code is 19|[tax reporting - IA]
|Kansas|Wage File Due Date is February-28|state FIPS code is 20|[tax reporting - KS]
|Kentucky|Wage File Due Date is January-31|state FIPS code is 21|[tax reporting - KY]
|Louisiana|Wage File Due Date is February-28|state FIPS code is 22|[tax reporting - LA]
|Maine|Wage File Due Date is February-28|state FIPS code is 23|[tax reporting - ME]
|Maryland|Wage File Due Date is January-31|state FIPS code is 24|[tax reporting - MD]
|Massachusetts|Wage File Due Date is January-31|state FIPS code is 25|[tax reporting - MA]
|Michigan|Wage File Due Date is February-28|state FIPS code is 26|[tax reporting - MI]
|Minnesota|Wage File Due Date is February-28|state FIPS code is 27|[tax reporting - MN]
|Missouri|Wage File Due Date is February-28|state FIPS code is 29|[tax reporting - MO]
At line 1,229 removed 2 lines
This page (revision-96) was last changed on 26-Nov-2021 10:22 by Meg McFarlandTop