Results for “encumbrance_date”

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

Overview

PSP_ENC_LINES_HISTORY is a Labor Distribution (PSP) table in Oracle E-Business Suite that stores successful encumbrance lines after they have been transferred to General Ledger and Grants Accounting. In the Oracle EBS 12.1.1 and 12.2.2 environments, the Labor Distribution module processes payroll and labor costs against project and award funding, generating encumbrance entries that must be posted to the financial ledgers. This table serves as the archival and audit record for the encumbrance lines that were successfully transmitted to GL and to Grants Accounting, preserving the full accounting context of each transaction. It is owned by the PSP schema, is documented as VALID in ETRM 12.2.2, and contains 58 columns.

Under the heuristic Data Vault classification mined from its foreign key structure, this table is assessed as satellite-leaning. In Data Vault modeling terms, a satellite stores descriptive attributes that change over time and relate back to a hub or link through a key. Here, the primary key ENC_LINE_ID anchors each historical encumbrance line record and joins to PSP_ENC_SUMMARY_LINES, while the surrounding descriptive and contextual columns (amounts, dates, accounts, reason codes, hierarchy data) represent the tracked attributes. This classification should be treated as a modeling suggestion rather than a prescriptive design.

Key Information Stored

The table records the accounting and operational detail of each transferred encumbrance line. The most significant columns include:

• ENC_LINE_ID — The primary key (PSP_ENC_LINES_HIST_PK) and a documented business-key candidate via unique index PSP_ENC_LINES_HISTORY_U1. It also serves as a foreign key to PSP_ENC_SUMMARY_LINES.
• ENCUMBRANCE_AMOUNT and DR_CR_FLAG — The monetary value of the encumbrance and its debit/credit direction.
• ENCUMBRANCE_DATE, ENC_START_DATE, and ENC_END_DATE — The accounting date and the effective date range for the encumbrance.
• GL_CODE_COMBINATION_ID and ORIG_GL_CODE_COMBINATION_ID — The current and originating General Ledger account combinations.
• PROJECT_ID, TASK_ID, AWARD_ID, EXPENDITURE_TYPE, and EXPENDITURE_ORGANIZATION_ID — The project, award, and expenditure context, with parallel ORIG_ columns preserving the original values.
• PERSON_ID, ASSIGNMENT_ID, and PAYROLL_ACTION_ID — The employee, assignment, and payroll action that originated the labor cost.
• TIME_PERIOD_ID, SET_OF_BOOKS_ID, and ENC_CONTROL_ID — The payroll period, ledger, and encumbrance control grouping.
• STATUS_CODE, CHANGE_FLAG, and the reason code columns — Processing state and explanatory codes.
• HIERARCHY_CODE, HIERARCHY_START_DATE, and HIERARCHY_END_DATE — The organizational hierarchy context associated with the line.

Standard audit columns (LAST_UPDATE_DATE, CREATED_BY, CREATION_DATE, and the ATTRIBUTE1-10 descriptive flexfield columns) are also present.

Common Use Cases and Queries

Primary practical uses include reconciling Labor Distribution encumbrances against General Ledger and Grants Accounting balances, auditing payroll-driven encumbrance transfers, and investigating suspense processing through the suspense reason and account columns.

A typical reconciliation query aggregates transferred encumbrances by ledger and period:

• SELECT set_of_books_id, time_period_id, SUM(encumbrance_amount) FROM psp_enc_lines_history WHERE status_code = 'PROCESSED' GROUP BY set_of_books_id, time_period_id;
• Joining to period and award reference tables to report by award or project, using award_id, project_id, and task_id.
• Comparing GL_CODE_COMBINATION_ID against ORIG_GL_CODE_COMBINATION_ID to identify lines whose accounting flexfield was re-derived during transfer.

Because the table stores only successful transfers, it is well suited to audit reporting and to feeds for downstream Grants Accounting analysis.

Related Objects

• PSP_ENC_SUMMARY_LINES — Joined via ENC_LINE_ID; provides the summary grouping for each historical line.
• PSP_ENC_CONTROLS — Joined via ENC_CONTROL_ID; defines the encumbrance control batch.
• PSP_DEFAULT_LABOR_SCHEDULES — Joined via ORG_SCHEDULE_ID; supplies the labor schedule for the organization.
• PSP_ELEMENT_TYPE_ACCOUNTS — Joined via ELEMENT_ACCOUNT_ID; maps element types to accounts.
• IGF_AW_AWARD_ALL — Joined via AWARD_ID; the award definition used by Grants Accounting.
• PER_TIME_PERIODS — Joined via TIME_PERIOD_ID; the payroll time period.
• PAY_PAYROLL_ACTIONS — Joined via PAYROLL_ACTION_ID; the payroll action driving the labor cost.