Results for “psp_payroll_interface_pk”

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

Overview

PSP_PAYROLL_INTERFACE is a transaction interface table in the PSP (Labor Distribution) schema within Oracle E-Business Suite, owned by the Labor Distribution module. As documented in the ETRM 12.2.2 metadata, it contains non-Oracle payroll subline information to be imported into Labor Distribution, functioning as a staging and import surface for payroll detail originating outside the standard Oracle Payroll engine. Each row represents an individual payroll subline, capturing the assignment, element, earning amount, and the accounting period against which that cost should be distributed. The table is central to the process that takes third-party or legacy payroll feeds and transforms them into cost distribution transactions for labor distribution and subsequent general ledger posting.

Applying a heuristic Data Vault classification based on the foreign key structure, PSP_PAYROLL_INTERFACE behaves as a link entity. It resolves relationships between payroll period (PER_TIME_PERIODS), assignment, element type, and set of books (GL_SETS_OF_BOOKS), stitching together the operational payroll event and the accounting context into a single associative record. This classification is a modeling suggestion rather than a physically enforced construct.

Key Information Stored

The table carries 47 documented columns. The most operationally significant include:

• PAYROLL_INTERFACE_ID — Surrogate identifier for the interface row; combined with BATCH_NAME it forms the primary key PSP_PAYROLL_INTERFACE_PK.
• BATCH_NAME — Groups interface rows into a single import batch; part of the primary key and both unique indexes.
• PAYROLL_PERIOD_ID — Foreign key to PER_TIME_PERIODS, identifying the earning period.
• ASSIGNMENT_ID — The assignment to which the payroll subline cost is attributed.
• PERSON_ID — The employee or person associated with the subline.
• ELEMENT_TYPE_ID — The earning or element type classifying the subline.
• PAY_AMOUNT, DAILY_RATE, FTE, SALARY_USED — Monetary and rate information used for cost derivation.
• SUB_LINE_START_DATE, SUB_LINE_END_DATE — Effective date range for the subline.
• STATUS_CODE and ERROR_CODE — Import processing state and any validation failure.
• SET_OF_BOOKS_ID — Foreign key to GL_SETS_OF_BOOKS, determining the accounting ledger.
• BUSINESS_GROUP_ID — Multi-organization partitioning key.

Two unique indexes act as business-key candidates: PSP_PAYROLL_INTERFACE_U1 (BATCH_NAME, PAYROLL_INTERFACE_ID) and PSP_PAYROLL_INTERFACE_U2 (PAYROLL_INTERFACE_ID).

Common Use Cases and Queries

Typical usage centers on monitoring import batches, diagnosing rejections, and reporting distributed payroll costs. A common validation query checks pending rows and their error status:

• SELECT payroll_interface_id, assignment_id, pay_amount, status_code, error_code FROM psp_payroll_interface WHERE batch_name = :batch AND status_code = 'ERROR'.
• Joining to PER_TIME_PERIODS and GL_SETS_OF_BOOKS to reconcile interface sublines to their accounting period and ledger.
• Aggregating PAY_AMOUNT by ASSIGNMENT_ID, ELEMENT_TYPE_ID, and PAYROLL_PERIOD_ID for distribution reporting.
• Auditing rows by CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, and LAST_UPDATED_BY for import traceability.

Related Objects

The FK relationships and PSP context identify the following significant related objects:

• PER_TIME_PERIODS — joined on PSP_PAYROLL_INTERFACE.PAYROLL_PERIOD_ID; supplies period dates.
• GL_SETS_OF_BOOKS — joined on PSP_PAYROLL_INTERFACE.SET_OF_BOOKS_ID; supplies ledger context.
• PER_ALL_ASSIGNMENTS_F — resolves ASSIGNMENT_ID to active assignment attributes.
• PER_ALL_PEOPLE_F — resolves PERSON_ID to person details.
• PAY_ELEMENT_TYPES_F — resolves ELEMENT_TYPE_ID to element definitions.
• PSP_PAYROLL_INTERFACE_BATCHES — groups interface rows by BATCH_NAME.
• PSP_ELEMENT_ENTRIES — downstream labor distribution entries generated from imported sublines.