Results for “pers_pension_saving”
16 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
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) — suppliesCANONICAL_TO_DATEfor converting the stored canonical date string.FND_NUMBER(PACKAGE) — suppliesCANONICAL_TO_NUMBERfor 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
ROW_ID— the ROWID of the underlying extra information row.ASSIGNMENT_EXTRA_INFO_ID— surrogate identifier of the source extra information record.ASSIGNMENT_ID— the assignment to which the tax exemption data belongs.INFORMATION_TYPE— alwaysKR_YEA_TAX_EXEM_INFOfor rows returned by this view.AEI_INFORMATION_CATEGORY— the extra information category of the record.OBJECT_VERSION_NUMBER— optimistic locking version of the source row.EFFECTIVE_DATE— canonical date converted fromAEI_INFORMATION1.NP_PREM— national pension premium, converted fromAEI_INFORMATION2. This is the column associated with the user search term "np_prem".PERS_PENSION_PREM— personal pension premium, fromAEI_INFORMATION3.PERS_PENSION_SAVING— personal pension saving, fromAEI_INFORMATION4.INVEST_PARTNERSHIP_FIN1andINVEST_PARTNERSHIP_FIN2— investment partnership figures, fromAEI_INFORMATION5andAEI_INFORMATION6.CREDIT_CARD_EXP— credit card expenditure, fromAEI_INFORMATION7.
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.
-
View: PAY_KR_TAX_EXEM_V 12.1.1
This view returns EIT value of 'KR_YEA_TAX_EXEM_INFO' based on assignment_id.
APPS.PAY_KR_TAX_EXEM_V·↳ FND_DATE·↳ FND_NUMBER·↳ FND_SESSIONS·Explore PAY module →
-
View: PAY_KR_TAX_EXEM_V 12.2.2
This view returns EIT value of 'KR_YEA_TAX_EXEM_INFO' based on assignment_id.
APPS.PAY_KR_TAX_EXEM_V·↳ FND_DATE·↳ FND_NUMBER·↳ FND_SESSIONS·Explore PAY module →
-
VIEW: APPS.PAY_KR_TAX_EXEM_V 12.1.1
-
VIEW: APPS.PAY_KR_TAX_EXEM_V 12.2.2
-
VIEW: APPS.PAY_KR_TAX_EXEM_V 12.1.1
-
VIEW: APPS.PAY_KR_TAX_EXEM_V 12.2.2
-
PACKAGE: APPS.PAY_KR_YEA_PKG 12.1.1
-
PACKAGE: APPS.PAY_KR_YEA_PKG 12.2.2
-
eTRM - PAY Tables and Views 12.1.1
Temporary table used to hold invalid location addresses.
-
eTRM - PAY Tables and Views 12.2.2
Temporary table used to hold invalid location addresses.