Search Results pay_nz_soe_run_elements_v2




Overview
Explore in AI Chat

Overview

PAY_NZ_SOE_RUN_ELEMENTS_V2 is an Oracle E-Business Suite view owned by the APPS schema and registered as VALID under the PAY (Payroll) product family. It is a New Zealand localization object designed to support Summary of Earnings (SOE) reporting. In practical terms, the view consolidates payroll run results into a report-ready shape, aggregating monetary amounts by element and by a derived classification label, for completed payroll actions within the New Zealand legislation.

The view is a reporting construct rather than a transactional entity. It exposes data for completed payroll runs (action types R and Q with an action status of C) and filters strictly on PEC.LEGISLATION_CODE = 'NZ'. Its role is to give downstream SOE extract programs, concurrent reports, and integration feeds a stable, pre-joined, pre-aggregated dataset, sparing those consumers from repeatedly encoding the same multi-table payroll joins.

Underlying Base Objects

The view is defined over nine base objects, all referenced through APPS synonyms:

The join chains link payroll actions to assignment actions, assignment actions to run results and interlocks, run results to run result values, and elements to their classifications, input values, and element definitions, forming the full payroll calculation trace.

Key Columns

  • REPORT_NAME — the display label for the element, returned as NVL(PET.REPORTING_NAME, PET.ELEMENT_NAME).
  • CLASSIFICATION_NAME — a derived concatenation of labels such as 'TAXABLE EARNINGS', 'NON TAXABLE ALLOWANCES', and 'DEDUCTIONS', with special handling mapping employer super contributions and SSCWT deductions.
  • AMOUNT — the aggregated monetary value, summed where the input value's unit of measure begins with 'M'.
  • PROCESSING_PRIORITY — the element processing priority from the element type definition.
  • RUN_ASSIGNMENT_ACTION_ID — the locking assignment action identifier obtained from PAI.LOCKING_ACTION_ID.
  • ASSIGNMENT_ID — the assignment identifier from the assignment action.

Common Use Cases and Queries

The principal use case is generating New Zealand Summary of Earnings output by element and classification for a completed pay period. A typical query restricts the view to a specific period or assignment action and orders the results by processing priority to produce a readable earnings statement.

  • SOE extract for a payroll period, grouped by assignment and report name.
  • Reconciliation of taxable earnings, non-taxable allowances, and deductions.
  • Employer superannuation and SSCWT reporting feeds.

Sample query:

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

Note that the view already filters to completed NZ payroll runs, so consumers need only add period, assignment, or classification predicates. Because amounts are aggregated at element level, joining back to run results for detail is required only when transaction-level granularity is needed.