Retirement Plan Report (FPSDR118) |
  
|
Navigation: Deposit Reports > Deposit Reports - Numerical Order >
Retirement Plan Report (FPSDR118) |
|
Availability
This report is usually run monthly in the afterhours. Contact your GOLDPoint Systems banking consultant if you want to schedule this report differently.
Purpose
The Retirement Plan Report gives key information about each retirement plan account. It is usually sorted by household number and plan number. It can also be sorted by Social Security number, short name, or IRA type. Send a work order specifying the sort option you want to use.
This report has the ability to give the total number of plans an institution has. In order for this additional total to be displayed, the report must be sorted by Social Security number first, then household number, and then by plan number.
|
GOLDPoint Systems Only: The subprogram controls print must be set to "Y" to print the total number of plans on the report. To sort by social security, set theSort fields to 82, 81, 80. Criticals should be 1 to 31 for this to work correctly.
•80 = Plan # •81 = Household # •82 = Social Security # •83 = Short Name •84 = IRA Type |
|---|
Report Column Information
See FPSDR118 Example for an example of this report.
Column Heading |
Description |
||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Household Number |
This column displays the full 12-digit household number (MNHHLD). |
||||||||||||
Plan |
This column displays the retirement plan number to which the account belongs (DMPLAN). |
||||||||||||
Account Number |
This column displays the office number (DMACTO) and account number (DMACTA). Field lengths are controlled by institution options. |
||||||||||||
5 Yr Pln |
This column displays a "Y" if the Distribution Option field is set to "1" on the Beneficiary Detail screen (Application 4, function 205/206). |
||||||||||||
Type |
This column displays the IRA type for each account. Valid possible types are IRA (DMRIRA), QRP (DMSTAR), SEP (DMSEPP), SIM (DMSIMP), RTH (DMROTH), ESA (DMEDUC), ROL (DMCOND), and HSA (DMRHSA). |
||||||||||||
Account Balance |
This column displays the current balance of the account (DMCRBL). |
||||||||||||
Short Name |
This column displays the short name of the plan owner. This name is the IRS owner and is taken from the CIF System. |
||||||||||||
Social Security # |
This column displays the plan owner’s social security number. |
||||||||||||
Date Deceased |
This column displays the death date of the owner of the plan. |
||||||||||||
Owners B/date |
This column displays the plan owner’s birth date. |
||||||||||||
Service Charge Code |
This column displays the service charge code. This comes from the retirement plan record (RPSVCD). |
||||||||||||
Service Charge Date |
This column displays the date the service charge is to be given (RPSVDT). |
||||||||||||
Service Charge Ct |
This column displays the service charge criteria code (RPCTCD). |
||||||||||||
Service Charge Fq |
This column indicates how often service charges are assessed. Valid service charge frequencies are:
|
Totals
The totals calculated at the end of the report include the number of plans, number of accounts, total of all balances, and the average balance. The total number of accounts for each IRA type are included with the Institution totals. If the report is set up to total plans, it will be included here also.
