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

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
20 26-Nov-2021 10:22 19 KB kparrott to previous
19 26-Nov-2021 10:22 19 KB kparrott to previous | to last
18 26-Nov-2021 10:22 19 KB kparrott to previous | to last
17 26-Nov-2021 10:22 19 KB kparrott to previous | to last
16 26-Nov-2021 10:22 18 KB kparrott to previous | to last
15 26-Nov-2021 10:22 18 KB mmcfarland to previous | to last
14 26-Nov-2021 10:22 18 KB mmcfarland to previous | to last
13 26-Nov-2021 10:22 18 KB mmcfarland to previous | to last
12 26-Nov-2021 10:22 18 KB mmcfarland to previous | to last
11 26-Nov-2021 10:22 18 KB kparrott to previous | to last
10 26-Nov-2021 10:22 18 KB rforbes to previous | to last
9 26-Nov-2021 10:22 18 KB kparrott to previous | to last
8 26-Nov-2021 10:22 18 KB eyeung to previous | to last
7 26-Nov-2021 10:22 18 KB jmyers to previous | to last W2_WAGE_FORM_DESCRIPTIONS ==> W2_PROCESS_W2_WAGE_FORM_DESCRIPTIONS
6 26-Nov-2021 10:22 18 KB jmyers to previous | to last
5 26-Nov-2021 10:22 18 KB jmyers to previous | to last
4 26-Nov-2021 10:22 18 KB jmyers to previous | to last
3 26-Nov-2021 10:22 18 KB jmyers to previous | to last
2 26-Nov-2021 10:22 19 KB jmyers to previous | to last
1 26-Nov-2021 10:22 19 KB jmyers to last

Page References

Incoming links Outgoing links
W 2_PROCESS_W 2_WAGE_FORM_DESCRIPTIONS...nobody
W2_PROCESS_W2_WAGE_FORM_DESCRIPTIONS

Version management

Difference between version and

