Results for “psp_summary_lines”

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

Overview

PSP_SUMMARY_LINES is a core table in the Oracle EBS Labor Distribution (PSP) module. It stores summarized distribution lines — the intermediate aggregation layer that consolidates detailed payroll costing and labor distribution activity into summarized amounts before those amounts are transferred to Oracle Projects, Oracle Grants, and the General Ledger. Each row represents a summarized distribution amount tied to a person, assignment, payroll control, and accounting context, expressed against a specific GL code combination, project, task, award, and expenditure type.

The table sits downstream of detailed calculation and pre-generation processing and upstream of the distribution, adjustment, and interface posting processes. It acts as the staging and reconciliation point where labor costs are grouped, balanced by debit/credit flag, and tracked through interface status codes before final accounting impact.

From a heuristic Data Vault perspective, the FK topology classifies PSP_SUMMARY_LINES as satellite-leaning. It carries a surrogate primary key, extensive descriptive and quantitative attributes, and multiple reference relationships; it is best modeled as a satellite attached to hubs/link structures constructed from person, assignment, payroll control, project, and code combination business keys rather than as an independent hub.

Key Information Stored

• SUMMARY_LINE_ID — surrogate primary key, enforced by PSP_SUMMARY_LINES_PK and uniquely indexed by PSP_SUMMARY_LINES_U1. This is the only documented unique/business-key candidate.
• PAYROLL_CONTROL_ID — links the summarized line to the governing payroll control record that drives the distribution run.
• PERSON_ID and ASSIGNMENT_ID — identify the employee and assignment whose labor cost is being distributed.
• TIME_PERIOD_ID — the payroll period the summarized amount belongs to.
• SUMMARY_AMOUNT and ACTUAL_SUMMARY_AMOUNT — the summarized monetary amounts, with the latter holding the actual figure used in reconciliation.
• DR_CR_FLAG — debit/credit indicator essential for balancing summarized distributions.
• GL_CODE_COMBINATION_ID — the accounting flexfield combination charged by the summarized line.
• PROJECT_ID, TASK_ID, AWARD_ID, EXPENDITURE_TYPE, and EXPENDITURE_ORGANIZATION_ID — the Projects/Grants costing dimensions.
• EXPENDITURE_ID and EXPENDITURE_ITEM_ID — link back to the created Oracle Projects expenditure and expenditure item after transfer.
• SET_OF_BOOKS_ID — the ledger to which the summarized line is destined.
• SOURCE_TYPE, SOURCE_CODE, and SOURCE_TYPE-derived GROUP_ID — classify the origin of the summarized line.
• INTERFACE_STATUS and STATUS_CODE — track processing state through the distribution/interface lifecycle.
• INTERFACE_BATCH_NAME, GMS_BATCH_NAME, and GMS_POSTING_EFFECTIVE_DATE — support batch identification and Grants posting.
• EFFECTIVE_DATE, ACCOUNTING_DATE, and EXPENDITURE_ENDING_DATE — key date attributes for period and accounting placement.
• Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) plus 30 descriptive ATTRIBUTE columns and ORG_ID.

Common Use Cases and Queries

Typical usage centers on reconciliation and interface monitoring. A common query retrieves summarized lines for a given payroll control and period to verify totals balance:

• Summing SUMMARY_AMOUNT by DR_CR_FLAG and PAYROLL_CONTROL_ID to confirm debits equal credits before posting.
• Filtering on INTERFACE_STATUS or STATUS_CODE to identify lines not yet transferred to Oracle Projects or the GL.
• Joining to GL_CODE_COMBINATIONS and GL_SETS_OF_BOOKS to build labor cost distribution reports by account and ledger.
• Aggregating by PROJECT_ID, TASK_ID, and EXPENDITURE_TYPE to reconcile labor costs charged to projects and awards.
• Drilling from a summarized line via SUMMARY_LINE_ID into PSP_DISTRIBUTION_LINES for the supporting detail.

Related Objects

• PSP_DISTRIBUTION_LINES / PSP_DISTRIBUTION_LINES_HISTORY — child detail referencing SUMMARY_LINE_ID.
• PSP_ADJUSTMENT_LINES / PSP_ADJUSTMENT_LINES_HISTORY — adjustments tied to a summarized line via SUMMARY_LINE_ID.
• PSP_PRE_GEN_DIST_LINES / PSP_PRE_GEN_DIST_LINES_HISTORY — pre-generation detail referencing SUMMARY_LINE_ID.
• PSP_PAYROLL_CONTROLS — joined on PAYROLL_CONTROL_ID.
• PA_PROJECTS_ALL, PA_TASKS, PA_EXPENDITURE_TYPES, PA_EXPENDITURES_ALL, and PA_EXPENDITURE_ITEMS_ALL — joined on PROJECT_ID, TASK_ID, EXPENDITURE_TYPE, EXPENDITURE_ID, and EXPENDITURE_ITEM_ID.
• GL_CODE_COMBINATIONS and GL_SETS_OF_BOOKS — joined on GL_CODE_COMBINATION_ID and SET_OF_BOOKS_ID.
• HR_ALL_ORGANIZATION_UNITS and PER_TIME_PERIODS — joined on EXPENDITURE_ORGANIZATION_ID and TIME_PERIOD_ID.
• IGF_AW_AWARD_ALL — joined on AWARD_ID for Grants integration.