Results for “kr_hi_information”

18 results




Overview
Explore in AI Chat

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

Overview

APPS.PAY_KR_SEP_HI_ADJ_V is a reporting view in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 that consolidates Korean Health Insurance (HI) separation adjustment information for terminated employees. The view is owned by the APPS schema and is typically consumed during Korean statutory year-end and separation processing, where an employer must reconcile health insurance premiums for employees who leave mid-period. It returns one row per qualifying person/assignment combination, exposing the HI number, employee identity, registration number, qualified date, separation date, reason code, and the business place (BP) HI number, together with a period indicator. Because it joins effective-dated person, assignment, and period-of-service records, the view delivers a point-in-time snapshot aligned to the actual termination date rather than the current system date.

Underlying Base Objects

The view is defined over several documented objects. PER_PEOPLE_F supplies the person record and effective-dated biographical data; PER_PEOPLE_EXTRA_INFO carries the Korean health insurance extra information (information type PER_KR_HEALTH_INSURANCE_INFO); PER_ASSIGNMENTS_F provides the assignment and establishment linkage; PER_PERIODS_OF_SERVICE supplies the actual termination date; and HR_ORGANIZATION_INFORMATION (context KR_HI_INFORMATION) supplies the business place HI number. Supporting packages HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY are referenced by the object's dependency chain, reflecting standard EBS date-track and security utilities used by the underlying views. PER_PEOPLE_F and PER_ASSIGNMENTS_F are date-tracked views over the PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F base tables.

Key Columns

  • ESTABLISHMENT_ID / ASSIGNMENT_ID — identifies the establishment and the assignment qualifying for the adjustment.
  • HI_NUMBER — the employee's Korean health insurance number (ppei_information1).
  • EMPLOYEE_NAME — concatenation of last name and first name.
  • REGISTRATION_NUMBER — the national identifier for the person.
  • QUALIFIED_DATE — the qualification date, derived as NVL(information4, information2).
  • SEPARATION_DATE — the actual termination date from PER_PERIODS_OF_SERVICE.
  • REASON_CODE — the separation reason (pei_information3).
  • PERIOD — a literal flag ('P' or 'C') produced by the UNION ALL branches, distinguishing processing periods.
  • BP_HI_NUMBER — the business place health insurance number from HR_ORGANIZATION_INFORMATION.
  • BUSINESS_GROUP_ID — the business group owning the person record.

Common Use Cases and Queries

The view supports Korean statutory reporting of health insurance adjustments at separation, feeding extracts and reconciliation reports. Typical queries filter on a date range and establishment. For example:

SELECT hi_number,
       employee_name,
       registration_number,
       qualified_date,
       separation_date,
       reason_code,
       period,
       bp_hi_number
  FROM apps.pay_kr_sep_hi_adj_v
 WHERE separation_date BETWEEN :p_start AND :p_end
   AND business_group_id = :p_bg_id;

Because the view drives from PER_PEOPLE_EXTRA_INFO with a null information6 filter and requires a matching period-of-service termination date within the same year, result sets are naturally scoped to separated employees. Consumers should apply business group and establishment predicates to control row volume, and may join ESTABLISHMENT_ID back to HR_ORGANIZATION_INFORMATION for organizational context. The UNION ALL of the 'P' and 'C' branches means callers should aggregate or filter on PERIOD when a single figure per separation is required.