GETPIADETAIL

Extracts calculation detail for a PIA Definition.

Formula Syntax

GETPIADETAIL("DefName", Type, MeasDate (optional))

"DefName": the name of the item for which you need additional detail. This name must be enclosed in quotes.

Type: refer to the table below to determine the type code to use:

MeasDate: this is the date as of which the amount determination is to be made for purposes of getting the requested detail.

If no date is passed here, DB Precision will measure as of the end date passed and if any calculation has already been done on or after the end date, the system will pull calculation details from those results.

This date generally only needs to be specified if you need to specify an exact calculation and account determination date (that is then equal to this date) for determining this detail.

Type
  • 0: Amount
  • 1: Benefit Amount on First Eligibility Date
  • 2: Benefit Amount on Social Security Retirement Date
  • 3: Early Adjustment Factor
  • 4: Late Adjustment Factor
  • 5: Law Year
  • 6: SSRD
  • 7: Benefit Eligibility Date
  • 8: Benefit Start Date
  • 9: Averaging Computation Years
  • 10: Averaging Computation - First Year
  • 11: Averaging Computation - Final Year
  • 12: Average Indexed Monthly Earnings - AIME
  • 13: Bend Point 1
  • 14: Bend Point 2
  • 15: Sum of Index Earnings
  • 16: Special Minimum
  • 17: Special Minimum Years
PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com