Results for “labor_hours”

37 results




Overview
Explore in AI Chat

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

Overview

PA_BUDGET_ITEMS is a transactional table in the Oracle Projects (PA) schema that stores the individual line-level detail of project budgets. According to the ETRM metadata, the object is documented as "10SC Only," indicating that its usage and structure are specific to that context within the Oracle E-Business Suite 12.1.1 and 12.2.2 releases. The table resides in the PA schema and is classified as VALID.

The table captures the budgetary positions recorded against a project and task, broken down by budget type, expenditure category, and expenditure type, with associated cost, revenue, and labor hour amounts. Because it links a project/task/budget-type context to expenditure classification dimensions, the ETRM heuristic Data Vault classification for this object is a link. This classification is a modeling suggestion derived from the foreign key topology rather than a documented Oracle designation, but it accurately reflects the table's role in joining budget context to classification reference data.

Key Information Stored

The physical schema documents 17 columns. The primary key is enforced by the index PA_BUDGET_ITEMS_PK, defined over PROJECT_ID, TASK_ID, BUDGET_TYPE_CODE, and LINE_NUM. A second unique index, PA_BUDGET_ITEMS_U1, shares the same four columns and therefore serves as the business-key candidate defining the natural uniqueness of a budget line.

  • PROJECT_ID — identifies the project to which the budget line belongs; part of both the primary key and the foreign key to PA_SUBBUDGETS.
  • TASK_ID — identifies the task within the project; part of the primary key and the PA_SUBBUDGETS foreign key.
  • BUDGET_TYPE_CODE — distinguishes the budget version or type (for example, approved versus baseline); part of the primary key and the PA_SUBBUDGETS foreign key.
  • LINE_NUM — the line sequence number that uniquely orders lines within a project/task/budget combination; part of the primary key.
  • EXPENDITURE_CATEGORY — classifies the line against the expenditure category reference table.
  • EXPENDITURE_TYPE — classifies the line against the expenditure type reference table.
  • COST — the budgeted cost amount for the line.
  • REVENUE — the budgeted revenue amount for the line.
  • LABOR_HOURS — the budgeted labor hours for the line.
  • JOB_ID — the job associated with labor budgeting where applicable.
  • ORGANIZATION_ID — the organization context for the budget line.
  • REVENUE_CATEGORY — the revenue classification associated with the line.
  • Standard WHO columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN provide audit traceability.

Common Use Cases and Queries

The table is typically queried to report budgeted cost, revenue, and labor hours by project, task, and classification. A representative pattern joins the budget lines to the project and task structures and filters on a single budget type:

  • Budget-versus-actual comparisons, aggregating COST, REVENUE, and LABOR_HOURS by PROJECT_ID and TASK_ID.
  • Expenditure category and type rollups, joining EXPENDITURE_CATEGORY and EXPENDITURE_TYPE to their respective reference tables.
  • Labor hour analysis by JOB_ID and ORGANIZATION_ID for resource planning.
  • Extract queries that reconcile approved budget lines against baseline or current budget versions using BUDGET_TYPE_CODE.

A typical query shape selects PROJECT_ID, TASK_ID, BUDGET_TYPE_CODE, LINE_NUM, EXPENDITURE_CATEGORY, EXPENDITURE_TYPE, COST, REVENUE, and LABOR_HOURS from PA_BUDGET_ITEMS, constrained by BUDGET_TYPE_CODE and PROJECT_ID, and optionally joined to PA_SUBBUDGETS for budget header context.

Related Objects

The foreign key relationships documented in the ETRM metadata identify the principal related objects:

  • PA_SUBBUDGETS — referenced via PROJECT_ID, BUDGET_TYPE_CODE, and TASK_ID; provides the budget header-level context for each line.
  • PA_EXPENDITURE_CATEGORIES — referenced via EXPENDITURE_CATEGORY; supplies the category description and classification hierarchy.
  • PA_EXPENDITURE_TYPES — referenced via EXPENDITURE_TYPE; supplies the expenditure type definition used to classify the line.

Additional related objects include the project and task definition tables (PA_PROJECTS and PA_TASKS) that supply PROJECT_ID and TASK_ID values, and the Oracle Projects budget maintenance interfaces and concurrent programs that populate and validate budget lines against these reference tables.