Which table can confirm if an employee has an active workforce compensation plan?

Summary:

We need a logic in the fast formula to confirm if an employee has an active workforce compensation plan.

We want to know which database table holds the plan status at employee level?

• We have checked CMP_CWB_PERSON_INFO and that table still holds the person comp data even if removed from the plan after termination.

There must be another table which holds this data.