Search Results hxc_time_attributes

Overview

The HXC_TIME_ATTRIBUTES table is a core data object within the Oracle E-Business Suite (EBS) Time and Labor Engine (HXC). It serves as the master repository for defining the individual attributes that can be used to describe a time entry, known as a building block. Each record in this table represents a discrete piece of information—such as a project number, task, absence type, or hours worked—that can be captured for a timecard. The table's primary role is to provide the metadata and definitional framework for all time attributes used across the application, enabling the flexible configuration of time capture templates and the structured storage of timecard data.

Key Information Stored

The table's structure is designed to uniquely define and describe each time attribute. While the full column list is not provided in the excerpt, the documented primary key is the TIME_ATTRIBUTE_ID, a unique system-generated identifier for each attribute. Based on standard HXC data model patterns, other critical columns typically include the ATTRIBUTE_NAME, CATEGORY (e.g., 'PROJECT', 'HOURS'), and data type information. These columns collectively define what the attribute is, how it is categorized for processing, and the format of its values. The table acts as a reference source, with the actual attribute values for specific time entries stored in related detail tables.

Common Use Cases and Queries

This table is central to administrative setup, data validation, and reporting. A common use case involves querying the catalog of available attributes for template design or troubleshooting. For instance, to list all defined time attributes, a query such as SELECT time_attribute_id, attribute_name FROM hxc_time_attributes ORDER BY attribute_name; would be used. Integration or data fix scripts often reference this table to validate TIME_ATTRIBUTE_ID values before manipulating transactional data. Furthermore, reporting on timecard configurations frequently joins this table to HXC_TIME_ATTRIBUTE_USAGES to understand which attributes are assigned to specific time entry layouts or building block types.

Related Objects

As indicated by the foreign key metadata, HXC_TIME_ATTRIBUTES has direct relationships with several key transactional and setup tables. The HXC_TIME_ATTRIBUTE_USAGES table links attributes to specific building block types, controlling where and how an attribute can be used. The HXC_ERRORS table references TIME_ATTRIBUTE_ID to log validation or processing errors associated with a specific attribute. Beyond these, the table is foundational to the HXC timecard data model, indirectly relating to tables such as HXC_TIME_BUILDING_BLOCKS and HXC_TIMECARD_SUMMARY_VIEW. Data is typically accessed via public APIs provided by the Time and Labor engine rather than through direct DML.