Search Results ivbalance_type_id

Overview

The PAY_KR_SEP_SLIP_V view is a Korean localization reporting object owned by the APPS schema within the Payroll (PAY) product module of Oracle E-Business Suite 12.1.1 and 12.2.2. Its purpose is to consolidate the data required to produce the Korean Severance Pay Slip (Separation Slip) — a statutory statement issued to employees upon termination of employment in the Republic of Korea. The view merges assignment, payroll action, run type, personal, and organizational attributes with bonus/severance balance information, exposing a denormalized result set that a concurrent program or BI Publisher report can render directly.

The name reflects its regional scope (KR), the business document it supports (SEP for separation), and its reporting role (SLIP). Because it encapsulates joins across payroll, human resources, and balance objects, it shields report developers from having to reconstruct the same multi-table logic manually.

Underlying Base Objects

The view is a compound query defined over a sub-select and several joined base objects. The primary driver sources include PAY_PAYROLL_ACTIONS (payroll action headers), PAY_ASSIGNMENT_ACTIONS (assignment-level action rows with ACTION_STATUS = 'C' and non-null SOURCE_ACTION_ID), and PAY_RUN_TYPES_F (run type definitions valid for the action effective date). Supporting joins reach PER_ASSIGNMENTS_F, PER_PEOPLE_F, PER_GRADES_TL, and HR_ORGANIZATION_UNITS for person, assignment, grade, and organization attributes.

Security-aware functions such as HR_SECURITY and the HR_PERSON_NAME and HR_GENERAL packages are referenced for row-level access and name derivation. Balance attributes resolve through PAY_BALANCE_TYPES (surfaced as BBALANCE_TYPE_ID, VBALANCE_TYPE_ID, and IVBALANCE_TYPE_ID) and the PAY_KR_REPORT_PKG package, whose function GET_BALANCE_VALUE_ASG_RUN returns the bonus/severance amount.

Key Columns

• BUSINESS_GROUP_ID, LEGISLATION_CODE, PAYROLL_ID — organizational and legal context.
• ASSIGNMENT_ID, PERSON_ID, ASSIGNMENT_ACTION_ID, XASSIGNMENT_ACTION_ID — the assignment and action identity for the separation event.
• EFFECTIVE_DATE, DATE_EARNED, RUN_TYPE_ID, RUN_TYPE_NAME — timing and run classification.
• LAST_NAME, FIRST_NAME, NATIONAL_IDENTIFIER, EMPLOYEE_NUMBER — employee identification on the slip.
• ORGANIZATION_NAME, KR_JOB_TITLE, GRADE_NAME, HIRING_DATE, LEAVING_DATE, WORKING_PERIOD — service and position details required by Korean severance rules.
• BBALANCE_TYPE_ID, VBALANCE_TYPE_ID, IVBALANCE_TYPE_ID — balance type keys used to resolve base, severance, and bonus balances; the vbalance_type_id column identifies the severance balance type.
• BON_AMT — computed balance value returned by PAY_KR_REPORT_PKG.GET_BALANCE_VALUE_ASG_RUN.
• ME_1ST_STD … ME_4TH_EDD — the four mandated severance calculation period start/end dates.

Common Use Cases and Queries

Typical usage is to feed the Korean separation slip report for a terminated employee over a run or date range. A representative query:

• SELECT employee_number, last_name, first_name, hiring_date, leaving_date, vbalance_type_id, bon_amt FROM apps.pay_kr_sep_slip_v WHERE assignment_id = :p_assignment_id;
• Reconcile severance balances by joining vbalance_type_id to PAY_BALANCE_TYPES to confirm the balance type name and currency.
• Extract period detail by filtering me_1st_std through me_4th_edd for audit or regulatory submission.

Because the view calls package functions, performance is best when filtered on assignment, person, or effective date predicates to limit function invocations.