This page (revision-21) was last changed on 26-Nov-2021 10:22 by Karen Parrott

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
21 26-Nov-2021 10:22 56 KB Karen Parrott to previous 1099R_PROCESSING ==> 1099R PROCESSING

Page References

Incoming links Outgoing links
1099 R PROCESSING...nobody
1099R PROCESSING

Version management

Difference between version and

At line 4 changed one line
There is required set up of 1099RWs before the forms, reports and media files can be produced. Users must confirm the setup of groups, states, counties, school districts and tax jurisdictions as they apply to your organization. \\ \\
There is required set up of 1099Rs before the forms, reports and media files can be produced. Users must confirm the setup of groups, states, counties, school districts and tax jurisdictions as they apply to your organization. \\ \\
At line 8 changed one line
After the 1099RWs set up is complete, the Summary Report is run for comparison to the Year-To-Date Register. When everything is balanced, the 1099RWs can be printed and the summary report can be re-run to produce the required media file.
After the 1099Rs set up is complete, the Summary Report is run for comparison to the Year-To-Date Register. When everything is balanced, the 1099Rs can be printed and the summary report can be re-run to produce the required media file.
At line 10 changed one line
!!!Year End Changes
!!!2018-2019 Year End Changes
At line 24 removed 2 lines
!!!IDFD Form Definition
At line 28 changed 2 lines
https://www.irs.gov/pub/irs-pdf/i1099RW.pdf \\
https://www.irs.gov/pub/irs-pdf/f1099RW.pdf \\ \\
https://www.irs.gov/pub/irs-pdf/i1099R.pdf \\
https://www.irs.gov/pub/irs-pdf/f1099R.pdf \\ \\
At line 31 removed 187 lines
__Form Code HL$US-1099RW-2019__ \\ \\
High Line provides seed data scripts to our clients with the Year End Software release to load the IDFD Form Code definition SEED_IDFD_HL$US_1099RW_YYYY.sql. \\ \\
It is not necessary to maintain this form, unless instructed to do so by High Line. \\ \\
Users can copy the IDFDV Variable definition from last year to the current year. Please refer to the US 2018 1099RW Process document, Copy Last Year’s definition to Current Year section. \\ \\
This seed data script is re-runnable. It will not erase the IDFDV set up of the same Form Code. \\ \\
!!!IDFDV Form Variables
IDFD Form: HL$US-1099RW-YYYY – system provided \\
IDFD Form Type: US 1099RW Definition \\ \\
__Form Code HL$US-1099RW-2019 Identifiers__
__NOTE: Fields marked with an asterisk (*) are mandatory.__\\ \\
;R99 Form Code Definitions
||Field Identifier||Description||Suggested Field Source||Suggested Variable
|* SUB-ER-EIN|Submitter’s Employer EIN|Constant|9 character EIN
|SUB-PIN-NUMBER|Personal Identification Number|Constant|8 characters assigned to you as PIN #. Enter 1 if the file is submitted, otherwise enter 0 (zero)
|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 EFR99|Constant|Enter Company name who receives EFR99
|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
|ER-AGENT-IND|Agent Indicator Code|Constant|If applicable, enter appropriate code
|ER-FOR-EIN|Agent for which EIN|Constant|If you are an agent, enter the EIN for which you are an agent for
|ER-TERM=BUS|Terminating business indicator|Constant|Enter appropriate code from SSA
|ER-ESTAB|Establishment Number|Constant|Further identify with EIN
|ER-OTHER-EIN|Other EIN|Constant|Other EIN used
|| || || ||
|* R99-ER-EIN|Employer Identification Number|Data Base Column|DGV.GOVT_REGIST_NUMBER
|* R99-ER-NAME|Employer Name|Data Base Column|DED.ENTITY_NAME
|R99-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.
|R99-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
|R99-ER-CITY|Employer City|Constant|Employer’s city\\DLN.LOCALITY or DLN.MAIL_LOCALITY\\ \\Enter blank, system derived
|R99-ER-STATE|Employer State Abbrev|Constant|Employer’s State abbreviation\\DSP.STATE_PROVINCE_CODE\\ \\Enter blank, system derived
|R99-ER-ZIP|Employer ZIP Code|Constant|Employer’s ZIP Code\\DLN.ZIP_POSTAL or DLN.MAIL_ZIP_POSTAL\\ \\Enter blank, system derived
|R99-ER-ZIP-EXT|Employer ZIP Extension|Constant|Employer’s ZIP Code\\DLN.ZIP_POSTAL or DLN.MAIL_ZIP_POSTAL\\ \\Enter blank, system derived
|R99-ER-F-STATE|Employer foreign State/province|Constant|Employer foreign state/province or Constant\\ \\Enter the word NAME or blank
|R99-ER-F-POSTAL|Employer foreign postal code|Constant|Enter Employer foreign postal code or Constant
|R99-ER-COUNTRY|Employer country if applicable|Constant|Enter Employer country\\ \\Enter blank, system derived
|R99-ER-F-COUNTRY|Employer foreign country|Constant|Enter the word NAME, ISO or blank
|R99-ER-TAX-JURIS|Tax Jurisdiction Code|Constant |Enter appropriate code or null
|R99-ER-ACCT-NO|Account Number|Constant, Data Base Column or IDGV variable|For IDGV variable, users can look up the IDGV Field Variable and enter the Account NUmber on IDGV
|R99-EE-SSN|Employee Social Security Number|Data Base Column|EID.GOVERNMENT_CODE
|R99-EE-FIRST-NAME|Employee First Name|Data Base Column|EID.FIRST_NAME
|R99-EE-MIDDLE|Employee Middle Name|Data Base Column|EID.MIDDLE_NAME
|R99-EE-LAST-NAME|Employee Last Name|Data Base Column|EID.LAST_NAME
|R99-EE-SUFFIX|Employee Suffix Name|Data Base Column|EID.RANK with derivation expression\\ \\Decode(~,’01’,’JR’,’02’,’SR’,NULL)
|R99-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.
|R99-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
|R99-EE-CITY|Employee City|Constant|Employee’s city\\ \\EPS.LOCALITY or EPS.MAIL_LOCALITY\\ \\Enter blank, system derived
|R99-EE-STATE|Employee State Abbrev|Constant|Employee’s State abbreviation\\ \\DSP.STATE_PROVINCE_CODE\\ \\Enter blank, system derived
|R99-EE-ZIP|Employee ZIP Code|Constant|Employee’s ZIP Code\\ \\EPS.ZIP_POSTAL or EPS.MAIL_ZIP_POSTAL\\ \\Enter blank, system derived
|R99-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
|R99-EE-F-STATE|Employee foreign State/province|Constant|Employee foreign state/province or Constant\\ \\Enter the word NAME or blank
|R99-EE-F-POSTAL|Employee foreign postal code|Constant|Employee foreign postal code\\ \\Enter blank, system derived
|R99-EE-COUNTRY|Employee country if applicable|Constant|Enter Employee country\\ \\Enter blank, system derived
|R99-EE-F-COUNTRY|Employer foreign country|Constant|Enter the word NAME or the word ISO or blank
|R99-CONTROL-PRT|Print Control Number on Form|Constant|Null, 0 – Do not print Control Number on R99 Form\\1 - Print Control Number as defined in R99-CONTROL-NUM Identifier\\2 - Print Control Number as defined from RPYEU ‘Sort Level By’ prompt\\3 - Print R99-CONTROL-NUM Identifier and Person Code\\4 - Print ‘Sort Level By’ prompt and Person Code\\5 - Print ‘Sort Level By’ prompt and R99-CONTROL-NUM Identifier\\6 - Print ‘Sort Level By’ prompt and R99-CONTROL-NUM Identifier and Person Code
|R99-CONTROL-NUM|Control Number on Form|Data Base Column|Enter your company data
|R99-DATE-OF-PAYMENT|Date of Death Benefit Paid|Data Base Column|EID.DATE_OF_PAYMENT. See note below for setup
|R99-EXCLUDE-EE|Exclude Employee|Data Base Column|Enter your company data
|R99-GROSS-DISTR|Gross Distribution|Element|F1099R-BOX-01
|R99-TAXABLE-AMT|Taxable Amount|Element|F1099R-BOX-02A
|R99-TXBL-NOT-DET|Taxable Amount Not Determined|Element|F1099R-BOX-02B-1
|R99-TXBL-TOT-DIS|Taxable Amount Total Distribution|Element|F1099R-BOX-02B-2
|R99-CAPITAL-GAIN|Capital Gain|Element|F1099R-BOX-03
|R99-FIT|Federal Income Tax Withheld|Element|F1099R-BOX-04
|R99-EE-ROTH|Employee Roth Contributions|Element|F1099R-BOX-05
|R99-NUA-ER-SEC|Net Unrealized Appreciation ER Securities|Element|F1099R-BOX-06
|R99-DISTR-CODE|Distribution Code(s)|Constant|Enter your company data
|R99-IRA-SEP-SIMP|IRA or SEP or SIMPLE|Element|F1099R-BOX-07
|R99-OTHER-DOL|Other Dollars|Element|F1099R-BOX-08
|R99-OTHER-PERC|Other Percent|Element|F1099R-BOX-08-1
|R99-PERC-DISTR|Percentage of Total Distribution|Element|F1099R-BOX-09A
|R99-EE-CONTR|Total Employee Contributions|Element|F1099R-BOX-09B
|R99-1ST-YR-ROTH|First Year Roth Contributions|Element|F1099R-BOX-ROTH
The values from R99-CODE-1 to R99-CODE-T are for Box 7 Distribution Codes and are for documentation purposes only. There is no need to set these identifiers up.\\
||Field Identifier||Description||Suggested Field Source||Suggested Variable
|R99-CODE-1|Early Distr, no known exceptions|Pay Component|Enter your company data
|R99-CODE-2|Early Distr, exception applies|Pay Component|Enter your company data
|R99-CODE-3|Disability|Pay Component|Enter your company data
|R99-CODE-4|Death|Pay Component|Enter your company data
|R99-CODE-5|Prohibited transaction|Pay Component|Enter your company data
|R99-CODE-6|Section 1035 exchange|Pay Component|Enter your company data
|R99-CODE-7|Normal distribution|Pay Component|Enter your company data
|R99-CODE-8|Excess contribution earnings deferrals 2018|Pay Component|Enter your company data
|R99-CODE-9|Cost current life insurance|Pay Component|Enter your company data
|R99-CODE-A|Eligible 10 year tax option|Pay Component|Enter your company data
|R99-CODE-B|Roth account distribution|Pay Component|Enter your company data
|R99-CODE-D|Excess contribution earnings deferrals 2018|Pay Component|Enter your company data
|R99-CODE-E|Excess 425 or 403(b)|Pay Component|Enter your company data
|R99-CODE-F|Charitable gift annuity|Pay Component|Enter your company data
|R99-CODE-G|Rollever contribution|Pay Component|Enter your company data
|R99-CODE-J|Early distribution Roth IRA|Pay Component|Enter your company data
|R99-CODE-L|Loans distribution 72(p)|Pay Component|Enter your company data
|R99-CODE-N|IRA contributions 2018|Pay Component|Enter your company data
|R99-CODE-P|Excess contribution earnings 2018|Pay Component|Enter your company data
|R99-CODE-Q|Qualified distributions Roth IRA|Pay Component|Enter your company data
|R99-CODE-R|IRA contributions 2018|Pay Component|Enter your company data
|R99-CODE-S|Early distribution SIMPLE IRA 2 yrs, no exception|Pay Component|Enter your company data
|R99-CODE-T|Roth IRA distributions, exception applies|Pay Component|Enter your company data
The values from R99-OTHER-01 to R99-OTHER-20 are for future use. There is no need to set these identifiers up.\\
||Field Identifier||Description||Suggested Field Source||Suggested Variable
|R99-OTHER-01|Your company description|Pay Component|Enter your company data
|R99-OTHER-nn|Your company description|Pay Component|Enter your company data
|R99-OTHER-20|Your company description|Pay Component|Enter your company data
Set up the following State/Local Identifiers, if necessary. \\
|R99-STATE-CODE|State Code|Data Base Column|DSP.STATE_PROVINCE_CODE
|R99-STATE-REGIST|State Registration I.D. No|Data Base Column|DGV.GOVT_REGIST_NUMBER
|R99-STATE-DIST-HOME|State Distributions (Home State)|Element|R99-STATE-DIST-H
|R99-STATE-DIST-WORK|State Distributions (Work State)|Element|R99-STATE-DIST-W
|R99-STATE-TAX-HOME|State Income Tax (Home State)|Element|R99-STATE-TAX-H
|R99-STATE-TAX-WORK|State Income Tax (Work State)|Element|R99-STATE-TAX-W
|R99-CNTY-NAME|County Name|Data Base Column|DCN.COUNTY_NAME
|R99-CN-DIST-HOME|County Distributions (Home County)|Element|R99-CNTY-DIST-H|State
|R99-CN-DIST-WORK|County Distributions (Work cOUNTY)|Element|R99-CNTY-DIST-W|State
|R99-CN-TAX-HOME|County Tax (Home County)|Element|R99-CNTY-TAX-H
|R99-CN-TAX-WORK|County Tax (Work County)|Element|R99-CNTY-TAX-W
|R99-CITY-NAME|City Name |Data Base Column|DTX.JURISDICTION_NAME
|R99-CI-DIST-HOME|City Distributions (Home City)|Element|R99-CITY-DIST-H
|R99-CI-DIST-WORK|City Distributions (Work City)|Element|R99-CITY-DIST-W
|R99-CI-TAX-HOME|City Tax (Home City)|Element|R99-CITY-TAX-H
|R99-CI-TAX-WORK|City Tax (Work City)|Element|R99-CITY-TAX-W
!!!DATE OF PAYMENT Field Setup
For the new field Date of Payment, Seq#2815, R99-DATE-OF-PAYMENT, a combination of User Defined Fields (UDF) in IMUF and User Fields (UF) in IMCD will be used.
The seed data (SEED_RP1099RWWW_20181220.sql) provided will create new user fields as follows: \\
*On IMUF, Table Alias EID – new User Field called Date_of_Payment in IMUF
*On IMCD, Table Alias EID - new Column Date_of_Payment
*On the IMFD/IMFDV, Sequence 2815, Identifier “R99-DATE-OF-PAYMENT” for the new field will also be created. \\
After loading the seed data, confirm these 2 fields are created. \\ \\
In IDFDV, for the new Seq#2815 Identifier “R99-DATE-OF-PAYMENT’ the field variable column must be set to “EID.DATE_OF_PAYMENT”. \\ \\
On the Maintain Identity Information (IEID) form, in the User Field ‘Date of Death Benefit Paid’, the date must be entered for the selected employees.
!!!US Year End Summary Report = RPYEU
Enter the most current year's IDFDV Form Code for 1099R reporting.
!!!1099RW Form Print Selection Criteria
INSERT RP1099RW PAGE
At line 239 removed 31 lines
!!!1099R MAGNETIC MEDIA FILING
If an employee has worked and/or lived in multiple tax jurisdictions during one taxation year, the reporting of 1099RW for this employee is as follows: \\ \\
!Taxation Level Processing
If an employee has worked in and/or lived in multiple tax jurisdictions during one taxation year, the reporting of 1099R for this employee is as follows:
__Federal Level__
*Federal information is totaled for all states for all employments for the reporting year by Federal Government Registration
*This includes Box 1 to 14
*The reporting of 1099R Form and Magnetic Media filing is sorted and grouped by Federal Government Registration.
*After all federal information is summarized, the Federal information will be printed on the first 1099R form for the employee (Box 1 to 11, Box 12's first 4 entries and Box 14's first 2 entries).
*Additional Box 12 and 14 information is printed on subsequent 1099R forms for each employee. These forms will __not__ repeat the federal information (Box 1 to 11).
__State Level__
*State information is summarized by each individual State regardless of whether the State Tax is generated from Work State Tax or Residence State Tax.
*If an employee has multiple tax jurisdictions within one State, the State tax information will be summarized by State.
*This includes Box 15 to 17 and SUI quarterly information.
*After all State information is summarized, each State is printed on the 1099R form and overflows onto subsequent 1099R forms, until all states are printed.
__Local Level__
*Local information is reported for County Tax Information and City Tax Information.
*If County tax has been withheld for a GEO code, the County tax information is summarized by the GEO code, regardless of whether the tax is generated as Work County or Residence County tax
*If City tax has been withheld for a GEO code, the City tax and wages are summarized by the GEO code regardless if the tax is generated as Work City or Residence City tax.
*This includes Box 18 to 20.
*After all Local (County/City) information is summarized, each Local is printed on the 1099R form and overflows onto subsequent 1099R forms, until all Locals are printed.
__School Level__
*School District tax information is reported in Box 14 with School Wage Base and School Tax
*On each 1099R form, Box 14 - "Other Information" allows up to four lines to be reported. Each Box 14 information requires 2 lines to be printed; the first line to print the description and second line to print the amount. School information requires 4 lines, therefore subsequent 1099R forms will be generated if more Box 14 entries (4 lines) are required.
*On each 1099R form, Box 12 code allows up to four entries to be reported. Subsequent 1099R forms will be generated if more entries are required.
At line 374 changed one line
!!!RPYEU
At line 479 added one line
At line 505 added 2 lines
!!!RP1099RW Form Print Program
The US 1099R Forms (RP1099RW) report will print a list of 1099R forms. \\ \\The RP1099RW program currently supports the 2 on-a-page format.
At line 508 added 7 lines
||Report Parameters||
|EE/ER Copy|Optional. Defines if the Employee ot Employer copy of 1099 will be printed. Options are: \\*01 - Employer Copy \\*02 - Employee Copy
|Corrected Toggle|Optional. When this toggle is set to ON, an “X” will be printed in the Corrected box (top of form).
|Reissued/Corrected|Optional. Defines if the 1099RW is being reissued for an employee. \\If an employee has lost their 1099RW form and have requested a replacement copy, users should run the RP1099RW process and define the Person Code for the specific employee. \\*Enter the word REISSUED in this field for re-issued 1099RW forms. \\*Enter the word CORRECTED in this field for corrected 1099RW forms. Users can enter a date in this field to indicate the Date of the Corrected copy (if an employee has more than one corrected copy). \\The exact wording in this field will be printed on the top of the 1099RW form.
|Exception Level|Optional. Defines the level of detail on the exception report. Users should always run with the Exception Level set to Exception Only for all employees, unless it is being used for debugging.
|Trial Print Only|Defines if the Print Stage field on the IPGH form will be updated when the 1099s are printed. \\When set to YES, the field will not updated. \\When set to NO, the Print Stage will be changed to Forms Printed
|User Comment|Optional, Text\\This field holds the user-supplied comment which will appear in the header of all pages of the report.
At line 516 added 162 lines
||Report Filters||
|GVT Run|Mandatory. This field defines the GVT Run number to be used to read, extract the data from and produce the 1099R forms.
|State|Optional. If used, only one State can be entered. \\This field should not be defined when users are printing the Employee Copy. Employees MUST have all of the States printed on their 1099 forms. \\ \\When printing the Employer copy, users can define to print by State to file the 1099RW paper copy to the State.
|Person|Optional. Users can enter one or more person codes to report on.
!!!IDFDV Form Variables
IDFD Form: HL$US-1099R-YYYY – system provided \\
IDFD Form Type: US 1099R Definition \\ \\
__Form Code HL$US-1099R-2019 Identifiers__
__NOTE: Fields marked with an asterisk (*) are mandatory.__\\ \\
;1099R Form Code Definitions
||Field Identifier||Description||Suggested Field Source||Suggested Variable
|* SUB-ER-EIN|Submitter’s Employer EIN|Constant|9 character EIN
|SUB-PIN-NUMBER|Personal Identification Number|Constant|8 characters assigned to you as PIN #. Enter 1 if the file is submitted, otherwise enter 0 (zero)
|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 EFR99|Constant|Enter Company name who receives EFR99
|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
|ER-AGENT-IND|Agent Indicator Code|Constant|If applicable, enter appropriate code
|ER-FOR-EIN|Agent for which EIN|Constant|If you are an agent, enter the EIN for which you are an agent for
|ER-TERM=BUS|Terminating business indicator|Constant|Enter appropriate code from SSA
|ER-ESTAB|Establishment Number|Constant|Further identify with EIN
|ER-OTHER-EIN|Other EIN|Constant|Other EIN used
|| || || ||
|* R99-ER-EIN|Employer Identification Number|Data Base Column|DGV.GOVT_REGIST_NUMBER
|* R99-ER-NAME|Employer Name|Data Base Column|DED.ENTITY_NAME
|R99-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.
|R99-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
|R99-ER-CITY|Employer City|Constant|Employer’s city\\DLN.LOCALITY or DLN.MAIL_LOCALITY\\ \\Enter blank, system derived
|R99-ER-STATE|Employer State Abbrev|Constant|Employer’s State abbreviation\\DSP.STATE_PROVINCE_CODE\\ \\Enter blank, system derived
|R99-ER-ZIP|Employer ZIP Code|Constant|Employer’s ZIP Code\\DLN.ZIP_POSTAL or DLN.MAIL_ZIP_POSTAL\\ \\Enter blank, system derived
|R99-ER-ZIP-EXT|Employer ZIP Extension|Constant|Employer’s ZIP Code\\DLN.ZIP_POSTAL or DLN.MAIL_ZIP_POSTAL\\ \\Enter blank, system derived
|R99-ER-F-STATE|Employer foreign State/province|Constant|Employer foreign state/province or Constant\\ \\Enter the word NAME or blank
|R99-ER-F-POSTAL|Employer foreign postal code|Constant|Enter Employer foreign postal code or Constant
|R99-ER-COUNTRY|Employer country if applicable|Constant|Enter Employer country\\ \\Enter blank, system derived
|R99-ER-F-COUNTRY|Employer foreign country|Constant|Enter the word NAME, ISO or blank
|R99-ER-TAX-JURIS|Tax Jurisdiction Code|Constant |Enter appropriate code or null
|R99-ER-ACCT-NO|Account Number|Constant, Data Base Column or IDGV variable|For IDGV variable, users can look up the IDGV Field Variable and enter the Account NUmber on IDGV
|R99-EE-SSN|Employee Social Security Number|Data Base Column|EID.GOVERNMENT_CODE
|R99-EE-FIRST-NAME|Employee First Name|Data Base Column|EID.FIRST_NAME
|R99-EE-MIDDLE|Employee Middle Name|Data Base Column|EID.MIDDLE_NAME
|R99-EE-LAST-NAME|Employee Last Name|Data Base Column|EID.LAST_NAME
|R99-EE-SUFFIX|Employee Suffix Name|Data Base Column|EID.RANK with derivation expression\\ \\Decode(~,’01’,’JR’,’02’,’SR’,NULL)
|R99-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.
|R99-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
|R99-EE-CITY|Employee City|Constant|Employee’s city\\ \\EPS.LOCALITY or EPS.MAIL_LOCALITY\\ \\Enter blank, system derived
|R99-EE-STATE|Employee State Abbrev|Constant|Employee’s State abbreviation\\ \\DSP.STATE_PROVINCE_CODE\\ \\Enter blank, system derived
|R99-EE-ZIP|Employee ZIP Code|Constant|Employee’s ZIP Code\\ \\EPS.ZIP_POSTAL or EPS.MAIL_ZIP_POSTAL\\ \\Enter blank, system derived
|R99-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
|R99-EE-F-STATE|Employee foreign State/province|Constant|Employee foreign state/province or Constant\\ \\Enter the word NAME or blank
|R99-EE-F-POSTAL|Employee foreign postal code|Constant|Employee foreign postal code\\ \\Enter blank, system derived
|R99-EE-COUNTRY|Employee country if applicable|Constant|Enter Employee country\\ \\Enter blank, system derived
|R99-EE-F-COUNTRY|Employer foreign country|Constant|Enter the word NAME or the word ISO or blank
|R99-CONTROL-PRT|Print Control Number on Form|Constant|Null, 0 – Do not print Control Number on R99 Form\\1 - Print Control Number as defined in R99-CONTROL-NUM Identifier\\2 - Print Control Number as defined from RPYEU ‘Sort Level By’ prompt\\3 - Print R99-CONTROL-NUM Identifier and Person Code\\4 - Print ‘Sort Level By’ prompt and Person Code\\5 - Print ‘Sort Level By’ prompt and R99-CONTROL-NUM Identifier\\6 - Print ‘Sort Level By’ prompt and R99-CONTROL-NUM Identifier and Person Code
|R99-CONTROL-NUM|Control Number on Form|Data Base Column|Enter your company data
|R99-DATE-OF-PAYMENT|Date of Death Benefit Paid|Data Base Column|EID.DATE_OF_PAYMENT. See note below for setup
|R99-EXCLUDE-EE|Exclude Employee|Data Base Column|Enter your company data
|R99-GROSS-DISTR|Gross Distribution|Element|F1099R-BOX-01
|R99-TAXABLE-AMT|Taxable Amount|Element|F1099R-BOX-02A
|R99-TXBL-NOT-DET|Taxable Amount Not Determined|Element|F1099R-BOX-02B-1
|R99-TXBL-TOT-DIS|Taxable Amount Total Distribution|Element|F1099R-BOX-02B-2
|R99-CAPITAL-GAIN|Capital Gain|Element|F1099R-BOX-03
|R99-FIT|Federal Income Tax Withheld|Element|F1099R-BOX-04
|R99-EE-ROTH|Employee Roth Contributions|Element|F1099R-BOX-05
|R99-NUA-ER-SEC|Net Unrealized Appreciation ER Securities|Element|F1099R-BOX-06
|R99-DISTR-CODE|Distribution Code(s)|Constant|Enter your company data
|R99-IRA-SEP-SIMP|IRA or SEP or SIMPLE|Element|F1099R-BOX-07
|R99-OTHER-DOL|Other Dollars|Element|F1099R-BOX-08
|R99-OTHER-PERC|Other Percent|Element|F1099R-BOX-08-1
|R99-PERC-DISTR|Percentage of Total Distribution|Element|F1099R-BOX-09A
|R99-EE-CONTR|Total Employee Contributions|Element|F1099R-BOX-09B
|R99-1ST-YR-ROTH|First Year Roth Contributions|Element|F1099R-BOX-ROTH
The values from R99-CODE-1 to R99-CODE-T are for Box 7 Distribution Codes and are for documentation purposes only. There is no need to set these identifiers up.\\
||Field Identifier||Description||Suggested Field Source||Suggested Variable
|R99-CODE-1|Early Distr, no known exceptions|Pay Component|Enter your company data
|R99-CODE-2|Early Distr, exception applies|Pay Component|Enter your company data
|R99-CODE-3|Disability|Pay Component|Enter your company data
|R99-CODE-4|Death|Pay Component|Enter your company data
|R99-CODE-5|Prohibited transaction|Pay Component|Enter your company data
|R99-CODE-6|Section 1035 exchange|Pay Component|Enter your company data
|R99-CODE-7|Normal distribution|Pay Component|Enter your company data
|R99-CODE-8|Excess contribution earnings deferrals 2018|Pay Component|Enter your company data
|R99-CODE-9|Cost current life insurance|Pay Component|Enter your company data
|R99-CODE-A|Eligible 10 year tax option|Pay Component|Enter your company data
|R99-CODE-B|Roth account distribution|Pay Component|Enter your company data
|R99-CODE-D|Excess contribution earnings deferrals 2018|Pay Component|Enter your company data
|R99-CODE-E|Excess 425 or 403(b)|Pay Component|Enter your company data
|R99-CODE-F|Charitable gift annuity|Pay Component|Enter your company data
|R99-CODE-G|Rollever contribution|Pay Component|Enter your company data
|R99-CODE-J|Early distribution Roth IRA|Pay Component|Enter your company data
|R99-CODE-L|Loans distribution 72(p)|Pay Component|Enter your company data
|R99-CODE-N|IRA contributions 2018|Pay Component|Enter your company data
|R99-CODE-P|Excess contribution earnings 2018|Pay Component|Enter your company data
|R99-CODE-Q|Qualified distributions Roth IRA|Pay Component|Enter your company data
|R99-CODE-R|IRA contributions 2018|Pay Component|Enter your company data
|R99-CODE-S|Early distribution SIMPLE IRA 2 yrs, no exception|Pay Component|Enter your company data
|R99-CODE-T|Roth IRA distributions, exception applies|Pay Component|Enter your company data
The values from R99-OTHER-01 to R99-OTHER-20 are for future use. There is no need to set these identifiers up.\\
||Field Identifier||Description||Suggested Field Source||Suggested Variable
|R99-OTHER-01|Your company description|Pay Component|Enter your company data
|R99-OTHER-nn|Your company description|Pay Component|Enter your company data
|R99-OTHER-20|Your company description|Pay Component|Enter your company data
Set up the following State/Local Identifiers, if necessary. \\
|R99-STATE-CODE|State Code|Data Base Column|DSP.STATE_PROVINCE_CODE
|R99-STATE-REGIST|State Registration I.D. No|Data Base Column|DGV.GOVT_REGIST_NUMBER
|R99-STATE-DIST-HOME|State Distributions (Home State)|Element|R99-STATE-DIST-H
|R99-STATE-DIST-WORK|State Distributions (Work State)|Element|R99-STATE-DIST-W
|R99-STATE-TAX-HOME|State Income Tax (Home State)|Element|R99-STATE-TAX-H
|R99-STATE-TAX-WORK|State Income Tax (Work State)|Element|R99-STATE-TAX-W
|R99-CNTY-NAME|County Name|Data Base Column|DCN.COUNTY_NAME
|R99-CN-DIST-HOME|County Distributions (Home County)|Element|R99-CNTY-DIST-H|State
|R99-CN-DIST-WORK|County Distributions (Work cOUNTY)|Element|R99-CNTY-DIST-W|State
|R99-CN-TAX-HOME|County Tax (Home County)|Element|R99-CNTY-TAX-H
|R99-CN-TAX-WORK|County Tax (Work County)|Element|R99-CNTY-TAX-W
|R99-CITY-NAME|City Name |Data Base Column|DTX.JURISDICTION_NAME
|R99-CI-DIST-HOME|City Distributions (Home City)|Element|R99-CITY-DIST-H
|R99-CI-DIST-WORK|City Distributions (Work City)|Element|R99-CITY-DIST-W
|R99-CI-TAX-HOME|City Tax (Home City)|Element|R99-CITY-TAX-H
|R99-CI-TAX-WORK|City Tax (Work City)|Element|R99-CITY-TAX-W
This page (revision-21) was last changed on 26-Nov-2021 10:22 by Karen ParrottTop