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:
- CASE_GROUP_ID — the surrogate primary key defined by the PODFDE CASEGROUPSPK unique index. It is the primary join key for any dependent case or advancement entity.
- CASE_GROUP_NUMBER — the user-facing business identifier for the case group, and the principal alternate business-key candidate for lookup and reporting.
- DESCRIPTION and SUB_CSGRP_DESCRIPTION — the long and subordinate descriptive text that labels the group and any sub-case-group classification shown to end users.
- ADVANCED_PAY_GRADE and TIME_ADVANCED_PAY_GRADE — the pay grade applied upon advancement and upon the time-based advancement path respectively.
- ADVANCEMENT_TO and TIME_ADVANCEMENT_TO — the target advancement positions or grades for standard and time-based advancement.
- ADVANCEMENT_ADDITIONAL_PYT — the additional payment amount or indicator attached to an advancement action.
- PERIOD_OF_PROB_ADVMNT and PERIOD_OF_TIME_ADVMNT — the qualifying probationary and elapsed-time periods that must be satisfied before advancement is permitted.
- TIME_ADVN_UNITS and PROB_ADVN_UNITS — the unit of measure (for example days, months, or periods) in which the time and probation advancement periods are expressed.
- ENTRIES_IN_MINUTE — a configuration column supporting minute-level entry handling within the case group.
- BUSINESS_GROUP_ID — the multi-tenant partitioning key that scopes the record to an operating business group.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER — the standard EBS WHO columns providing audit history and optimistic locking.
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.
-
De - Case Groups
-
De - Case Groups
-
VIEW: HR.PQH_DE_CASE_GROUPS# 12.2.2
-
PACKAGE: APPS.PQH_CGN_BUS 12.2.2
-
PACKAGE: APPS.PQH_CGN_SHD 12.2.2
-
PACKAGE: APPS.PQH_CGN_SHD 12.1.1
-
VIEW: HR.PQH_DE_CASE_GROUPS# 12.2.2
-
PACKAGE: APPS.PQH_CGN_BUS 12.1.1
-
TABLE: HR.PQH_DE_CASE_GROUPS 12.1.1
-
TABLE: HR.PQH_DE_CASE_GROUPS 12.2.2
-
PACKAGE: APPS.PQH_CGN_UPD 12.1.1
-
PACKAGE: APPS.PQH_CGN_UPD 12.2.2
-
PACKAGE: APPS.PQH_CGN_INS 12.1.1
-
PACKAGE: APPS.PQH_CGN_INS 12.2.2
-
PACKAGE: APPS.PQH_CGN_SHD 12.2.2
-
PACKAGE: APPS.PQH_CGN_SHD 12.1.1