Search Results hr_questionnaires_pk




Overview
Explore in AI Chat

Overview

The HR.HR_QUESTIONNAIRES table is a core data repository within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Self-Service Human Resources (SSHR) module. It functions as the master definition table for all questionnaire templates created in the system. A questionnaire is a structured form used to capture standardized information, commonly integrated into processes like performance appraisals, surveys, and candidate evaluations. The table stores the template's metadata and the HTML structure of the form itself, enabling the dynamic generation and consistent presentation of questionnaires across the application.

Key Information Stored

The table's columns can be categorized into identification, control, and content data. The primary identifier is the system-generated QUESTIONNAIRE_TEMPLATE_ID, a mandatory 15-digit number that uniquely defines each template. The NAME column holds the unique, user-defined identifier for the questionnaire within a business group. Operational status is managed by AVAILABLE_FLAG, which controls whether the template is active for use. The BUSINESS_GROUP_ID column enforces data security by partitioning questionnaire definitions to specific operating units. The most significant content column is TEXT, defined as a CLOB, which stores the complete HTML code that defines the questionnaire's layout, fields, and logic. Standard EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and the OBJECT_VERSION_NUMBER for optimistic locking complete the row.

Common Use Cases and Queries

This table is central to administrative reporting, data validation, and integration tasks. A common requirement is to audit all available questionnaire templates within a business group for maintenance or upgrade purposes. The following query provides a foundational report:

SELECT QUESTIONNAIRE_TEMPLATE_ID, NAME, AVAILABLE_FLAG, CREATION_DATE, LAST_UPDATE_DATE FROM HR.HR_QUESTIONNAIRES WHERE BUSINESS_GROUP_ID = :p_bg_id ORDER BY NAME;

Another critical use case involves troubleshooting or migrating specific questionnaire definitions. Developers and functional consultants often query the HTML structure stored in the TEXT column to verify content or logic, though this is typically handled via the application's user interface. Integration scenarios, such as populating external systems with questionnaire responses, will use the QUESTIONNAIRE_TEMPLATE_ID from this table as a foreign key to link to detailed answers stored in related tables like HR_QUEST_ANSWERS.

Related Objects

The HR_QUESTIONNAIRES table sits at the center of a defined data model, with several key dependencies. It is referenced by foreign key constraints from child tables that store instance-specific data: HR_QUEST_ANSWERS (holds responses), HR_QUEST_FIELDS (may store additional field definitions), and PER_APPRAISAL_TEMPLATES (links appraisal templates to specific questionnaires). The table's primary key is enforced by the unique index HR_QUESTIONNAIRES_PK on QUESTIONNAIRE_TEMPLATE_ID. A non-unique index, HR_QUESTIONNAIRES_UK1 on NAME and BUSINESS_GROUP_ID, ensures name uniqueness within a business group. The table also maintains a referential integrity link to HR_ALL_ORGANIZATION_UNITS via the BUSINESS_GROUP_ID column.