Search Results hxc_absence_type_elements_fk

Overview

The HXC.HXC_ABSENCE_TYPE_ELEMENTS table is a configuration and mapping object within the Oracle E-Business Suite HXC (Time and Labor) schema. It stores the association between Oracle Payroll/HR Elements and Absence Attendance Types that have been imported into Oracle Time and Labor through the Generate Flexfield and Mapping Process. This table underpins the "Configure Absences" screen, which was introduced to allow administrators to maintain Alternate Name Definitions for absence elements brought into OTL through that same import process.

Functionally, the table serves as the bridge between an Element Type (the payroll/HR element) and an Absence Attendance Type (the OTL absence construct), enriching that relationship with attributes such as edit control, unit of measure, and absence category. From a Data Vault modeling perspective, the metadata classifies this object heuristically as standalone. This suggests it behaves more like a self-contained reference or link-style table rather than a deep satellite, though the presence of two numeric identifiers (ELEMENT_TYPE_ID and ABSENCE_ATTENDANCE_TYPE_ID) naturally positions it as a junction between two conceptual hubs if a Data Vault model were built over the EBS source.

Key Information Stored

The table contains five documented columns. The most significant are the two foreign-key-style identifiers that together form the business relationship:

• ABSENCE_ATTENDANCE_TYPE_ID (NUMBER, 15) — The identifier of the Absence Attendance Type of the element imported into OTL.
• ELEMENT_TYPE_ID (NUMBER, 15) — The Element Type identifier of the absence element.
• EDIT_FLAG (VARCHAR2) — Determines whether pre-populated entries against the absence element may be edited within OTL by the end user.
• UOM (VARCHAR2, 10) — The unit of measure associated with the absence element.
• ABSENCE_CATEGORY (VARCHAR2, 30) — The absence category of the absence type attached to the element.

Two unique indexes are documented, and importantly both encode the same column pair in opposite order. The primary business key is HXC_ABSENCE_TYPE_ELEMENTS_UK on (ELEMENT_TYPE_ID, ABSENCE_ATTENDANCE_TYPE_ID), per the documented primary key declaration. A second unique index, HXC_ABSENCE_TYPE_ELEMENTS_FK, covers the reverse ordering (ABSENCE_ATTENDANCE_TYPE_ID, ELEMENT_TYPE_ID). No single-column surrogate sequence key is documented; the table relies on this composite business key. The duplicate index ordering aids lookups driven from either side of the relationship.

Common Use Cases and Queries

Typical usage centers on validating and reporting the element-to-absence mappings configured for OTL. A common query retrieves the full mapping set:

• SELECT ABSENCE_ATTENDANCE_TYPE_ID, ELEMENT_TYPE_ID, EDIT_FLAG, UOM, ABSENCE_CATEGORY FROM HXC.HXC_ABSENCE_TYPE_ELEMENTS;
• Filter by ABSENCE_CATEGORY to audit which absence categories are populated across elements.
• Filter by EDIT_FLAG to determine which absence elements permit user editing of pre-populated entries.
• Join ELEMENT_TYPE_ID to Payroll element definitions and ABSENCE_ATTENDANCE_TYPE_ID to OTL absence type definitions to build reconciliation reports confirming that every imported absence element has a corresponding attendance type.

Because the table is populated by the Generate Flexfield and Mapping Process, it is also consulted during troubleshooting when absence elements fail to appear on the Configure Absences screen or when editability behavior is inconsistent.

Related Objects

The documented dependency data states that this table references no database objects directly and is referenced by the HXC schema object HXC_ABSENCE_TYPE_ELEMENTS# (the underlying table for a synonym or editioning view). Practical joins, based on documented column semantics, are:

• PAY_ELEMENT_TYPES_F / Payroll element definitions — joined on ELEMENT_TYPE_ID.
• HXC_ABSENCE_ATTENDANCE_TYPES (OTL absence type definitions) — joined on ABSENCE_ATTENDANCE_TYPE_ID.
• HXC_ABSENCE_TYPE_ELEMENTS_UK and HXC_ABSENCE_TYPE_ELEMENTS_FK — the unique indexes enforcing the business key.
• HXC_ABSENCE_TYPE_ELEMENTS# — the schema object that references this table.

These relationships support the end-to-end configuration path from payroll elements, through the import mapping, to OTL absence attendance behavior.