Search Results acct_rate_date_code




Overview
Explore in AI Chat

Overview

PA_ORG_LABOR_SCH_RULE is an Oracle Projects (PA) table that stores labor costing rule and rate schedule assignments for organizations. It defines, at the organization level, which labor costing rule (compensation rule set), cost rate schedule, forecast cost rate schedule, and overtime treatment should be applied when project labor costs are calculated. This table sits at the intersection of organization setup and project costing configuration, and it serves as the source of the configuration snapshot that is stamped onto cost distribution lines when labor is processed.

From a data modeling perspective, the heuristic Data Vault classification derived from its foreign key structure is satellite-leaning. PA_ORG_LABOR_SCH_RULE functions primarily as a descriptive satellite: it holds a versioned set of attributes (rules, schedules, overtime defaults, effective dates) attached to an organization business key, with ORG_LABOR_SCH_RULE_ID acting as the surrogate primary key. Modelers should treat it as an effectivity-dated satellite anchored to the organization hub rather than as an independent hub or a pure link table.

Key Information Stored

The table contains 20 documented columns in ETRM 12.2.2. The most significant columns are:

Common Use Cases and Queries

The table is most frequently queried to determine which rate schedule or costing rule was active for an organization on a given date, to reconcile labor costs against the configuration used during cost distribution, and to audit configuration changes across effective periods.

A typical query resolves the active rule for an organization on a specific date:

  • SELECT organization_id, labor_costing_rule, cost_rate_sch_id, forecast_cost_rate_sch_id, start_date_active, end_date_active FROM pa.pa_org_labor_sch_rule WHERE org_id = :p_org_id AND organization_id = :p_organization_id AND TRUNC(:p_effective_date) BETWEEN start_date_active AND NVL(end_date_active, TRUNC(SYSDATE));

Because PA_COST_DISTRIBUTION_LINES_ALL and PA_COST_DIST_LINES_AR carry ORG_LABOR_SCH_RULE_ID, a common reconciliation pattern joins cost distribution lines back to this table to explain why a particular rate was applied to a labor expenditure item. Reporting queries also aggregate multiple effective rows per organization to produce configuration history and to detect overlapping effectivity ranges. The table is frequently combined with HR_ALL_ORGANIZATION_UNITS to translate organization IDs into names for user-facing reports.

Related Objects

The following related objects are the most significant consumers or providers of data for PA_ORG_LABOR_SCH_RULE, based on the documented foreign key relationships:

  • HR_ALL_ORGANIZATION_UNITS — joined on ORGANIZATION_ID; supplies the organization definition.
  • PA_IMPLEMENTATIONS_ALL — joined on ORG_ID; supplies the operating unit and implementation context.
  • PA_COMPENSATION_RULE_SETS — joined on LABOR_COSTING_RULE; defines the compensation rules applied.
  • PA_PROJECTS_ALL — joined on OVERTIME_PROJECT_ID; identifies the overtime charging project.
  • PA_TASKS — joined on OVERTIME_TASK_ID; identifies the overtime charging task.
  • PA_COST_DISTRIBUTION_LINES_ALL — references this table via ORG_LABOR_SCH_RULE_ID; stores the labor cost distribution results.
  • PA_COST_DIST_LINES_AR — references this table via ORG_LABOR_SCH_RULE_ID; holds the corresponding cost distribution details for a second period.

Together these objects confirm that PA_ORG_LABOR_SCH_RULE is a configuration (satellite) table that governs labor costing and is subsequently referenced by the transactional cost distribution tables.