Search Results kr_job_title




Overview
Explore in AI Chat

Overview

APPS.PAY_KR_SEP_SLIP_V is a valid Oracle E-Business Suite database view owned by the APPS schema, registered in Oracle's design metadata under the identifier PAY.PAY_KR_SEP_SLIP_V. The view supports the Korean (KR) localization of Oracle Payroll and exists specifically to supply the data set required for separation (termination) payslip reporting. It consolidates person, assignment, payroll action, run type, grade, organization, and balance information into a single denormalized result set that the Korean payroll reporting package PAY_KR_REPORT_PKG consumes when generating statutory separation slips.

The object is classified as "Oracle Internal Use Only." Oracle Corporation does not support direct customer access to applications data through this view except from standard Oracle Applications programs. Its view type is recorded as Internal, indicating that it is not exposed as a supported public interface. The view spans the EBS 12.1.1 and 12.2.2 releases with identical structure, though column-level semantics rely on the underlying HRMS and Payroll APIs, which are subject to change between release levels and patch sets.

Underlying Base Objects

The view is defined over a combination of HRMS and Payroll synonyms, views, and server-side packages. Documented referenced base objects include:

Because the definition embeds HR_SECURITY, query results are filtered by the caller's security profile, restricting the rows visible to a given session.

Key Columns

Identity and context columns include BUSINESS_GROUP_ID, LEGISLATION_CODE, PAYROLL_ID, ASSIGNMENT_ID, ASSIGNMENT_ACTION_ID, EFFECTIVE_DATE, DATE_EARNED, RUN_TYPE_ID, RUN_TYPE_NAME, and TAX_UNIT_ID. XASSIGNMENT_ACTION_ID is an additional action identifier used to disambiguate multiple actions within a run.

Employee-facing attributes include LAST_NAME, FIRST_NAME, NATIONAL_IDENTIFIER, EMPLOYEE_NUMBER, ORGANIZATION_NAME, KR_JOB_TITLE, GRADE_NAME, HIRING_DATE, LEAVING_DATE, and WORKING_PERIOD. The ME_1ST_STD through ME_4TH_EDD column pairs capture up to four monthly earnings start and end dates, supporting period-based earnings presentation on the separation slip.

Balance and bonus columns include BBALANCE_TYPE_ID, VBALANCE_TYPE_ID, IVBALANCE_TYPE_ID, BASSIGNMENT_ACTION_ID, BEFFECTIVE_DATE, BRUN_TYPE_ID, BRUN_TYPE_NAME, and BON_AMT, allowing the view to carry a related bonus or balance amount alongside the primary separation record. PERSON_ID (10) is retained for person-level joins and reporting.

Common Use Cases and Queries

The canonical consumer is the Korean separation slip report executed through PAY_KR_REPORT_PKG. Customers typically query the view read-only for reconciliation or audit of separation payments. A representative query:

  • SELECT employee_number, last_name, first_name, national_identifier, organization_name, grade_name, hiring_date, leaving_date, run_type_name, bon_amt FROM apps.pay_kr_sep_slip_v WHERE business_group_id = :bg_id AND effective_date BETWEEN :start_date AND :end_date ORDER BY employee_number;
  • Filtering by assignment_action_id or xassignment_action_id isolates a specific payroll action, useful when validating a single separation run.
  • Joining to PAY_ASSIGNMENT_ACTIONS or PER_ALL_ASSIGNMENTS_F on assignment_id enables drill-down from the slip line to the underlying payroll run.

Given the INTERNAL designation, any direct query should be treated as diagnostic only; production reporting must remain within supported Oracle Applications programs.