Search Results pd_classification_id




Overview
Explore in AI Chat

Overview

The GHR_PD_CLASSIFICATIONS table is a core data object within the Oracle E-Business Suite US Federal Human Resources (GHR) module. It serves as the central repository for storing the official classification and grading details associated with a Position Description (PD). In the context of US federal personnel management, a PD's classification determines its pay plan, series, grade, and other attributes critical for staffing, compensation, and compliance. This table is essential for maintaining the integrity of the federal position classification process within the EBS system, linking the descriptive elements of a job to its formal, standardized government occupational and pay structures.

Key Information Stored

The table's primary function is to record the classification attributes that define a federal position's pay and grade. Key columns include the surrogate primary key PD_CLASSIFICATION_ID and the foreign key POSITION_DESCRIPTION_ID, which links each classification record to its parent position description in the GHR_POSITION_DESCRIPTIONS table. The CLASS_GRADE_BY column is a critical field indicating the authority or method by which the position is classified. Another significant column is PAY_PLAN, which is a foreign key to the GHR_PAY_PLANS table and specifies the statutory pay system (e.g., General Schedule, Senior Executive Service). While the provided metadata does not list all columns, typical data stored would also include occupational series, grade level, and potentially classification decision dates and justifications.

Common Use Cases and Queries

This table is central to processes involving position management, audit reporting, and vacancy creation. Common operational use cases include generating reports for agency classification audits, determining eligibility and pay for personnel actions, and validating that a proposed position description aligns with established classification standards. A typical query might join this table to the position description and pay plan tables to produce a roster of all classified positions.

  • Sample Query (Classification Details by PD): SELECT pd.position_description_id, pd.description, cl.pay_plan, cl.class_grade_by FROM ghr_position_descriptions pd, ghr_pd_classifications cl WHERE pd.position_description_id = cl.position_description_id;
  • Reporting Use Case: Creating a report for the Office of Personnel Management (OPM) that lists all positions classified under a specific pay plan and grade, including the classification authority.

Related Objects

The GHR_PD_CLASSIFICATIONS table maintains defined foreign key relationships with other critical GHR tables, ensuring referential integrity for position data.

  • GHR_POSITION_DESCRIPTIONS: The primary parent table. The relationship is maintained via the foreign key column GHR_PD_CLASSIFICATIONS.POSITION_DESCRIPTION_ID referencing GHR_POSITION_DESCRIPTIONS. Every classification record must be associated with a valid position description.
  • GHR_PAY_PLANS: A key reference table for valid pay plans. The relationship is via the foreign key column GHR_PD_CLASSIFICATIONS.PAY_PLAN referencing GHR_PAY_PLANS, ensuring that the classification uses a pay plan defined in the system.

These relationships position GHR_PD_CLASSIFICATIONS as a vital junction between a position's narrative description and the codified federal personnel structures that govern it.