Determines the total amount of benefits paid between the start date and end date specified (based upon benefit payment information stored for a person).

GETRETAMT(StartDate, EndDate, AmountType, StateLocalCode)

• StartDate: Date from which amount is to be measured. This may be a fixed date such as DATE(1,1,2015) or system date such as CALCDATE.
• EndDate: Date to which amount is to be measured. This may be a fixed date such as DATE(1,1,2015) or system date such as CALCDATE.
• AmountType: please refer to the following to determine amount type to use:
  • 0: Gross retirement benefit
  • 1: Non-taxable benefit
  • 2: Taxable benefit
  • 3: Federal withholding
  • 4: State withholding
  • 5: Local withholding
  • 6: Medical withholding
  • 7: Other withholding
  • 8: Net benefit amount
  • 9: Final non-taxable payment date
• StateLocalCode: not used. Enter 0 for now.

• GETRETAMT(ACD, CALCDATEINPUT, 0, 0): returns the total gross retirement benefit paid since ACD as of the calculation date.