Search Results accrual_band_id

Overview

The PAY_ACCRUAL_BANDS table is a core data object within the Oracle E-Business Suite Payroll module (PAY). It is owned by the HR schema and is designated as VALID in both the 12.1.1 and 12.2.2 releases. Its primary function is to store the length-of-service band definitions that are integral to the calculation of paid time off (PTO) accruals. The table enables the configuration of tiered accrual rates, where the rate at which an employee accrues leave (e.g., vacation, sick time) changes based on their duration of service with the organization. This table acts as a child to the accrual plan definition, allowing for complex, service-based accrual rule modeling.

Key Information Stored

The table's structure is designed to define the boundaries and rates for each service band within an accrual plan. The primary key is ACCRUAL_BAND_ID, which uniquely identifies each band record. The most critical columns include ACCRUAL_PLAN_ID, which links the band to its parent plan in PAY_ACCRUAL_PLANS, and BUSINESS_GROUP_ID, which secures the data to a specific organizational unit via HR_ALL_ORGANIZATION_UNITS. Other essential columns typically define the band's service range (e.g., FROM_AGE, TO_AGE or FROM_SERVICE, TO_SERVICE measured in days or months) and the accrual rate or amount (e.g., ACCRUAL_RATE, ACCRUAL_AMOUNT) applicable within that band. The table may also include columns for processing priority or sequencing of bands.

Common Use Cases and Queries

The primary use case is the administration and reporting of tiered leave accrual plans. Payroll administrators use this data to configure and maintain how accruals progress over an employee's career. Common reporting needs include listing all bands for a specific accrual plan to verify configuration or auditing accrual rates for a given length of service. A typical query would join to the accrual plan table to retrieve a human-readable plan name.

• Sample Query: Retrieving all service bands for a specific accrual plan.
  SELECT pab.accrual_band_id, pap.accrual_plan_name, pab.from_service, pab.to_service, pab.accrual_rate FROM pay_accrual_bands pab, pay_accrual_plans pap WHERE pab.accrual_plan_id = pap.accrual_plan_id AND pap.accrual_plan_name = 'STANDARD_VACATION' ORDER BY pab.from_service;
• Process Flow: During payroll or absence accrual processes, the engine references this table to determine the correct accrual rate for an employee based on their calculated length of service, applying the rate from the band into which their service falls.

Related Objects

PAY_ACCRUAL_BANDS is centrally connected to several key payroll objects. Its two documented foreign key relationships are fundamental:

• PAY_ACCRUAL_PLANS: This is the direct parent table. The ACCRUAL_PLAN_ID foreign key ensures every service band is associated with a defined accrual plan.
• HR_ALL_ORGANIZATION_UNITS: The BUSINESS_GROUP_ID foreign key enforces data security at the Business Group level, a core multi-org principle in Oracle HRMS.

While not listed in the provided metadata, this table is also intrinsically linked to the accrual calculation engine and is likely referenced by key payroll tables such as PAY_ACCRUAL_PERIODS and PAY_ACCRUAL_BALANCES. Data in this table is typically maintained via the Oracle HRMS professional forms or relevant accrual plan APIs, not via direct SQL manipulation.