Results for “pay_kr_prev_er_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PAY_KR_PREV_ER_V is an APPS-owned, VALID database view within the Oracle E-Business Suite Payroll (PAY) module. It is a country-specific (KR, South Korea) reporting and integration object whose stated purpose is to return the value of the Extra Information Type (EIT) named KR_YEA_PREV_ER_INFO, keyed on assignment_id. The view is registered in the ETRM (E-Business Suite Tables and Views Reference Manual) and is documented for both 12.1.1 and 12.2.2.

The EIT KR_YEA_PREV_ER_INFO stores prior-year employer remuneration information used in South Korean Year-End Adjustment (YEA) processing. Rather than exposing the raw, positionally mapped AEI_INFORMATION1 through AEI_INFORMATION15 columns of the underlying extra information table, this view decodes and type-converts those columns into business-meaningful named fields. It thereby serves as a denormalised, human-readable projection layer for statutory year-end tax reporting, external data exchange, and payroll analytics queries.

Underlying Base Objects

The documented ETRM metadata lists the following referenced base objects:

• PER_ASSIGNMENT_EXTRA_INFO (synonym) — aliased AEI, the primary source table holding assignment-level extra information rows.
• FND_SESSIONS (synonym) — aliased FND, used to resolve the current session's effective date, which drives the year-matching join condition.
• FND_DATE (package) — its CANONICAL_TO_DATE function converts the canonical (stored) date string in AEI_INFORMATION1 to an Oracle date.
• FND_NUMBER (package) — its CANONICAL_TO_NUMBER function converts canonical numeric strings in AEI_INFORMATION4 through AEI_INFORMATION15 into proper numeric values.

The core predicate restricts rows to INFORMATION_TYPE = 'KR_YEA_PREV_ER_INFO'. A second predicate equates the year fragment of the session effective date — SUBSTR(TO_CHAR(FND.EFFECTIVE_DATE,'DD-MON-YYYY'),8,4) — with the four-character year prefix of AEI_INFORMATION1 (SUBSTR(AEI.AEI_INFORMATION1,1,4)). Note that AEI_INFORMATION1 therefore functions both as a date component and as the join key against the session year.

Key Columns

• ROW_ID / ASSIGNMENT_EXTRA_INFO_ID — identifier of the AEI row and the view's primary key candidates.
• ASSIGNMENT_ID — the assignment the EIT record belongs to; the documented search key.
• INFORMATION_TYPE / AEI_INFORMATION_CATEGORY / OBJECT_VERSION_NUMBER — EIT type, its category, and the optimistic locking version.
• TERMINATION_DATE — decoded from AEI_INFORMATION1 via FND_DATE.
• BP_NAME / BP_NUMBER — business place name and identifier (AEI_INFORMATION2/3), returned as character strings.
• TAXABLE_EARNINGS_MTH / TAXABLE_EARNINGS_BON / SP_IRREG_BONUS — monthly taxable earnings, bonus taxable earnings, and special/irregular bonus (AEI_INFORMATION4/5/6).
• NON_TAXABLE_OVS_EARNINGS / NON_TAXABLE_OVT_EARNINGS / NON_TAXABLE_OTH_EARNINGS — non-taxable overtime (scheduled), overtime, and other non-taxable earnings (AEI_INFORMATION7/8/9).
• HI_PREM — health insurance premium (AEI_INFORMATION10). This is the column matched by the user search string hi_prem.
• EI_PREM / NP_PREM — employment insurance and national pension premiums (AEI_INFORMATION11/12).
• ITAX / RTAX / STAX — income tax, resident tax, and special (local) tax amounts (AEI_INFORMATION13/14/15).

Common Use Cases and Queries

Typical usage includes prior-year remuneration verification for YEA, external tax-filing extracts, and reconciliation against payroll balance results. Retrieve the decoded record for a given assignment:

SELECT assignment_id, bp_name, bp_number, taxable_earnings_mth, hi_prem, ei_prem, np_prem, itax, rtax, stax FROM apps.pay_kr_prev_er_v WHERE assignment_id = :p_assignment_id;

Search specifically for health insurance premium values:

SELECT assignment_id, hi_prem FROM apps.pay_kr_prev_er_v WHERE hi_prem IS NOT NULL;

Because the view filters on the current FND_SESSIONS effective year, callers must be aware that the returned row set varies with the session context; queries executed outside an active EBS session may return no rows or unexpected results.