Search Results backpay_set_id




Overview
Explore in AI Chat

Overview

The HR.PAY_BACKPAY_SETS table is a core data structure within Oracle E-Business Suite 12.1.1 and 12.2.2, specifically for the Oracle Payroll module. It functions as the master definition table for RetroPay (or backpay) sets. A RetroPay set is a user-defined configuration that groups specific payroll balances and element input values to be processed during a retroactive pay calculation. This table stores the high-level metadata for each set, such as its name and description, while the detailed rules for what is included in the calculation are stored in the related PAY_BACKPAY_RULES table. Its primary role is to provide a reusable template that can be referenced by payroll processes to ensure consistent and accurate retroactive calculations across different payroll runs and legislative environments.

Key Information Stored

The table's columns store essential identifiers, descriptive data, and audit information. The primary and unique identifier is BACKPAY_SET_ID (NUMBER). The BUSINESS_GROUP_ID (NUMBER) and LEGISLATION_CODE (VARCHAR2) columns provide the organizational and legislative context, scoping the set's usage. User-defined identifiers include BACKPAY_SET_NAME (VARCHAR2(30)) and DESCRIPTION (VARCHAR2(240)). A critical functional column is BACKPAY_SET_TYPE (VARCHAR2), which dictates the specific RetroPay or backpay process engine that handles the set. Standard Oracle EBS "Who" columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE) complete the row, providing full auditability.

Common Use Cases and Queries

This table is central to configuring and auditing retroactive pay. Common use cases include administrative setup, where HR or payroll managers create and maintain different RetroPay sets for various calculation scenarios (e.g., one set for salary adjustments, another for bonus recalculations). It is also frequently referenced in troubleshooting and reporting to verify which RetroPay set was used in a specific payroll run. A typical query to retrieve all defined sets for a business group would be:

SELECT backpay_set_id, backpay_set_name, description, backpay_set_type
FROM hr.pay_backpay_sets
WHERE business_group_id = :p_bg_id
ORDER BY backpay_set_name;

To investigate the usage of a specific set, one would join to PAY_PAYROLL_ACTIONS using the BACKPAY_SET_ID foreign key to find all payroll runs that invoked it.

Related Objects

PAY_BACKPAY_SETS has defined foreign key relationships with two critical payroll tables, forming the backbone of the RetroPay process:

  • PAY_BACKPAY_RULES: This is a direct child table. The foreign key from PAY_BACKPAY_RULES.BACKPAY_SET_ID references PAY_BACKPAY_SETS.BACKPAY_SET_ID. This relationship links the set definition to its detailed calculation rules.
  • PAY_PAYROLL_ACTIONS: The foreign key from PAY_PAYROLL_ACTIONS.BACKPAY_SET_ID references PAY_BACKPAY_SETS.BACKPAY_SET_ID. This relationship documents which RetroPay set was applied during a specific payroll action (run), providing a critical audit trail.

These relationships ensure data integrity, where a RetroPay set must exist before rules can be added to it, and it can be linked to payroll execution.