Search Results ghr_interfaces_s

Overview

The HR.GHR_INTERFACE table is a general-purpose staging table within the Oracle E-Business Suite Federal Human Resources (GHR) module. Its primary role is to serve as a flexible data repository for various inbound interfaces that populate the core HR database. As documented, it acts as a landing zone where external system data is first loaded before being processed and validated by custom interface programs. A key implementation, noted in the ETRM, is its use for the Payroll interface to capture data required for the SF-113A report, a federal government form related to civilian pay adjustments.

Key Information Stored

The table's structure is designed for adaptability. The SOURCE_NAME column (VARCHAR2(30)) is critical, as it identifies the origin system or interface process, such as 'PAYROLL', that created the record. This value dictates the interpretation of the generic INFORMATION1 through INFORMATION11 columns. The primary key is the system-generated INTERFACE_ID. Temporal validity is managed via DATE_FROM and DATE_TO, while PROCESS_DATE tracks when the interface ran. The non-unique index GHR_INTERFACE_N1 on INFORMATION1 and INFORMATION4 suggests these are commonly filtered columns for specific interface logic.

Common Use Cases and Queries

The primary use case is extracting and transforming interface data for loading into transactional HR tables. Development teams write PL/SQL procedures that select records based on SOURCE_NAME and PROCESS_DATE, then parse the INFORMATIONn columns according to a source-specific mapping. A typical query pattern for reviewing pending interface data for a specific source would be:

• SELECT interface_id, process_date, information1, information2 FROM hr.ghr_interface WHERE source_name = 'PAYROLL' AND process_date > TRUNC(SYSDATE-1) ORDER BY interface_id;

For reporting or auditing, queries often join this table to error log tables or summary reports to reconcile data flows, particularly for the SF-113A report generation process.

Related Objects

The table's dependencies and related objects are central to its operation. The primary key is supported by the sequence GHR_INTERFACES_S, which generates unique INTERFACE_ID values. The unique index GHR_INTERFACE_PK enforces this primary key constraint. While the ETRM excerpt does not list foreign key relationships, the table is intrinsically linked to the custom interface programs (likely stored procedures or concurrent programs) referenced in the documentation that process its data into the HR schema. These programs define the semantic mapping for the INFORMATIONn columns for each SOURCE_NAME.