Search Results ben_ded_sched_py_freq




Overview
Explore in AI Chat

Overview

BEN_DED_SCHED_PY_FREQ is a table in the BEN schema belonging to the Oracle Advanced Benefits (BEN) product module. As its description states, it stores the pay frequency configuration associated with a deduction schedule. Within Oracle EBS 12.1.1 and 12.2.2, this table acts as the linkage between a deduction schedule definition and the payroll frequency at which that deduction should be processed, such as monthly, semi-monthly, biweekly, or weekly.

From a modeling perspective, the ETRM metadata classifies this object as hub-leaning based on its foreign key structure. The table is referenced by two downstream tables (BEN_ACTY_RT_DED_SCHED_F and BEN_PERD_TO_PROC), and it carries a single primary key column, which suggests it behaves as a hub or reference entity rather than a transactional link. This classification is heuristic and should be treated as a modeling suggestion rather than a documented designation.

Key Information Stored

The table contains 42 documented columns. The most significant include:

The business-key candidate is DED_SCHED_PY_FREQ_ID via the unique index; there is no separate composite unique constraint documented over PY_FREQ_CD.

Common Use Cases and Queries

Typical reporting scenarios include identifying the default pay frequency for a given deduction schedule, listing all frequencies defined for a deduction schedule, and joining the frequency to downstream activity rate and payroll period records.

  • Retrieve all frequencies for a deduction schedule: SELECT DED_SCHED_PY_FREQ_ID, PY_FREQ_CD, DFLT_FLAG FROM BEN.BEN_DED_SCHED_PY_FREQ WHERE ACTY_RT_DED_SCHED_ID = :p_id AND BUSINESS_GROUP_ID = :p_bg_id
  • Isolate the default: SELECT PY_FREQ_CD FROM BEN.BEN_DED_SCHED_PY_FREQ WHERE DFLT_FLAG = 'Y' AND ACTY_RT_DED_SCHED_ID = :p_id
  • Join to downstream activity rate deductions: SELECT f.PY_FREQ_CD, a.* FROM BEN.BEN_DED_SCHED_PY_FREQ f, BEN.BEN_ACTY_RT_DED_SCHED_F a WHERE f.DED_SCHED_PY_FREQ_ID = a.DED_SCHED_PY_FREQ_ID

These queries support benefits administration reporting, deduction schedule validation, and audit of pay frequency configuration.

Related Objects

  • BEN_ACTY_RT_DED_SCHED_F — references BEN_DED_SCHED_PY_FREQ via DED_SCHED_PY_FREQ_ID; carries activity rate deduction schedule flexfield data.
  • BEN_PERD_TO_PROC — references BEN_DED_SCHED_PY_FREQ via DED_SCHED_PY_FREQ_ID; defines periods to process for the associated schedule.
  • BEN_DED_SCHED_PY_FREQ_PK — the primary key unique index enforcing row uniqueness on DED_SCHED_PY_FREQ_ID.

Because the object is a hub-leaning reference entity, dependent records in the two foreign-key tables rely on the surrogate key, and any change to DED_SCHED_PY_FREQ_ID must preserve referential integrity across those children.