Results for “ghr_pd_classifications_uk”

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

Overview

HR.GHR_PD_CLASSIFICATIONS is a transactional table in the Oracle E-Business Suite HR schema that stores the classification details associated with a Position Description. A Position Description record captures the narrative and structural definition of a job role, while this child table carries the graded, coded classification attributes — such as official title, pay plan, occupational code, and grade level — that determine how the position is classified under federal or enterprise grading rules. The object is owned by the HR schema, registered in FND Design Data as GHR.GHR_PD_CLASSIFICATIONS, and resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10. It is valid in both Oracle EBS 12.1.1 and 12.2.2.

From a Data Vault modeling perspective, the mined FK structure classifies this object heuristically as a link. This suggests the table behaves primarily as an associative structure joining a position description to its classification and pay-plan attributes, rather than as a standalone hub of business entities or a pure descriptive satellite.

Key Information Stored

The table contains 13 documented columns. The most significant are summarized below.

• PD_CLASSIFICATION_ID — The surrogate primary key, generated from the sequence GHR_PA_CLASSIFICATIONS_S. It uniquely identifies each classification row and is the anchor of the GHR_PD_CLASSIFICATIONS_PK index.
• POSITION_DESCRIPTION_ID — Foreign key to GHR_POSITION_DESCRIPTIONS, linking each classification back to its parent position description.
• CLASS_GRADE_BY — A code indicating the level of review provided during classification. Together with POSITION_DESCRIPTION_ID it forms the unique business key GHR_PD_CLASSIFICATIONS_UK.
• OFFICIAL_TITLE — The official title (up to 80 characters) assigned to the classified position.
• PAY_PLAN — The pay plan associated with the classification; also carries a documented FK relationship to GHR_PAY_PLANS.
• OCCUPATIONAL_CODE — The occupational code classifying the nature of the work.
• GRADE_LEVEL — The grade or level assigned to the position.
• OBJECT_VERSION_NUMBER — System-generated row version that increments on each update, supporting optimistic locking.
• Standard WHO columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE provide audit and concurrency tracking.

The distinction between surrogate and business keys is important: PD_CLASSIFICATION_ID is a system-generated identifier, whereas the combination of POSITION_DESCRIPTION_ID and CLASS_GRADE_BY constitutes the documented unique business-key candidate enforced by GHR_PD_CLASSIFICATIONS_UK.

Common Use Cases and Queries

Typical usage centers on retrieving the classification attributes for a given position description, validating uniqueness of the classification key, and reporting on pay plans, grades, and occupational codes across an organization.

• Fetch all classifications for a position description:

  SELECT PD_CLASSIFICATION_ID, OFFICIAL_TITLE, PAY_PLAN, GRADE_LEVEL
  FROM   HR.GHR_PD_CLASSIFICATIONS
  WHERE  POSITION_DESCRIPTION_ID = :p_position_description_id;

• Enforce or verify the business key:

  SELECT COUNT(*) FROM HR.GHR_PD_CLASSIFICATIONS
  WHERE POSITION_DESCRIPTION_ID = :p_id AND CLASS_GRADE_BY = :p_code;

• Report distributions by pay plan and grade:

  SELECT PAY_PLAN, GRADE_LEVEL, COUNT(*)
  FROM   HR.GHR_PD_CLASSIFICATIONS
  GROUP  BY PAY_PLAN, GRADE_LEVEL;

Related Objects

• HR.GHR_POSITION_DESCRIPTIONS — Parent object referenced via POSITION_DESCRIPTION_ID.
• HR.GHR_PAY_PLANS — Referenced via the PAY_PLAN column.
• GHR_PD_CLASSIFICATIONS_PK — Unique primary index on PD_CLASSIFICATION_ID.
• GHR_PD_CLASSIFICATIONS_UK — Unique business-key index on POSITION_DESCRIPTION_ID and CLASS_GRADE_BY (the object the user searched for).
• GHR_PD_CLASSIFICATIONS_FK2 — Non-unique index supporting the PAY_PLAN foreign key.
• Sequence GHR_PA_CLASSIFICATIONS_S — Source of the primary key.