Results for “bp_number”
45 results
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_DATEfunction converts the canonical (stored) date string in AEI_INFORMATION1 to an Oracle date. - FND_NUMBER (package) — its
CANONICAL_TO_NUMBERfunction 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.
-
View: PAY_KR_PREV_ER_V 12.1.1
This view returns EIT value of 'KR_YEA_PREV_ER_INFO' based on assignment_id.
APPS.PAY_KR_PREV_ER_V·↳ FND_DATE·↳ FND_NUMBER·↳ FND_SESSIONS·Explore PAY module →
-
View: PAY_KR_YER_PREV_ER_V 12.1.1
This view returns previous employer information from assignment EIT.YEA process does not output previous employer information as database item.Therefore, the system have to get these data from assignment EIT based on assignment_id and termi
APPS.PAY_KR_YER_PREV_ER_V·↳ FND_DATE·↳ FND_NUMBER·↳ PER_ASSIGNMENT_EXTRA_INFO·Explore PAY module →
-
View: PAY_KR_SEP_TAX_V 12.1.1
APPS.PAY_KR_SEP_TAX_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PAY module →
-
View: PAY_KR_YER_PREV_ER_V 12.2.2
This view returns previous employer information from assignment EIT.YEA process does not output previous employer information as database item.Therefore, the system have to get these data from assignment EIT based on assignment_id and termi
APPS.PAY_KR_YER_PREV_ER_V·↳ FND_DATE·↳ FND_NUMBER·↳ PER_ASSIGNMENT_EXTRA_INFO·Explore PAY module →
-
View: PAY_KR_SEP_MASTER_V 12.1.1
This view returns employee assignment which are target for Separation Pay Process.
APPS.PAY_KR_SEP_MASTER_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_INFORMATION·↳ HR_ORGANIZATION_UNITS·Explore PAY module →
-
View: PAY_KR_PREV_ER_V 12.2.2
This view returns EIT value of 'KR_YEA_PREV_ER_INFO' based on assignment_id.
APPS.PAY_KR_PREV_ER_V·↳ FND_DATE·↳ FND_NUMBER·↳ FND_SESSIONS·Explore PAY module →
-
View: PAY_KR_SEP_MASTER_V 12.2.2
This view returns employee assignment which are target for Separation Pay Process.
APPS.PAY_KR_SEP_MASTER_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_INFORMATION·↳ HR_ORGANIZATION_UNITS·Explore PAY module →
-
View: PAY_KR_SEP_TAX_V 12.2.2
APPS.PAY_KR_SEP_TAX_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PAY module →
-
APPS.PAY_KR_SEP_TAX_WO_ADDR_V·↳ FND_TERRITORIES_VL·↳ HR_GENERAL·↳ HR_LOCATIONS·Explore PAY module →
-
APPS.PAY_KR_SEP_TAX_WO_ADDR_V·↳ FND_TERRITORIES_VL·↳ HR_GENERAL·↳ HR_LOCATIONS·Explore PAY module →
-
VIEW: APPS.PAY_KR_PREV_ER_V 12.1.1
-
VIEW: APPS.PAY_KR_PREV_ER_V 12.2.2
-
VIEW: APPS.PAY_KR_SEP_TAX_V 12.2.2
-
VIEW: APPS.PAY_KR_PREV_ER_V 12.2.2
-
VIEW: APPS.PAY_KR_SEP_TAX_V 12.1.1
-
VIEW: APPS.PAY_KR_PREV_ER_V 12.1.1
-
eTRM - PAY Tables and Views 12.2.2
Temporary table used to hold invalid location addresses.
-
eTRM - PAY Tables and Views 12.1.1
Temporary table used to hold invalid location addresses.