Search Results grade_point_name




Overview
Explore in AI Chat

Overview

The view APPS.PER_KR_G_POINTS_V is a Korean localization view within the Oracle E-Business Suite Human Resources (PER) product family. It exposes grade point definitions — the ordered gradations or "points" that can be assigned within a grade — as maintained for Korean legislated payroll and HR reporting requirements. The view is owned by the APPS schema, is documented under FND Design Data reference PER.PER_KR_G_POINTS_V, and carries a status of VALID as of Oracle EBS 12.1.1 and 12.2.2. Its view type is classified as Internal, and the ETRM documentation carries the standard Oracle warning that the object is for Oracle Internal Use Only. Oracle Corporation does not support direct access to application data through this object except from standard Oracle Applications programs. Consequently, the view should be treated as a reporting and integration surface rather than as a supported extension point. It presents grade point records in a flattened, query-friendly form so that downstream localization logic, concurrent programs, and reporting extracts can resolve grade point names without joining the underlying transactional table directly.

Underlying Base Objects

The documented dependency for PER_KR_G_POINTS_V is the base object PER_KR_G_POINTS, exposed to the view through a SYNONYM in the APPS schema. The view is therefore a thin projection over that single base table; it performs no joins to other PER tables in the documented definition. The ETRM metadata confirms that APPS.PER_KR_G_POINTS_V references APPS.PER_KR_G_POINTS and that the view itself is not referenced by any other database object, meaning it sits at the top of its dependency chain. Because the view is defined over a localization table, the KR segment in the object name identifies it as part of the Korean country-specific extension set, distinct from global grade structures such as PER_GRADES. Any code that queries this view is dependent on the continued existence and column shape of the base synonym, and changes to that base object will propagate directly into the view's result set.

Key Columns

The view exposes a compact, well-defined column set. The most significant column for the user's search term, grade_point_name, is GRADE_POINT_NAME, a VARCHAR2(80) attribute holding the descriptive label of the grade point. Related identifiers include GRADE_POINT_ID (NUMBER(15)), the primary key of the grade point record, and GRADE_ID (NUMBER(15)), which links the point to its parent grade. Ordering within the grade is controlled by SEQUENCE (NUMBER(15)). Availability is governed by ENABLED_FLAG and by the effective dating columns START_DATE_ACTIVE and END_DATE_ACTIVE. The view also carries standard Oracle concurrency and audit columns: OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE, plus the pseudo-column ROW_ID of type ROWID. The audit columns support row-level change detection and reconciliation between EBS and external systems.

  • GRADE_POINT_ID — unique identifier for the grade point.
  • GRADE_ID — parent grade to which the point belongs.
  • GRADE_POINT_NAME — the descriptive name searched by users.
  • SEQUENCE — display or processing order within the grade.
  • ENABLED_FLAG — indicates whether the point is currently active.
  • START_DATE_ACTIVE / END_DATE_ACTIVE — date-range validity of the point.

Common Use Cases and Queries

The primary practical use of this view is to resolve grade point names and their effective dates for Korean HR reporting, payroll elements, and interface extracts. A typical query retrieves all enabled points for a given grade, ordered by sequence:

SELECT grade_point_id
     , grade_id
     , grade_point_name
     , sequence
     , start_date_active
     , end_date_active
FROM   apps.per_kr_g_points_v
WHERE  grade_id = :p_grade_id
AND    enabled_flag = 'Y'
AND    TRUNC(SYSDATE) BETWEEN NVL(start_date_active, TRUNC(SYSDATE))
                          AND NVL(end_date_active, TRUNC(SYSDATE) + 1)
ORDER BY sequence;

A second common pattern is a lookup by name, which directly serves the search term that led to this article, using an exact or partial match on GRADE_POINT_NAME and restricting to currently enabled rows. Because the view is marked Internal and unsupported for direct application access, organizations should prefer invoking standard Oracle Applications programs and concurrent programs wherever possible, using the view only for read-only reporting extracts and reconciliation queries where no supported API exists.