Search Results ghr_pois




Overview
Explore in AI Chat

Overview

The GHR_POIS table is a core data object within the Oracle E-Business Suite US Federal Human Resources (GHR) module. It serves as the master repository for Personnel Office Identifier (POI) data, a critical organizational construct in the federal HR context. The table's primary role is to define and maintain distinct personnel offices, which are administrative entities responsible for managing employee records and processing HR actions for specific groups of federal employees. This centralized reference table ensures data integrity and consistency across the numerous GHR transactional and reporting processes that depend on a valid personnel office assignment.

Key Information Stored

While the provided ETRM metadata does not list specific columns beyond the primary key, the table's structure is defined by its purpose. The central column is PERSONNEL_OFFICE_ID, which serves as the unique primary key (GHR_POIS_PK) for each record. This identifier is referenced by numerous foreign keys in other GHR tables. Based on standard GHR data models, the table likely also contains descriptive columns such as the personnel office name, effective dates, and status indicators. A key relational column is GROUPBOX_ID, which establishes a foreign key relationship to the GHR_GROUPBOXES table, linking the personnel office to a specific organizational group or hierarchy within the federal agency structure.

Common Use Cases and Queries

The GHR_POIS table is fundamental for transactional integrity and organizational reporting. Common use cases include validating personnel office assignments during data entry for HR actions, generating reports segmented by personnel office, and serving as a source list for LOVs in application forms. A typical query would retrieve active personnel offices for a specific group box, which is essential for security and data access rules. For example:

  • Basic Lookup: SELECT personnel_office_id, name FROM ghr_pois WHERE sysdate BETWEEN effective_start_date AND effective_end_date;
  • Transactional Validation: SQL within forms or APIs to verify that a user-selected PERSONNEL_OFFICE_ID exists in GHR_POIS before committing a record in tables like GHR_PA_REQUESTS or GHR_MASS_SALARIES.
  • Reporting: Joining GHR_POIS to transactional tables to produce summaries of actions or costs by personnel office.

Related Objects

As indicated by the foreign key relationships, GHR_POIS is a parent table to several key GHR transactional entities. The primary related objects include:

  • GHR_GROUPBOXES: Parent table via GHR_POIS.GROUPBOX_ID, defining the organizational container.
  • GHR_PA_REQUESTS: Stores personnel action requests linked to a specific personnel office.
  • GHR_MASS_REALIGNMENT, GHR_MASS_SALARIES, GHR_MASS_TRANSFERS: Core tables for bulk HR operations, which use the PERSONNEL_OFFICE_ID to define the target or source office for the mass action.
  • GHR_MASS_REALIGNMENT (dual relationship): This table references GHR_POIS twice—for both the source (PERSONNEL_OFFICE_ID) and target (TARGET_PERSONNEL_OFFICE_ID) offices involved in a realignment.