Results for “hxc_tk_groups_v”

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

Overview

HXC_TK_GROUPS_V is a VALID database view owned by the APPS schema within the Oracle E-Business Suite Release 12.1.1 and 12.2.2 environment. It belongs to the HXC product, the Time and Labor Engine, and is documented as the "Timekeeper Groups" view. Its function is to present timekeeper group definitions in a reporting-friendly, denormalized form by joining the transactional timekeeper group header table to the person record of the individual designated as the timekeeper resource. This enables inquiry, reporting, and integration scenarios where consumers need both the group identity and the human identity of the timekeeper in a single row, without authoring their own join between HXC and PER tables. The view is read-only in nature and is intended for query access rather than direct DML.

Underlying Base Objects

The view text is defined as a join between HXC_TK_GROUPS (referenced through a SYNONYM) and PER_PEOPLE (a view over the core person data), joined on the condition TKG.TK_RESOURCE_ID = P.PERSON_ID. Documented ETRM metadata additionally lists HR_GENERAL, HR_PERSON_NAME, HR_PERSON_TYPE_USAGE_INFO, and HR_SECURITY as referenced base objects. These are the HRMS security and naming packages leveraged indirectly through PER_PEOPLE, which itself resolves person names and applies business group and security filtering. Practically, this means name and person attributes surfaced by HXC_TK_GROUPS_V are governed by the same HR security model that applies to the underlying PER_PEOPLE view, and rows may be restricted according to the querying user's HRMS security profile.

Key Columns

• TK_GROUP_ID — Primary identifier of the timekeeper group record; the key for joining back to HXC_TK_GROUPS or related HXC entities.
• TK_GROUP_NAME — Descriptive name assigned to the timekeeper group.
• TK_RESOURCE_ID — Person identifier of the timekeeper resource, joined to PERSON_ID of PER_PEOPLE.
• LAST_NAME, FIRST_NAME, FULL_NAME — Person name attributes retrieved from PER_PEOPLE for the timekeeper.
• ROW_ID — RowID of the HXC_TK_GROUPS row, exposed as ROW_ID.
• BUSINESS_GROUP_ID — Business group that owns the timekeeper group record, relevant for multi-organization filtering.
• OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO columns supporting audit and change tracking.

Common Use Cases and Queries

Typical usages include listing timekeeper groups with the name of the assigned timekeeper, validating timekeeper assignments, and feeding downstream reporting or interface extracts. Because the join to PER_PEOPLE is embedded, the view is convenient for ad hoc queries that would otherwise require manual joins.

• List all timekeeper groups with their timekeeper name:
  SELECT TK_GROUP_ID, TK_GROUP_NAME, TK_RESOURCE_ID, FULL_NAME FROM APPS.HXC_TK_GROUPS_V ORDER BY TK_GROUP_NAME;
• Retrieve the timekeeper assigned to a specific group:
  SELECT TK_GROUP_NAME, FULL_NAME, LAST_NAME, FIRST_NAME FROM APPS.HXC_TK_GROUPS_V WHERE TK_GROUP_ID = :p_group_id;
• Filter by business group for multi-org reporting:
  SELECT TK_GROUP_ID, TK_GROUP_NAME, FULL_NAME FROM APPS.HXC_TK_GROUPS_V WHERE BUSINESS_GROUP_ID = :p_bg_id;
• Search timekeeper groups by person name:
  SELECT TK_GROUP_NAME, FULL_NAME FROM APPS.HXC_TK_GROUPS_V WHERE UPPER(FULL_NAME) LIKE UPPER('%' || :p_name || '%');

Queries should be executed with APPS credentials or a synonym exposing the view, and results are subject to HRMS security on PER_PEOPLE.