Search Results per_kr_g_point_amount_f




Overview
Explore in AI Chat

Overview

The PER_KR_G_POINT_AMOUNT_F table is a Korea-specific (KR) localization object within the Oracle E-Business Suite Human Resources (PER) module. It is owned by the HR schema and is designated "KR specific," indicating that it supports country-extension functionality required by Korean statutory or business compensation practices rather than core global HR processing. The table stores grade point amount information, effectively defining monetary values associated with grade points used in Korean grade structures.

The object follows the standard EBS date-tracked (datetrack) pattern, evident from the presence of EFFECTIVE_START_DATE and EFFECTIVE_END_DATE columns and a three-part composite primary key. Its structure includes the standard WHO audit columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE) and a full 30-column ATTRIBUTE1 through ATTRIBUTE30 descriptive flexfield (DFF) block, which is typical of EBS localization tables.

Based on the documented foreign key relationship and the surrounding column set, the heuristic Data Vault classification for this object is satellite-leaning. The table functions as a date-effective descriptive satellite hanging off the grade point entity (PER_KR_G_POINTS) via the GRADE_POINT_ID foreign key, capturing the point amount value plus contextual attributes. It does not itself act as a hub or link under this classification heuristic, though this is offered as a modeling suggestion rather than a documented fact.

Key Information Stored

The table contains 42 documented columns. The most significant are outlined below.

  • GRADE_POINT_AMOUNT_ID — Surrogate primary key component; uniquely identifies each grade point amount record and is the first member of the PER_KR_G_POINT_AMOUNT_F_PK composite key.
  • EFFECTIVE_START_DATE — Date-tracked start of validity; second member of the composite primary key.
  • EFFECTIVE_END_DATE — Date-tracked end of validity; third member of the composite primary key.
  • GRADE_POINT_ID — Foreign key referencing PER_KR_G_POINTS; links the amount record to its parent grade point definition.
  • GRADE_POINT_AMOUNT — The monetary value associated with the grade point for the effective period.
  • OBJECT_VERSION_NUMBER — Optimistic locking column used to detect concurrent updates in the EBS framework.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — WHO audit columns recording the last modification context.
  • CREATED_BY, CREATION_DATE — WHO audit columns recording record creation.
  • ATTRIBUTE_CATEGORY — DFF context column governing which descriptive attributes are active.
  • ATTRIBUTE1 – ATTRIBUTE30 — Thirty flexible descriptive flexfield segments for capturing additional localization-specific data configured at implementation.

The composite primary key (GRADE_POINT_AMOUNT_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE) is also the sole documented unique index and therefore serves as the business-key candidate. The surrogate portion (GRADE_POINT_AMOUNT_ID) is distinguished from the date-bounded business identity, which enforces one effective-dated row per surrogate identifier.

Common Use Cases and Queries

Typical reporting scenarios include retrieving the currently effective amount for a grade point and auditing historical amount changes. Because the table is date-tracked, queries must always constrain EFFECTIVE_START_DATE and EFFECTIVE_END_DATE to the date of interest.

  • Fetching the active amount for a grade point as of a given date, joining to PER_KR_G_POINTS on GRADE_POINT_ID.
  • Producing an amount-change history for a grade point ordered by EFFECTIVE_START_DATE.
  • Reconciling grade point amounts against payroll or compensation calculations for Korean legal entities.
  • Extracting configured DFF attributes (ATTRIBUTE1–ATTRIBUTE30) for localization reporting.

A representative query pattern is: SELECT gpa.grade_point_id, gpa.grade_point_amount FROM hr.per_kr_g_point_amount_f gpa WHERE gpa.grade_point_id = :p_id AND :p_date BETWEEN gpa.effective_start_date AND gpa.effective_end_date; Note that the EBS date-track convention sets EFFECTIVE_END_DATE to a high sentinel date for the current active row, so BETWEEN comparisons should account for that convention.

Related Objects

  • PER_KR_G_POINTS — Parent object joined via PER_KR_G_POINT_AMOUNT_F.GRADE_POINT_ID → PER_KR_G_POINTS.GRADE_POINT_ID; holds the grade point definition.
  • PER_GRADES — Broader grade definition typically referenced by the grade point structure for contextual reporting.
  • PER_GRADE_POINT_SCALES — Grade point scale definitions that may govern the points referenced here.
  • HR_LOCATIONS / HR_ORGANIZATION_UNITS — Organizational context tables often joined when grade point amounts are reported by business unit or location.
  • PAY_ELEMENT_ENTRIES / compensation tables — Downstream payroll and compensation objects whose values depend on grade point amounts in Korean localization processing.

The singular documented foreign key (GRADE_POINT_ID to PER_KR_G_POINTS) establishes the primary referential dependency; other relationships should be validated against the deployment's actual schema before being relied upon in production queries.