Search Results np_prem




Overview
Explore in AI Chat

Overview

PAY_KR_TAX_EXEM_V is a payroll view owned by the APPS schema in Oracle E-Business Suite, defined in the PAY — Payroll product. Its stated purpose is to return the Extra Information Type (EIT) value stored under the information type KR_YEA_TAX_EXEM_INFO, resolved by assignment_id. The view exists to expose Korean year-end adjustment (YEA) tax exemption and pension-related data captured as descriptive extra information on an assignment, presenting it in a normalized, strongly typed form suitable for reporting and downstream integration.

Because the underlying storage of assignment extra information is generic — values are held in positional columns such as AEI_INFORMATION1 through AEI_INFORMATION7 — raw queries against PER_ASSIGNMENT_EXTRA_INFO return untyped character strings. This view applies date and number conversion functions and assigns meaningful column aliases, so consumers can work with effective dates and numeric premium amounts directly. In practice it functions as a reporting convenience layer for Korean payroll localization data.

Underlying Base Objects

The view is defined over the following documented base objects:

  • PER_ASSIGNMENT_EXTRA_INFO (SYNONYM) — the primary source, aliased AEI, holding the assignment-level extra information rows.
  • FND_SESSIONS (SYNONYM) — aliased FND, joined to supply the session effective date.
  • FND_DATE (PACKAGE) — supplies CANONICAL_TO_DATE for converting the stored canonical date string.
  • FND_NUMBER (PACKAGE) — supplies CANONICAL_TO_NUMBER for converting stored canonical numeric strings.

The join logic restricts rows to INFORMATION_TYPE = 'KR_YEA_TAX_EXEM_INFO', matches FND.SESSION_ID to USERENV('SESSIONID'), and correlates the four-digit year extracted from the session effective date with the leading four characters of AEI_INFORMATION1. This year-matching predicate scopes results to the active tax year of the current session, which is a critical behavioral characteristic when writing queries against the view.

Key Columns

Common Use Cases and Queries

Typical usage includes year-end tax adjustment processing, reconciliation of pension premium deductions, and extraction of assignment-level exemption figures for reporting or integration into external tax systems.

  • Retrieve all exemption records for an assignment: SELECT assignment_id, effective_date, np_prem, pers_pension_prem, pers_pension_saving FROM apps.pay_kr_tax_exem_v WHERE assignment_id = :p_assignment_id;
  • Aggregate national pension premiums across assignments in the current session tax year: SELECT assignment_id, SUM(np_prem) FROM apps.pay_kr_tax_exem_v GROUP BY assignment_id;
  • Audit credit card and investment partnership entries: SELECT assignment_id, credit_card_exp, invest_partnership_fin1, invest_partnership_fin2 FROM apps.pay_kr_tax_exem_v;

Because the view depends on USERENV('SESSIONID') and the effective date held in FND_SESSIONS, results are session- and tax-year sensitive. Consumers should initialize the session context appropriately and avoid assuming the view returns all historical rows for an assignment.