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: choose the type of detail to return:
    • 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
  • MeasDate (optional): the date to use when calculating the PIA detail. If omitted, DB Precision uses the current calculation date. Specify this parameter when the detail is needed as of a different date. When a date is supplied, existing calculation details for that exact date may be reused; otherwise, DB Precision calculates the PIA definition for that date.
Related Topics
PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com