Results for “pa_labor_expenditures_view”

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

Overview

PA_LABOR_EXPENDITURES_VIEW is an APPS-owned database view in the Oracle EBS Projects (PA) module that presents detail labor transactions for employee activity and utilization reporting. As a denormalized reporting construct, it joins project, task, person, job, organization, and expenditure data into a single queryable result set, sparing report authors and integrators from reconstructing the base transactional joins themselves. The view exposes both raw and burdened cost amounts alongside multiple currency representations (denominated, accounted, and project currency), making it suitable for cross-currency labor cost analysis. It is status VALID and documented for both EBS 12.1.1 and 12.2.2.

The view is particularly relevant to searches involving premium_hours, because it exposes labor quantity broken out by SYSTEM_LINKAGE_FUNCTION values via DECODE expressions. Standard time ('ST') and overtime ('OT') quantities are separated into distinct columns, which is the mechanism most commonly used to approximate premium or overtime hour reporting where the base expenditure item records carry that system linkage indicator.

Underlying Base Objects

The documented base objects underlying the view are:

• PA_PROJECTS_ALL (synonym) — project header, providing PROJECT_ID, SEGMENT1, NAME, PROJECT_TYPE.
• PA_TASKS (synonym) — task detail, providing TASK_ID, TASK_NUMBER, TASK_NAME.
• PA_EXPENDITURES_ALL (synonym) — expenditure batch header, providing expenditure ending date, transfer status, workflow status, original references, batch name, and overriding approver.
• PA_EXPENDITURE_ITEMS_ALL (synonym) — expenditure item detail, the primary source of quantity, cost, revenue, currency, and billable attributes.
• PER_PEOPLE_F (view) — person effective-dated record, restricted to rows effective as of TRUNC(SYSDATE).
• PER_JOBS (synonym) — job definition for the labor resource.
• HR_ORGANIZATION_UNITS (view) — organization (typically expenditure organization) of the labor.
• HR_GENERAL, HR_PERSON_NAME, HR_SECURITY (packages) — referenced by the view definition, consistent with secured person name and organization access.

The core join path links project to task, task to expenditure item, expenditure item to expenditure header, and the header's INCURRED_BY_PERSON_ID to the effective-dated person record. A key restriction is EI.SYSTEM_LINKAGE_FUNCTION = 'ST' in the WHERE clause, meaning the view is anchored on standard time transactions.

Key Columns

• Identity: PROJECT_ID, SEGMENT1, NAME, PROJECT_TYPE, TASK_ID, TASK_NUMBER, TASK_NAME, PERSON_ID, EMPLOYEE_NUMBER (NVL of EMPLOYEE_NUMBER/NPW_NUMBER), FULL_NAME, JOB_ID, JOB NAME, ORGANIZATION_ID, ORGANIZATION NAME.
• Dates: EXPENDITURE_ENDING_DATE, EXPENDITURE_ITEM_DATE.
• Type and references: EXPENDITURE_TYPE, ORIG_USER_EXP_TXN_REFERENCE, ORIG_EXP_TXN_REFERENCE1/2/3, USER_BATCH_NAME.
• Quantity breakdowns: DECODE-based columns for standard time (ST), overtime (OT), billable quantity (BILLABLE_FLAG = 'Y'), and non-billable quantity ('N'). The OT quantity column is the primary proxy for premium/overtime hours.
• Cost and revenue: RAW_COST, BURDEN_COST, NVL(ADJUSTED_REVENUE, RAW_REVENUE), ACCRUED_REVENUE, BILLABLE_FLAG.
• Currency sets: DENOM_CURRENCY_CODE, DENOM_RAW_COST, DENOM_BURDENED_COST; ACCT_CURRENCY_CODE with rate date/type/exchange rate and ACCT_RAW_COST, ACCT_BURDENED_COST; PROJECT_CURRENCY_CODE with rate date/type/exchange rate.
• Workflow: TRANSFER_STATUS_CODE, WF_STATUS_CODE, OVERRIDING_APPROVER_PERSON_ID.

Common Use Cases and Queries

Typical uses include employee utilization analysis, overtime/premium hour trending, billable versus non-billable labor mix, and cost/revenue reconciliation across currencies.

• Overtime (premium) hours by person and project: SELECT EMPLOYEE_NUMBER, FULL_NAME, SEGMENT1, SUM(OT_QUANTITY) FROM PA_LABOR_EXPENDITURES_VIEW GROUP BY ...
• Billable versus non-billable hour comparison per task.
• Burdened labor cost by organization and expenditure type.
• Project-currency versus accounted-currency cost variance.
• Unapproved or untransferred labor transactions filtered on TRANSFER_STATUS_CODE and WF_STATUS_CODE.

Because the view is governed by HR security packages and filters current effective-dated person rows, query results respect person and organization security. Report authors should note the fixed 'ST' restriction and that the view is read-only, intended strictly for reporting and integration extraction rather than transactional update.