GETSTATUS

Determines participant status as of the calculation date specified and returns the following:

  • 0: Ineligible
  • 1: Active
  • 2: Non-accruing
  • 3: Vested Terminated
  • 4: Disabled
  • 5: Retired
  • 6: Beneficiary
  • 7: Non-vested Term
  • 8: Cashed out
  • 9: Death
  • 10: Active (first active on determination date)
Formula Syntax

GETSTATUS(CalculationDate, LookupType)

CalculationDate: fixed date such as DATE(1,1,2020) or system date such as CALCDATEINPUT.

LookupType: refer to the following values to determine which type to use:

  • 0: use reconciliation (snapshot) status or, if unavailable, use actual data to determine status. When there are multiple runs on the same date, status for the row with the highest run number is returned.
  • 1: ignore reconciliation status and only use actual data
  • 2: only use reconciliation (snapshot) status
Examples

GETSTATUS(CALCDATEINPUT, 0) return status as of the calculation date that was input

PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com