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