Search Results ghr_compl_bases




Overview
Explore in AI Chat

Overview

GHR_COMPL_BASES is a table owned by the HR schema within the Oracle E-Business Suite Release 12.1.1 and 12.2.2 environments, and it belongs to the GHR — US Federal Human Resources product family. As the description states, the table stores the Issues and Basis associated with a given complaint. In practical terms, it functions as the detail-level repository that captures the specific regulatory, statutory, or administrative grounds upon which a complaint, grievance, or equal employment opportunity (EEO) case has been filed. Each row records a distinct basis asserted against a particular complaint claim, allowing a single claim to carry multiple independent legal or administrative grounds.

From a data modeling perspective, the ETRM metadata suggests a satellite-leaning classification under Data Vault heuristics. This reflects the fact that the table describes attributes and descriptive context of a parent business entity — the complaint claim — rather than serving as a standalone hub of business keys or a pure associative link. Modelers should treat GHR_COMPL_BASES as a descriptive satellite hanging off the claim entity when normalizing into a Data Vault or dimensional warehouse.

Key Information Stored

The table contains 13 documented columns. The most significant are summarized below.

  • COMPL_BASIS_ID — The surrogate primary key, defined by the unique index GHR_COMPL_BASES_PK. It uniquely identifies each basis record and is the sole documented business-key candidate.
  • COMPL_CLAIM_ID — The foreign key to GHR_COMPL_CLAIMS. This is the critical join column linking each basis back to its parent complaint claim.
  • BASIS — The categorical code or value describing the legal or administrative basis asserted (for example, discrimination on a protected characteristic).
  • VALUE — Descriptive detail qualifying the basis, typically the specific value or narrative accompanying the BASIS code.
  • STATUTE — The statutory reference under which the complaint basis is asserted, important for regulatory and legal reporting.
  • AGENCY_FINDING — The agency-level determination associated with the basis, used during adjudication and disposition tracking.
  • AJ_FINDING — The Administrative Judge finding rendered against the basis, supporting formal case outcome reporting.
  • OBJECT_VERSION_NUMBER — The optimistic locking column used by the Oracle Applications Framework (OAF) to manage concurrent updates.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — The standard Oracle EBS WHO columns capturing audit history for each row.

Common Use Cases and Queries

Because the table underpins federal complaint adjudication, it is referenced by case management, EEO reporting, and statutory compliance queries. A common pattern retrieves all bases for a specific claim:

SELECT COMPL_BASIS_ID, BASIS, VALUE, STATUTE FROM HR.GHR_COMPL_BASES WHERE COMPL_CLAIM_ID = :claim_id;

Reporting scenarios frequently join to the parent claim table to present a hierarchy of complaint, claim, and asserted basis:

SELECT c.COMPL_CLAIM_ID, b.BASIS, b.STATUTE, b.AGENCY_FINDING, b.AJ_FINDING FROM HR.GHR_COMPL_CLAIMS c JOIN HR.GHR_COMPL_BASES b ON b.COMPL_CLAIM_ID = c.COMPL_CLAIM_ID;

Analysts also aggregate findings by statute or basis to produce trend reporting on adjudication outcomes, counting rows grouped by BASIS and AJ_FINDING. Auditing queries exploit the WHO columns to trace record provenance.

Related Objects

The following objects are the most significant in relation to GHR_COMPL_BASES.

  • GHR_COMPL_CLAIMS — The parent table referenced by the foreign key GHR_COMPL_BASES.COMPL_CLAIM_ID. It is the primary relationship for this object.
  • GHR_COMPL_BASES_PK — The unique index enforcing the surrogate primary key on COMPL_BASIS_ID.
  • GHR_COMPL_BASIS_LOOKUPS — Reference/lookup objects supplying valid BASIS and STATUTE values.
  • GHR_COMPL_ADMIN — Administrative case tables that consume basis and finding data for disposition processing.
  • Related GHR complaint views and OAF-based pages in the US Federal Human Resources module that read and write basis records through the standard WHO and OBJECT_VERSION_NUMBER columns.