Search Results child_support_code

Overview

APPS.PAY_NZ_ASG_CAL_MTH_BAL_V is a reporting view in the Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2 environment, owned by the APPS schema and registered in FND Design Data under the application short name PAY. The view is currently VALID and is classified as an internal view, meaning Oracle Corporation explicitly does not support direct customer access to its data except through standard Oracle Applications programs. Its designation as internal notwithstanding, the view is commonly queried within the Payroll and HRMS reporting layer for New Zealand (NZ) legislative payroll processing.

The view presents assignment-level payroll balance information on a calendar month basis. It aggregates and exposes balances that are specific to New Zealand statutory deductions and contributions, including PAYE, child support, student loan, and KiwiSaver amounts. This makes it a consolidated source for New Zealand payroll reporting, reconciliation, and downstream payroll analytics. The user searching for "child_support_code" will find this view directly relevant, since the view exposes both CHILD_SUPPORT_DEDUCTIONS and CHILD_SUPPORT_CODE as discrete columns.

Underlying Base Objects

The view is defined over a set of core Payroll and HRMS base objects. The documented dependencies include the following:

• PER_ALL_ASSIGNMENTS_F — the primary assignment table supplying ASSIGNMENT_ID and related assignment context.
• PAY_RUN_RESULTS and PAY_RUN_RESULT_VALUES — source of balance and run result values generated during payroll processing.
• PAY_BALANCE_FEEDS_F, PAY_BALANCE_TYPES, and PAY_INPUT_VALUES_F — the balance definition infrastructure that defines and feeds the balances aggregated by the view.
• PAY_PAYROLL_ACTIONS and PAY_ASSIGNMENT_ACTIONS — payroll action and assignment action context.
• PAY_NZ_TAX (PACKAGE) — the New Zealand tax package that supplies NZ-specific tax logic and derived values such as child support and PAYE.
• FND_SESSIONS and HR_SOFT_CODING_KEYFLEX — session context and soft coding key flexfield information.

Objects that reference this view downstream include APPS.PAY_NZ_EMS and PAY_NZ_ER_CAL_MTH_BAL_V, confirming its role as a foundational NZ calendar month balance view used by additional reporting and extract objects.

Key Columns

• ASSIGNMENT_ID — the assignment identifier, described as a system-generated primary key column; this is the primary join key to PER_ALL_ASSIGNMENTS_F.
• ORGANIZATION_ID — documented as a key flexfield segment column, carrying organizational context.
• EFFECTIVE_DATE — the effective date associated with the balance row.
• GROSS_EARNINGS — total gross earnings for the assignment in the calendar month.
• EARNINGS_NOT_LIABLE_FOR_ACC_EP — earnings excluded from ACC earners' levy liability.
• EXTRA_EMOL_AT_LOW_TAX_RATE — extra emolument amounts taxed at the low tax rate.
• PAYE_DEDUCTIONS — PAYE tax deducted.
• CHILD_SUPPORT_DEDUCTIONS — the monetary amount of child support deducted.
• CHILD_SUPPORT_CODE — the code identifying the child support category/type associated with the deduction.
• STUDENT_LOAN_DEDUCTIONS — student loan deductions, with SLCIR_DEDUCTION and SLBOR_DEDUCTION capturing the specific student loan components.
• KIWISAVER_EE_CONTRIBUTIONS and KIWISAVER_ER_CONTRIBUTIONS — employee and employer KiwiSaver contributions.
• PAYROLL_TAX_CREDITS — payroll tax credit amounts.

The presence of CHILD_SUPPORT_CODE alongside CHILD_SUPPORT_DEDUCTIONS allows reporting to distinguish not only how much child support was deducted but also which coded category it belongs to.

Common Use Cases and Queries

This view is typically used for New Zealand payroll reconciliation, statutory deduction reporting (PAYE, child support, student loan, ACC), KiwiSaver reporting, and downstream extracts. A representative query is:

SELECT ASSIGNMENT_ID, ORGANIZATION_ID, EFFECTIVE_DATE, GROSS_EARNINGS, PAYE_DEDUCTIONS, CHILD_SUPPORT_DEDUCTIONS, CHILD_SUPPORT_CODE, STUDENT_LOAN_DEDUCTIONS, KIWISAVER_EE_CONTRIBUTIONS, KIWISAVER_ER_CONTRIBUTIONS FROM APPS.PAY_NZ_ASG_CAL_MTH_BAL_V WHERE CHILD_SUPPORT_CODE IS NOT NULL ORDER BY EFFECTIVE_DATE, ASSIGNMENT_ID;

Because the object is flagged Oracle Internal Use Only, customers should generally consume it indirectly through supported Oracle payroll reports and extracts rather than building customizations directly against it, except where explicitly permitted under the applicable Oracle license and support agreement.