Results for “pay_amount”

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

Overview

PSP_PAYROLL_LINES is a Labor Distribution (PSP) table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores one row for every payroll line imported into Oracle Labor Distribution from Oracle Payroll or from external, non-Oracle payroll sources. It functions as the central staging and detail repository for payroll cost data before that data is distributed, balanced, and transferred to General Ledger. Each record captures the pay event, the earning element, the employee, the assignment, and the accounting attributes required to allocate labor costs across the enterprise.

The table is owned by the PSP schema and is documented as VALID with 30 columns. Based on the foreign key structure mined from the ETRM metadata, PSP_PAYROLL_LINES presents a satellite-leaning profile: it carries descriptive and measurable payroll attributes (amounts, dates, status codes) that surround its parent collection context defined by PSP_PAYROLL_CONTROLS. In a Data Vault model, this would suggest treating PSP_PAYROLL_LINES as a satellite hanging off the payroll control hub, with links to GL and cost reference data. Because the table also holds several foreign keys to independent reference dimensions (GL_SETS_OF_BOOKS, PAY_COSTS, GL_CODE_COMBINATIONS), it may alternatively be modeled as a link table in certain designs.

Key Information Stored

The table's surrogate primary key is PAYROLL_LINE_ID, enforced by the unique index PSP_PAYROLL_LINES_U1 and the constraint PSP_PAYROLL_LINES_PK. The most significant business columns include:

• PAYROLL_CONTROL_ID — foreign key to PSP_PAYROLL_CONTROLS, tying each line to the payroll run or control batch it belongs to.
• ASSIGNMENT_ID and PERSON_ID — identify the employee assignment and person whose labor cost is being recorded.
• ELEMENT_TYPE_ID — the earning or deduction element from which the payroll line originated.
• PAY_AMOUNT and BALANCE_AMOUNT — the monetary value of the line and its balancing amount used in cost distribution.
• STATUS_CODE — processing state of the line (for example, imported, distributed, or transferred).
• CHECK_DATE, EARNED_DATE, and ACCOUNTING_DATE — the payment date, the date the pay was earned, and the GL accounting date respectively.
• SET_OF_BOOKS_ID — foreign key to GL_SETS_OF_BOOKS, identifying the ledger.
• GL_CODE_COMBINATION_ID — foreign key to GL_CODE_COMBINATIONS, the accounting flexfield charged by the line.
• COST_ALLOCATION_KEYFLEX_ID — foreign key to PAY_COST_ALLOCATION_KEYFLEX, the allocation flexfield used to spread costs.
• COST_ID — foreign key to PAY_COSTS, linking the line to its cost record.
• DR_CR_FLAG — indicates whether the line is a debit or credit.
• OR_GL_CODE_COMBINATION_ID, OR_PROJECT_ID, OR_TASK_ID, OR_AWARD_ID, OR_EXPENDITURE_ORG_ID, and OR_EXPENDITURE_TYPE — the original (pre-redistribution) accounting and project attributes, supporting audit and reversal of redistributed costs.
• EFFECTIVE_DATE and standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) provide date-effective and WHO-column tracking.

Common Use Cases and Queries

Typical uses include reconciling imported payroll costs against Oracle Payroll, reporting labor distribution by employee, element, or account, and auditing cost redistribution. A representative query joins the line to its control batch and ledger:

• SELECT pl.payroll_line_id, pl.pay_amount, pl.status_code, pl.check_date FROM psp_payroll_lines pl WHERE pl.payroll_control_id = :control_id;
• Reporting by account: join GL_CODE_COMBINATIONS on GL_CODE_COMBINATION_ID to summarize debits and credits for a period, filtering on ACCOUNTING_DATE and STATUS_CODE.
• Reconciliation: join to PAY_COSTS on COST_ID and to PSP_PAYROLL_CONTROLS on PAYROLL_CONTROL_ID to compare imported versus distributed amounts.
• Audit of redistributions: compare OR_GL_CODE_COMBINATION_ID and OR_PROJECT_ID against the current GL_CODE_COMBINATION_ID to identify reallocated lines.

Related Objects

The following objects are the most significant dependencies per the documented foreign key metadata:

• PSP_PAYROLL_CONTROLS — parent control batch; joined via PAYROLL_CONTROL_ID.
• PSP_PAYROLL_SUB_LINES — child table referencing this table through PSP_PAYROLL_SUB_LINES.PAYROLL_LINE_ID.
• GL_SETS_OF_BOOKS — ledger definition; joined via SET_OF_BOOKS_ID.
• GL_CODE_COMBINATIONS — accounting flexfield; joined via GL_CODE_COMBINATION_ID.
• PAY_COST_ALLOCATION_KEYFLEX — allocation flexfield; joined via COST_ALLOCATION_KEYFLEX_ID.
• PAY_COSTS — cost detail; joined via COST_ID.