Search Results per_kr_g_points_uk2

Overview

The PER_KR_G_POINTS table is an HR (PER – Human Resources) product table in Oracle E-Business Suite 12.1.1 and 12.2.2, delivered under the HR schema. It is part of the Korea-specific localization layer of Oracle HRMS, storing grade point definitions that subdivide a grade into finer, sequence-ordered pay or progression points. In Korean HR and payroll practice, grades are commonly decomposed into defined steps (ho-bong) so that seniority-based or point-based progression can be modeled and reported. This table supplies that step definition layer for the Korean localization.

Based on the documented foreign key structure, the table behaves as a satellite-leaning entity: its primary key is independent, but it carries descriptive attributes about a parent grade and is itself referenced by an amount/rate child. This is a heuristic Data Vault modeling suggestion rather than a delivered classification, and should be confirmed against the parent object's key semantics during any warehouse or integration design.

Key Information Stored

The documented schema contains 13 columns. The most significant are the grade point identifier, the owning grade, the point name, and the sequence, together with the standard EBS audit and concurrency columns.

• GRADE_POINT_ID — surrogate primary key (PER_KR_G_POINTS_PK) uniquely identifying each grade point record.
• GRADE_ID — foreign key to PER_KR_GRADES, identifying the parent Korean grade to which the point belongs.
• GRADE_POINT_NAME — the business name or label of the grade point; used as the second unique key component (PER_KR_G_POINTS_UK2 on GRADE_ID, GRADE_POINT_NAME).
• SEQUENCE — ordinal position of the point within its grade; used as the first unique key component (PER_KR_G_POINTS_UK1 on GRADE_ID, SEQUENCE).
• ENABLED_FLAG — indicates whether the grade point is active and available for selection.
• START_DATE_ACTIVE and END_DATE_ACTIVE — effective dating boundaries controlling when the point is valid.
• OBJECT_VERSION_NUMBER — optimistic locking / concurrency control column.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard EBS audit columns recording who created and last modified the row and when.

Two unique indexes (PER_KR_G_POINTS_UK1 and PER_KR_G_POINTS_UK2) act as business-key candidates, guaranteeing that within a grade both the sequence order and the point name remain unique.

Common Use Cases and Queries

Typical uses include listing points for a grade, reconstructing progression ladders, and joining point definitions to their amount/rate records. A representative query enumerates active points in order:

• SELECT grade_point_id, grade_id, grade_point_name, sequence, start_date_active, end_date_active FROM per_kr_g_points WHERE grade_id = :p_grade_id AND enabled_flag = 'Y' AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE + 1) ORDER BY sequence;
• Joining to the parent grade: SELECT p.grade_point_name, g.grade_name FROM per_kr_g_points p, per_kr_grades g WHERE p.grade_id = g.grade_id;
• Joining to amounts: SELECT p.grade_point_name, a.* FROM per_kr_g_points p, per_kr_g_point_amount_f a WHERE a.grade_point_id = p.grade_point_id;

These patterns support localization reporting, payroll validation, and data migration checks for Korean grade structures.

Related Objects

• PER_KR_GRADES — parent table; joined on PER_KR_G_POINTS.GRADE_ID = PER_KR_GRADES.GRADE_ID.
• PER_KR_G_POINT_AMOUNT_F — child table holding amount/rate rows per point; joined on PER_KR_G_POINT_AMOUNT_F.GRADE_POINT_ID = PER_KR_G_POINTS.GRADE_POINT_ID and referenced by foreign key.
• PER_KR_G_POINTS_PK / UK1 / UK2 — primary and unique indexes enforcing identity and business-key uniqueness.
• Standard HR grade and grade-step APIs in the PER module, which may read or validate grade point definitions during grade administration.

Administrators and developers should treat this table as localization-specific reference data, maintained alongside its parent grade and dependent amount records.