At line 1 changed one line
The following W-2 WAGE FORM DESCRIPTIONS should be read and the "2016 Instructions for Forms W-2 Wages and Tax Statement" referenced prior to setting up [IDFDV].
The following W-2 WAGE FORM DESCRIPTIONS should be read and the "Instructions for Forms W-2 Wages and Tax Statement" referenced prior to setting up [IDFDV].
At line 4 changed 2 lines
||Field Identifier||Suggested Field Variable
|W2-EE-SSN|EID.GOVERNMENT_CODE
||SEQ #||Field Identifier||Suggested Field Variable
|2500 |W2-EE-SSN|EID.GOVERNMENT_CODE
At line 9 changed 2 lines
||Field Identifier||Suggested Field Variable
|W2-ER-EIN|DGV.GOVT_REGIST_NUMBER
||SEQ #||Field Identifier||Suggested Field Variable
|2000|W2-ER-EIN|DGV.GOVT_REGIST_NUMBER
At line 14 changed 9 lines
||Field Identifier||Suggested Field Variable
|W2-ER-NAME|DED.ENTITY_NAME
|W2-ER-LOCN-ADDR|MAIL
|W2-ER-DELIV-ADDR|Blank
|W2-ER-CITY|Blank
|W2-ER-STATE|Blank
|W2-ER-ZIP|Blank
|W2-ER-ZIP-EXT|Blank
The City State ZIP print format will be conformed with USPS format as follows: “CITYbbSTbbZIPCD-nnnn” where b = one space, ST = State Abbreviated Code, ZIPCD = ZIP code, ‘-nnnn’ = ZIP extension
||SEQ #||Field Identifier||Suggested Field Variable
|2010 |W2-ER-NAME|DED.ENTITY_NAME
|2020 |W2-ER-LOCN-ADDR|MAIL
|2030 |W2-ER-DELIV-ADDR|Blank
|2040 |W2-ER-CITY|Blank
|2050 |W2-ER-STATE|Blank
|2060 |W2-ER-ZIP|Blank
|2070 |W2-ER-ZIP-EXT|Blank
The City State ZIP print format will conform with USPS format as follows: “CITYbbSTbbZIPCD-nnnn” where b = one space, ST = State Abbreviated Code, ZIPCD = ZIP code, ‘-nnnn’ = ZIP extension.
At line 26 changed 2 lines
||Field Identifier||Suggested Field Variable
|W2-ER-COUNTRY|If W2-ER-COUNTRY=USA, this country field is left 'Blank'\\ \\Otherwise, W2-ER-COUNTRY will be retrieved from [IDCO] UDF ‘ISO COUNTRY CODE’.
||SEQ #||Field Identifier||Suggested Field Variable
|2100 |W2-ER-COUNTRY|If W2-ER-COUNTRY=USA, this field is left Blank, otherwise, W2-ER-COUNTRY will be retrieved from [IDCO] UDF ‘ISO COUNTRY CODE’.
At line 36 changed 3 lines
||Field Identifier||Suggested Field Variable
|W2-CONTROL-PRT|Defines if the Control Number should be printed on the form or not.\\ \\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’ field\\3 - Print W2-CONTROL-NUM Identifier and Person Code\\4 - Print ‘Sort Level By’ field and Person Code\\5 - Print ‘Sort Level By’ field and W2-CONTROL-NUM Identifier\\6 - Print ‘Sort Level By’ field and W2-CONTROL-NUM Identifier and Person Code. \\If the ‘W2-CONTROL-PRT’ value is defined, then the value of ‘W2-CONTROL-NUM’ is printed on W2 Form Control Number field.
|W2-CONTROL-NUM|Control Number on Form. Can contain a Data Base Column. Enter your company data, such as EID.PERSON_CODE
||SEQ #||Field Identifier||Suggested Field Variable
|2800 |W2-CONTROL-PRT|Defines if the Control Number should be printed on the form or not.\\ \\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’ field\\3 - Print W2-CONTROL-NUM Identifier and Person Code\\4 - Print ‘Sort Level By’ field and Person Code\\5 - Print ‘Sort Level By’ field and W2-CONTROL-NUM Identifier\\6 - Print ‘Sort Level By’ field and W2-CONTROL-NUM Identifier and Person Code. \\If the ‘W2-CONTROL-PRT’ value is defined, then the value of ‘W2-CONTROL-NUM’ is printed on W2 Form Control Number field.
|2810 |W2-CONTROL-NUM|Control Number on Form. Can contain a Data Base Column. Enter your company data, such as EID.PERSON_CODE
At line 42 changed 5 lines
||Field Identifier||Suggested Field Variable
|W2-EE-FIRST-NAME|EID.FIRST_NAME
|W2-EE-MIDDLE|EID.MIDDLE_NAME
|W2-EE-LAST-NAME|EID.LAST_NAME
|W2-EE-SUFFIX|EID.RANK’\\derivation expression: Decode(~,'01','JR','02','SR',NULL)
||SEQ #||Field Identifier||Suggested Field Variable
|2510 |W2-EE-FIRST-NAME|EID.FIRST_NAME
|2520 |W2-EE-MIDDLE|EID.MIDDLE_NAME
|2530 |W2-EE-LAST-NAME|EID.LAST_NAME
|2540 |W2-EE-SUFFIX|EID.RANK’\\derivation expression: Decode(~,'01','JR','02','SR',NULL)
At line 50 changed 8 lines
||Field Identifier||Suggested Field Variable
|W2-EE-LOCN-ADDR|Blank or constant MAIL
|W2-EE-DELIV-ADDR|Blank
|W2-EE-CITY|Blank
|W2-EE-STATE|Blank
|W2-EE-ZIP|Blank
|W2-EE-ZIP-EXT|Blank
The City State ZIP print format will be conformed with USPS format as follows: “CITYbbSTbbZIPCD-nnnn” where b = one space, ST = State Abbreviated Code, ZIPCD = ZIP code, ‘-nnnn’ = ZIP extension
||SEQ #||Field Identifier||Suggested Field Variable
|2600 |W2-EE-LOCN-ADDR|Blank or constant MAIL
|2610 |W2-EE-DELIV-ADDR|Blank
|2620 |W2-EE-CITY|Blank
|2630 |W2-EE-STATE|Blank
|2640 |W2-EE-ZIP|Blank
|2650 |W2-EE-ZIP-EXT|Blank
The City State ZIP print format will conform with USPS format as follows: “CITYbbSTbbZIPCD-nnnn” where b = one space, ST = State Abbreviated Code, ZIPCD = ZIP code, ‘-nnnn’ = ZIP extension.
At line 61 changed 2 lines
||Field Identifier||Suggested Field Variable
|W2-EE-COUNTRY|If W2-EE-COUNTRY = USA, then this country field is left 'Blank'\\ \\Otherwise, W2-EE-COUNTRY will be retrieved from [IDCO] UDF ‘ISO COUNTRY CODE’.
||SEQ #||Field Identifier||Suggested Field Variable
|2680 |W2-EE-COUNTRY|If W2-EE-COUNTRY = USA, then this field is left Blank, otherwise, W2-EE-COUNTRY will be retrieved from [IDCO] UDF ‘ISO COUNTRY CODE’.
At line 71 changed 2 lines
||Field Identifier||Suggested Field Variable
|W2-FIT-WAGE|W2-BOX-01
||SEQ #||Field Identifier||Suggested Field Variable
|3000 |W2-FIT-WAGE|W2-BOX-01
At line 79 changed 2 lines
||Field Identifier||Suggested Field Variable
|W2-FIT-TAX|W2-BOX-02
||SEQ #||Field Identifier||Suggested Field Variable
|3010 |W2-FIT-TAX|W2-BOX-02
At line 84 changed 2 lines
||Field Identifier||Suggested Field Variable
|W2-SSN-WAGE|W2-BOX-03|
||SEQ #||Field Identifier||Suggested Field Variable
|3020 |W2-SSN-WAGE|W2-BOX-03|
At line 91 changed 2 lines
||Field Identifier||Suggested Field Variable
|W2-SSN-TAX|W2-BOX-04
||SEQ #||Field Identifier||Suggested Field Variable
|3030 |W2-SSN-TAX|W2-BOX-04
At line 96 changed 2 lines
||Field Identifier||Suggested Field Variable
|W2-MEDI-WAGE|W2-BOX-05
||SEQ #||Field Identifier||Suggested Field Variable
|3040 |W2-MEDI-WAGE|W2-BOX-05
At line 101 changed 2 lines
||Field Identifier||Suggested Field Variable
|W2-MEDI-TAX|W2-BOX-06
||SEQ #||Field Identifier||Suggested Field Variable
|3050 |W2-MEDI-TAX|W2-BOX-06
At line 106 changed 2 lines
||Field Identifier||Suggested Field Variable
|W2-SSN-TIP|W2-BOX-07
||SEQ #||Field Identifier||Suggested Field Variable
|3060 |W2-SSN-TIP|W2-BOX-07
At line 113 changed 2 lines
||Field Identifier||Suggested Field Variable
|W2-ALLOC-TIP|W2-BOX-08
||SEQ #||Field Identifier||Suggested Field Variable
|3070 |W2-ALLOC-TIP|W2-BOX-08
At line 121 changed 2 lines
||Field Identifier||Suggested Field Variable
|W2-DEP-CARE|W2-BOX-10
||SEQ #||Field Identifier||Suggested Field Variable
|3090 |W2-DEP-CARE|W2-BOX-10
At line 126 changed 2 lines
||Field Identifier||Suggested Field Variable
|W2-NQUAL|W2-BOX-11
||SEQ #||Field Identifier||Suggested Field Variable
|3100 |W2-NQUAL|W2-BOX-11
At line 133 changed 8 lines
||Field Identifier
|W2-CODE-A |W2-CODE-B |W2-CODE-C |W2-CODE-D
|W2-CODE-E |W2-CODE-F |W2-CODE-G |W2-CODE-H
|W2-CODE-J |W2-CODE-K |W2-CODE-L |W2-CODE-M
|W2-CODE-N |W2-CODE-P |W2-CODE-Q |W2-CODE-R
|W2-CODE-S |W2-CODE-T |W2-CODE-V |W2-CODE-W
|W2-CODE-Y |W2-CODE-Z |W2-CODE-AA |W2-CODE-BB
|W2-CODE-CC |W2-CODE-DD |W2-CODE-EE |
||SEQ #||Field Identifier
|4000 - 4030 |W2-CODE-A |W2-CODE-B |W2-CODE-C |W2-CODE-D
|4040 - 4070 |W2-CODE-E |W2-CODE-F |W2-CODE-G |W2-CODE-H
|4080 - 4110 |W2-CODE-J |W2-CODE-K |W2-CODE-L |W2-CODE-M
|4120 - 4150 |W2-CODE-N |W2-CODE-P |W2-CODE-Q |W2-CODE-R
|4160 - 4190 |W2-CODE-S |W2-CODE-T |W2-CODE-V |W2-CODE-W
|4200 - 4230 |W2-CODE-Y |W2-CODE-Z |W2-CODE-AA |W2-CODE-BB
|4240 - 4270 |W2-CODE-CC |W2-CODE-DD |W2-CODE-EE |W2-CODE-FF
|4280 - 4290 |W2-CODE-GG |W2-CODE-HH
At line 149 changed 2 lines
||Field Identifier||Suggested Field Variable
|W2-STAT-EE|If the amount is greater than zero, then this box is checked
||SEQ #||Field Identifier||Suggested Field Variable
|4240 - 4270 |W2-CODE-CC\\W2-CODE-DD \\W2-CODE-EE \\W2-CODE-FF\\W2-STAT-EE|If the amount is greater than zero, then this box is checked
At line 153 changed 2 lines
||Field Identifier||Suggested Field Variable
|W2-RETIRE-PLAN|If the amount is greater than zero, then this box is checked
||SEQ #||Field Identifier||Suggested Field Variable
|6020 |W2-RETIRE-PLAN|If the amount is greater than zero, then this box is checked
At line 157 changed 2 lines
||Field Identifier||Suggested Field Variable
|W2-3PARTY-SICK|If the amount is greater than zero, then this box is checked
||SEQ #||Field Identifier||Suggested Field Variable
|6060 |W2-3PARTY-SICK|If the amount is greater than zero, then this box is checked
At line 162 changed 4 lines
||Field Identifier||Suggested Field Variable
|W2-OTHER-01, W2-OTHER-02, ... up to W2-OTHER-20|
|W2-SCHL-WAGE for school district taxable wages|
|W2-SCHL-TAX for school district tax|
||SEQ #||Field Identifier||Suggested Field Variable
|5000 - 5190|W2-OTHER-01, W2-OTHER-02, ... up to W2-OTHER-20|
|6500 |W2-SCHL-WAGE for school district taxable wages|
|6510 |W2-SCHL-TAX for school district tax|
At line 180 changed 2 lines
|W2-STATE-CODE|DSP.STATE_PROVINCE_CODE
*The RPW2 program will print the proper [STATE_PROVINCE_CODE] according to YTD State information \\ \\
|7000 |W2-STATE-CODE|DSP.STATE_PROVINCE_CODE
*The W2 Print Programs will print the proper [STATE_PROVINCE_CODE] according to YTD State information \\ \\
At line 184 changed 3 lines
||Field Identifier||Suggested Field Variable
|W2-STATE-REGIST|DGV.GOVT_REGIST_NUMBER
*RPW2 program will print the [GOVT_REGIST_NUMBER] of the proper [STATE_PROVINCE_CODE] according to YTD State information.
||SEQ #||Field Identifier||Suggested Field Variable
|7010 |W2-STATE-REGIST|DGV.GOVT_REGIST_NUMBER
*The W2 Print Programs will print the [GOVT_REGIST_NUMBER] of the proper [STATE_PROVINCE_CODE] according to YTD State information.
At line 190 changed 3 lines
||Field Identifier||Suggested Field Variable
|W2-ST-WAGE-HOME|W2-BOX-16-H
|W2-ST-WAGE-WORK|W2-BOX-16-W
||SEQ #||Field Identifier||Suggested Field Variable
|7020 |W2-ST-WAGE-HOME|W2-BOX-16-H
|7030 |W2-ST-WAGE-WORK|W2-BOX-16-W
At line 204 changed 3 lines
||Field Identifier||Suggested Field Variable
|W2-ST-TAX-HOME|W2-BOX-17-H
|W2-ST-TAX-WORK|W2-BOX-17-W
||SEQ #||Field Identifier||Suggested Field Variable
|7040 |W2-ST-TAX-HOME|W2-BOX-17-H
|7050 |W2-ST-TAX-WORK|W2-BOX-17-W
At line 216 changed 5 lines
||Field Identifier||Suggested Field Variable
|W2-CN-WAGE-HOME|W2-BOX-18-CN-H|
|W2-CN-WAGE-WORK|W2-BOX-18-CN-W|
|W2-CI-WAGE-HOME|W2-BOX-18-CI-H|
|W2-CI-WAGE-WORK|W2-BOX-18-CI-W|
||SEQ #||Field Identifier||Suggested Field Variable
|8010 |W2-CN-WAGE-HOME|W2-BOX-18-CN-H
|8020 |W2-CN-WAGE-WORK|W2-BOX-18-CN-W
|8510 |W2-CI-WAGE-HOME|W2-BOX-18-CI-H
|8520 |W2-CI-WAGE-WORK|W2-BOX-18-CI-W
At line 232 changed 5 lines
||Field Identifier||Suggested Field Variable
|W2-CN-TAX-HOME|W2-BOX-19-CN-H
|W2-CN-TAX -WORK|W2-BOX-19-CN-W
|W2-CI-TAX -HOME|W2-BOX-19-CI-H
|W2-CI-TAX -WORK|W2-BOX-19-CI-W
||SEQ #||Field Identifier||Suggested Field Variable
|8030 |W2-CN-TAX-HOME|W2-BOX-19-CN-H
|8040 |W2-CN-TAX-WORK|W2-BOX-19-CN-W
|8530 |W2-CI-TAX-HOME|W2-BOX-19-CI-H
|8540 |W2-CI-TAX-WORK|W2-BOX-19-CI-W
At line 247 changed one line
#For California, if [IDFDV] W2-SDI-TAX-EE Identifier Seq 7260 is not defined, users can set up Box 14 to print ‘CASDI’ and the SDI amount.
#For California: if [IDFDV] W2-SDI-TAX-EE Identifier Seq 7260 is not defined, users can set up Box 14 to print ‘CASDI’ and the SDI amount.
At line 250 changed 6 lines
||Field Identifier||Suggested Field Variable
|W2-CNTY-NAME|
|DCN.COUNTY_NAME|
|W2-CITY-NAME|
|DTX.JURISDICTION_NAME|
*[RPW2] program will print the correct DTX.JURISDICTION_NAME according to YTD GEO information.
||SEQ #||Field Identifier||Suggested Field Variable
|8000 |W2-CNTY-NAME|DCN.COUNTY_NAME|
|8500 |W2-CITY-NAME|DTX.JURISDICTION_NAME|
*The W2 Print Programs will print the correct DTX.JURISDICTION_NAME according to YTD GEO information.
This page (revision-20) was last changed on 26-Nov-2021 10:22 by kparrottTop