Search Results pay_au_term_super_v




Overview
Explore in AI Chat

Overview

PAY_AU_TERM_SUPER_V is an Australian localisation view owned by the APPS schema within the Payroll (PAY) product module of Oracle E-Business Suite. It is a reporting and integration artifact that consolidates the termination-related superannuation rollover element entries for a terminated employee, exposing the associated payment method and payment type information alongside the key input values captured on the element entry. The view is documented as VALID in the ETRM repository for release 12.2.2 and remains applicable to 12.1.1, where the same underlying dictionary objects exist.

The view isolates entries for the element named "SUPERANNUATION ROLLOVER ON TERMINATION". It joins each element entry to its three relevant input values (PAY VALUE, AMOUNT PART PREV ETP, and AMOUNT NOT PART PREV ETP) and to the employee's personal payment method, the organisation payment method, and the payment type. It also derives a single-character processing indicator by invoking the PAY_AU_TERMINATIONS.PROCESSED database function, which is the principal reason the view exists: it surfaces payroll processing status for rollover amounts in a single queryable row.

Because it is a view rather than a table, it stores no data of its own and is used strictly for read access in reporting, reconciliation, and downstream dataload scenarios.

Underlying Base Objects

The view is defined over the following documented base objects, all referenced through APPS synonyms:

Key Columns

The view exposes the ROWID and OBJECT_VERSION_NUMBER of the underlying element entry, together with ELEMENT_ENTRY_ID, ELEMENT_LINK_ID, CREATOR_TYPE, ENTRY_TYPE, and ELEMENT_TYPE_ID. Assignment context is provided by ASSIGNMENT_ID and PERSONAL_PAYMENT_METHOD_ID. Payment descriptors include ORG_PAYMENT_METHOD_ID, PAYMENT_TYPE_ID, and a concatenated string combining the organisation name, organisation payment method name, and payment type name.

The three input-value pairs expose INPUT_VALUE_ID, SCREEN_ENTRY_VALUE, and UOM for PAY VALUE, AMOUNT PART PREV ETP, and AMOUNT NOT PART PREV ETP. Date-effective control is handled by EFFECTIVE_START_DATE and EFFECTIVE_END_DATE. The final column is a one-character SUBSTR of the PAY_AU_TERMINATIONS.PROCESSED result, representing the termination processing status indicator for the entry.

Common Use Cases and Queries

The view is typically queried to report superannuation rollover amounts on termination, to reconcile paid versus unpaid rollover components, and to validate payment method routing.

  • Listing all rollover entries for an assignment with their amounts and payment method.
  • Filtering entries where the PROCESSED indicator is not a completed status to identify pending rollovers.
  • Extracting the split between the part-prev-ETP and not-part-prev-ETP amounts for tax reconciliation.

A representative query is:

SELECT assignment_id, screen_entry_value, uom, effective_start_date FROM pay_au_term_super_v WHERE assignment_id = :p_assignment_id AND TRUNC(effective_start_date) <= TRUNC(SYSDATE);

Because the view calls a package function per row, queries should be restricted by assignment or effective date to limit processing overhead on large payroll volumes.