Search Results per_kr_grades_uk1

Overview

HR.PER_KR_GRADES is a Korean localization table within the Oracle E-Business Suite Human Resources (HR) module. It stores Korean-specific secondary grade information, complementing the global grade model maintained in PER_GRADES. In EBS 12.1.1 and 12.2.2, the table resides in the APPS_TS_TX_DATA tablespace with an FND design data reference of PER.PER_KR_GRADES, and is registered as VALID in the HR schema.

From a dimensional modeling perspective, the mined foreign key topology classifies HR.PER_KR_GRADES as hub-leaning. It functions as a master reference source for Korean grade definitions, holding a stable business key (the surrogate GRADE_ID plus unique business identifiers) that downstream transactional tables join against. The table carries a foreign key to HR_ALL_ORGANIZATION_UNITS via BUSINESS_GROUP_ID, anchoring each grade definition to a specific business group (legislative context). Two dependent tables — PER_KR_GRADE_AMOUNT_F and PER_KR_G_POINTS — reference it, confirming its role as a parent hub in the Korean grade sub-model.

Key Information Stored

The physical schema documents 13 columns. The most significant are:

• GRADE_ID (NUMBER 15) — Surrogate primary key, enforced by the unique index PER_KR_GRADES_PK. Unique identifier for the grade row.
• BUSINESS_GROUP_ID (NUMBER 15) — Foreign key to HR_ALL_ORGANIZATION_UNITS. Establishes the legislative/business-group scope. Participates in both unique business keys.
• GRADE_NAME (VARCHAR2 80) — Grade name; with BUSINESS_GROUP_ID forms unique key PER_KR_GRADES_UK1.
• SEQUENCE (NUMBER 15) — Display ordering; with BUSINESS_GROUP_ID forms unique key PER_KR_GRADES_UK2.
• ENABLED_FLAG — Grade enabled indicator.
• START_DATE_ACTIVE — Date before which the grade is invalid.
• END_DATE_ACTIVE — Date after which the grade is invalid.
• OBJECT_VERSION_NUMBER — System-generated row version, incremented on each update (optimistic locking).
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — Standard WHO audit columns.

The key distinction is between the surrogate key (GRADE_ID) and the business keys (BUSINESS_GROUP_ID combined with GRADE_NAME, and with SEQUENCE). Each business group can define multiple grades, but names and sequence values must be unique within a group.

Common Use Cases and Queries

Typical uses include Korean grade-level reporting, validation of grade inputs, and integration with grade amount and points tables. Because ENABLED_FLAG and the active date range govern validity, queries commonly filter on those columns.

• List all enabled Korean grades for a business group, in display order:

SELECT GRADE_ID, GRADE_NAME, SEQUENCE
FROM   HR.PER_KR_GRADES
WHERE  BUSINESS_GROUP_ID = :p_bg_id
AND    ENABLED_FLAG = 'Y'
ORDER  BY SEQUENCE;

• Resolve a grade name to its surrogate key for downstream joins:

SELECT GRADE_ID
FROM   HR.PER_KR_GRADES
WHERE  BUSINESS_GROUP_ID = :p_bg_id
AND    GRADE_NAME = :p_name;

• Reporting that aggregates grade points or amounts per grade, joining through GRADE_ID, and filtering by the active window using START_DATE_ACTIVE and END_DATE_ACTIVE.

Related Objects

The following objects are most significant in relation to HR.PER_KR_GRADES, based on documented relationship data:

• HR.PER_KR_GRADE_AMOUNT_F — References this table via GRADE_ID. Holds Korean grade amount (flexfield) data.
• HR.PER_KR_G_POINTS — References this table via GRADE_ID. Stores Korean grade points.
• HR_ALL_ORGANIZATION_UNITS — Referenced by BUSINESS_GROUP_ID; the parent business-group definition.
• HR.PER_KR_GRADES# — Referencing entity noted in dependency metadata (typically the underlying synonym/trigger artifact of the base table).
• PER_GRADES (global HR grade model) — Related conceptually as the non-localized grade definition that PER_KR_GRADES augments for Korean legislation.

Developers and report authors should treat GRADE_ID as the stable join key and validate active status through ENABLED_FLAG together with the START_DATE_ACTIVE/END_DATE_ACTIVE range before using a grade in transactional or payroll-related logic.