Search Results psp_matrix_driver2_pk

Overview

PSP_MATRIX_DRIVER2 is a table in the PSP (Labor Distribution) product schema within Oracle E-Business Suite 12.1.1 and 12.2.2. According to the ETRM metadata, its documented purpose is to support the matrix functionality in the Monthly Schedule Summary. In practical terms, the table stores the per-period distribution percentages that drive how a scheduled labor distribution line is spread across accounting periods within a monthly schedule. This is the second driver table in the matrix family, complementing the primary driver table used to derive period-level allocations in Labor Distribution.

The object is owned by the PSP schema and is documented as VALID. From a data modeling perspective, the metadata's heuristic Data Vault classification identifies this object as standalone. That suggests the table behaves as a self-contained structure without foreign-key dependency chains in the documented relationship data — a modeling suggestion rather than a definitive architectural statement. Its two-column composite primary key anchors the distribution percentage rows to a schedule line and a period, effectively serving as a satellite-like structure keyed to the schedule line concept, though no parent hub/link relationship is documented.

Key Information Stored

The documented physical schema contains three columns. The most important are:

• SCHEDULE_LINE_ID — The identifier of the schedule line whose period distribution is being described. This is the primary business reference to the parent schedule line record.
• PERIOD — The accounting period for which the distribution percentage applies. Together with SCHEDULE_LINE_ID it forms the composite key.
• PERIOD_SCHEDULE_PERCENT — The distribution percentage applied to the schedule line for the identified period. This is the driving value used by the Monthly Schedule Summary matrix logic.

The surrogate primary key is PSP_MATRIX_DRIVER2_PK, defined on (SCHEDULE_LINE_ID, PERIOD). The unique index PSP_MATRIX_DRIVER2_U1 also spans (SCHEDULE_LINE_ID, PERIOD), making this the single candidate business key. Because the primary key and the unique index cover the same columns, the uniqueness of a schedule line–period combination is guaranteed twice, which reinforces that one percentage row exists per schedule line per period. Since only three columns are documented, there is no separate meaningless surrogate key column such as a generated ID; the natural composite key serves directly as the primary key.

Common Use Cases and Queries

The table is queried primarily when reconstructing or auditing the Monthly Schedule Summary, particularly to verify how a schedule line was distributed across periods. A typical join pattern retrieves the percentage rows for a given schedule line:

• Retrieve all period rows for a schedule line: SELECT SCHEDULE_LINE_ID, PERIOD, PERIOD_SCHEDULE_PERCENT FROM PSP.PSP_MATRIX_DRIVER2 WHERE SCHEDULE_LINE_ID = :p_schedule_line_id ORDER BY PERIOD;
• Validate that percentages sum to 100 per schedule line: SELECT SCHEDULE_LINE_ID, SUM(PERIOD_SCHEDULE_PERCENT) FROM PSP.PSP_MATRIX_DRIVER2 GROUP BY SCHEDULE_LINE_ID HAVING SUM(PERIOD_SCHEDULE_PERCENT) <> 100;
• Report distribution by period across all lines: select PERIOD and aggregate PERIOD_SCHEDULE_PERCENT to visualize period-by-period load.
• Detect orphaned rows or duplicates by relying on the PSP_MATRIX_DRIVER2_U1 unique index expectations.

A key integrity check in any reporting scenario is confirming that the primary-key uniqueness holds and that no schedule line has more than one row per period.

Related Objects

Because the documented relationship data classifies this object as standalone, no foreign-key dependencies are published. The most significant related objects are therefore inferred from the naming and functional context:

• PSP_MATRIX_DRIVER or the primary matrix driver table — the companion driver that this table extends for the second matrix driver dimension.
• PSP_SCHEDULE_LINES (or the corresponding schedule-line table) — the parent of SCHEDULE_LINE_ID.
• PSP_MONTHLY_SCHEDULE_SUMMARY — the Monthly Schedule Summary structure referenced in the description.
• Labor Distribution schedule and period tables in the PSP schema that share the SCHEDULE_LINE_ID reference.
• Monthly Schedule Summary concurrent programs and reports that consume PERIOD_SCHEDULE_PERCENT.

Join columns center on SCHEDULE_LINE_ID and PERIOD. DBA and support teams should verify actual FK definitions in their instance, since the ETRM data documents no explicit constraints for this table.