Results for “current_salary”

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

Overview

PSP_PAYROLL_SUB_LINES is a table in the PSP (Labor Distribution) product schema of Oracle E-Business Suite, present in both release 12.1.1 and 12.2.2. It stores the detail rows that result when a single payroll amount recorded on a payroll line is divided across more than one subline, a situation that arises whenever a costing or distribution split is required for a portion of an employee's pay. In this way the table acts as the intermediate granular level between the payroll header/lines layer and the distribution layer, capturing the specific organisation, job, position, and amount values that will ultimately drive cost allocation.

The table carries 37 documented columns and is owned by the PSP schema with status VALID. Its primary key, PSP_PAYROLL_SUB_LINES_PK, is defined on the PAYROLL_SUB_LINE_ID column, and a unique index (PSP_PAYROLL_SUB_LINES_U1) enforces the same column, making it the sole documented business-key candidate. Using a Data Vault style heuristic, the mined foreign key structure suggests a satellite-leaning classification: the object holds descriptive and measure-level detail attached to a parent payroll line rather than functioning as a pure hub or an associative link. This should be treated as a modelling suggestion rather than a definitive Oracle design statement.

Key Information Stored

The most significant columns fall into three groups: identity, financial measures, and assignment context.

• PAYROLL_SUB_LINE_ID — surrogate primary key and the column referenced by all downstream tables.
• PAYROLL_LINE_ID — foreign key to PSP_PAYROLL_LINES, tying the subline back to its parent payroll line.
• SUB_LINE_START_DATE and SUB_LINE_END_DATE — the effective period for the split amount.
• REASON_CODE — identifies why the amount was split; reason detail is held in PSP_SUB_LINE_REASONS.
• PAY_AMOUNT — the monetary value assigned to this subline.
• DAILY_RATE, SALARY_USED, and CURRENT_SALARY — rate and salary basis fields supporting costing calculations.
• ORGANIZATION_ID — foreign key to HR_ALL_ORGANIZATION_UNITS, identifying the costing organisation.
• JOB_ID and POSITION_ID — foreign keys into HR job and position definitions (JOB_ID references PER_JOBS).
• GRADE_ID and PEOPLE_GROUP_ID — the grade and people group (PAY_PEOPLE_GROUPS) associated with the subline.
• FTE — full-time equivalent factor used in pro-rating.
• EMPLOYMENT_BEGIN_DATE, EMPLOYMENT_END_DATE, ASSIGNMENT_BEGIN_DATE, ASSIGNMENT_END_DATE — dates establishing the employment and assignment context.
• EMPLOYEE_STATUS_ACTIVE_DATE and EMPLOYEE_STATUS_INACTIVE_DATE — status transition dates.
• Standard WHO/audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and ten ATTRIBUTE flex columns.

Common Use Cases and Queries

The table is used principally for cost distribution reporting and reconciliation between payroll and the general ledger. A typical pattern retrieves all sublines for a payroll line with their organisation context:

• SELECT s.payroll_sub_line_id, s.pay_amour, s.organization_id FROM psp_payroll_sub_lines s WHERE s.payroll_line_id = :line_id;
• Joining to PSP_DISTRIBUTION_LINES on PAYROLL_SUB_LINE_ID to trace how each subline was distributed to accounting segments.
• Joining to PSP_SUB_LINE_REASONS to report the reason a payroll amount was split.
• Aggregating PAY_AMOUNT by ORGANIZATION_ID or PEOPLE_GROUP_ID for labour cost analysis by department or group.

Related Objects

• PSP_PAYROLL_LINES — parent table joined on PAYROLL_LINE_ID.
• PSP_DISTRIBUTION_LINES — child table joined on PAYROLL_SUB_LINE_ID.
• PSP_DISTRIBUTION_LINES_HISTORY and PSP_DISTRIBUTION_LINES_ARCH — historical and archived distribution records.
• PSP_SUB_LINE_REASONS — holds reason detail for splits.
• HR_ALL_ORGANIZATION_UNITS — organisation referenced by ORGANIZATION_ID.
• PER_JOBS — job referenced by JOB_ID.
• PAY_PEOPLE_GROUPS — people group referenced by PEOPLE_GROUP_ID.