Search Results default_indicator

Overview

PSPBV_LABOR_SCHEDULE_LINES is a reporting view in the Oracle EBS Labor Distribution (PSP) module that exposes schedule information and charging instructions associated with employees, assignments, element types, and organizations. In the Oracle E-Business Suite release context of 12.1.1 and 12.2.2, this view serves as a denormalized read interface over the labor schedule definition data held in the PSP_SCHEDULE_LINES table, joined to the General Ledger chart of accounts through GL_CODE_COMBINATIONS. Its principal role is to support inquiry, reconciliation, and downstream integration where authorized users or processes need to understand how labor costs are being distributed across accounting flexfield combinations over defined date ranges.

The ETRM documentation indicates that the view is not implemented in the reference database used to generate that metadata, meaning the accompanying column list and view text should be treated as the authoritative definition even though the object may not be instantiated in every environment. This is a common characteristic of seeded views that are shipped conditionally based on installed products and patching levels.

Underlying Base Objects

The documented view text sources from two base tables:

• PSP_SCHEDULE_LINES (PSL) — the primary table holding schedule line records, including schedule begin and end dates, schedule percentages, encumbrance status, default flags, warning codes, and the foreign keys to project, task, award, expenditure organization, expenditure type, business group, and the GL code combination.
• GL_CODE_COMBINATIONS (GCC) — joined on PSL.GL_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID to resolve the accounting flexfield, substituted in the view as the key flexfield token.

The join is an inner join against GL_CODE_COMBINATIONS, and the view is defined WITH READ ONLY, reinforcing that it is intended purely for query access rather than DML. A security predicate token is embedded in the WHERE clause, indicating that the view participates in row-level security filtering, typically restricting rows to the operating unit or organization context of the querying responsibility. The metadata lists no other referenced base objects.

Key Columns

The columns exposed by the view map largely to PSP_SCHEDULE_LINES, with the key flexfield surfaced from GL_CODE_COMBINATIONS:

• SCHEDULE_LINE_ID — primary identifier for the schedule line.
• SCHEDULE_BEGIN_DATE / SCHEDULE_END_DATE — effective period over which the schedule line applies.
• SCHEDULE_PERCENTAGE — the percentage of labor cost allocated by this line.
• ENCUMBRANCE_STATUS — indicates encumbrance processing state for the line.
• DEFAULT_INDICATOR — flags the default schedule line for the associated employee, assignment, element type, or organization. This is the column most relevant to searches on "default_indicator," as it identifies which charging instruction should be treated as the default when multiple lines exist.
• WARNING_CODE — carries any warning raised against the line.
• SET_OF_BOOKS_ID — ledger context for the schedule line.
• SCHEDULE_HIERARCHY_ID — links the line to its parent schedule hierarchy.
• _KF:GL_ACCOUNT — the accounting flexfield derived from GL_CODE_COMBINATIONS.
• PROJECT_ID, TASK_ID, AWARD_ID — project accounting references for the charging instruction.
• ORGANIZATION_ID, EXPENDITURE_TYPE — the expenditure organization and type targeted by the schedule.
• BUSINESS_GROUP_ID — HR business group context.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE.

Common Use Cases and Queries

Typical reporting scenarios include identifying default charging instructions for a given employee or organization, reviewing effective-dated schedule percentages, and reconciling labor distribution setups to the GL chart of accounts. A common query targets the default indicator:

SELECT schedule_line_id, schedule_begin_date, schedule_end_date, schedule_percentage, default_indicator, organization_id, expenditure_type FROM pspbv_labor_schedule_lines WHERE default_indicator = 'Y' AND schedule_begin_date <= SYSDATE AND NVL(schedule_end_date, SYSDATE) >= SYSDATE;

Other queries filter by project, task, or GL account to audit how labor is being charged, or join the view to HR and payroll tables for integration extracts. Because the view is read-only and subject to row-level security, it is appropriate for concurrent programs, OBIEE/BIP reports, and read-only integration interfaces rather than for maintaining schedule data.