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

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

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
7 26-Nov-2021 10:22 18 KB mmcfarland to previous
6 26-Nov-2021 10:22 15 KB mmcfarland to previous | to last
5 26-Nov-2021 10:22 15 KB mmcfarland to previous | to last
4 26-Nov-2021 10:22 15 KB mmcfarland to previous | to last
3 26-Nov-2021 10:22 15 KB mmcfarland to previous | to last
2 26-Nov-2021 10:22 15 KB mmcfarland to previous | to last
1 26-Nov-2021 10:22 15 KB mmcfarland to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 14 changed 2 lines
|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-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
At line 25 changed 2 lines
|* 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-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
At line 50 changed 7 lines
|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-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
At line 58 changed one line
|W2-ER-COUNTRY|Employer country if applicable|Constant|Enter Employer country\\ \\Enter blank, system derived
|W2-ER-COUNTRY|Employer country if applicable|Constant|Enter Employer country\\Enter blank, system derived
At line 65 changed 7 lines
|W2-EE-SUFFIX|Employee Suffix Name|Data Base Column|EID.RANK with derivation expression\\ \\Decode(~,’01’,’JR’,’02’,’SR’,NULL)
|W2-EE-LOCN-ADDR|Employee Location Address|Constant|Employee’s location address\\ \\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-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
At line 73 changed 2 lines
|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-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
At line 81 changed 2 lines
|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-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