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 3 changed one line
!!!1099R Form Processing
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 5 removed 2 lines
There is required set up for 1099Rs before the forms and reports 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 9 changed one line
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.
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 12 changed one line
__New for 2018__ \\
__New for 2018__
At line 30 removed 217 lines
!!!1099R SET UP
!Date of Payment
For the new 'Date of Payment' field, 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 defined employees.
!!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, below. \\ \\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. \\
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 – 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. \\
!IDFDV Form Descriptions
Use the IDFDV form to enter the variable data needed to correctly complete the 1099R’s, for the printed 1099R’s.
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 #|Defines the sequential order of the variable.
|[Identifier|FIELD_IDENTIFIER]|The fields within this form are defined 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 defined 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 Defintion Variables
After IDFD is loaded, users must set up their organization’s information for this Form Definition on the IDFDV form. \\ \\
__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 \\
||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-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 #
|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.
|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-ALLOC-TO-IRR|Amount allocable to IRR within 5 years|Pay Component|F1099R-BOX-10
|R99-1ST-YR-ROTH|First Year Roth Contributions|Element|F1099R-BOX-ROTH
|R99-FATCA|FATCA Requirement|Element|F1099R-BOX-10-FATCA
\\
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 415 or 403(b)|Pay Component|Enter your company data
|R99-CODE-F|Charitable gift annuity|Pay Component|Enter your company data
|R99-CODE-G|Rollover 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
|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
\\
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
|R99-CN-DIST-WORK|County Distributions (Work cOUNTY)|Element|R99-CNTY-DIST-W
|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 258 changed one line
Users should verify the RP1099RW numeric box totals balance to the RPYEU numeric box totals. \\ \\
Users should verify the RP1099RW numeric box totals balance to the RPYEU numeric box totals. \\
At line 67 added 6 lines
!Government Media File Name
*When [RPYEU] is run, users can select to generate a magnetic media file
*Users must define a valid directory name and a magnetic media file name, such as 1099R_2017.txt)
*Users can also attach the [RPYEU] Execution ID to the file name by defining the word ‘Mex’ in the file name, such as 1099R_2017_mex.txt. This will generate a magnetic media file 1099R_2017_67109.txt for Execution ID 67109
Example: 1099R_mex_ohio.txt will generate a magnetic media file 1099R_67109_ohio.txt for Execution ID 67109
At line 92 added one line
**rpyeu_1099R_750234.txt - Magnetic media file to be sent to the government
At line 101 added one line
**rpyeu_1099R_150277.txt - Magnetic media file to be sent to the government
At line 104 added 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 186 added one line
The following exception messages are always printed for an employee:
At line 320 added one line
At line 345 added 13 lines
Form Code: Use current year's form code \\
Identifier: 1099R-CONTROL-PRINT \\
Level: Federal \\
O/R: CONTROL NUM PRT \\
Source: Constant \\
Field Variable Options: \\
*Null, 0 – Do not print Control Number on 1099R Form
*1 - Print Control Number as defined in 1099R-CONTROL-NUM Identifier
*2 - Print Control Number as defined from RPYEU ‘Sort Level By’ field
*3 - Print 1099R-CONTROL-NUM Identifier and Person Code
*4 - Print ‘Sort Level By’ field and Person Code
*5 - Print ‘Sort Level By’ field and 1099R-CONTROL-NUM Identifier
*6 - Print ‘Sort Level By’ field, the 1099R-CONTROL-NUM Identifier and Person Code \\
At line 551 removed 8 lines
||Field||Description
|Form Code|Use current year's form code
|Identifier|1099R-CONTROL-PRINT
|Level|Federal
|O/R|CONTROL NUM PRT
|Source|Constant
|Field Variable|Options are: \\ *Null, 0 – Do not print Control Number on 1099R Form \\ *1 - Print Control Number as defined in 1099R-CONTROL-NUM Identifier \\ *2 - Print Control Number as defined from RPYEU ‘Sort Level By’ field \\ *3 - Print 1099R-CONTROL-NUM Identifier and Person Code \\ *4 - Print ‘Sort Level By’ field and Person Code \\ *5 - Print ‘Sort Level By’ field and 1099R-CONTROL-NUM Identifier \\ *6 - Print ‘Sort Level By’ field, the 1099R-CONTROL-NUM Identifier and Person Code \\
At line 362 added 6 lines
Form Code: Use current year's form code \\
Identifier: 1099R-CONTROL-NUM \\
Level: Federal \\
O/R: CONTROL NUMBER \\
Source: Data Base Column \\
Field Vaiable Option: Enter your company data, such as 'EID.PERSON_CODE’, or ‘DLN.LOCALITY’, or ‘PPA.PAYROLL_CODE’ etc. \\
At line 563 changed 10 lines
||Field||Description
|Form Code|Use current year's form code
|Identifier|1099R-CONTROL-NUM
|Level|Federal
|O/R|CONTROL NUMBER
|Source|Data Base Column
|Field Variable|Enter your company data, such as 'EID.PERSON_CODE’, or ‘DLN.LOCALITY’, or ‘PPA.PAYROLL_CODE’ etc. \\
__NOTE:__ If Seq # 2810 1099R-CONTROL-NUM defines a data base column, such as PPA.PAYROLL_CODE, and:
* within the reporting year, an employee has been paid by more than one entry of this database column (employee is paid under 2 Payroll Codes), and
If Seq # 2810 1099R-CONTROL-NUM defines a data base column, such as PPA.PAYROLL_CODE, and:
* within the reporting year the employee has been paid by more than one entry of this database column (employee is paid under 2 Payroll Codes), and
At line 574 changed one line
the YTD values will be accumulated together, and 1099R Form Box D Control Number will be printed with one [PAYROLL_CODE] only, usually the [PAYROLL_CODE] with the name that is sorted last. \\
the YTD values will be accumulated together, and 1099R Form Box D Control Number will be printed with one [PAYROLL_CODE] only, usually the [PAYROLL_CODE] with the name that is sorted last. \\ \\
At line 580 changed one line
Then ‘US WEST BW’ code will be printed. \\
Then ‘US WEST BW’ code will be printed.
At line 585 changed 4 lines
* Users can run RPREGT for a group, unit, department, etc., or for a list of employees using the People List Code parameter. \\ \\
* Create an element on the IPPE form with only the pay components that will be reported on the 1099RW form. This will greatly reduce the size of the Year-to-Date Register. \\ \\
* If an employee worked in two different jurisdictions, there will be one register for each jurisdiction. Consequently, the employee will receive a separate 1099RW form for each jurisdiction. \\ \\
* For auditing purposes, (comparing RPREGT TO RPYEU) users should define the Provide Totals By field as Fed Regist Number when RPREGT is run. \\ \\
Users can run RPREGT for a group, unit, department, etc., or for a list of employees using the People List Code parameter. \\ \\
At line 385 added 6 lines
Create an element on the IPPE form with only the pay components that will be reported on the 1099RW form. This will greatly reduce the size of the Year-to-Date Register. \\ \\
If an employee worked in two different jurisdictions, there will be one register for each jurisdiction. Consequently, the employee will receive a separate 1099RW form for each jurisdiction. \\ \\
For auditing purposes, (comparing RPREGT TO RPYEU) users should define the Provide Totals By field as Fed Regist Number when RPREGT is run. \\ \\
At line 622 changed one line
\\
At line 627 removed one line
|Federal Regist Type|To define and report on a specific Federal Registration type, defined on IDGV. Optional
At line 630 changed one line
|Person|Enter the Person Code of the employee you are testing with. Optional
|Person|Enter the Person Code of the employee you are tesating with. Optional
At line 633 changed 2 lines
|State Regist Type|To define and report on a specific State Registration type, defined on IDGV. Optional
|State Regist Number|Used only for Quarterly State filing. If a State is not entered, then the Federal Regist Number on [IDGV] is used. Optional
|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
At line 636 changed 2 lines
|Local Regist Type|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
|Local Reigst Number|To define and report on a specific Local Registration set. Optional
At line 440 added 18 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
|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
At line 459 added 17 lines
__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 644 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/i1099R.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/i1099RW.pdf
At line 646 changed one line
!2018 1099R format for reporting in 2019
2018 1099R format for reporting in 2019
At line 669 changed one line
The US 1099R Forms (RP1099RW) report will print a list of 1099R forms. The RP1099RW program currently supports the 2 on-a-page format.
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 671 changed one line
||Report Parameters||Description
||Report Parameters||
At line 676 changed one line
|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 be updated. \\When set to NO, the Print Stage will be updated to Forms Printed
|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
At line 679 changed one line
||Report Filters||Description
||Report Filters||
At line 518 added 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