Search Results ben_ptd_lmt_f_fk3

Overview

BEN.BEN_PTD_LMT_F is a date-effective (datetracked) configuration table in the Oracle E-Business Suite Benefits (BEN) schema. It defines period-to-date (PTD) limits that are applied to the results of participant contributions or distributions. During benefits processing, the values stored in this table are compared against balances derived from PAY_RUN_RESULT_VALUES for the periods configured in the associated calculation rule. These limits typically enforce government-mandated maximum contribution thresholds, commonly expressed as plan year-to-date or calendar year-to-date caps.

From a data-modeling perspective, the table is best classified as a satellite-leaning entity. It holds descriptive, attribute-rich configuration rows keyed by a surrogate identifier and delimited by effective dates, rather than acting as a transaction hub or an associative link. The primary key BEN_PTD_LMT_F_PK, composed of PTD_LMT_ID, EFFECTIVE_END_DATE, and EFFECTIVE_START_DATE, demonstrates the datetrack pattern that allows multiple historical versions of the same limit definition to coexist.

Key Information Stored

The table stores 49 documented columns. The most operationally significant are:

• PTD_LMT_ID — system-generated surrogate primary key identifying each limit record.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — date-effective boundaries that, combined with PTD_LMT_ID, form the unique business-key candidate in BEN_PTD_LMT_F_PK.
• NAME — the descriptive name of the period-to-date limit.
• BUSINESS_GROUP_ID — foreign key to HR_ORGANIZATION_UNITS, scoping the limit to an enterprise or business group; indexed by BEN_PTD_LMT_F_FK1.
• BALANCE_TYPE_ID — references the balance type whose accumulated value is being capped; indexed by BEN_PTD_LMT_F_FK3.
• LMT_DET_CD — the limit determination code that controls how the limit is evaluated.
• COMP_LVL_FCTR_ID — foreign key to BEN_COMP_LVL_FCTR, defining any compensation-level factor applied.
• MX_COMP_TO_CNSDR, MX_VAL, MX_PCT_VAL — the maximum compensation to consider, the absolute maximum value, and the maximum percentage value used in limit computation.
• PTD_LMT_CALC_RL — the calculation rule governing limit evaluation; indexed by BEN_PTD_LMT_F_N1.
• PDL_ATTRIBUTE_CATEGORY and PDL_ATTRIBUTE1–30 — a descriptive flexfield (DFF) structure and its segment columns for extensibility.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, OBJECT_VERSION_NUMBER — standard who-columns and optimistic locking support.

Common Use Cases and Queries

Typical use cases include validating contribution caps during benefits processing, auditing limit configurations for compliance reporting, and reconciling accumulated balances against statutory maximums. A representative query retrieving active limits by balance type follows:

• SELECT ptd_lmt_id, name, balance_type_id, mx_val, mx_pct_val, ptd_lmt_calc_rl FROM ben_ptd_lmt_f WHERE balance_type_id = :p_balance_type_id AND TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date AND business_group_id = :p_bg_id;
• Reporting on effective-dated history: SELECT ptd_lmt_id, name, effective_start_date, effective_end_date FROM ben_ptd_lmt_f WHERE ptd_lmt_id = :p_id ORDER BY effective_start_date DESC;
• Joining to the compensation level factor: SELECT l.name, f.name FROM ben_ptd_lmt_f l, ben_comp_lvl_fctr f WHERE l.comp_lvl_fctr_id = f.comp_lvl_fctr_id;

Because PTD_LMT_CALC_RL and LMT_DET_CD drive algorithmic behavior, ad hoc reporting should generally avoid modifying them outside the Benefits configuration UI.

Related Objects

The following objects are most frequently associated with BEN_PTD_LMT_F:

• BEN.BEN_COMP_LVL_FCTR — referenced via COMP_LVL_FCTR_ID; supplies compensation-level factor definitions.
• HR.HR_ORGANIZATION_UNITS — referenced via BUSINESS_GROUP_ID; defines the business group scope.
• PAY.PAY_RUN_RESULT_VALUES — the source of accumulated balances compared against these limits.
• BEN.BEN_PTD_LMT_F_PK (index) — unique index enforcing the surrogate/key combination.
• BEN.BEN_PTD_LMT_F_FK1, _FK3, _N1 (indexes) — non-unique indexes supporting joins on business group, balance type, and calculation rule.

The table participates in the broader Benefits limit configuration model and is consumed by payroll/benefits calculation routines that evaluate whether a participant's period-to-date balance has exceeded the defined cap. It is not generally referenced by other foreign keys, reinforcing its satellite classification within the schema.