Results for “gl_cr_amount”

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

Overview

PSP_ENC_CONTROLS is a core transactional table within the PSP – Labor Distribution module of Oracle E-Business Suite (documented across 12.1.1 and 12.2.2). It stores one record for each time period batch processed during labor encumbrance and cost distribution. Each row represents a control header that governs how salary, wage, and related labor costs are summarized, encumbered, and posted to the General Ledger (GL) and Oracle Grants Management (OGM) for a specific time period and payroll action.

The table acts as the central anchor for the encumbrance batch lifecycle, capturing both the counts and monetary totals of debit and credit activity, the summarization rules applied, and the resulting GL and OGM amounts. It is owned by the PSP schema and is classified as VALID in the data dictionary.

From a heuristic Data Vault modeling perspective, the FK structure indicates a hub-leaning classification. The table carries a stable business key (ENC_CONTROL_ID) and references surrounding dimensions such as time periods and payroll actions, making it suitable as a hub in a Data Vault design, with its descriptive columns distributed to satellites.

Key Information Stored

The table exposes 37 documented columns. The most significant include:

• ENC_CONTROL_ID — The surrogate primary key (PSP_ENC_CONTROLS_PK), uniquely identifying each time period batch control record.
• PAYROLL_ACTION_ID — Foreign key to PAY_PAYROLL_ACTIONS; combines with ENC_CONTROL_ID to form unique index PSP_ENC_CONTROLS_U2, a strong business-key candidate.
• TIME_PERIOD_ID — Foreign key to PER_TIME_PERIODS, defining the accounting period for the batch.
• PAYROLL_ID and SET_OF_BOOKS_ID — Identify the payroll and the ledger set impacted by the encumbrance run.
• ENCUMBRANCE_DATE — The effective date applied to generated encumbrances.
• TOTAL_DR_AMOUNT / TOTAL_CR_AMOUNT — Aggregate debit and credit amounts before summarization.
• GL_DR_AMOUNT / GL_CR_AMOUNT and OGM_DR_AMOUNT / OGM_CR_AMOUNT — Posting amounts destined for the GL and Grants modules respectively.
• SUMM_GL_DR_AMOUNT / SUMM_GL_CR_AMOUNT / SUMM_OGM_DR_AMOUNT / SUMM_OGM_CR_AMOUNT — Summarized totals after applying the configured summarization options.
• CI_SUMMARIZATION_OPTION / TIME_SUMMARIZATION_OPTION — Control flags determining how cost and time entries are consolidated.
• NUMBER_OF_DR / NUMBER_OF_CR — Row counts of debit and credit lines associated with the batch.
• ACTION_CODE / ACTION_TYPE — Classify the operation (for example, encumbrance, liquidation, or adjustment).
• GL_PHASE / GMS_PHASE — Track the processing stage toward the GL and Grants modules.
• ARCHIVE_FLAG and LIQUIDATE_REQUEST_ID — Support archival and encumbrance liquidation tracking.

Common Use Cases and Queries

Typical reporting and reconciliation scenarios include verifying that summarized amounts equal the sum of detail lines, auditing encumbrance batches by period, and monitoring the GL/GMS posting phases.

• Batch control totals for a period: query TOTAL_DR_AMOUNT, TOTAL_CR_AMOUNT, and row counts by TIME_PERIOD_ID.
• Reconciliation against detail: join to PSP_ENC_LINES and PSP_ENC_SUMMARY_LINES on ENC_CONTROL_ID to compare control totals with line-level sums.
• Posting status reporting: filter on GL_PHASE and GMS_PHASE to identify batches not yet transferred to the GL or Grants.
• Archive management: select records where ARCHIVE_FLAG indicates completed processing.

A representative query pattern:

SELECT ENC_CONTROL_ID, TIME_PERIOD_ID, TOTAL_DR_AMOUNT, TOTAL_CR_AMOUNT, GL_PHASE, GMS_PHASE FROM PSP.PSP_ENC_CONTROLS WHERE TIME_PERIOD_ID = :period AND ARCHIVE_FLAG = 'N';

Related Objects

The control record anchors a well-defined parent/child structure within Labor Distribution:

• PSP_ENC_LINES — Detail lines joining on ENC_CONTROL_ID.
• PSP_ENC_LINES_HISTORY and PSP_ENC_LINES_ARCH — Historical and archived detail records.
• PSP_ENC_SUMMARY_LINES — Summarized cost lines referencing the control via ENC_CONTROL_ID and ENC_SUMMARY_LINE_ID.
• PSP_ENC_SUMMARY_LINES_ARCH — Archived summary lines.
• PER_TIME_PERIODS — Referenced through TIME_PERIOD_ID.
• PAY_PAYROLL_ACTIONS — Referenced through PAYROLL_ACTION_ID.

These relationships make PSP_ENC_CONTROLS the pivotal control entity for reconciling, auditing, and reporting labor encumbrance activity across Labor Distribution, Payroll, General Ledger, and Grants.