Results for “pay_cost_allocations_f_pk”

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

Overview

PAY_COST_ALLOCATIONS_F is a date-tracked (datetrack) table owned by the HR schema that stores the cost allocation details for an assignment within Oracle Payroll (PAY). It defines how the payroll costs generated by an employee's assignment are distributed across one or more costing accounts, enabling organizations to charge labor expense to the appropriate general ledger accounts, departments, projects, or cost centers. The table operates within the Oracle E-Business Suite 12.1.1 and 12.2.2 data model as a fundamental component of the payroll costing and General Ledger transfer process.

From a Data Vault modeling perspective (heuristic classification derived from the foreign key structure), this table exhibits the characteristics of a link. It associates an assignment with a cost allocation keyflex, capturing the proportional relationship between the assignment and its designated cost distribution. This link-style classification reflects the object's role in resolving many-to-many relationships between workforce entities and costing structures, rather than serving as a pure hub (independent business key) or satellite (descriptive attributes).

Key Information Stored

The table contains 17 documented columns. The most significant are summarized below.

• COST_ALLOCATION_ID – Surrogate identifier for the cost allocation record. Together with the datetrack columns below, it forms the composite primary key.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE – Datetrack date range columns that define the validity period of the allocation record, enabling historical tracking of changes to cost distribution over time. These are part of the primary key PAY_COST_ALLOCATIONS_F_PK.
• BUSINESS_GROUP_ID – Identifies the enterprise or business group (organization) that owns the allocation; a foreign key to HR_ALL_ORGANIZATION_UNITS.
• COST_ALLOCATION_KEYFLEX_ID – References the keyflex definition in PAY_COST_ALLOCATION_KEYFLEX that holds the actual costing account segments (the target GL accounts).
• ASSIGNMENT_ID – The assignment to which the cost allocation applies.
• PROPORTION – The fraction or percentage of payroll cost directed to this allocation, used when an assignment's cost is split across multiple accounts.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE – Concurrent program and request audit columns identifying the process that created or modified the record.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE – Standard WHO audit columns.
• OBJECT_VERSION_NUMBER – Optimistic locking column used by the EBS framework to detect concurrent updates.

The surrogate primary key is COST_ALLOCATION_ID combined with the two datetrack columns; no separate business-key unique index is documented beyond this composite PK.

Common Use Cases and Queries

Costing administrators and payroll analysts query PAY_COST_ALLOCATIONS_F to verify how an assignment's costs are distributed, to reconcile payroll costing to the General Ledger, and to report on cost center utilization. Typical scenarios include auditing proportional splits across multiple accounts and tracing historical allocation changes via the datetrack columns.

SELECT ca.cost_allocation_id,
       ca.assignment_id,
       ca.proportion,
       ca.cost_allocation_keyflex_id,
       ca.effective_start_date,
       ca.effective_end_date
FROM   pay_cost_allocations_f ca
WHERE  ca.assignment_id = :assignment_id
AND    TRUNC(SYSDATE) BETWEEN ca.effective_start_date
                          AND ca.effective_end_date;

For reconciliation, joining to the keyflex table resolves the account segments; join to HR_ALL_ORGANIZATION_UNITS via BUSINESS_GROUP_ID validates enterprise context. Reporting queries frequently aggregate PROPORTION by keyflex to confirm that allocations sum to unity.

Related Objects

• PAY_COST_ALLOCATION_KEYFLEX – Joined via COST_ALLOCATION_KEYFLEX_ID; stores the account segment values for each allocation.
• HR_ALL_ORGANIZATION_UNITS – Joined via BUSINESS_GROUP_ID; provides business group context.
• PAY_ASSIGNMENT_ACTIONS / PER_ALL_ASSIGNMENTS_F – Source of the ASSIGNMENT_ID used by the allocation.
• PAY_RUN_RESULTS / PAY_COST_ALLOCATIONS – Related costing and payroll run output objects that consume allocation definitions.
• GL_JE_LINES – Receives the accounting entries generated from these allocations during the payroll-to-GL transfer.