Search Results ghr_pd_classifications_pk




Overview
Explore in AI Chat

Overview

The HR.GHR_PD_CLASSIFICATIONS table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically under the HRMS module's Government HR (GHR) functionality. It serves as the central repository for storing the formal classification details associated with a Position Description. This table is critical for managing and defining the job structure, pay, and occupational coding for positions within a government or similarly regulated organizational context. Its primary role is to maintain a detailed and auditable link between a position description and its official classification attributes, which are essential for compliance, reporting, and personnel actions.

Key Information Stored

The table stores the definitive classification metadata for a position. The key columns, as documented in the ETRM, include:

The unique constraint GHR_PD_CLASSIFICATIONS_UK on POSITION_DESCRIPTION_ID and CLASS_GRADE_BY enforces business rules regarding classification authorities per position.

Common Use Cases and Queries

This table is central to processes involving position management, audit reporting, and data validation. A common use case is retrieving the complete classification profile for a specific position description or a set of positions for reporting purposes. For instance, to generate a list of all positions classified under a specific pay plan and grade, or to audit which positions have been classified by a particular authority. A fundamental query pattern involves joining to the parent position description table: 

SELECT pd.position_description_id,
       cl.official_title,
       cl.pay_plan,
       cl.grade_level,
       cl.class_grade_by
FROM   hr.ghr_position_descriptions pd,
       hr.ghr_pd_classifications    cl
WHERE  pd.position_description_id = cl.position_description_id
AND    cl.pay_plan = 'GS'
AND    cl.grade_level = '13';
Another critical use case is ensuring data integrity during updates or migrations by verifying the existence of a classification record for a given POSITION_DESCRIPTION_ID before performing related operations.

Related Objects

The HR.GHR_PD_CLASSIFICATIONS table has defined relationships with several key EBS objects, primarily through foreign key constraints:

  • GHR_POSITION_DESCRIPTIONS: This is the primary parent table. The foreign key on POSITION_DESCRIPTION_ID establishes that every classification record must be associated with a valid position description. This is a one-to-many relationship from descriptions to classifications.
  • GHR_PAY_PLANS: The foreign key on the PAY_PLAN column references this lookup table, ensuring that the classification uses a valid, defined pay plan code.
  • The table's primary key, PD_CLASSIFICATION_ID, is referenced by the GHR_PD_CLASSIFICATIONS_PK index. While not listed in the provided metadata, it is a standard pattern for this primary key to be referenced by other child tables or APIs within the GHR product family that require a specific classification context.
These relationships are essential for maintaining referential integrity across the Government HR position description and classification data model.