Results for “requisition_code”

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

Overview

PAY_KR_NP_ADJ_V is an APPS-owned reporting view within the Oracle E-Business Suite Payroll (PAY) product, validated and available in both 12.1.1 and 12.2.2. It exposes Korean National Pension adjustment information by joining person-level flexfield data to current and historical person, assignment, and periods-of-service records. Its principal function is to present a denormalized, query-ready result set that combines personal identifiers, employment dates, earnings figures, requisition and loss details, and National Pension reporting flags in a single row per matching combination.

For users searching on "employee_name," this view is significant because it does not expose a raw first or last name column. Instead, it exposes EMPLOYEE_NAME, a concatenation of PER_PEOPLE_F.LAST_NAME and PER_PEOPLE_F.FIRST_NAME. This makes the view directly usable in ad hoc queries, BI Publisher reports, and interface extracts where a display name is required alongside the Korean National Pension reporting attributes.

Underlying Base Objects

The view is defined over several documented base objects. The primary driver is PER_PEOPLE_EXTRA_INFO (PEI), filtered on INFORMATION_TYPE = 'PER_KR_NATIONAL_PENSION_INFO'. This extra information type supplies the Korean-specific National Pension attributes stored in PEI_INFORMATION1 through PEI_INFORMATION7. PER_PEOPLE_F (PAP) supplies the person's name segments, national identifier, and effective dates. PER_ASSIGNMENTS_F (PAA) contributes assignment-level dates and the establishment identifier used as BUSINESS_PLACE_ID, while PER_PERIODS_OF_SERVICE (PPS) supplies ACTUAL_TERMINATION_DATE.

The joins are keyed on PERSON_ID, with BUSINESS_GROUP_ID also matched between PER_PEOPLE_F and PER_ASSIGNMENTS_F. Documented dependencies include the FND_DATE package, used to convert canonical date values via FND_DATE.CANONICAL_TO_DATE, and the HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY packages, which support person naming and security-based row filtering at runtime.

Key Columns

• INFORMATION_TYPE — extra information type; fixed at 'PER_KR_NATIONAL_PENSION_INFO'.
• BUSINESS_GROUP_ID — the business group context for the person and assignment.
• PERSON_ID — unique person identifier used across the joined objects.
• BUSINESS_PLACE_ID — establishment identifier from the assignment.
• EMPLOYEE_NAME — concatenation of last name and first name from PER_PEOPLE_F.
• EMPLOYEE_NI — national identifier of the employee.
• PERSON_START_DATE / PERSON_END_DATE — effective dates of the person record.
• ASG_START_DATE / ASG_END_DATE — effective dates of the assignment record.
• MONTHLY_EARNINGS — numeric monthly earnings value derived from PEI_INFORMATION1.
• REQUISITION_CODE and REQUISITION_START_DATE — requisition identifier and its converted start date.
• SPECIAL_JOB_CODE, LOSS_CODE, and LOSS_START_DATE — special job and loss reporting attributes.
• NP_REPORTED — National Pension reported flag from PEI_INFORMATION7.
• ASSIGNMENT_ID — assignment identifier.
• TERMINATION_DATE — actual termination date from periods of service.

Common Use Cases and Queries

Typical scenarios include Korean National Pension reporting, reconciliation of reported versus unreported pension records, and interface extracts to statutory authorities. A simple lookup by employee name follows:

• SELECT employee_name, employee_ni, monthly_earnings, np_reported FROM apps.pay_kr_np_adj_v WHERE UPPER(employee_name) LIKE UPPER(:name);
• SELECT business_place_id, employee_name, termination_date FROM apps.pay_kr_np_adj_v WHERE np_reported = 'N';
• SELECT employee_name, requisition_code, requisition_start_date, loss_code FROM apps.pay_kr_np_adj_v WHERE business_group_id = :bg_id;

Because EMPLOYEE_NAME is a concatenation rather than a stored column, name-based filtering should account for spacing and locale. Queries are also subject to HR security profiles applied through the documented HR_SECURITY dependency.