Search Results ghr_position_descriptions




Overview
Explore in AI Chat

Overview

The GHR_POSITION_DESCRIPTIONS table is a core data object within the Oracle E-Business Suite (EBS) US Federal Human Resources (GHR) module. It serves as the central repository for storing detailed information related to Federal Position Descriptions (PDs). In the context of US federal HR management, a Position Description is a formal document that defines the duties, responsibilities, scope, and classification of a specific job. This table is fundamental to the GHR module's functionality, enabling the creation, management, routing, and approval of these critical personnel documents in compliance with federal regulations. Its existence is specific to the GHR product family and is not present in the standard, non-federal Oracle HRMS implementations.

Key Information Stored

While the provided metadata does not list individual columns, the structure and foreign key relationships indicate the table's primary purpose. The key identifier is the POSITION_DESCRIPTION_ID, which is the primary key column for the table. This unique identifier links the position description master record to numerous related transactional and classification tables. Another critical column is ROUTING_GROUP_ID, which establishes a foreign key relationship to the GHR_ROUTING_GROUPS table. This link is essential for defining the workflow and approval hierarchy through which a position description must progress. The table likely stores core attributes of the PD itself, such as effective dates, status, document identifiers, and references to the associated position and organization within the federal structure.

Common Use Cases and Queries

This table is central to processes involving position management and classification. Common use cases include generating reports on all active position descriptions, tracking the status of PDs in the approval workflow, and auditing classification actions over time. A typical reporting query would join GHR_POSITION_DESCRIPTIONS with related tables to provide a comprehensive view. For example, to list PDs along with their current routing group, one might use:

  • SELECT pd.POSITION_DESCRIPTION_ID, pd.DESCRIPTION, rg.ROUTING_GROUP_NAME
  • FROM HR.GHR_POSITION_DESCRIPTIONS pd,
  • HR.GHR_ROUTING_GROUPS rg
  • WHERE pd.ROUTING_GROUP_ID = rg.ROUTING_GROUP_ID
  • AND pd.EFFECTIVE_DATE <= SYSDATE;

Data from this table is also critical for integration with other federal systems and for supporting the official classification process managed by personnel specialists.

Related Objects

The GHR_POSITION_DESCRIPTIONS table is a primary entity with several dependent objects, as shown in the foreign key metadata. Key related tables include:

  • GHR_ROUTING_GROUPS: References this table via ROUTING_GROUP_ID to define the approval path.
  • GHR_PD_CLASSIFICATIONS: A child table that holds detailed classification data (e.g., series, grade, pay plan) for each position description, linked by POSITION_DESCRIPTION_ID.
  • GHR_PD_ROUTING_HISTORY: A child table that logs the complete workflow history and audit trail for the PD's routing and approval process, linked by POSITION_DESCRIPTION_ID.

These relationships illustrate that GHR_POSITION_DESCRIPTIONS acts as the parent record for the entire lifecycle of a federal position description, from creation and classification through workflow to final approval.