Search Results kiwisaver_er_contributions




Overview
Explore in AI Chat

Overview

APPS.PAY_NZ_ER_CAL_MTH_BAL_V is a reporting view in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 that presents aggregated, calendar-month New Zealand employer payroll balances at the organization level. Its role is to consolidate assignment-level payroll results into monthly totals suitable for statutory reporting, reconciliation, and downstream integration—particularly where deduction categories such as child support, PAYE, student loan, and KiwiSaver must be summed across a payroll period.

The view filters the underlying data set to records where gross earnings less PAYE deductions, child support deductions, and student loan deductions is greater than or equal to zero, and restricts element types to "PAYE Information" and "Withholding Tax Information Record". It also resolves the latest effective version of the element type and assignment and the most recent assignment action, ensuring that only the current valid records are included for the reporting month derived from fnd_sessions.

The name itself—employer (ER) calendar month balance view—signals that the output is oriented toward the employer's monthly summary position rather than individual payslips. The inclusion of the child_support_deductions column explains its relevance to searches about child support, as NZ payroll reporting requires accurate monthly totals of child support withheld from employees.

Underlying Base Objects

According to the documented metadata, the view is defined over the following base objects:

  • PAY_NZ_ASG_CAL_MTH_BAL_V — the assignment-level calendar-month balance view that supplies the core payroll amounts aggregated by the outer query.
  • PAY_ELEMENT_TYPES_F — element type definitions, used to restrict results to PAYE Information and Withholding Tax Information Record elements and to obtain the latest effective row.
  • PAY_ASSIGNMENT_ACTIONS — links assignments to payroll actions; the view selects the maximum assignment action ID per assignment.
  • PAY_PAYROLL_ACTIONS — payroll action context, joined to assignment actions and run results.
  • PAY_RUN_RESULTS — individual payroll run result rows used in the subquery to determine the latest assignment action.
  • PER_ASSIGNMENTS_F — assignment (and person) effective-dated records, resolved to the latest version valid within the month.
  • FND_SESSIONS — provides the effective date used to derive the calendar month boundaries via last_day and 01/mm/yyyy logic.
  • HR_GENERAL and HR_SECURITY — security and utility packages associated with the view's governed data access.
  • PAY_NZ_TAX — the New Zealand tax package referenced in the view definition.

Key Columns

  • organization_id — the employer/organization identifier; the primary grouping key.
  • effective_date — the date associated with the monthly balance.
  • gross_earnings — total gross earnings for the month.
  • earnings_not_liable_for_acc_ep — earnings exempt from ACC earners' premium.
  • paye_deductions — total PAYE withheld.
  • child_support_deductions — total child support withheld from employees for the month.
  • student_loan_deductions — total student loan deductions.
  • kiwisaver_ee_contributions and kiwisaver_er_contributions — employee and employer KiwiSaver contributions (added for Bug 5846247).
  • payroll_tax_credits — payroll tax credits (added for Bug 9237657).
  • slcir_deduction and slbor_deduction — student loan interest/border deduction components (added for Bug 13627558).

Common Use Cases and Queries

The view is typically used to produce monthly employer summaries and to reconcile child support and other statutory deductions. A simple query returns monthly totals per organization:

  • SELECT organization_id, effective_date, child_support_deductions FROM apps.pay_nz_er_cal_mth_bal_v;
  • Reconciling child support, PAYE, and student loan totals for a given month and organization.
  • Feeding employer-level statutory reporting, KiwiSaver returns, and ACC-related earning extracts.
  • Comparing gross earnings against aggregate deductions, since the view enforces a non-negative net constraint.

Because the view derives its month from fnd_sessions, queries executed within a payroll session reflect the effective date of that session. For historical or cross-period reporting, it is advisable to combine the view with explicit date filters on effective_date and validate results against the underlying assignment-level view.