Results for “psp_enc_controls_u2”

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

Overview

PSP.PSP_ENC_CONTROLS is a transaction-level control table within the Oracle EBS Payroll encumbrance subsystem. It stores one record for each time period batch processed during encumbrance generation, acting as the header for the batch's debit and credit totals across the General Ledger (GL) and Grants Accounting (OGM/GMS) ledgers. Each row captures the parameters used at generation time — encumbrance period extensions, summarization options, effective time period, and set of books — together with the aggregated amounts transferred to each destination ledger. The table is owned by the PSP schema (Oracle Payroll), resides in the APPS_TS_TX_DATA tablespace with PCT Free 10, and is documented as VALID in ETRM 12.2.2 with 37 columns.

Under a heuristic Data Vault classification, this object is hub-leaning. It carries a single-column surrogate primary key (ENC_CONTROL_ID), references two upstream entities via foreign keys, and is referenced by several downstream line and summary tables, giving it the characteristics of a central hub with attached link and satellite structures. This classification is a modeling suggestion derived from the FK topology rather than a definitive physical designation.

Key Information Stored

• ENC_CONTROL_ID — system-generated surrogate primary key for the encumbrance control identifier (index PSP_ENC_CONTROLS_U1).
• PAYROLL_ACTION_ID — foreign key to PAY_PAYROLL_ACTIONS; combined with ENC_CONTROL_ID it forms the second unique business key (PSP_ENC_CONTROLS_U2), confirming one control record per payroll action.
• PAYROLL_ID — foreign key to PAY_PAYROLLS_F, identifying the payroll that produced the batch.
• SET_OF_BOOKS_ID — foreign key to GL_SETS_OF_BOOKS, identifying the target ledger.
• TIME_PERIOD_ID — foreign key to PER_TIME_PERIODS; the period in which the encumbrance date falls.
• ENCUMBRANCE_DATE — the date on which the encumbrance was generated.
• GL_ENC_PERIOD_EXT_VALUE / OGM_ENC_PERIOD_EXT_VALUE — extensions beyond the default encumbrance period for GL and Grants Accounting respectively.
• CI_SUMMARIZATION_OPTION / TIME_SUMMARIZATION_OPTION — charging instruction and time-based summarization settings applied to the batch.
• NUMBER_OF_DR / NUMBER_OF_CR — counts of debit and credit transactions in the batch.
• TOTAL_DR_AMOUNT / TOTAL_CR_AMOUNT — batch debit and credit totals prior to ledger transfer.
• GL_DR_AMOUNT / GL_CR_AMOUNT — amounts transferred to General Ledger.
• OGM_DR_AMOUNT / OGM_CR_AMOUNT — amounts transferred to Grants Accounting.
• ACTION_CODE, ACTION_TYPE, GL_PHASE, GMS_PHASE, ARCHIVE_FLAG — status and processing-phase indicators governing the batch lifecycle.

Common Use Cases and Queries

Typical uses include reconciling payroll encumbrance batches between Payroll and GL, auditing transfers to Grants Accounting, and reporting on summarization behaviour across periods. A common pattern joins the control row to its detail lines:

• Batch reconciliation — compare TOTAL_DR_AMOUNT/TOTAL_CR_AMOUNT against GL_DR_AMOUNT/GL_CR_AMOUNT and OGM_DR_AMOUNT/OGM_CR_AMOUNT to identify unposted balances.
• Period reporting — filter by TIME_PERIOD_ID and PAYROLL_ID, supported by the non-unique index PSP_ENC_CONTROLS_N1.
• Action auditing — filter by PAYROLL_ACTION_ID and ACTION_CODE, supported by PSP_ENC_CONTROLS_N2.

Sample query:

SELECT c.ENC_CONTROL_ID, c.PAYROLL_ID, c.TIME_PERIOD_ID, c.GL_DR_AMOUNT, c.GL_CR_AMOUNT
FROM PSP.PSP_ENC_CONTROLS c
WHERE c.TIME_PERIOD_ID = :p_period
AND c.PAYROLL_ID = :p_payroll
AND c.ACTION_CODE = :p_status;

Related Objects

• PSP_ENC_LINES — detail encumbrance lines; joins on ENC_CONTROL_ID.
• PSP_ENC_SUMMARY_LINES — summarized lines; references ENC_CONTROL_ID and ENC_SUMMARY_LINE_ID.
• PSP_ENC_LINES_ARCH — archived encumbrance lines keyed by ENC_CONTROL_ID.
• PSP_ENC_SUMMARY_LINES_ARCH — archived summary lines keyed by ENC_CONTROL_ID.
• PSP_ENC_LINES_HISTORY — historical line records referencing ENC_CONTROL_ID.
• PAY_PAYROLL_ACTIONS — parent action entity via PAYROLL_ACTION_ID.
• PER_TIME_PERIODS — period definition via TIME_PERIOD_ID.
• PAY_PAYROLLS_F and GL_SETS_OF_BOOKS — payroll and ledger references.