Results for “psp_default_labor_schedules”

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

Overview

The PSP_DEFAULT_LABOR_SCHEDULES table, owned by the PSP schema within the Oracle E-Business Suite Labor Distribution module, stores default labor schedules that are applied when no employee-specific schedule has been defined. Labor Distribution relies on schedule rows to assign distribution percentages across a combination of accounts, projects, tasks, awards, and expenditure types. When an employee record lacks an explicit schedule, the rows in this table serve as the fallback template, ensuring that labor costs can still be distributed without manual intervention.

Under the heuristic Data Vault classification mined from its foreign key structure, this table is characterized as satellite-leaning. In dimensional modeling terms, this suggests it is best treated as a descriptive satellite attached to a core business key (represented by ORGANIZATION_ID and SCHEDULE_BEGIN_DATE) rather than as an independent hub or an associative link. Analysts building a data vault or dimensional warehouse layer over EBS should consider modeling PSP_DEFAULT_LABOR_SCHEDULES as a satellite whose parent hub is the organization/schedule context, joined through the documented surrogates.

Key Information Stored

The physical schema documented for release 12.2.2 contains 37 columns. The most operationally significant are summarized below.

• ORG_SCHEDULE_ID — surrogate primary key (PSP_DEFAULT_LABOR_SCHEDULES_PK) and also the sole unique business-key candidate via PSP_DEFAULT_LABOR_SCHEDULES_U1.
• ORGANIZATION_ID — the organization that owns the default schedule.
• SCHEDULE_BEGIN_DATE and SCHEDULE_END_DATE — the effective date range during which the default schedule applies.
• SCHEDULE_PERCENT — the percentage of labor cost allocated to this distribution line.
• GL_CODE_COMBINATION_ID — the accounting flexfield combination receiving the distribution.
• PROJECT_ID, TASK_ID, and AWARD_ID — project, task, and award context for costing.
• EXPENDITURE_TYPE and EXPENDITURE_ORGANIZATION_ID — the expenditure classification and the organization incurring the expenditure.
• BUSINESS_GROUP_ID and SET_OF_BOOKS_ID — the HR business group and ledger context.
• POETA_START_DATE and POETA_END_DATE — the Project Expenditure/Transaction Adjustment effective window.
• COMMENTS and the ATTRIBUTE_CATEGORY / ATTRIBUTE1–ATTRIBUTE15 descriptive flexfield columns, plus standard WHO audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN).

Common Use Cases and Queries

Typical scenarios include reviewing default distribution templates by organization, validating that percentages sum to 100 percent per effective date range, and tracing how fallback distributions populate downstream encumbrance and distribution lines.

Retrieve active defaults for an organization:

• SELECT ORG_SCHEDULE_ID, ORGANIZATION_ID, SCHEDULE_BEGIN_DATE, SCHEDULE_END_DATE, SCHEDULE_PERCENT, GL_CODE_COMBINATION_ID FROM PSP.PSP_DEFAULT_LABOR_SCHEDULES WHERE ORGANIZATION_ID = :org AND SYSDATE BETWEEN SCHEDULE_BEGIN_DATE AND SCHEDULE_END_DATE;

Validate percentage coverage for a schedule:

• SELECT ORG_SCHEDULE_ID, SUM(SCHEDULE_PERCENT) FROM PSP.PSP_DEFAULT_LABOR_SCHEDULES GROUP BY ORG_SCHEDULE_ID HAVING SUM(SCHEDULE_PERCENT) <> 100;

Trace distribution lines generated from a default schedule:

• SELECT d.* FROM PSP.PSP_DISTRIBUTION_LINES d JOIN PSP.PSP_DEFAULT_LABOR_SCHEDULES s ON d.ORG_SCHEDULE_ID = s.ORG_SCHEDULE_ID WHERE s.ORGANIZATION_ID = :org;

Related Objects

The table participates in a dense foreign key network. The following are the most significant related objects.

• PSP_DISTRIBUTION_LINES — references ORG_SCHEDULE_ID; holds generated distribution results.
• PSP_DISTRIBUTION_LINES_HISTORY — references SCHEDULE_LINE_ID and ORG_SCHEDULE_ID; historical distribution records.
• PSP_ENC_LINES and PSP_ENC_LINES_HISTORY — encumbrance lines tied to ORG_SCHEDULE_ID.
• PA_PROJECTS_ALL and PA_TASKS — joined via PROJECT_ID and TASK_ID.
• GL_CODE_COMBINATIONS and GL_SETS_OF_BOOKS — accounting and ledger context via GL_CODE_COMBINATION_ID and SET_OF_BOOKS_ID.
• HR_ALL_ORGANIZATION_UNITS — supplies BUSINESS_GROUP_ID and EXPENDITURE_ORGANIZATION_ID.
• PA_EXPENDITURE_TYPES and IGF_AW_AWARD_ALL — expenditure and award classification.