Functionality
The database table Rtp_Us_Tot contains all the aggregated amounts ofthe retirement plans for a tax-year. If the batch job has been ran thatcalculates the fair market value of a retirement plan, this databasetable contains the fair market value as well. However, in alllikelyhood the fair market value of a retirement plan will only becalculated once a year. This function is intended to obtain the actualfair market value of a retirement plan in a given year.
The fair market value of a retirement plan can be obtained in two ways:
Directly by reading the fair market value from the database tableRtp_Us_Tot.
Indirectly by:
Reading the mutations made to the funds of the retirement plan fromdatabase table Rtp_Us_Hist.
Removing all entries (combinations of plan number and bank area) thatalready have been read from the database table Rtp_Us_Tot.
Summing the remaining mutation amounts, thereby removing "unwanted"amount like withholding amounts and fair market values amount (the lastamounts should not be present in the table!).
Reading the fair market value of the previous year from the databasetable Rtp_Us_Tot.
Summing the aggregated amounts obtained in step 'c' to the fair marketvalue of the previous year.
It may be clear that the second method is rather time consuming.