Search Results pay_ele_tmplt_class_usages_uk2




Overview
Explore in AI Chat

Overview

HR.PAY_ELE_TMPLT_CLASS_USAGES is a transactional configuration table in the Oracle E-Business Suite HR (Payroll) schema. It functions as an intermediate table that associates element templates with element classifications and is the primary data store leveraged by the Element Template Wizard. When a payroll administrator creates or edits an element template, the Wizard reads and writes rows here to persist which classifications a given template may use, along with the display behavior for each association.

The table is registered under FND Design Data as PAY.PAY_ELE_TMPLT_CLASS_USAGES and carries a VALID status in both 12.1.1 and 12.2.2. It is stored in the APPS_TS_TX_DATA tablespace, while its indexes reside in APPS_TS_TX_IDX. The metadata classifies this object heuristically as a standalone entity, meaning no foreign keys are formally declared. From a Data Vault modeling perspective, this pattern suggests treating the table as a link-style association between element templates and element classifications, with descriptive attributes (display modes and the ELE_TMPLT_CLASS_INFO columns) behaving like satellite payload rather than independent hubs.

Key Information Stored

The table is organized around a surrogate primary key and two business-key candidates. The most important columns are:

  • ELE_TEMPLATE_CLASSIFICATION_ID — Numeric surrogate primary key, enforced by the unique index PAY_ELE_TMPLT_CLASS_USAGES_PK. Uniquely identifies each template-to-classification association row.
  • CLASSIFICATION_ID — Identifies the element classification being associated. Part of the natural business key.
  • TEMPLATE_ID — Identifies the element template being associated. Part of the natural business key.
  • DISPLAY_PROCESS_MODE — VARCHAR2(30). Controls whether and how the process mode field is surfaced in the Element Template Wizard for this association.
  • DISPLAY_ARREARAGE — VARCHAR2(30). Controls whether the arrearage field is displayed for this template/classification pairing.
  • ELE_TMPLT_CLASS_INFO_CATEGORY — Categorizes the associated template-classification information.
  • ELE_TMPLT_CLASS_INFO1 through ELE_TMPLT_CLASS_INFO30 — A wide set of descriptive/seed columns used to hold additional template-classification attributes consumed by the Wizard.
  • ZD_EDITION_NAME — Editioning column supporting the 12.2 online patching (edition-based redefinition) model; it participates in both unique indexes.

The business-key candidate, PAY_ELE_TMPLT_CLASS_USAGES_UK2, enforces uniqueness across CLASSIFICATION_ID, TEMPLATE_ID, and ZD_EDITION_NAME, guaranteeing that a classification-template pairing appears only once per edition. This makes UK2 the primary target for query predicates when validating or de-duplicating associations, while the surrogate PK is the safer join key for internal processing.

Common Use Cases and Queries

Typical usage centers on Element Template Wizard configuration, payroll setup validation, and migration reporting. A standard retrieval query is:

  • SELECT ELE_TEMPLATE_CLASSIFICATION_ID, CLASSIFICATION_ID, TEMPLATE_ID, DISPLAY_PROCESS_MODE, DISPLAY_ARREARAGE FROM HR.PAY_ELE_TMPLT_CLASS_USAGES;
  • Join to element templates and element classifications to report which classifications each template is permitted to use, filtering on TEMPLATE_ID.
  • Validate uniqueness before bulk loading template-classification mappings by testing against UK2 columns (TEMPLATE_ID, CLASSIFICATION_ID).
  • Audit display behavior across templates by grouping on DISPLAY_PROCESS_MODE and DISPLAY_ARREARAGE.
  • Compare setup between environments by extracting rows for a defined set of TEMPLATE_ID values.

Related Objects

Although the metadata records no declared foreign keys, the table is functionally dependent on the following HR objects.

  • HR.PAY_ELEMENT_TEMPLATES — Parent of the TEMPLATE_ID reference; defines the element template being configured.
  • HR.PAY_ELEMENT_CLASSIFICATIONS — Parent of the CLASSIFICATION_ID reference; defines the element classifications available to templates.
  • PAY_ELE_TMPLT_CLASS_USAGES (APPS synonym) — Application-layer synonym referenced by the Element Template Wizard and PL/SQL.
  • PAY_ELE_TMPLT_CLASS_USAGES (PUBLIC synonym) — Public synonym exposed for external access.
  • PAY_ELE_TMPLT_CLASS_USAGES_PK — Unique index on ELE_TEMPLATE_CLASSIFICATION_ID (with ZD_EDITION_NAME).
  • PAY_ELE_TMPLT_CLASS_USAGES_UK2 — Unique index on CLASSIFICATION_ID, TEMPLATE_ID, ZD_EDITION_NAME.