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 28 added 205 lines
!!!1099R SET UP
!!1099R Form Definitions IDFD
__Form Code HL$US-1099R-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_1099R_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 Copy Last Year’s definition to Current Year section, later in this document. \\This seed data script is re-runnable. It will not erase the IDFDV set up of the same Form Code.
!IDFD Store Option
The IDFD Form Code HL$US-1099R-2019 provides the Store Option starting from Seq# 2000 in order for the RPYEU process to store the Employer Name/Addresses, the Employee Name/ Addresses and the Amounts of the Seq# in the Government Remittance Tables. \\ \\
__IMPORTANT:__ Users must run the RPYEU process with the new IDFD HL$US-1099R-2019 Form Code, or users can run 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. \\ \\
!IDFDV – Copy Last Year’s Definition to Current Year
After the HL$US-1099R-2019 information has been loaded, users can copy the IDFDV Variable definition from the last year to the current year using the COPY button on the IDFDV form as follows:
1) On the IDFDV form, select last year’s Form Code: HL$US-1099R-2018
2) Press the Copy Form Definition button
3) The Copying dialog box is displayed. Enter the current year New Form Code: HL$US-1099R-2019
4) Set the Copy Definition with Variables toggle to ON. This will copy the variables set up from HL$US-1099R-2018 to HL$US-1099R-2019 for the same Field Identifier name.
!1099R Form Definition Variables
Use the IDFDV form to enter the variable data needed to correctly complete the 1099R’s, for both the printed 1099R’s and the Magnetic Media files.
Users should only work with the Source and Field Variable columns. The Derivation Expression field can be used by __advanced__ users or under the guidance of a High Line consultant.
On this form, users define where, in their particular set up, each required field of data is to be retrieved from.
!IDFDV Field Descriptions
||Field||Desciption
|Seq # [FIELD_SEQUENCE]|Defines the sequential order of the variable.
|[Identifier|FIELD_IDENTIFIER]|The fields within this form are identified here.
|[Description|DESCRIPTION]|Enter a short description of the variable.
|[Level|FIELD_LEVEL]| Defines the field level, such as employee, employer, federal, etc.
|[O/R Prompt|OVERRIDE_PROMPT]|The override name of the field that will be displayed on the form is identified here.
|[Source|FIELD_SOURCE]|Defines the type of source of the field, such as database column, element, pay component, etc.
|[Field Variable|FIELD_VARIABLE]|The variable for the field is defined here.
|[Copy Form Definition|]|Press this button to copy the form definition.
|[Field Usage|FIELD_USAGE]|Defines the field usage, such as file only, form only, internal, etc.
|[Text|REFERENCE_TEXT]|Users can add additional notes in this field
|[Derivation Expression|DERIVATION_EXPRESSION]|Users can add programming code for additional computation of the data within the record.
!!!IDFDV Form Defintiions
__IDFDV Form Code HL$US-1099R-2018__
After IDFD is loaded, users must set up your organization’s information for this Form Definition on the IDFDV form. \\ \\
For 2018-2019 reporting, the IDFD Form Code HL$US-1099R-YYYY starter script has provided the Store Option starting from Sequence # 2000 in order for the RPYEU process to store the Amount of the Seq # in the Government Remittance Tables. \\ \\
__IMPORTANT:__ Users must run the RPYEU process with the IDFD HL$US-1099R-YYYY Form Code or a copy of this Form Code that has the Store Option set up to store 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 the RPYEU process. \\ \\
IDFDV HL$US-1099R-2019 Form Code Identifiers
IDFD Form: HL$US-1099R-YYYY – system provided
IDFD Form Type: US 1099R Definition
NOTE: Fields marked with an asterisk (*) are MANDATORY
;1099R Form Code Identifiers
||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
At line 451 changed one line
|Media Format|Enter the State file format or SUI file format for State Reporting. For the SUI file format, use the SUI Registration Number from IDGV. \\ Defines the Federal file format for SSA reporting. Optional
|Media Format|Enter the State file format or SUI file format for State Reporting. For the SUI file format, use the SUI Registration Number from IDGV. \\ Defines the Federal file format for SSA reporting. Optional
At line 518 removed 156 lines
!!!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