Search Results pay_freq_rule_periods




Overview
Explore in AI Chat

Overview

The PAY_FREQ_RULE_PERIODS table is a core data object within the Oracle E-Business Suite Payroll module (PAY). It is owned by the HR schema and is integral to the system's configuration of deduction and payment frequencies. As indicated by its description, this table stores the specific frequency rule for a given combination of a deduction and a payroll. This functionality is critical for ensuring that recurring deductions, such as loan repayments, union dues, or garnishments, are correctly applied according to a defined schedule within each payroll processing cycle. The table's validity in both releases 12.1.1 and 12.2.2 underscores its stable, foundational role in the payroll architecture.

Key Information Stored

The table's primary key is the FREQ_RULE_PERIOD_ID, a unique system-generated identifier for each frequency rule period record. Two critical foreign key columns establish its relationships within the HR and Payroll data model. The ELE_PAYROLL_FREQ_RULE_ID column links to the PAY_ELE_PAYROLL_FREQ_RULES table, which defines the overarching frequency rule for an element entry on a specific payroll. The BUSINESS_GROUP_ID column links to HR_ALL_ORGANIZATION_UNITS, thereby securing the rule within the appropriate business group for data security and partitioning (Multi-Org). While the specific descriptive columns for the frequency period (e.g., period type, duration, anchor dates) are not detailed in the provided excerpt, this table is the child entity where the concrete, periodic schedule derived from its parent rule is stored.

Common Use Cases and Queries

This table is primarily accessed for auditing, troubleshooting, and reporting on deduction schedules. A common scenario involves investigating why a particular deduction did not occur in a payroll run. A technical consultant or analyst would trace from the element entry through the frequency rule to the periods stored in this table. A typical diagnostic query would join PAY_FREQ_RULE_PERIODS to PAY_ELE_PAYROLL_FREQ_RULES and the element entry tables. Reporting use cases include generating a list of all active deduction schedules for an employee or payroll, which requires querying this table to understand the effective periodicity. Direct manipulation of data in this table via SQL is strongly discouraged; changes should be made through the standard Oracle Payroll APIs or the applicable forms to maintain business logic integrity.

Related Objects

The table maintains documented foreign key relationships with two key objects, defining its place in the data model:

  • PAY_ELE_PAYROLL_FREQ_RULES: This is the primary parent table. The relationship is defined by the column PAY_FREQ_RULE_PERIODS.ELE_PAYROLL_FREQ_RULE_ID referencing PAY_ELE_PAYROLL_FREQ_RULES. This links the stored period details to the master frequency rule definition.
  • HR_ALL_ORGANIZATION_UNITS: The relationship via PAY_FREQ_RULE_PERIODS.BUSINESS_GROUP_ID enforces business group context and security, a standard pattern across HRMS tables.
As a child of PAY_ELE_PAYROLL_FREQ_RULES, PAY_FREQ_RULE_PERIODS is also indirectly related to core payroll tables such as PAY_ELEMENT_ENTRIES_F and PAY_PAYROLLS_F, which feed into the rule definition.