Results for “pa_compensation_rule_sets”

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

Overview

PA_COMPENSATION_RULE_SETS is an Oracle Projects (PA) implementation table that stores user-defined classifications of employee compensation, commonly referred to as pay types. Each row defines a compensation rule set that governs how labor costs are calculated, accrued, and allocated to projects and tasks. The table resides in the PA schema and is marked VALID in the ETRM 12.2.2 physical schema, which documents 32 columns. Compensation rule sets act as the central reference for labor costing behavior, determining costing methods, rate sources, overtime expenditure allocation, and accrual or planning flags that downstream labor distribution and costing processes rely upon.

From a Data Vault modeling perspective, the heuristic classification of this object is hub-leaning. PA_COMPENSATION_RULE_SETS behaves as a business concept hub that anchors several dependent satellite and link structures, with transactions and defaults referencing it through foreign keys rather than the reverse.

Key Information Stored

The surrogate primary key is PA_COMPENSATION_RULE_SETS_PK, defined on the COMPENSATION_RULE_SET column. A unique index, PA_COMPENSATION_RULE_SETS_U1, also covers COMPENSATION_RULE_SET, making it the business-key candidate for this entity. The most significant columns include:

• COMPENSATION_RULE_SET — the primary business identifier and primary key of the rule set.
• START_DATE_ACTIVE / END_DATE_ACTIVE — define the effective date range during which the rule set is active.
• COSTING_METHOD — identifies how labor costs are calculated for the pay type.
• RATE_SOURCE_CODE — specifies the source from which rates are derived.
• ALLOCATED_OVERTIME_EXP_TYPE — foreign key to PA_EXPENDITURE_TYPES, defining the expenditure type used for allocated overtime.
• PROJECT_ID — foreign key to PA_PROJECTS_ALL, optionally scoping the rule set to a project.
• TASK_ID — foreign key to PA_TASKS, optionally scoping the rule set to a task.
• ENABLE_ACCRUAL_CODE — controls whether accrual processing is enabled.
• ENABLE_PLANNING_CODE — controls whether planning is enabled for the rule set.
• TOTAL_TIME_COSTING_CODE — governs whether total-time costing applies.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield columns for extensible, customer-defined attributes.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Compensation rule sets are queried during labor costing setup, pay type reporting, and audit of overtime allocation configuration. A typical pattern joins the rule set to its referenced projects and tasks to resolve scoping:

• Reporting active pay types: SELECT compensation_rule_set, costing_method, rate_source_code FROM pa_compensation_rule_sets WHERE SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);
• Resolving project and task context: joining PROJECT_ID to PA_PROJECTS_ALL and TASK_ID to PA_TASKS.
• Overtime allocation analysis: joining ALLOCATED_OVERTIME_EXP_TYPE to PA_EXPENDITURE_TYPES.
• Impact analysis before changes: querying dependent rows in PA_COMPENSATION_DETAILS_ALL, PA_COMP_OT_EXP_TYPES, and PA_COMP_RULE_OT_DEFAULTS_ALL by COMPENSATION_RULE_SET.

Related Objects

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

• PA_COMPENSATION_DETAILS_ALL — references PA_COMPENSATION_RULE_SETS via COMPENSATION_RULE_SET.
• PA_COMP_OT_EXP_TYPES — references it via LABOR_COSTING_RULE.
• PA_COMP_RULE_OT_DEFAULTS_ALL — references it via COMPENSATION_RULE_SET.
• PA_ORG_LABOR_SCH_RULE — references it via LABOR_COSTING_RULE.
• PA_EXPENDITURE_TYPES — referenced by ALLOCATED_OVERTIME_EXP_TYPE.
• PA_PROJECTS_ALL — referenced by PROJECT_ID.
• PA_TASKS — referenced by TASK_ID.