Search Results ghr_complaint_issues_pk

Overview

The GHR_COMPLAINT_ISSUES table is a core data object within the US Federal Human Resources (GHR) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as a child table within the formal complaint tracking system, designed to manage the specific issues associated with a given complaint. Its primary role is to enable a one-to-many relationship between a single complaint record and the multiple distinct issues that may be raised within it. This structure is critical for detailed case management, allowing federal HR personnel to track, analyze, and resolve each component of a complaint independently while maintaining its overall context.

Key Information Stored

While the provided metadata does not list all columns, the documented primary and foreign keys define its essential structure. The central column is COMPLAINT_ISSUE_ID, which serves as the unique primary key (GHR_COMPLAINT_ISSUES_PK) for each issue record. The COMPLAINT_ID column is a mandatory foreign key that links each issue back to its parent complaint in the GHR_COMPLAINTS table. This establishes the foundational relationship. Although not detailed in the excerpt, typical columns in such a table would include fields to categorize and describe the issue (e.g., ISSUE_CODE, ISSUE_DESCRIPTION), track its status, and record relevant dates for creation, updates, and resolution.

Common Use Cases and Queries

This table supports operational reporting and compliance tracking for federal HR complaints. A common use case is generating a detailed issue breakdown for a specific complaint or a set of complaints within a date range. Analysts may query this table to identify the most frequently raised issues across the organization, which informs proactive HR policies. A typical SQL pattern involves joining to the parent complaint table to retrieve complaint metadata. For example:

• Listing all issues for a complaint: SELECT * FROM GHR_COMPLAINT_ISSUES WHERE complaint_id = <ID> ORDER BY complaint_issue_id;
• Counting issues per complaint for reporting: SELECT c.complaint_number, COUNT(i.complaint_issue_id) FROM ghr_complaints c, ghr_complaint_issues i WHERE c.complaint_id = i.complaint_id GROUP BY c.complaint_number;

Related Objects

The GHR_COMPLAINT_ISSUES table sits at the center of a key relationship hierarchy within the GHR complaint schema, as confirmed by the documented foreign keys.

• Parent Table (Referenced by GHR_COMPLAINT_ISSUES):
  • GHR_COMPLAINTS: This is the master complaint header table. Each record in GHR_COMPLAINT_ISSUES must link to a single parent record in GHR_COMPLAINTS via the foreign key column GHR_COMPLAINT_ISSUES.COMPLAINT_ID.
• Child Table (References GHR_COMPLAINT_ISSUES):
  • GHR_COMPLAINT_BASES: This table stores the legal bases or grounds (e.g., specific statutes or regulations) cited for each issue. It is a child of GHR_COMPLAINT_ISSUES, linked by the foreign key GHR_COMPLAINT_BASES.COMPLAINT_ISSUE_ID pointing to GHR_COMPLAINT_ISSUES.COMPLAINT_ISSUE_ID. This creates a drill-down path: Complaint → Issue → Basis.