Search Results ben_ded_sched_py_freq_pk

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:

DED_SCHED_PY_FREQ_ID — the surrogate primary key, enforced by the BEN_DED_SCHED_PY_FREQ_PK unique index. This is the internal identifier referenced by child tables.
PY_FREQ_CD — the pay frequency code, a primary business-key candidate describing the frequency at which the deduction is processed.
DFLT_FLAG — indicates whether this pay frequency is the default for the associated deduction schedule.
BUSINESS_GROUP_ID — the operating business group (legislative data group) under which the record is defined, supporting multi-tenant partitioning.
ACTY_RT_DED_SCHED_ID — the deduction schedule identifier linking the frequency to a specific activity rate deduction schedule.
DSQ_ATTRIBUTE_CATEGORY and DSQ_ATTRIBUTE1 through DSQ_ATTRIBUTE30 — a descriptive flexfield (DFF) block providing 30 flexfield segments plus a category for client-specific extensions.
LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE, OBJECT_VERSION_NUMBER — standard WHO audit columns and the optimistic-locking version number.

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.

Table: BEN_DED_SCHED_PY_FREQ 12.1.1
owner:BEN, object_type:TABLE, fnd_design_data:BEN.BEN_DED_SCHED_PY_FREQ, object_name:BEN_DED_SCHED_PY_FREQ, status:VALID, product: BEN - Advanced Benefits , description: Pay frequency for deduction schedule. , implementation_dba_data: BEN.BEN_DED_SCHED_PY_FREQ ,
INDEX: BEN.BEN_DED_SCHED_PY_FREQ_PK 12.2.2
owner:BEN, object_type:INDEX, object_name:BEN_DED_SCHED_PY_FREQ_PK, status:VALID,
Table: BEN_DED_SCHED_PY_FREQ 12.2.2
owner:BEN, object_type:TABLE, fnd_design_data:BEN.BEN_DED_SCHED_PY_FREQ, object_name:BEN_DED_SCHED_PY_FREQ, status:VALID, product: BEN - Advanced Benefits , description: Pay frequency for deduction schedule. , implementation_dba_data: BEN.BEN_DED_SCHED_PY_FREQ ,
INDEX: BEN.BEN_DED_SCHED_PY_FREQ_PK 12.1.1
owner:BEN, object_type:INDEX, object_name:BEN_DED_SCHED_PY_FREQ_PK, status:VALID,
TABLE: BEN.BEN_DED_SCHED_PY_FREQ 12.1.1
owner:BEN, object_type:TABLE, fnd_design_data:BEN.BEN_DED_SCHED_PY_FREQ, object_name:BEN_DED_SCHED_PY_FREQ, status:VALID,
TABLE: BEN.BEN_DED_SCHED_PY_FREQ 12.2.2
owner:BEN, object_type:TABLE, fnd_design_data:BEN.BEN_DED_SCHED_PY_FREQ, object_name:BEN_DED_SCHED_PY_FREQ, status:VALID,
PACKAGE BODY: APPS.BEN_DSQ_BUS 12.1.1
PACKAGE BODY: APPS.BEN_DSQ_BUS 12.2.2
PACKAGE BODY: APPS.BEN_DSQ_SHD 12.2.2
PACKAGE BODY: APPS.BEN_DSQ_SHD 12.1.1
12.1.1 DBA Data 12.1.1
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
APPS.BEN_DSQ_BUS dependencies on BEN_DED_SCHED_PY_FREQ 12.2.2
APPS.BEN_DSQ_BUS dependencies on BEN_DED_SCHED_PY_FREQ 12.1.1
APPS.BEN_DSQ_BUS dependencies on BEN_DSQ_SHD 12.2.2
APPS.BEN_DSQ_BUS dependencies on BEN_DSQ_SHD 12.1.1
APPS.BEN_DSQ_SHD dependencies on BEN_DED_SCHED_PY_FREQ 12.2.2
APPS.BEN_DSQ_SHD dependencies on BEN_DED_SCHED_PY_FREQ 12.1.1
APPS.BEN_DSQ_SHD dependencies on FND_MESSAGE 12.2.2
APPS.BEN_DSQ_SHD dependencies on FND_MESSAGE 12.1.1
APPS.BEN_DSQ_SHD dependencies on HR_UTILITY 12.1.1
APPS.BEN_DSQ_SHD dependencies on HR_UTILITY 12.2.2
eTRM - BEN Tables and Views 12.2.2
description: Start and End periods. ,
eTRM - BEN Tables and Views 12.1.1
description: Start and End periods. ,
eTRM - BEN Tables and Views 12.2.2
description: Start and End periods. ,
eTRM - BEN Tables and Views 12.1.1
description: Start and End periods. ,