Results for “psp_payroll_sub_lines_u1”

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

Overview

PSP.PSP_PAYROLL_SUB_LINES is a transaction-level table in the Oracle E-Business Suite Payroll sub-ledger for projects (PSP) schema. It stores the decomposition of a payroll amount recorded on a payroll line into one or more finer-grained sublines. A subline is created when Human Resources attributes — such as Dates of Interest, salary changes, assignment changes, or organizational movement — change within the period covered by a single payroll line. According to the ETRM documentation, PSP_PAYROLL_SUB_LINES contains information where a payroll amount in a payroll line is split into more than one subline because of changes in Human Resources information. One or more payroll sublines must correspond to one payroll line.

The table resides in the APPS_TS_TX_DATA tablespace with PCT Free 10. It is owned by the PSP schema and carries FND Design Data under PSP.PSP_PAYROLL_SUB_LINES. In Oracle EBS 12.1.1 and 12.2.2 the object is reported as VALID. From a dimensional modeling perspective, the heuristic Data Vault classification mined from the foreign key structure is satellite-leaning, suggesting the table behaves as a descriptive satellite attached to the payroll line hub rather than as an independent business hub or linking table.

Key Information Stored

Each row is uniquely identified by the system-generated primary key PAYROLL_SUB_LINE_ID, which also anchors the unique index PSP_PAYROLL_SUB_LINES_U1. The documented schema contains 37 columns that fall into several logical groups.

• PAYROLL_LINE_ID — foreign key to PSP_PAYROLL_LINES; the parent payroll line being split.
• SUB_LINE_START_DATE and SUB_LINE_END_DATE — the effective date range the subline covers.
• PAY_AMOUNT, DAILY_RATE, SALARY_USED, CURRENT_SALARY, and FTE — the monetary and effort measures apportioned to the subline for the given date range.
• REASON_CODE — explains why the subline was created (for example, a change in Human Resources information).
• ORGANIZATION_ID, JOB_ID, POSITION_ID, and GRADE_ID — the HR assignment attributes in effect for the subline.
• EMPLOYMENT_BEGIN_DATE, EMPLOYMENT_END_DATE, EMPLOYEE_STATUS_INACTIVE_DATE, EMPLOYEE_STATUS_ACTIVE_DATE, ASSIGNMENT_BEGIN_DATE, and ASSIGNMENT_END_DATE — the employment and assignment life cycle dates that drive the split.
• PEOPLE_GROUP_ID — foreign key to PAY_PEOPLE_GROUPS.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE — standard Who columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE10 — the standard descriptive flexfield (DFF) columns.

The unique index PSP_PAYROLL_SUB_LINES_U1 (PAYROLL_SUB_LINE_ID) is the business-key candidate, while the nonunique index PSP_PAYROLL_SUB_LINES_N1 (PAYROLL_LINE_ID) supports parent-child lookups. The primary key constraint is PSP_PAYROLL_SUB_LINES_PK (PAYROLL_SUB_LINE_ID).

Common Use Cases and Queries

Payroll and project costing reporting frequently requires flattening sublines back to their parent payroll line. A typical pattern joins the subline to PSP_PAYROLL_LINES on PAYROLL_LINE_ID, filtering by the effective date range to isolate a pay period:

• Retrieving all sublines for a payroll line: SELECT PAYROLL_SUB_LINE_ID, SUB_LINE_START_DATE, SUB_LINE_END_DATE, PAY_AMOUNT, DAILY_RATE FROM PSP.PSP_PAYROLL_SUB_LINES WHERE PAYROLL_LINE_ID = :line_id ORDER BY SUB_LINE_START_DATE.
• Summing apportioned amounts per line to reconcile against the parent: SELECT PAYROLL_LINE_ID, SUM(PAY_AMOUNT) FROM PSP.PSP_PAYROLL_SUB_LINES GROUP BY PAYROLL_LINE_ID.
• Reporting distribution activity by joining PSP_DISTRIBUTION_LINES to PSP_PAYROLL_SUB_LINES on PAYROLL_SUB_LINE_ID.
• Investigating why a split occurred by joining to PSP_SUB_LINE_REASONS on PAYROLL_SUB_LINE_ID.
• Historical comparisons against PSP_DISTRIBUTION_LINES_HISTORY and PSP_DISTRIBUTION_LINES_ARCH.

Because the table carries standard Who columns and DFF attributes, it is also commonly queried for audit and flexfield extraction reporting.

Related Objects

The foreign key metadata identifies the following key relationships. Parents referenced by PSP_PAYROLL_SUB_LINES include PSP_PAYROLL_LINES (via PAYROLL_LINE_ID), HR_ALL_ORGANIZATION_UNITS (via ORGANIZATION_ID), PER_JOBS (via JOB_ID), and PAY_PEOPLE_GROUPS (via PEOPLE_GROUP_ID). Child tables referencing PSP_PAYROLL_SUB_LINES through PAYROLL_SUB_LINE_ID include PSP_DISTRIBUTION_LINES, PSP_DISTRIBUTION_LINES_HISTORY, PSP_SUB_LINE_REASONS, and PSP_DISTRIBUTION_LINES_ARCH. Together these objects describe how a payroll amount is split, distributed to cost accounts, reclassified, and archived, making PSP_PAYROLL_SUB_LINES a central transactional anchor for payroll-to-project distribution reporting in Oracle EBS 12.1.1 and 12.2.2.