Results for “case_group_number”

50+ results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PQH_DE_CASE_GROUPS is a Public Sector HR (PQH) table owned by the HR schema in Oracle E-Business Suite 12.1.1 and 12.2.2. The object name prefix "DE" designates a Data Element construct, and the table stores the case group definitions used by the Public Sector HR case management and advancement framework. A case group acts as a configuration container that governs how a class of cases — typically probationary or time-based advancement actions for employees — is classified, evaluated, and processed. Each record defines the business rules applied to a grouping of cases, including the advancement targets, qualifying periods, and pay-grade advancement behavior.

From a modeling perspective, the supplied metadata classifies this object heuristically as standalone within a Data Vault context; no foreign-key relationships were mined, and the object functions as an independent reference or hub-style entity keyed on CASEGROUPID. This classification should be treated as a modeling suggestion rather than a definitive constraint, since the physical schema is documented by the ETRM repository and the referencing relationships are maintained at the application layer rather than through enforced database constraints.

Key Information Stored

The table contains 21 documented columns. The most operationally significant are:

Common Use Cases and Queries

The table is most commonly queried when configuring or auditing advancement rules, when validating that a submitted case maps to a valid case group, and when reporting on advancement entitlements by pay grade and qualifying period. A typical lookup returns the advancement configuration for a business group:

  • Join PQH_DE_CASE_GROUPS to case-level tables on CASE_GROUP_ID to resolve the governing rules for each case.
  • Filter by BUSINESS_GROUP_ID to restrict results to the appropriate operating unit or legislative business group.
  • Report CASE_GROUP_NUMBER against DESCRIPTION and the advancement target columns for rule review and configuration audits.
  • Use ADVN_UNITS and PERIOD columns to calculate projected advancement dates, joining to employee assignment and grade tables.
  • Reconcile records by OBJECT_VERSION_NUMBER and LAST_UPDATE_DATE when tracing configuration changes.

Related Objects

Because the metadata records no enforced foreign keys, relationships are application-defined. The most significant dependents and companions are the case-instance tables in the PQH_DE family, which reference CASE_GROUP_ID, and the case group setup or a corresponding entity that shares the primary key. The table is also referenced by the Public Sector HR advancement and probation processing logic, the multi-tenant business group definitions keyed by BUSINESS_GROUP_ID, and the WHO audit columns owned by the standard HR audit infrastructure. Configuration and lookup views in the PQH module expose CASE_GROUP_ID and CASE_GROUP_NUMBER for selection lists, and the case group setup entity provides the administrative entry point that populates these rows.