Results for “bill_rate”

50+ results




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

Overview

PA_NL_BILL_RATE_OVERRIDES is a Projects (PA) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores non-standard, negotiated non-labor bill rates for specific projects and tasks. Standard non-labor bill rates are typically driven by the resource-and-expenditure-type combination defined in the billing rate schedules; this table provides the override layer that allows an organization to substitute a project- and task-specific rate, markup percentage, discount percentage, or discount reason when the standard schedule rate is not commercially appropriate. The table is owned by the PA schema and is classified as VALID in the ETRM 12.2.2 data dictionary, with 18 documented physical columns.

From a Data Vault modeling perspective, the mined foreign key structure suggests this object behaves as a link, since it joins multiple independent business entities — project, task, expenditure type, and non-labor resource — rather than representing a single business key or descriptive satellite. Each row captures a negotiated commercial agreement between those entities, which is consistent with link semantics.

Key Information Stored

The table has a composite primary key defined by PA_NL_BILL_RATE_OVERRIDES_PK on (PROJECT_ID, TASK_ID, EXPENDITURE_TYPE, START_DATE_ACTIVE, NON_LABOR_RESOURCE). This composite key is also reflected in the unique index PA_NL_BILL_RATE_OVERRIDES_U1, making it a strong business-key candidate. A second unique index, PA_NL_BILL_RATE_OVERRIDES_U3, is defined on NL_BILL_RATE_OVERRIDE_ID, which serves as the internal surrogate identifier.

Common Use Cases and Queries

Typical reporting scenarios include identifying which projects or tasks carry non-standard negotiated rates, auditing discount usage, and validating that override validity windows are consistent with project or task date ranges.

  • List all overrides for a given project and task:
    SELECT nlbr.project_id, nlbr.task_id, nlbr.expenditure_type,
           nlbr.non_labor_resource, nlbr.bill_rate,
           nlbr.rate_currency_code, nlbr.start_date_active, nlbr.end_date_active
    FROM   pa_nl_bill_rate_overrides nlbr
    WHERE  nlbr.project_id = :project_id
    AND    nlbr.task_id = :task_id;
  • Identify currently active overrides within a date window:
    SELECT * FROM pa_nl_bill_rate_overrides
    WHERE  start_date_active <= SYSDATE
    AND   (end_date_active IS NULL OR end_date_active >= SYSDATE);
  • Aggregate discount exposure by reason code:
    SELECT rate_disc_reason_code, COUNT(*), AVG(discount_percentage)
    FROM   pa_nl_bill_rate_overrides
    GROUP BY rate_disc_reason_code;
  • Audit changes via audit columns ordered by LAST_UPDATE_DATE for reconciliation against rate schedules.

Related Objects

The following objects are documented as directly related through the foreign key structure:

  • PA_PROJECTS_ALL — joined on PROJECT_ID; source of the project definition.
  • PA_TASKS — joined on TASK_ID; defines the task context for the override.
  • PA_EXPENDITURE_TYPES — joined on EXPENDITURE_TYPE; defines the classification of cost being billed.
  • PA_NON_LABOR_RESOURCES — joined on NON_LABOR_RESOURCE; identifies the billable non-labor item.

These four tables provide the reference integrity for PA_NL_BILL_RATE_OVERRIDES and should be joined when building reporting queries that need descriptive project, task, expenditure type, or resource information.