Search Results psp_matrix_driver2_u1

Overview

PSP.PSP_MATRIX_DRIVER2 is a reference and driver table within the Oracle E-Business Suite PSP (Projects, Contracts, and Grants) schema. It stores the period-by-period percentage distribution used to drive schedule calculations for a given schedule line. Each row represents the weighting applied to one accounting or project period within a schedule line, enabling the ETRM scheduling engine to spread amounts across time.

The object is documented as VALID and is owned solely by the PSP schema with FND Design Data registration PSP.PSP_MATRIX_DRIVER2. Per the Data Vault classification in the metadata, this table is a candidate standalone structure rather than a classic hub, link, or satellite; it can be modeled as a satellite that hangs off a schedule-line hub if the PSP_MATRIX_DRIVER2_PK (SCHEDULE_LINE_ID, PERIOD) is treated as the natural key.

It resides in the APPS_TS_NOLOGGING tablespace, a characteristic consistent with transient scheduling/ETRM calculation data, and physical storage is defined with PCT Free 10.

Key Information Stored

Only three columns are documented in the ETRM metadata, and each is critical:

• SCHEDULE_LINE_ID (NUMBER) — Unique key of the Schedule lines table. Also documented as the first component of the unique index PSP_MATRIX_DRIVER2_U1 and of the primary key PSP_MATRIX_DRIVER2_PK. It is the foreign-link to the parent schedule line.
• PERIOD (DATE) — The schedule period (the accounting/project period) to which the percentage applies. Forms the second component of the PK and of the PSP_MATRIX_DRIVER2_U1 unique index.
• PERIOD_SCHEDULE_PERCENT (NUMBER) — The percentage allocated to the period; this is the driving value used by ETRM calculations.

The surrogate key is PSP_MATRIX_DRIVER2_PK (SCHEDULE_LINE_ID, PERIOD). The business-key candidate is the unique index PSP_MATRIX_DRIVER2_U1 on the same column pair. There is no separate generated ID column, so the primary key and business key are effectively identical.

Common Use Cases and Queries

Typical uses include reporting on the schedule distribution for a contract or grant, validating that the sum of PERIOD_SCHEDULE_PERCENT equals 100 per schedule line, and reconciling period amounts. The documented query text is:

• SELECT SCHEDULE_LINE_ID, PERIOD, PERIOD_SCHEDULE_PERCENT FROM PSP.PSP_MATRIX_DRIVER2;
• SELECT SCHEDULE_LINE_ID, SUM(PERIOD_SCHEDULE_PERCENT) FROM PSP.PSP_MATRIX_DRIVER2 GROUP BY SCHEDULE_LINE_ID HAVING SUM(PERIOD_SCHEDULE_PERCENT) <> 100;
• SELECT SCHEDULE_LINE_ID, PERIOD, PERIOD_SCHEDULE_PERCENT FROM PSP.PSP_MATRIX_DRIVER2 WHERE SCHEDULE_LINE_ID = :line_id ORDER BY PERIOD;

Related Objects

The documented metadata states that PSP_MATRIX_DRIVER2 does not itself reference other database objects, and that it is referenced by PSP_MATRIX_DRIVER2# (the Oracle-generated shadow/entity object). Joins in practice are made using SCHEDULE_LINE_ID to the PSP schedule lines table, and the pair (SCHEDULE_LINE_ID, PERIOD) can be joined to period-balance and ETRM calculation tables. Most significant related objects include the schedule-line master table, the ETRM percentage/matrix driver program (which populates this table), the PSP_MATRIX_DRIVER2_U1 index, the PSP_MATRIX_DRIVER2_PK constraint, and reporting views over the PSP ETRM schedule component.