Compensation Eligibility Status

Summary:

Content (required):

Hello everyone,

I'm currently trying to create a Value Set that will get me the Compensation Plan ID and the Compensation Eligibility Status in order to create a Fast Formula that will exclude from Plan B the population that is eligible to Plan A. Although, I'm facing difficulty to find the correct table and column for Compensation Eligibility Status.

I have found that in table: CMP_CWB_STORED_PERSON_DATA there is this column: PLAN_ELIG_FLAG but it does not seem to return the correct data when working on Data Model.

For example, for a specific Person Number=XXXX, the Data Model returns all these data. This can not be correct since the Employee is not eligible to all these Plans.