Results for “qualifier_attribute2”

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

Overview

HXC_LAYOUT_COMP_QUALIFIERS is a table owned by the HXC schema within the Oracle E-Business Suite Time and Labor Engine product (HXC). It stores the qualifier definitions that are attached to layout components used by the Time and Labor Engine's layout and rules framework. Layout components represent the configurable building blocks of timecard and time-calculation layouts, and qualifiers provide the additional attribute-based filtering and classification metadata that determines when, how, and for which population a given component applies.

In Oracle EBS 12.1.1 and 12.2.2, this table is a configuration/metadata repository rather than a transactional table. Its rows define reusable qualifier records, each of which may be referenced by qualifier rules that drive conditional logic during layout rendering and time processing. The presence of the ZD_EDITION_NAME column indicates the object is edition-enabled, consistent with the editioning and data-model refactoring introduced in the 12.2.x upgrade path.

From a Data Vault modeling perspective, the mined FK structure suggests this table is satellite-leaning. It carries descriptive qualifier attributes keyed to a parent layout component, with dependent rule tables referencing it, rather than acting as a pure hub or link. This classification is a heuristic modeling suggestion, not a documented architectural claim.

Key Information Stored

The table contains 41 documented columns. The most significant are:

• LAYOUT_COMP_QUALIFIER_ID — the surrogate primary key (HXC_LAYOUT_COMP_QUALIFIERS_PK) uniquely identifying each qualifier row.
• QUALIFIER_NAME — the business-facing name of the qualifier; this column participates in the unique index HXC_LAYOUT_COMP_QUALIFIERS_UK1, making it a business-key candidate.
• LAYOUT_COMPONENT_ID — foreign key to HXC_LAYOUT_COMPONENTS, anchoring the qualifier to its parent layout component.
• QUALIFIER_ATTRIBUTE_CATEGORY — the descriptive flexfield context/attribute category governing the qualifier's attribute set.
• QUALIFIER_ATTRIBUTE1 through QUALIFIER_ATTRIBUTE30 — thirty generic descriptive flexfield segments holding qualifier-specific configuration values. These typically carry filter criteria, applicability conditions, or classification values that drive rule evaluation.
• OBJECT_VERSION_NUMBER — optimistic locking / row version control.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard Oracle EBS WHO columns for audit tracking.
• ZD_EDITION_NAME — editioning identifier; the primary key index is defined on (LAYOUT_COMP_QUALIFIER_ID, ZD_EDITION_NAME).

Common Use Cases and Queries

Typical use cases center on diagnostics and reporting of Time and Labor layout configuration, migration/patching validation, and troubleshooting why a layout component does or does not apply to a given employee or timecard scenario.

• Listing all qualifiers for a given layout component:

  SELECT q.layout_comp_qualifier_id, q.qualifier_name
  FROM hxc.hxc_layout_comp_qualifiers q
  WHERE q.layout_component_id = :component_id;

• Resolving a qualifier by business name:

  SELECT * FROM hxc.hxc_layout_comp_qualifiers
  WHERE qualifier_name = :name;

• Joining qualifiers to their rules:

  SELECT q.qualifier_name, r.*
  FROM hxc.hxc_layout_comp_qualifiers q,
       hxc.hxc_layout_comp_qual_rules r
  WHERE q.layout_comp_qualifier_id = r.layout_comp_qualifier_id;

• Auditing attribute usage (e.g., finding qualifiers that populate a specific flexfield segment) for configuration baselines and comparisons between environments.
• Supporting upgrade impact analysis by filtering on ZD_EDITION_NAME and OBJECT_VERSION_NUMBER.

Related Objects

The following objects are the most significant references and dependencies based on documented PK/FK relationships:

• HXC_LAYOUT_COMPONENTS — parent table; joined via LAYOUT_COMPONENT_ID. Qualifiers cannot exist without a parent layout component.
• HXC_LAYOUT_COMP_QUAL_RULES — child table; references LAYOUT_COMP_QUALIFIER_ID. Stores the rules that evaluate qualifier conditions.
• HXC_LAYOUT_COMP_QUALIFIERS_PK — primary key index on LAYOUT_COMP_QUALIFIER_ID and ZD_EDITION_NAME.
• HXC_LAYOUT_COMP_QUALIFIERS_UK1 — unique index supporting QUALIFIER_NAME as a business key.

These relationships establish the qualifier table as the connective tissue between layout component definitions and the rule engine that governs conditional layout behavior in Oracle Time and Labor.