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

Version management

Difference between version and

At line 7 changed one line
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.
After the 1099R 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
__New for 2018__
__New for 2018__ \\
At line 30 added 15 lines
!!Date of Payment
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 are 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.__ \\ \\
On IDFDV, for the new “R99-DATE-OF-PAYMENT’ Identifier, the field variable column must be set to “EID.DATE_OF_PAYMENT”. \\ \\
On the Maintain Identity Information (IEID) form, in the ‘Date of Death Benefit Paid’ User Field, the date must be entered for the selected employees.
At line 60 changed 2 lines
|Seq # [FIELD_SEQUENCE]|Defines the sequential order of the variable.
|[Identifier|FIELD_IDENTIFIER]|The fields within this form are identified here.
|Seq #|Defines the sequential order of the variable.
|[Identifier|FIELD_IDENTIFIER]|The fields within this form are defined here.
At line 64 changed one line
|[O/R Prompt|OVERRIDE_PROMPT]|The override name of the field that will be displayed on the form is identified here.
|[O/R Prompt|OVERRIDE_PROMPT]|The override name of the field that will be displayed on the form is defined here.
At line 88 removed one line
|SUB-VENDOR|Software Vendor Code|Constant|Enter your company data
At line 122 changed one line
|ER-TERM=BUS|Terminating business indicator|Constant|Enter appropriate code from SSA
|ER-TERM-BUS|Terminating business indicator|Constant|Enter appropriate code from SSA
At line 157 changed one line
|R99-DATE-OF-PAYMENT|Date of Death Benefit Paid|Data Base Column|EID.DATE_OF_PAYMENT. See note below for setup
|R99-DATE-OF-PAYMENT|Date of Death Benefit Paid|Data Base Column|EID.DATE_OF_PAYMENT.
At line 187 added 4 lines
|R99-ALLOC-TO-IRR|Amount allocable to IRR within 5 years|Pay Component|F1099R-BOX-10
|R99-FATOA
At line 190 changed one line
|R99-CODE-E|Excess 425 or 403(b)|Pay Component|Enter your company data
|R99-CODE-E|Excess 415 or 403(b)|Pay Component|Enter your company data
At line 219 added 2 lines
|R99-CODE-U|ESOP under section 404(k)|Pay Component|Enter your company data
|R99-CODE-W|Payments for LT Care Insurance|Pay Component|Enter your company data
At line 218 changed 2 lines
|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-DIST-HOME|County Distributions (Home County)|Element|R99-CNTY-DIST-H
|R99-CN-DIST-WORK|County Distributions (Work cOUNTY)|Element|R99-CNTY-DIST-W
At line 305 removed 4 lines
!Government Media File – Code RW, RS when Select by State
*When [RPYEU] is run with no specific State selected, the Federal magnetic media file and Code RW records will be generated.
*When [RPYEU] is run with one State selected, only the specific State records is processed, therefore Code RW records will __not__ be generated.
Code RS records will be generated according the State government requirements and the 1099R State Media Filing’ defined on [IDGV Variables|IDGV#VariablesTab] tab.
At line 645 added one line
|Federal Regist Type|To define and report on a specific Federal Registration type, defined on IDGV. Optional
At line 651 added one line
|State Regist Type|To define and report on a specific State Registration type, defined on IDGV. Optional
At line 636 changed one line
|Local Reigst Number|To define and report on a specific Local Registration set. Optional
|Local Regist Set|To define and report on a specific Local Registration type, defined on IDGV. Optional
|Local Regist Number|To define and report on a specific Local Registration set. Optional
At line 641 removed 12 lines
!!RPYEU Selection Criteria - Quarterly Reporting
__Report Parameters__
||Parameter||Description
|Annual Form Code|Mandatory. \\Form Code that is defined on the IDFDV form. \\NOTE: Always use the current year form code. __DO NOT__ use a prior year form code as the Identifiers may be obsolete.
|Quarterly Form Code|Optional. If not defined, it defaults to the Annual Form Code with the EF1099R format. \\ \\If the State is using a format such as ICESA, TIB-4 and other special formats for quarterly reporting, enter HL$US-QTR-2014. \\ \\HL$US-QTR-2014 will not be updated after 2014 because this format code is only used for prior year ICESA and TIB-4 formats. Most States are now converted to EF1099R.
|Govt Interface Format|Optional. Some States require a specific government XML file format that is defined on the IDIF form. \\Example: The Florida State format is HL$US-QTR-FL2019. Please refer to the State document that indiciates if this parameter should be used.
|Period Type|Mandatory. Defines the period type. Enter "Quarter" for quarterly reporting.
|Period End Date|Mandatory. Defines the end date of the quarterly reporting period.
|As of Date|Mandatory. Defines the start date of the quarterly reporting period.
|Combine Employment Type|Defines if the employees on the report should be sorted by their Employment Type. Set this toggle to YES to combine Regular and Other Types of Employment.
|Combine Fed Regist|Defines if all of the selected 'Federal Regist' for State/Local Reporting should be combined. Set this field to YES to combine all 'Federal Regist' for State/Local reporting. __DO NOT SET THIS TOGGLE TO YES WHEN GENERATING THE FEDERAL FILE.__\\ \\When this field is set to YES, RPYEU will not store the Federal Level amounts on the IPGH form because the Federal Registration Numbers are combined and will not be linked to a specific Federal Registration Number. \\ \\A warning message is issued when this field is set to YES: *** WARNING: Combine Fed Regist = Yes, IPGR Federal Amounts and Employee Remittance Header are not added by Federal Registration Number.
|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 654 removed 24 lines
|Directory Name| Mandatory. Defines the name of the government Magnetic Media file.
|Media File Name|Mandatory. Defines the media file name of the data being uploaded.
|Create Data Dump| Defines if a data dump file with the extension of .csv should be generated. Optional
|Trace Level|Defines the tracing level (report messages) for the report. Optional. Users should always run RPYEU with the Trace Level set to 'Exceptions Only' for all employees, unless required for tracing.
|Regist/Set Up Audit|Option to print exceptions that may exist from set up. Optional. Options are: \\00-Do not print, run \\01-Print, do not run \\02-Print and run \\03-Excp and run
|User Comments|Enter a comment to print on the header of the report. Optional
__Report Filters__
||Filter||Description
|Entity|To define and report on a specific Entity. Optional
|Federal Regist Set|To define and report on a specific Federal Registration Set, on [IDGV]. Optional
|Federal Regist Number|Defines the Employer Identification Number, on [IDGV]. Optional
|People List|This field limits the process to the people in the defined list. Optional
|Person|Enter the Person Code of the employee you are tesating with. Optional
|Select State|Defines a State to report on. Optional. Do not enter a State when generating the Federal File or W2 forms. If a State is selected, the process will report on the defined State only.
|State Regist Set|To define and report on a specific State Registration set, on [IDGV]. Optional. This field is not required for Annual reporting.
|State Regist Number|Used only for Quarterly State filing. Is a State is not entered, then the Federal Regist Number on [IDGV] is used. Optional
|Local Regist Set|To define and report on a specific Local Registration set. Optional
|Local Reigst Number|To define and report on a specific Local Registration set. Optional
|Select County|To define and report on a specific County. Optional
|Select City|To define and report on a specific City. Optional
|Select School|To define and report on a specific School District. Optional
At line 679 changed one line
Users should read the following form descriptions and refer to the IRS 2018 instructions for Forms 1099R and 5498 prior to setting up the IDFDV form. \\https://www.irs.gov/pub/irs-pdf/i1099RW.pdf
Users should read the following form descriptions and refer to the IRS 2018 instructions for Forms 1099R and 5498 prior to setting up the IDFDV form. \\https://www.irs.gov/pub/irs-pdf/i1099R.pdf
At line 681 changed one line
2018 1099R format for reporting in 2019
!2018 1099R format for reporting in 2019