Results for “hxc_time_building_blocks_ar”

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

Overview

The HXC_TIME_BUILDING_BLOCKS_AR table is the archive counterpart to HXC_TIME_BUILDING_BLOCKS, the core time-entry and time-card transaction table within the Oracle Time and Labor Engine (HXC) product in Oracle E-Business Suite 12.1.1 and 12.2.2. Time building blocks represent discrete units of recorded time — a labor hour entry, a shift segment, an approval-level decomposition, or a measured quantity — that together compose the detailed time records processed by the Time and Labor Engine and ultimately transferred to Oracle Payroll, Projects, and other consuming applications. The _AR suffix indicates that the table stores archived or retained copies of building-block rows, typically populated by purging, retention, or transfer processes that relocate historical time data out of the active transactional tables while preserving it for audit, statutory retention, and historical reporting.

The ETRM metadata classifies this object heuristically as standalone under the Data Vault model, with only a single mined foreign key (APPROVAL_STYLE_ID to HXC_APPROVAL_STYLES). As a modeling suggestion, the archive table behaves primarily as a satellite-like store of descriptive and measure data keyed by the building-block identifier; it does not act as a central hub or a true link because the catalogued relationships are limited to the approval-style reference.

Key Information Stored

The table contains 25 documented columns. The most significant include:

• TIME_BUILDING_BLOCK_ID — the surrogate primary key identifying each archived time building block.
• OBJECT_VERSION_NUMBER — the optimistic-locking version; together with the ID it forms the unique index HXC_TIME_BUILDING_BLOCKS_AR_PK, making this pair the documented business-key candidate for the archive.
• TYPE, MEASURE, UNIT_OF_MEASURE — describe the nature of the block (for example, time versus quantity) and the unit recorded.
• START_TIME, STOP_TIME, DATE_FROM, DATE_TO — the effective and actual time boundaries of the block, supporting temporal and interval reporting.
• PARENT_BUILDING_BLOCK_ID, PARENT_BUILDING_BLOCK_OVN — self-referencing hierarchy columns that reconstruct parent/child composition of time entries.
• SCOPE, RESOURCE_ID, RESOURCE_TYPE — identify the person, resource, or scope to which the time belongs.
• APPROVAL_STATUS, APPROVAL_STYLE_ID — approval state and the referenced approval style from HXC_APPROVAL_STYLES.
• COMMENT_TEXT — free-text notes attached to the archived block.
• DATA_SET_ID, APPLICATION_SET_ID, TRANSLATION_DISPLAY_KEY — set-based and localization context columns.
• Standard audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical uses include historical time audits, retention reporting, reconciliation after purge cycles, and reconstruction of approval history. A common pattern joins archived blocks to the source person or assignment through RESOURCE_ID/RESOURCE_TYPE, filtered by date range:

• Retrieve archived entries for a resource: SELECT TIME_BUILDING_BLOCK_ID, START_TIME, STOP_TIME, MEASURE, APPROVAL_STATUS FROM HXC_TIME_BUILDING_BLOCKS_AR WHERE RESOURCE_ID = :p_resource_id AND START_TIME BETWEEN :p_from AND :p_to.
• Reconstruct hierarchy: self-join on PARENT_BUILDING_BLOCK_ID = TIME_BUILDING_BLOCK_ID to rebuild parent/child time composition.
• Compare active versus archived volumes: aggregate counts by TYPE and SCOPE across HXC_TIME_BUILDING_BLOCKS and this archive to validate purge processes.
• Approval reporting: join APPROVAL_STYLE_ID to HXC_APPROVAL_STYLES to summarize approved versus pending historical time.

Related Objects

• HXC_TIME_BUILDING_BLOCKS — the active source table from which archived rows originate.
• HXC_APPROVAL_STYLES — referenced via APPROVAL_STYLE_ID.
• HXC_TIME_ATTRIBUTES / HXC_TIME_ATTRIBUTE_USAGES — carry the detail attribute values that qualify each block.
• HXC_ELEMENTS_AND_RULES / HXC_RULES — define the rules that generate and evaluate blocks.
• HR / PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F — resolve RESOURCE_ID to the underlying person and assignment.
• HXC_TIME_CARDS / HXC_TIME_CARD_FIELDS — associate archived blocks with the time card context.
• HXC_APPLY_LEGACY_TIME / Time and Labor transfer APIs — invoked to move or purge data into the archive tables.