Search Results pqh_template_attributes




Overview
Explore in AI Chat

Overview

The PQH_TEMPLATE_ATTRIBUTES table is a core data object within the Oracle E-Business Suite (EBS) Public Sector Human Resources (PQH) module. It functions as a junction table that establishes and governs the relationship between document templates and their associated data attributes. Its primary role is to define which specific attributes are available for use within a given template and to assign a security level to each attribute within that template's context. This structure is fundamental to the configuration of flexible, secure, and template-driven data entry and reporting processes, particularly for complex public sector personnel actions, position management, and budget control workflows.

Key Information Stored

The table stores the linkage between a template and its constituent attributes, along with critical control information. The key columns, as indicated by the provided metadata, include:

  • TEMPLATE_ATTRIBUTE_ID: The primary key (PK) column, uniquely identifying each record in this table.
  • ATTRIBUTE_ID: A foreign key (FK) referencing the PQH_ATTRIBUTES table. This column identifies the specific data element (e.g., salary, grade, funding source) being associated with the template.
  • TEMPLATE_ID: A foreign key referencing the PQH_TEMPLATES table. This column identifies the document or form template to which the attribute is assigned.

The metadata also specifies a unique key (UK) constraint on the combination of ATTRIBUTE_ID and TEMPLATE_ID, ensuring that a single attribute cannot be redundantly assigned to the same template more than once. The "security level" mentioned in the description, while not explicitly listed in the provided column list, is a crucial piece of data this table holds, likely controlling view or edit permissions for the attribute within the template.

Common Use Cases and Queries

This table is central to administrative setup and audit reporting. A common use case is the analysis of which attributes are configured for a specific template, such as a position creation or budget transfer form. System administrators may query this table to validate configuration or troubleshoot missing data fields. For reporting, it is often joined to its parent tables to generate attribute inventories.

Sample query to list all attributes for a specific template name:

  • SELECT pa.ATTRIBUTE_CODE, pa.NAME, pta.SECURITY_LEVEL
    FROM pqh_template_attributes pta,
         pqh_attributes pa,
         pqh_templates pt
    WHERE pta.attribute_id = pa.attribute_id
    AND pta.template_id = pt.template_id
    AND pt.template_name = '<TEMPLATE_NAME>';

Related Objects

As defined by its foreign key constraints, PQH_TEMPLATE_ATTRIBUTES has direct, integral relationships with two primary master tables:

  • PQH_TEMPLATES: The parent table defining the document or form template. The TEMPLATE_ID FK links an attribute assignment to a specific template record.
  • PQH_ATTRIBUTES: The parent table defining the master list of all available data elements within the PQH module. The ATTRIBUTE_ID FK links a template assignment to a specific attribute definition.

This table is also a likely parent to other transactional or security-related tables within the PQH schema, which would reference its primary key (TEMPLATE_ATTRIBUTE_ID) to store data values or detailed security rules for the template-attribute combination.