Determines participant second status (if any) 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)

If there is no second status, -1 is returned.

GETSTATUS2(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
  • 1: ignore reconciliation status and only use actual data
  • 2: only use reconciliation (snapshot) status

• GETSTATUS2(CALCDATEINPUT, 0): return secondary status as of the calculation date