Results for “ben_elig_los_prte_f”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

BEN_ELIG_LOS_PRTE_F is a core configuration table in the Oracle Advanced Benefits (BEN) module. It identifies the length-of-service (LOS) requirements that determine whether a participant is included in or excluded from a compensation object, such as a plan, program, or option. Each row represents an eligibility rule that ties a length-of-service factor to a specific eligibility profile, together with timestamps and business-group scoping that allow the rule to be effective-dated and partitioned across legislative or organizational boundaries. In Oracle EBS 12.1.1 and 12.2.2, this table sits within the benefits eligibility engine and is evaluated for every participant processed by benefits eligibility batch programs.

From a heuristic Data Vault perspective, the mined foreign-key structure suggests a satellite-leaning classification. The table carries descriptive eligibility attributes (exclusion flags, criteria scoring, display ordering) that qualify an eligibility profile or LOS factor rather than acting as an independent business hub or an associative link. This is a modeling suggestion derived from the FK topology, not a formal declaration by Oracle.

Key Information Stored

The physical schema documents 47 columns. The most significant are:

• ELIG_LOS_PRTE_ID — the surrogate identifier for the eligibility LOS rule. This participates in the primary key BEN_ELIG_LOS_PRTE_F_PK along with the two date columns below.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the date-effective bounds that make every rule time-versioned. Together with the surrogate identifier they form the composite business key exposed by the unique index BEN_ELIG_LOS_PRTE_F_PK.
• LOS_FCTR_ID — foreign key to BEN_LOS_FCTR, pointing to the underlying length-of-service factor that supplies the service computation logic.
• ELIGY_PRFL_ID — identifies the eligibility profile to which this LOS rule belongs, linking the rule into a broader eligibility definition.
• EXCLD_FLAG — the inclusion/exclusion switch. A value indicating exclusion reverses the rule so that participants meeting the LOS condition are removed rather than admitted.
• BUSINESS_GROUP_ID — the operating-unit scope for the rule.
• ORDR_NUM — the evaluation ordering used when multiple LOS rules are processed against a profile.
• CRITERIA_SCORE / CRITERIA_WEIGHT — scoring and weighting values used by derived or scored eligibility evaluation.
• ELS_ATTRIBUTE_CATEGORY and ELS_ATTRIBUTE1 through ELS_ATTRIBUTE30 — the descriptive flexfield segment columns, providing attribute-category identification and thirty segment values on this table.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER — the standard audit and optimistic-locking columns.

Common Use Cases and Queries

Typical reporting scenarios include auditing which plans require a given length of service, reconstructing the eligibility rules in effect on a historical date, and validating that exclusion rules are configured as intended. Because the table is date-effective, queries should always constrain the effective window to a single point in time to avoid returning multiple versions of the same rule.

A representative query joining the LOS factor and eligibility profile definitions:

• SELECT p.ELIG_LOS_PRTE_ID, p.ELIGY_PRFL_ID, p.EXCLD_FLAG, p.ORDR_NUM, f.LOS_FCTR_ID
  FROM BEN.BEN_ELIG_LOS_PRTE_F p, BEN.BEN_LOS_FCTR f
  WHERE p.LOS_FCTR_ID = f.LOS_FCTR_ID
  AND p.BUSINESS_GROUP_ID = :p_bg_id
  AND TRUNC(SYSDATE) BETWEEN p.EFFECTIVE_START_DATE AND p.EFFECTIVE_END_DATE;

Additional uses include reconciling eligibility rule counts per profile, generating configuration migration scripts between instances, and root-causing participants who were unexpectedly excluded by reviewing the EXCLD_FLAG value on their qualifying rows.

Related Objects

• BEN_LOS_FCTR — joined on LOS_FCTR_ID; holds the length-of-service factor referenced by each rule.
• BEN_ELIG_PRFL_F — the eligibility profile header to which ELIGY_PRFL_ID logically relates.
• BEN_ELIG_PRFL_DF — the date-effective eligibility profile detail rows that consume these rules.
• BEN_ELIG_PPL_STAT_F and other BEN_ELIG_*_F eligibility rule tables — sibling rule tables evaluated alongside this one by the eligibility engine.
• BEN_LOS_FCTR_DF — detail rows defining the LOS factor calculation behind LOS_FCTR_ID.

All joins should respect the documented effective-dating and BUSINESS_GROUP_ID scoping to remain consistent with how the Benefits engine itself resolves these rows.