Search Results ben_elig_asnt_set_prte_f_pk

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:

• ELIG_ASNT_SET_PRTE_ID — surrogate identifier for the eligibility/assignment-set criterion row; part of the composite primary key.
• EFFECTIVE_START_DATE, EFFECTIVE_END_DATE — the DateTrack validity interval; together with the ID these form BEN_ELIG_ASNT_SET_PRTE_F_PK.
• ELIGY_PRFL_ID — the eligibility profile this criterion belongs to; the principal business-key join to the eligibility profile definition.
• ASSIGNMENT_SET_ID — the assignment set being tested against; the membership group whose assignment population is included or excluded.
• EXCLD_FLAG — controls whether matching assignments are excluded (Y) or included (N).
• BUSINESS_GROUP_ID — the HR business group (operating unit) owning the row.
• ORDR_NUM — sequence order in which this criterion is evaluated relative to other criteria.
• CRITERIA_SCORE, CRITERIA_WEIGHT — scoring values used when eligibility is determined by a scored/weighted model rather than a hard include/exclude.
• OBJECT_VERSION_NUMBER — optimistic-locking version for concurrent update control.
• EAN_ATTRIBUTE_CATEGORY and EAN_ATTRIBUTE1…EAN_ATTRIBUTE30 — a 30-column descriptive-flexfield block for customer-extensible attributes.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard WHO audit columns.

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

• BEN_ELIGY_PRFL — the eligibility profile joined via ELIGY_PRFL_ID.
• BEN_ELIG_PRFL_STAT_RULE and related BEN_ELIG_*_PRTE_F tables (person, organization, job, grade) that share the same criterion pattern.
• PER_ASSIGNMENT_SETS and PER_ASSIGNMENT_SET_MEMBERS — the HRMS assignment set definitions joined via ASSIGNMENT_SET_ID.
• BEN_ELIG_ASNT_SET_PRTE — any non-effective-dated counterpart view or synonym.
• BEN_COMP_OBJ_ELIGY — compensation object eligibility associations consuming these criteria.
• FND_FLEX_VALUES / FND_DESCR_FLEX_COL_USAGE — descriptive flexfield metadata for the EAN attribute columns.