Search Results ben_elig_asnt_set_prte_f




Overview
Explore in AI Chat

Overview

BEN_ELIG_ASNT_SET_PRTE_F is a date-tracked (non-"_F" suffix notwithstanding, an effective-dated) table in the BEN schema of Oracle E-Business Suite Advanced Benefits (Oracle Benefits). It identifies the assignment sets associated with a given eligibility profile, and defines whether members of those assignment sets are included in or excluded from a compensation object evaluated during the eligibility determination process. Each row represents a single participation/eligibility rule that links an eligibility profile to an assignment set, with an include/exclude disposition.

Assignment sets are defined in Oracle HRMS and are used to group assignments (typically by organization, location, job, grade, or payroll) for mass processing and population-based eligibility. Within the benefits eligibility engine, BEN_ELIG_ASNT_SET_PRTE_F acts as the assignment-set counterpart to the person-type, organization, job, and other eligibility criteria tables. The suffix "_F" denotes that the row is part of an effective-dated (DateTrack) entity, meaning historical and future-dated changes are preserved through the EFFECTIVE_START_DATE and EFFECTIVE_END_DATE interval columns.

From a Data Vault modeling standpoint, the metadata heuristic classifies this object as standalone. In Data Vault terms it behaves most like a satellite attached to the eligibility-profile business key, rather than a pure hub or link, because it carries descriptive criteria attributes plus an effective-dated validity window. This is a modeling suggestion only; the physical table itself is a conventional EBS DateTrack entity with no declared foreign keys in the documented metadata.

Key Information Stored

The most significant columns are:

The surrogate primary key is (ELIG_ASNT_SET_PRTE_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE), which is also the sole documented unique index and therefore the business-key candidate. Note there is no separate ID-only unique index, so queries must always supply the date interval to guarantee a unique row.

Common Use Cases and Queries

Typical uses include auditing which assignment sets drive a compensation object's eligibility, troubleshooting why a population was excluded, and reporting current eligibility criteria for a plan or program.

Retrieve current criteria for an eligibility profile:

SELECT prte.eligy_prfl_id, prte.assignment_set_id, prte.excld_flag
FROM ben.ben_elig_asnt_set_prte_f prte
WHERE prte.eligy_prfl_id = :p_profile_id
AND SYSDATE BETWEEN prte.effective_start_date AND prte.effective_end_date;

Identify exclusion rules only:

SELECT prte.elig_asnt_set_prte_id, prte.assignment_set_id
FROM ben.ben_elig_asnt_set_prte_f prte
WHERE prte.excld_flag = 'Y';

As-of historical reporting uses the effective dates directly, since DateTrack preserves prior versions.

Related Objects