Search Results pay_nz_soe_run_elements_v1




Overview
Explore in AI Chat

Overview

PAY_NZ_SOE_RUN_ELEMENTS_V1 is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Payroll (PAY) product family. It supports New Zealand statutory reporting, specifically the compilation of payroll element runs required for the New Zealand Summary of Earnings (SOE) and related month-end or year-end reconciliation extracts. The view consolidates completed payroll run activity for New Zealand assignments and normalises each payroll element into a statutory reporting category — taxable earnings, non-taxable allowances, deductions, or employer superannuation contributions — based on the element classification seeded against the NZ legislation.

Because the object is defined as a view rather than a table, it carries no data of its own and imposes no storage or maintenance overhead. Its role is entirely read-oriented: it presents a business-friendly projection of payroll run results that downstream SOE extracts, balances reports, and external file generation processes can consume with a single query. The view is marked VALID in the ETRM 12.2.2 object registry.

Underlying Base Objects

The view is defined over eight base objects, all referenced through APPS synonyms: PAY_PAYROLL_ACTIONS, PER_ALL_ASSIGNMENTS_F, PAY_ASSIGNMENT_ACTIONS, PAY_RUN_RESULTS, PAY_RUN_RESULT_VALUES, PAY_ELEMENT_TYPES_F, PAY_INPUT_VALUES_F, and PAY_ELEMENT_CLASSIFICATIONS. These are joined on the standard payroll processing keys: payroll action to assignment action, assignment action to run result, run result to input value, and element type to classification.

The driving filter restricts output to payroll actions of type R (regular) and Q (quick) with a status of C (completed). Only result values whose input value is either PAY VALUE or HOURS are returned, and only those element classifications whose legislation code is NZ and whose classification name contains the statutory keywords: EARNINGS, REIMBURSEMENTS, DEDUCTIONS, EMPLOYER SPECIFIED SUPERANNUATION CONTRIBUTIONS, or EMPLOYER CHARGES.

Key Columns

  • REPORT_NAME — the element's reporting name where defined, otherwise the element name; used as the display label in the SOE output.
  • CLASSIFICATION_NAME — derived statutory bucket mapped from the element classification, such as TAXABLE EARNINGS, NON TAXABLE ALLOWANCES, DEDUCTIONS, or EMPLOYER SUPERANNUATION CONTRIBUTIONS. The decode logic also remaps specific elements like EMPLOYER SUPER CONTRIBUTIONS and SSCWT DEDUCTION.
  • AMOUNT — the summed run result value, taken only where the input value UOM begins with M (monetary), ensuring hours are excluded from financial totals.
  • PROCESSING_PRIORITY — the element's processing priority, used to preserve the run sequence in reporting.
  • RUN_ASSIGNMENT_ACTION_ID — the assignment action identifier, enabling drill-down back to the specific run.
  • ASSIGNMENT_ID — the assignment for which the amount was calculated.

Common Use Cases and Queries

Typical usage covers SOE reconciliation, taxable earnings verification, and employer superannuation reporting. A representative query groups amounts by assignment and classification:

SELECT run_assignment_action_id, assignment_id, report_name, classification_name, amount FROM apps.pay_nz_soe_run_elements_v1 WHERE assignment_id = :p_assignment_id ORDER BY processing_priority;

A second common pattern aggregates totals per classification for a payroll period:

SELECT classification_name, SUM(amount) FROM apps.pay_nz_soe_run_elements_v1 GROUP BY classification_name;

Analysts frequently join the view to PAY_PAYROLL_ACTIONS or PER_ALL_ASSIGNMENTS_F to tie results to a payroll period or employee. Note that the view exposes only PAY VALUE and HOURS input values, so balances-based reporting should use the payroll balance views instead.