Results for “accrual_plan_element_type_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PAY_ACCRUAL_PLANS is the definitional table for Paid Time Off (PTO) accrual plans within the Oracle EBS Payroll (PAY) module. It resides in the HR schema and stores the configuration that governs how accrual balances are calculated, banded, and reported for employee populations. Each row represents a single accrual plan — an absence or leave policy such as vacation, sick leave, or personal time — and carries the formulas, element references, and eligibility rules that drive the payroll accrual process.

Because PTO accrual processing relies on element entries, balance feeds, and fast formulas, PAY_ACCRUAL_PLANS acts as the central definition record that ties those components together. Payroll administrators and implementers define plans here before assigning them to employees, and the payroll run then consumes the plan configuration to compute accrual amounts and post them to balances.

With respect to Data Vault modeling, the metadata classifies this table as hub-leaning: it holds a stable, unique business key (the accrual plan) surrounded by descriptive and reference attributes, which is characteristic of a hub with attached descriptive context. The physical schema exposes 60 columns, and the primary key is documented as PAY_ACCRUAL_PLANS_PK on ACCRUAL_PLAN_ID.

Key Information Stored

The surrogate primary key is ACCRUAL_PLAN_ID, which uniquely identifies each plan and is the column referenced by dependent tables. BUSINESS_GROUP_ID is the principal business-key candidate and organizational scoping column; it is a foreign key to HR_ALL_ORGANIZATION_UNITS and ties the plan to a legislative or business group. ACCRUAL_PLAN_NAME provides the user-facing identifier for the plan.

Accrual behavior is driven by a set of formula and element references. ACCRUAL_FORMULA_ID, INELIGIBILITY_FORMULA_ID, PAYROLL_FORMULA_ID, and CO_FORMULA_ID point to the fast formulas executed during accrual, ineligibility, and carryover processing. ACCRUAL_PLAN_ELEMENT_TYPE_ID, TAGGING_ELEMENT_TYPE_ID, BALANCE_ELEMENT_TYPE_ID, and DEFINED_BALANCE_ID link the plan to the payroll elements and balance definitions that store and track the accrued amounts. PTO_INPUT_VALUE_ID, CO_INPUT_VALUE_ID, CO_DATE_INPUT_VALUE_ID, CO_EXP_DATE_INPUT_VALUE_ID, RESIDUAL_INPUT_VALUE_ID, and RESIDUAL_DATE_INPUT_VALUE_ID identify the input values used for carryover and residual balances.

Policy attributes include ACCRUAL_CATEGORY, ACCRUAL_START, ACCRUAL_UNITS_OF_MEASURE (such as hours or days), INELIGIBLE_PERIOD_LENGTH, and INELIGIBLE_PERIOD_TYPE, which together describe how and when accrual begins and when employees are excluded. DESCRIPTION and INELIGIBLE_PERIOD_TYPE supply administrative context, while the INFORMATION_CATEGORY and INFORMATION1 through INFORMATION30 columns provide thirty user-defined flexfields for client-specific attributes. Standard audit columns include OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical usage centers on plan discovery, dependency analysis, and accrual reconciliation. A common query lists all active plans for a business group:

• SELECT accrual_plan_id, accrual_plan_name, accrual_category, accrual_units_of_measure FROM pay_accrual_plans WHERE business_group_id = :p_business_group_id;
• Joining to PAY_ACCRUAL_BANDS on accrual_plan_id to inspect the banded accrual rates assigned to a plan.
• Joining to PAY_NET_CALCULATION_RULES on accrual_plan_id to determine which net calculation rules reference a given plan, useful before retire or purge activities.
• Reverse lookups from a payroll element or formula to locate the owning plan when troubleshooting accrual calculation errors.
• Extract queries that read the INFORMATION flexfield columns for downstream reporting or data warehouse loads.

Reporting use cases include auditing which plans are attached to which formulas, verifying balance element configuration, and identifying plans whose eligibility rules or carryover input values are incomplete.

Related Objects

The most significant related objects, based on documented foreign key relationships, include:

• HR_ALL_ORGANIZATION_UNITS — referenced via PAY_ACCRUAL_PLANS.BUSINESS_GROUP_ID; identifies the business group owning the plan.
• PAY_ACCRUAL_BANDS — references PAY_ACCRUAL_PLANS.ACCRUAL_PLAN_ID; holds the accrual bands and rates for each plan.
• PAY_NET_CALCULATION_RULES — references PAY_ACCRUAL_PLANS.ACCRUAL_PLAN_ID; defines net-to-gross calculation rules associated with the plan.
• Payroll element and formula definitions (FF_FORMULAS, PAY_ELEMENT_TYPES) — referenced indirectly through the formula ID and element type ID columns.
• Balance definitions (PAY_BALANCES) — linked through DEFINED_BALANCE_ID and BALANCE_ELEMENT_TYPE_ID for tracking accrued amounts.

Because ACCRUAL_PLAN_ID is a parent key for PAY_ACCRUAL_BANDS and PAY_NET_CALCULATION_RULES, any data cleanup or plan retirement must account for those child records before deleting or updating a plan definition.