Results for “rbc_element_type_id”

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

Overview

PA_COMPENSATION_DETAILS_ALL is a Projects (PA) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores information about hourly employee cost rates and the compensation rules assigned to those employees. It is the operational repository that drives labor cost calculation for hourly-paid resources, linking a person to a compensation rule set and, optionally, to a rate schedule that determines how the hourly cost rate is derived over time. The table is owned by the PA schema and is fully valid in the documented release.

The primary key, PA_COMPENSATION_DETAILS_PK, is composed of PERSON_ID, START_DATE_ACTIVE, and ORG_ID. The presence of a unique business-key index, PA_COMPENSATION_DETAILS_U1, on the same three columns reinforces that this combination is the natural business identifier. Under the heuristic Data Vault classification mined from the foreign-key structure, this object is satellite-leaning. In modeling terms, it behaves as a satellite attached to a person hub (and an operating-unit hub), carrying descriptive and time-variant rate attributes rather than acting as an independent hub or a pure associative link.

Key Information Stored

The documented physical schema contains 30 columns. The most significant are:

• PERSON_ID — the employee or contingent worker whose compensation is defined; part of the primary key and unique index.
• START_DATE_ACTIVE / END_DATE_ACTIVE — the effective date range for the compensation record; START_DATE_ACTIVE is part of the primary key, enabling date-tracked rate history for a person.
• ORG_ID — the operating unit, part of the primary key and unique index, allowing the same person to carry separate compensation definitions per organization.
• COMPENSATION_RULE_SET — foreign key to PA_COMPENSATION_RULE_SETS, identifying the rule set applied to derive the cost rate.
• HOURLY_COST_RATE — the hourly cost rate value used when an override or direct rate is in effect.
• OVERRIDE_TYPE — indicates how the rate is overridden relative to the rule set logic.
• RATE_SCHEDULE_ID — foreign key to CN_RATE_SCHEDULES_ALL, linking to a rate schedule when rate derivation is schedule-driven.
• COST_RATE_CURRENCY_CODE — currency of the cost rate.
• ACCT_RATE_DATE_CODE, ACCT_RATE_TYPE, ACCT_EXCHANGE_RATE — the accounting rate date basis, rate type, and exchange rate used to convert the cost rate for accounting purposes.
• BASE_HOURS — the base hours associated with the compensation definition.
• RBC_ELEMENT_TYPE_ID — reference to the element type used in the rate-by-cost (RBC) calculation.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE10 — the standard Oracle descriptive flexfield columns for client-specific extensions.
• Who-audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical scenarios include resolving a person's effective hourly cost rate for a given date and operating unit, auditing rate-history changes, and validating that every active hourly resource has a compensation rule set assigned before running cost distribution or labor costing.

A common lookup retrieves the currently effective compensation row for a person:

• SELECT person_id, compensation_rule_set, hourly_cost_rate, cost_rate_currency_code, rate_schedule_id FROM pa_compensation_details_all WHERE person_id = :p_person AND org_id = :p_org AND TRUNC(SYSDATE) BETWEEN start_date_active AND NVL(end_date_active, TRUNC(SYSDATE));

Reporting queries frequently join to PA_COMPENSATION_RULE_SETS to describe the rule set name and to CN_RATE_SCHEDULES_ALL for schedule detail. Analysts also query OVERRIDE_TYPE distributions and BASE_HOURS to reconcile calculated versus defined rates, and use START_DATE_ACTIVE/END_DATE_ACTIVE to build slowly changing compensation histories for cost trend reports.

Related Objects

• PA_COMPENSATION_RULE_SETS — referenced via COMPENSATION_RULE_SET; defines the rule set governing rate derivation.
• CN_RATE_SCHEDULES_ALL — referenced via RATE_SCHEDULE_ID; supplies schedule-based rate values.
• PER_ALL_PEOPLE_F — joined on PERSON_ID to resolve the employee/assignment identity and effective dating.
• PA_COMPENSATION_DETAILS_ALL (base table and any associated _ALL/_TL variants) — access via standard PA compensation query views and concurrent programs.
• PA_COMPENSATION_RULE_SETS / rule-set assignment screens — the Projects compensation setup forms that create and maintain these rows.
• PER_ALL_ASSIGNMENTS_F — joined on PERSON_ID to align compensation with assignment and organization records.

The table therefore sits at the intersection of personnel data, compensation rule configuration, and rate scheduling, serving as the authoritative source for hourly labor cost rates within Oracle Projects.