Search Results hxc_tk_group_query_criteria




Overview
Explore in AI Chat

Overview

HXC_TK_GROUP_QUERY_CRITERIA is a Time and Labor Engine (HXC) table that stores the filter criteria used to define dynamic timekeeper groups in Oracle E-Business Suite 12.1.1 and 12.2.2. Timekeeper groups allow administrators to bundle employees, assignments, or other time-entry entities into logical units for processing, approval, and reporting purposes. Rather than assigning members statically, a timekeeper group can be driven by a saved query whose selection criteria live in this table. Each row captures one criterion belonging to a parent query record, so the table functions as a child of HXC_TK_GROUP_QUERIES and holds the individual predicates that together define how the parent group is populated.

Based on the foreign key structure documented in the ETRM metadata, this object is classified heuristically as satellite-leaning in a Data Vault style model. It carries descriptive attributes that qualify a parent relationship (the timekeeper group query) rather than serving as an independent hub of business entities or a pure link between hubs. The single outbound foreign key to HXC_TK_GROUP_QUERIES reinforces this associative, descriptive role.

Key Information Stored

The table is documented with 10 columns. The most significant are:

  • TK_GROUP_QUERY_CRITERIA_ID – The surrogate primary key, uniquely identifying each criterion row and backed by the unique index HXC_TK_GRP_QUERY_CRITERIA_PK. This is a system-generated identifier, not a business key.
  • TK_GROUP_QUERY_ID – The foreign key to HXC_TK_GROUP_QUERIES, linking each criterion to its owning query definition. This is the primary business relationship column and the main join path.
  • CRITERIA_TYPE – Identifies the category or nature of the criterion (for example, which attribute or dimension is being filtered). It determines how CRITERIA_ID should be interpreted.
  • CRITERIA_ID – The reference value for the criterion, typically pointing to the specific entity, lookup, or value being matched. Its meaning is context-dependent on CRITERIA_TYPE.
  • OBJECT_VERSION_NUMBER – Supports optimistic locking and concurrency control, incremented on each update.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard Oracle EBS audit columns recording who created and last modified each row, when, and through which session.

The surrogate primary key should be distinguished from the composite TK_GROUP_QUERY_ID plus CRITERIA_TYPE/CRITERIA_ID combination, which effectively behaves as the business-key candidate defining what a criterion means.

Common Use Cases and Queries

This table is primarily consumed by the Time and Labor Engine when evaluating dynamic group membership. Common practical scenarios include:

  • Auditing which criteria define a given timekeeper group query.
  • Reporting on group definitions to reconcile expected versus actual membership.
  • Troubleshooting why an employee is or is not included in a timekeeper group.

A typical query joins the criteria to its parent query:

SELECT q.TK_GROUP_QUERY_ID, c.CRITERIA_TYPE, c.CRITERIA_ID
FROM HXC_TK_GROUP_QUERIES q, HXC_TK_GROUP_QUERY_CRITERIA c
WHERE q.TK_GROUP_QUERY_ID = c.TK_GROUP_QUERY_ID
ORDER BY q.TK_GROUP_QUERY_ID, c.CRITERIA_TYPE;

Filtering by a specific parent query is common:

SELECT * FROM HXC_TK_GROUP_QUERY_CRITERIA
WHERE TK_GROUP_QUERY_ID = :p_query_id;

Because CRITERIA_ID is polymorphic, reporting tools generally resolve it against the reference implied by CRITERIA_TYPE rather than treating it as a fixed foreign key.

Related Objects

  • HXC_TK_GROUP_QUERIES – The parent table; joined on TK_GROUP_QUERY_ID. This is the direct FK relationship documented in the metadata and the most important dependency.
  • HXC_TK_GROUPS – The timekeeper group definitions that ultimately consume the resolved query results.
  • HXC_TK_GROUP_MEMBERS – Stores resolved or assigned membership, complementary to the dynamic criteria here.
  • HXC_TIMEKEEPER_GROUPS and related HXC timekeeper configuration tables – context for group administration.
  • HXC_TK_GROUP_QUERY_CRITERIA_PK – The unique index enforcing the surrogate primary key.

These objects together form the timekeeper group definition subsystem within the Time and Labor Engine, with this table supplying the filter-level detail that drives dynamic membership.