This page (revision-66) 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
66 26-Nov-2021 10:22 13 KB Meg McFarland to previous
65 26-Nov-2021 10:22 13 KB Meg McFarland to previous | to last
64 26-Nov-2021 10:22 13 KB Meg McFarland to previous | to last
63 26-Nov-2021 10:22 18 KB Meg McFarland to previous | to last
62 26-Nov-2021 10:22 18 KB Meg McFarland to previous | to last
61 26-Nov-2021 10:22 17 KB Meg McFarland to previous | to last

Page References

Incoming links Outgoing links
Tax Reporting - DC
Tax Reporting - DC

Version management

Difference between version and

At line 58 removed one line
At line 60 removed one line
At line 62 removed one line
At line 64 removed one line
At line 66 removed one line
At line 68 removed one line
At line 70 removed one line
At line 72 removed one line
At line 66 added 23 lines
|200-214|Company Foreign Postal Code|Derived from [IDFDV], Field Identifier: ‘SUB-COMP-F-POST’ (seq 1130)
|215-216|Company Country Code|Derived from [IDFDV], Field Identifier: ‘SUB-COMP-COUNTRY’ (seq 1140)
|217-273|Submitter Name|Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-NAME’ (seq 1150)
|274-295|Submitter Location Address|Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-LOCN’ (seq 1160)
|296-317|Submitter Delivery Address|Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-DELIV’ (seq 1170)
|318-339|Submitter City|Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-CITY’ (seq 1180)
|340-341|Submitter State Abbreviation|Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-STATE’ (seq 1190)
|342-346|Submitter ZIP code|Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-ZIP’ (seq 1200)
|347-350|Submitter ZIP code extension|Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-ZIP-EXT’ (seq 1210)
|351-355|Blank|
|356-378|Submitter Foreign State/Province|Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-F-STATE’ (seq 1220)
|379-393|Submitter Foreign Postal Code|Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-F-POST’ (seq 1230)
|394-395|Submitter Country Code|Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-COUNTRY’ (seq 1240)
|396-422|Contact Name|Derived from [IDFDV], Field Identifier: ‘SUB-CONT-NAME’ (seq 1250)
|423-437|Contact Phone Number|Derived from [IDFDV], Field Identifier: ‘SUB-CONT-TEL’ (seq 1260)
|438-442|Contact Phone Extension|Derived from [IDFDV], Field Identifier: ‘SUB-CONT-TEL-EXT’ (seq 1270)
|443-445|Blank|
|446-485|Contact E-mail|Derived from [IDFDV], Field Identifier: ‘SUB-CONT-EMAIL’ (seq 1280)
|486-488|Blank|
|489-498|Contact FAX|Derived from [IDFDV], Field Identifier: ‘SUB-CONT-FAX’ (seq 1290)
|499-499|Preferred Method of Problem Notification Code|Derived from [IDFDV], Field Identifier: ‘SUB-CONT-METH’ (seq 1300)
|500-500|Preparer Code|Derived from [IDFDV], Field Identifier: ‘SUB-PREPARER’ (seq 1310)
|501-512|Blanks
At line 75 changed 2 lines
200-214 - Company Foreign Postal Code
- Derived from [IDFDV], Field Identifier: ‘SUB-COMP-F-POST’ (seq 1130)
!Record Name: Code RE - Employer Record (same as federal code RE)
||Column||Description||Source
|1-2|Record Identifier|Constant "RE"
|3-6|Tax year CCYY|From user specified FROM-TO period converted to CCYY
|7|Agent Indicator Code|Derived from [IDFDV], Field Identifier: ‘W2-ER-AGENT-IND’ (seq 1500)
|8-16|Employer/Agent EIN|System derived the applicable Federal reporting EIN, from IDGV or IDGR
|17-25|Agent for EIN|Derived from [IDFDV], Field Identifier: ‘W2-ER-FOR-EIN’ (seq 1510)
|26|Terminating Business Indicator|Derived from [IDFDV], Field Identifier: ‘W2-ER-TERM-BUS’ (seq 1520)
|27-30|Establishment Number|Derived from [IDFDV], Field Identifier: ‘W2-ER-ESTAB’ (seq 1530)
|31-39|Other EIN|Derived from [IDFDV], Field Identifier: ‘W2-ER-OTHER-EIN’ (seq 1540)
|40-96|Employer Name|Derived from [IDFDV], Field Identifier: ‘W2-ER-NAME’ (seq 2010)
|97-118|Employer Location Address|Derived from [IDFDV], Field Identifier: ‘W2-ER-LOCN-ADDR’ (seq 2020)
|119-140|Employer Delivery Address|Derived from [IDFDV], Field Identifier: ‘W2-ER-DELIV-ADDR’ (seq 2030)
|141-162|Employer City|Derived from [IDFDV], Field Identifier: ‘W2-ER-CITY’ (seq 2040)
|163-164|Employer State Abbreviation|Derived from [IDFDV], Field Identifier: ‘W2-ER-STATE’ (seq 2050)
|165-169|Employer ZIP Code|Derived from [IDFDV], Field Identifier: ‘W2-ER-ZIP’ (seq 2060)
|170-173|Employer ZIP Code Extension|Derived from [IDFDV], Field Identifier: ‘W2-ER-ZIP-EXT’ (seq 2070)
|174-174|Kind of Employer|Derived from [IDFDV], Field Identifier: ‘W2-KIND-OF-EMPLOYER’ (seq 2120)
|175-178|Blank|
|179-201|Employer Foreign State/Province|Derived from [IDFDV], Field Identifier: ‘W2-ER-F-STATE’ (seq 2080)
|202-216|Employer Foreign Postal Code|Derived from [IDFDV], Field Identifier: ‘W2-ER-F-POSTAL’ (seq 2090)
|217-218|Employer Country Code|Derived from [IDFDV], Field Identifier: ‘W2-ER-COUNTRY’ (seq 2100)
|219|Employment Code|From [IDGR] ‘W2 Employment Type’ or [IPRLU] FICA and Medicare method\\ \\If IPRLU.FICA method = "Do not calculate" and MEDICARE method is NOT "Do Not Calculate" then the employee is classified as Employment Type ‘Q’ for W2 reporting, otherwise, the W2 Type of employment is derived from [IDGR].\\ \\A set of code RE, RW/RO/RS, RT/RU records will be generated for different types of employment
|220|Tax Jurisdiction Code|Derived from [IDFDV], Field Identifier: ‘W2-ER-TAX-JURIS’ (seq 2110)
|221|Third-Party Sick Pay Indicator|Derived from [IDFDV], Field Identifier: ‘SUB-3RD-PARTY-SICK’ (seq 1480)
|222-512|Blank|
At line 78 changed 2 lines
215-216 - Company Country Code
- Derived from [IDFDV], Field Identifier: ‘SUB-COMP-COUNTRY’ (seq 1140)
!Record Name: Code RW - Employee Wage Record (same as federal code RW)
At line 81 removed 61 lines
217-273 - Submitter Name
- Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-NAME’ (seq 1150)
274-295 - Submitter Location Address
- Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-LOCN’ (seq 1160)
296-317 - Submitter Delivery Address
- Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-DELIV’ (seq 1170)
318-339 - Submitter City
- Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-CITY’ (seq 1180)
340-341 - Submitter State Abbreviation
- Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-STATE’ (seq 1190)
342-346 - Submitter ZIP code
- Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-ZIP’ (seq 1200)
347-350 - Submitter ZIP code extension
- Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-ZIP-EXT’ (seq 1210)
351-355 - Blanks.
356-378 - Submitter Foreign State/Province
- Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-F-STATE’ (seq 1220)
379-393 - Submitter Foreign Postal Code
- Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-F-POST’ (seq 1230)
394-395 - Submitter Country Code
- Derived from [IDFDV], Field Identifier: ‘SUB-SUBM-COUNTRY’ (seq 1240)
396-422 - Contact Name
- Derived from [IDFDV], Field Identifier: ‘SUB-CONT-NAME’ (seq 1250)
423-437 - Contact Phone Number
- Derived from [IDFDV], Field Identifier: ‘SUB-CONT-TEL’ (seq 1260)
438-442 - Contact Phone Extension
- Derived from [IDFDV], Field Identifier: ‘SUB-CONT-TEL-EXT’ (seq 1270)
443-445 - Blanks
446-485 - Contact E-mail
- Derived from [IDFDV], Field Identifier: ‘SUB-CONT-EMAIL’ (seq 1280)
486-488 - Blanks
489-498 - Contact FAX
- Derived from [IDFDV], Field Identifier: ‘SUB-CONT-FAX’ (seq 1290)
499-499 - Preferred Method of Problem Notification Code
- Derived from [IDFDV], Field Identifier: ‘SUB-CONT-METH’ (seq 1300)
500-500 - Preparer Code
- Derived from [IDFDV], Field Identifier: ‘SUB-PREPARER’ (seq 1310)
501-512 - Blanks
Record name: Code RE - Employer Record (same as federal code RE)
At line 145 removed 78 lines
- Constant "RE"
3-6 - Tax year CCYY
- From user specified FROM-TO period converted to CCYY
7 - Agent Indicator Code
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-AGENT-IND’ (seq 1500)
8-16 -Employer/Agent EIN
- System derived the applicable Federal reporting EIN, from IDGV or IDGR
17-25 - Agent for EIN
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-FOR-EIN’ (seq 1510)
26 - Terminating Business Indicator
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-TERM-BUS’ (seq 1520)
27-30 - Establishment Number
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-ESTAB’ (seq 1530)
31-39 - Other EIN
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-OTHER-EIN’ (seq 1540)
40-96 - Employer Name
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-NAME’ (seq 2010)
97-118 - Employer Location Address
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-LOCN-ADDR’ (seq 2020)
119-140 - Employer Delivery Address
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-DELIV-ADDR’ (seq 2030)
141-162 - Employer City
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-CITY’ (seq 2040)
163-164 - Employer State Abbreviation
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-STATE’ (seq 2050)
165-169 - Employer ZIP Code
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-ZIP’ (seq 2060)
170-173 - Employer ZIP Code Extension
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-ZIP-EXT’ (seq 2070)
174-174 - Kind of Employer
- Derived from IDFDV screen, Field Identifier: ‘W2-KIND-OF-EMPLOYER’ (seq 2120)
175-178 - Blanks
179-201 - Employer Foreign State/Province
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-F-STATE’ (seq 2080)
202-216 - Employer Foreign Postal Code
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-F-POSTAL’ (seq 2090)
217-218 - Employer Country Code
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-COUNTRY’ (seq 2100)
219 - Employment Code
- from IDGR ‘W2 Employment Type’ or IPRLU FICA and Medicare method
- If IPRLU.FICA method = "Do not calculate" and MEDICARE method is NOT "Do Not Calculate" then the employee is classified as Employment Type ‘Q’ for W2 reporting
- otherwise the W2 Type of employment is derived from IDGR screen
- a set of code RE, RW/RO/RS, RT/RU records will be generated for different Type of employment
220 - Tax Jurisdiction Code
- Derived from IDFDV screen, Field Identifier: ‘W2-ER-TAX-JURIS’ (seq 2110)
221 - Third-Party Sick Pay Indicator
- Derived from IDFDV screen, Field Identifier: ‘SUB-3RD-PARTY-SICK’ (seq 1480)
222-512 - Blanks.
Record name: Code RW - Employee Wage Record (same as federal code RW)
Column Description
1-2 - Record Identifier
This page (revision-66) was last changed on 26-Nov-2021 10:22 by Meg McFarlandTop