Results for “psp_schedules”

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

Overview

PSP_SCHEDULES is a table in the PSP (Labor Distribution) product schema of Oracle E-Business Suite, documented as VALID in releases 12.1.1 and 12.2.2. It stores the labor cost distribution schedules that correspond to assignments maintained in Oracle Human Resources. Each row ties an HR assignment to a distribution schedule that drives how salary, wages, and related costs are spread across accounting flexfields, thereby feeding labor distribution and cost allocation processing. The table supports the PSP requirement that assignment-level organizations and effort percentages be translated into general ledger accounting entries.

From a Data Vault modeling perspective, the FK structure suggests a hub-leaning classification: the combination of ASSIGNMENT_ID, BUSINESS_GROUP_ID, and SET_OF_BOOKS_ID functions as a stable business key, with the surrounding descriptive and audit columns behaving like satellite attributes. This classification is a heuristic suggestion derived from the foreign-key topology and is not a physical implementation directive.

Key Information Stored

The table contains 26 documented columns. The primary key is PSP_SCHEDULES_PK, defined over ASSIGNMENT_ID, BUSINESS_GROUP_ID, and SET_OF_BOOKS_ID. Because this composite also appears in the unique index PSP_SCHEDULES_U1, those three columns serve as both the surrogate primary key and the business-key candidate for the row. The most significant columns include:

• ASSIGNMENT_ID — the HR assignment to which the schedule belongs; a core component of the primary key.
• BUSINESS_GROUP_ID — the HR business group, providing the multi-tenant boundary for the assignment.
• SET_OF_BOOKS_ID — the ledger context for the resulting accounting entries.
• PERSON_ID — the worker associated with the assignment.
• FTE — the full-time equivalent value used in effort and cost proration.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — the standard Oracle EBS descriptive flexfield columns for capturing client-specific schedule attributes.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — audit columns identifying who created and last modified the record and when.

Common Use Cases and Queries

Typical reporting scenarios include reconciling labor distribution schedules against HR assignment data and auditing which schedules exist for a given person or ledger. A representative query joins the schedule back to the assignment and filters by ledger:

• Extracting all schedules for a business group: SELECT assignment_id, person_id, fte FROM psp.psp_schedules WHERE business_group_id = :bg_id;
• Reconciling FTE totals: aggregate FTE by person_id and compare with HR assignment FTE.
• Supporting cost allocation runs: identify schedules missing a set of books or with null FTE before distribution processing.
• Flexfield-based reporting: query ATTRIBUTE_CATEGORY with the ATTRIBUTE1–15 columns to segment schedules by client-defined criteria.

Related Objects

The documented relationship data identifies PSP_SCHEDULE_HIERARCHY as dependent on this table, with a foreign key mapping PSP_SCHEDULE_HIERARCHY.ASSIGNMENT_ID, BUSINESS_GROUP_ID, and SET_OF_BOOKS_ID back to the same columns in PSP_SCHEDULES. This makes PSP_SCHEDULE_HIERARCHY the principal child object for schedule hierarchy and roll-up logic. Because the business key extends into Oracle Human Resources, relevant related objects also include the HR assignment and person entities referenced by ASSIGNMENT_ID and PERSON_ID, and the ledger referenced by SET_OF_BOOKS_ID, all of which join into standard labor distribution and costing reports.