Results for “psp_default_labor_sch_enc_v”

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

Overview

PSP_DEFAULT_LABOR_SCH_ENC_V is a read-only database view within the PSP (Labor Distribution) module of Oracle E-Business Suite, applicable to releases 12.1.1 and 12.2.2. It presents encumbered-style default labor schedule records that are associated with either a general ledger code combination or an award. As the "ENC" suffix suggests, the view is oriented toward rows that carry financial encumbrance meaning, specifically those where a valid GL_CODE_COMBINATION_ID or AWARD_ID has been assigned.

In EBS reporting and integration, the view serves as a filtered, conventional reading surface over the default labor schedules maintained by the labor distribution functionality. Because it is declared "WITH READ ONLY," it cannot be used for DML and is intended purely for query and extraction. This makes it suitable for concurrent programs, discoverer reports, and outbound interfaces that need to identify labor schedule defaults already tied to accounting or sponsored-project awards.

Underlying Base Objects

The view is defined over a single documented base object: PSP_DEFAULT_LABOR_SCHEDULES. The defining query selects a prescribed column list from that table and applies the filter WHERE GL_CODE_COMBINATION_ID IS NOT NULL OR AWARD_ID IS NOT NULL, terminating with the read-only clause. Consequently, the view returns only those default labor schedule rows that have been enriched with either a GL code combination or an award reference; rows lacking both are excluded.

No additional referenced base objects are documented in the ETRM metadata. The view therefore functions as a semantic subset of PSP_DEFAULT_LABOR_SCHEDULES rather than an aggregation or join, preserving the grain of the underlying table (one row per default labor schedule entry that satisfies the filter). This one-to-one relationship simplifies lineage analysis and makes the view a drop-in alternative wherever the base table is used but the encumbrance/award filter is desired.

Key Columns

The column set mirrors the base table and can be grouped by function:

• ORG_SCHEDULE_ID — primary schedule identifier; the logical key for the returned rows.
• BUSINESS_GROUP_ID — operating unit / HR business group context for the schedule.
• SET_OF_BOOKS_ID — ledger context used for accounting.
• GL_CODE_COMBINATION_ID — the accounting flexfield combination linked to the schedule; a driving filter column for this view.
• PROJECT_ID and TASK_ID — project and task associations for project-accounted labor.
• AWARD_ID — sponsored-projects award association; the other driving filter column.
• EXPENDITURE_ORGANIZATION_ID, EXPENDITURE_TYPE, ORGANIZATION_ID — expenditure classification and organization attribution.
• SCHEDULE_PERCENT — the percentage allocation applied by the default schedule.
• SCHEDULE_BEGIN_DATE, SCHEDULE_END_DATE — effective date range of the schedule.
• COMMENTS — free-form descriptive text.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard EBS descriptive flexfield columns for extensibility.

Common Use Cases and Queries

Typical scenarios include validating which default labor schedules carry accounting or award links before payroll costing, and extracting allocation percentages for labor distribution analysis. The following sample query lists schedules for a ledger and project:

SELECT org_schedule_id, gl_code_combination_id, project_id, task_id,
       award_id, schedule_percent, schedule_begin_date, schedule_end_date
FROM psp_default_labor_sch_enc_v
WHERE set_of_books_id = :p_sob_id
  AND project_id = :p_project_id
ORDER BY schedule_begin_date;

To identify award-linked schedules only, filter on AWARD_ID IS NOT NULL. Because the view is read-only, all access should be SELECT-only, and because it lacks a documented owner in the provided metadata, references should be fully qualified with the appropriate application schema in deployment queries.