Search Results ele_payroll_freq_rule_id

Overview

The PAY_ELE_PAYROLL_FREQ_RULES table is a core data structure within the Oracle E-Business Suite (EBS) Payroll module (PAY). It serves as a configuration table that defines the frequency rules governing how specific deductions or earnings (elements) are processed in relation to a particular payroll. Its primary role is to establish the temporal logic for element payments, dictating the periods over which calculations are applied and reset. This table is essential for ensuring that payroll calculations adhere to complex, organization-specific payment schedules and compliance requirements.

Key Information Stored

The table stores the linkage between an element type, a payroll, and its associated frequency rule. Key columns include the surrogate primary key, ELE_PAYROLL_FREQ_RULE_ID, and the unique combination of ELEMENT_TYPE_ID and PAYROLL_ID, which together define the specific rule. The BUSINESS_GROUP_ID column provides multi-org security, scoping the rule to a specific business unit. A critical column is RESET_PERIOD_TYPE, which references a time period type (e.g., Calendar Month, Fiscal Quarter) to define the cycle over which the rule's calculations or limits are reset. This structure allows for precise control over payment timing and accumulation periods.

Common Use Cases and Queries

A primary use case is auditing and troubleshooting payroll calculation results. For instance, if a deduction is not appearing on an employee's payslip as expected, a consultant might query this table to verify a frequency rule exists for the relevant element and payroll. Common SQL patterns include joining to element and payroll definitions.

• To list all frequency rules for a specific payroll: SELECT * FROM pay_ele_payroll_freq_rules WHERE payroll_id = <payroll_id>;
• To find the reset period for a specific element and payroll combination: SELECT reset_period_type FROM pay_ele_payroll_freq_rules WHERE element_type_id = <element_id> AND payroll_id = <payroll_id>;
• For reporting, this table is often joined with PAY_ELEMENT_TYPES_F and PAY_ALL_PAYROLLS_F to produce user-friendly lists of configured rules.

Related Objects

The table maintains defined relationships with several other key HR and Payroll objects, as documented in the ETRM metadata.

• Referenced Foreign Keys: PAY_ELE_PAYROLL_FREQ_RULES references two tables:
  • HR_ALL_ORGANIZATION_UNITS via BUSINESS_GROUP_ID.
  • PER_TIME_PERIOD_TYPES via RESET_PERIOD_TYPE.
• Referencing Foreign Key: The table is referenced by one key Payroll object:
  • PAY_FREQ_RULE_PERIODS via ELE_PAYROLL_FREQ_RULE_ID. This child table holds the detailed period definitions (e.g., specific dates) that implement the high-level rule defined in the parent.