Search Results bp_number




Overview
Explore in AI Chat

Overview

PAY_KR_YER_PREV_ER_V is a reporting view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2, delivered as part of the Payroll (PAY) product family. Its purpose is to expose previous employer information captured on the assignment for Korean Year-End Adjustment (YEA) processing. The Year-End Adjustment process does not output previous employer data as a standard database item, so the view is provided to retrieve those values directly from the assignment extra information (EIT) records, keyed by assignment and by termination date. The view is registered with a status of VALID in the ETRM repository and is treated as an Oracle Proprietary, Confidential object.

Functionally, the view presents one row per qualifying assignment extra information record where the INFORMATION_TYPE equals 'KR_YEA_PREV_ER_INFO'. It therefore serves as the canonical access point for prior-employer attributes required by Korean payroll statutory reporting and by downstream extracts that depend on Year-End Adjustment inputs.

Underlying Base Objects

The view is defined over three documented dependencies:

The join to PER_ASSIGNMENT_EXTRA_INFO is filtered to a single information type, so the view is effectively a typed, decoded projection of a subset of EIT rows rather than a multi-table join.

Key Columns

Common Use Cases and Queries

The primary use case is extracting previous employer details for Korean Year-End Adjustment reporting, tax filing extracts, and reconciliation of prior-employer income against current payroll results. Because the YEA process omits this data as a database item, report developers and interfaces query this view directly.

SELECT assignment_id,
       termination_date,
       bp_name,
       bp_number,
       taxable_total
FROM   apps.pay_kr_yer_prev_er_v
WHERE  assignment_id = :p_assignment_id;

To locate records by employer identifier, the following pattern is typical:

SELECT assignment_id, bp_name, bp_number, termination_date
FROM   apps.pay_kr_yer_prev_er_v
WHERE  bp_number = :p_bp_number;

Aggregate reporting, such as totalling prior-employer taxable earnings across a population, can be performed directly against TAXABLE_TOTAL. When joining to assignment or person views, use ASSIGNMENT_ID as the linking key so results remain consistent with the EIT source rows.