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

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

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
155 19-Oct-2022 21:04 1 KB Karen Parrott to previous
154 26-Nov-2021 10:22 1 KB kparrott to previous | to last
153 26-Nov-2021 10:22 1 KB mmcfarland to previous | to last
152 26-Nov-2021 10:22 2 KB mmcfarland to previous | to last
151 26-Nov-2021 10:22 2 KB kparrott to previous | to last
150 26-Nov-2021 10:22 2 KB kparrott to previous | to last
149 26-Nov-2021 10:22 2 KB kparrott to previous | to last
148 26-Nov-2021 10:22 2 KB kparrott to previous | to last
147 26-Nov-2021 10:22 2 KB kparrott to previous | to last
146 26-Nov-2021 10:22 2 KB rforbes to previous | to last
145 26-Nov-2021 10:22 2 KB eyeung to previous | to last
144 26-Nov-2021 10:22 2 KB eyeung to previous | to last
143 26-Nov-2021 10:22 2 KB rforbes to previous | to last Taxation W2 Process ==> W2 Process
142 26-Nov-2021 10:22 2 KB rforbes to previous | to last W2 Process ==> Taxation W2 Process
141 26-Nov-2021 10:22 2 KB jmyers to previous | to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 367 added 6 lines
*When installing the US Year End software, a seed data script is executed to load in the [IDFD] Form Code:
‘HL$US-W2-2012’: SEED_IDFD_HL$US_W2_2012.sql
*This script may be run multiple times and performs the following:
**If Form Code ‘HL$US-W2-2012’ does not exist, the script loads all new identifiers for Form Code ‘HL$US-W2-2012’.
**If Form Code ‘HL$US-W2-2012’ already exists, the script will update Form Code ‘HL$US-W2-2012’ existing identifiers from [IDFD] and leaving the client’s [IDFDV] set up untouched for existing identifiers.
**If Form Code Identifier does not exist, the script will insert new identifier, then set up the content on [IDFDV] for the new identifier.
At line 368 removed 14 lines
- when user is installing the US Year End software, a seed data script is executed to load in the IDFD Form Code:
‘HL$US-W2-2012’: SEED_IDFD_HL$US_W2_2012.sql
- this script is a re-runable script and perform the following:
- if Form Code ‘HL$US-W2-2012’ does not exist, the script loads all new Identifiers for Form Code ‘HL$US-W2-2012’
- if Form Code ‘HL$US-W2-2012’ already exists, the script will update Form Code ‘HL$US-W2-2012’ existing Identifiers from IDFD screen and leaving the client’s IDFDV set up untouched for existing Identifiers
- if Form Code Identifier does not exist, the script will insert new Identifier, user then should set up the content on IDFDV screen for the new Identifier
At line 375 added one line
Since 2010-tax year reporting, [IDFD] Form Code ‘HL$US-W2-2011’ has supplied the ‘Store Option’ starting from Seq# 2000 in order for [RPYEU] to store the Employer Name / Addresses, Employee Name / Addresses and the Amounts of the Seq# in the Government Remittance Tables.
At line 384 changed one line
Since 2010-tax year reporting, IDFD Form Code ‘HL$US-W2-2011’ has supplied the ‘Store Option’ starting from Seq# 2000 in order for RPYEU to store the Employer Name / Addresses, Employee Name / Addresses and the Amounts of the Seq# in the Government Remittance Tables.
%%warning Important: [RPYEU] must be run with the new [IDFD] Form Code ‘HL$US-W2-2012’ or a copy of this Form Code that has the ‘Store Option’ set up to store the Addresses and the Amounts in the Government Remittance Tables.
Any prior year’s Form Codes do not supply this option and therefore will not turn on the store feature for [RPYEU].%%
At line 380 added 6 lines
!IDFDV – Copy Last Year’s Definition to Current Year
*After the script is loaded for ‘HL$US-W2-2012’, the [IDFDV] Variable definition may be copied from last year to current year. Go to [IDFDV] and use the COPY button to copy from last year’s definition as follows:
**On [IDFDV], select last year’s Form Code: ‘HL$US-W2-2011’
**Then press the COPY button on the screen
**The Copying dialog box is displayed, within the box, enter the current year New Form Code: ‘HL$US-W2-2012’
**Press the 'Copy Definition with Variables' button, this will copy the variables set up from ‘HL$US-W2-2011’ to ‘HL$US-W2-2012’ for the same Field Identifier name
At line 387 removed 30 lines
IMPORTANT:
Users must run RPYEU with the new IDFD Form Code ‘HL$US-W2-2012’ or a copy of this Form Code that has the ‘Store Option’ set up to store the Addresses and the Amounts in the Government Remittance Tables.
Any prior year’s Form Codes do not supply this Option and therefore will not turn on the Store feature for RPYEU.
!IDFDV – Copy Last Year’s definition to Current Year
- after the user is loading the script for ‘HL$US-W2-2012’, the user may want to copy the IDFDV Variable definition from last year to current year, the user should go to IDFDV screen and use the COPY button to copy from last year’s definition as follows:
- on IDFDV screen, select last year’s Form Code: ‘HL$US-W2-2011’
- then press the COPY button on the screen
- the Copying dialog box is displayed, then enter current year New Form Code: ‘HL$US-W2-2012’
- then press [Copy Definition with Variables] button, this will copy the variables set up from ‘HL$US-W2-2011’ to ‘HL$US-W2-2012’ for the same Field Identifier name
At line 388 added 4 lines
;IDFD FORM:
HL$US-W2-2012 - system supplied
;IDFD FORM TYPE:
US W2 EFW2 Definition - indicates the W2 definition for EFW2 filing format
At line 419 removed 5 lines
IDFD FORM: HL$US-W2-2012 - system supplied
IDFD FORM TYPE: US W2 EFW2 Definition - indicate the W2 definition is for EFW2 filing format
At line 425 changed 23 lines
Field Identifier Description Suggested Field Source Suggested Variable
SUB-ER-EIN Submitter’s Employer EIN Constant 9 characters EIN
SUB-USER-ID Submitter User Identification Constant 8 characters 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 resubmitt, 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 receive
EFW2
SUB-COMP-LOCN Company Location Address Constant Enter company’s location address
i.e. Attention, Suite, Room # etc
SUB-COMP-DELIV Company Delivery Address Constant Enter company’s delivery address
i.e. Street or Post Office Box
SUB-COMP-CITY Company’s City Constant Enter company’s city
SUB-COMP-STATE Company’s State Abbrev Constant Enter company’s State
Abbreviation
SUB-COMP-ZIP Company’s ZIP Code Constant Enter company’s ZIP code
SUB-COMP-ZIP-EXT Company’s ZIP Code Extension Constant Enter company’s ZIP code extn
SUB-COMP-F-STATE Company’s foreign State/province Constant Enter company’s foreign
||Field Identifier||Description||Suggested Field Source||Suggested Variable
|SUB-ER-EIN|Submitter’s Employer EIN|Constant|9 characters EIN
|SUB-USER-ID|Submitter User Identification|Constant|8 characters 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 resubmitt, 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 receive EFW2
|SUB-COMP-LOCN|Company Location Address|Constant|Enter company’s location address\\ \\i.e. Attention, Suite, Room # etc
|SUB-COMP-DELIV|Company Delivery Address|Constant|Enter company’s delivery address\\ \\i.e. Street or Post Office Box
|SUB-COMP-CITY|Company’s City|Constant|Enter company’s city
|SUB-COMP-STATE|Company’s State Abbrev|Constant|Enter company’s State Abbreviation
|SUB-COMP-ZIP|Company’s ZIP Code|Constant|Enter company’s ZIP code
|SUB-COMP-ZIP-EXT|Company’s ZIP Code Extension|Constant|Enter company’s ZIP code extn
|SUB-COMP-F-STATE|Company’s foreign State/province|Constant|Enter company’s foreign
At line 449 changed 11 lines
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
unprocess data
SUB-SUBM-LOCN Submitter Location Address Constant Enter submitter location address
i.e. Attention, Suite, Room # etc
SUB-SUBM-DELIV Submitter Delivery Address Constant Enter submitter delivery address
i.e. Street or Post Office Box
|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 unprocess data
|SUB-SUBM-LOCN|Submitter Location Address|Constant|Enter submitter location address\\ \\i.e. Attention, Suite, Room # etc
|SUB-SUBM-DELIV|Submitter Delivery Address|Constant|Enter submitter delivery address\\ \\i.e. Street or Post Office Box