Search Results personnel_office_id




Overview
Explore in AI Chat

Overview

The HR.GHR_POIS table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the US Federal Human Resources (GHR) module. It serves as the master reference table for Personnel Office Identifiers (POIs). A POI is a critical code used to designate and manage the specific personnel or human resources office responsible for processing and approving personnel actions for a group of employees. This table's primary role is to maintain a definitive list of valid POIs, their descriptions, associated administrative groupboxes, and related contact information, ensuring data integrity and control across federal personnel transactions.

Key Information Stored

The table's structure is designed to store both the identifier and its administrative context. The primary and mandatory column is PERSONNEL_OFFICE_ID (VARCHAR2), which holds the unique identifier code. The DESCRIPTION (VARCHAR2(80)) provides a meaningful name for the POI. A key relational attribute is GROUPBOX_ID (NUMBER(15)), which associates the POI with an administrative groupbox defined in the GHR_GROUPBOXES table, defining its organizational hierarchy. The PERSON_ID (NUMBER(10)) column stores the identifier for the designated approver, linking to the PER_PEOPLE_F table. Additional columns store the HR office's name, up to four address lines, a benefits contact name, and a contact phone number. Standard EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) track audit information.

Common Use Cases and Queries

This table is central to any process requiring validation or reporting based on Personnel Office. Common use cases include setting up and maintaining valid POIs for the enterprise, configuring approval hierarchies, and generating reports on personnel actions grouped by responsible HR office. A fundamental query retrieves the master list of all POIs with their descriptions and associated groupbox:

  • SELECT PERSONNEL_OFFICE_ID, DESCRIPTION, GROUPBOX_ID, HR_OFFICE_NAME FROM HR.GHR_POIS ORDER BY PERSONNEL_OFFICE_ID;

To identify the specific approver for a POI, a join to the person table is required:

The POI is a critical parameter in mass transaction processes and personnel action (PA) request workflows.

Related Objects

The GHR_POIS table has defined foreign key relationships with several key transactional tables in the GHR module, as documented in the ETRM. These relationships enforce referential integrity, ensuring that POIs used in transactions are valid. The primary key (PERSONNEL_OFFICE_ID) is referenced by the following tables:

Furthermore, GHR_POIS itself contains a foreign key to GHR_GROUPBOXES via its GROUPBOX_ID column, linking the POI to its administrative grouping. The PERSON_ID column is a foreign key to the PER_PEOPLE_F table, identifying the approver.