Search Results hr_questionnaires_pk

Overview

The HR_QUESTIONNAIRES table is a core data object within the Oracle E-Business Suite (EBS) Human Resources (HR) module, specifically under the product code PER. It serves as the master repository for defining questionnaire templates used within the Self-Service Human Resources (SSHR) application. This table stores the foundational metadata for all structured questionnaires, which are subsequently deployed to capture and standardize employee or manager input across various HR processes. Its primary role is to act as the central definitional source, enabling the creation, assignment, and completion of dynamic forms for purposes such as performance appraisals, surveys, and data collection workflows.

Key Information Stored

The table's structure is designed to uniquely identify and categorize each questionnaire template within a specific business group context. The most critical columns include QUESTIONNAIRE_TEMPLATE_ID, which is the system-generated primary key and unique identifier for each template. The NAME column holds the descriptive title of the questionnaire, and when combined with BUSINESS_GROUP_ID (which links to HR_ALL_ORGANIZATION_UNITS), forms a unique key constraint (HR_QUESTIONNAIRES_UK1). This ensures questionnaire names are unique within a given business group, a fundamental requirement for multi-organization implementations. While the provided metadata does not list all columns, typical supplementary attributes would include columns for effective dating, description, status (e.g., active, inactive), and versioning information.

Common Use Cases and Queries

A primary use case is reporting on available questionnaire templates or troubleshooting their assignment. For instance, an HR analyst may need to list all active questionnaire templates within a business group. A common SQL pattern would be:

• SELECT name, questionnaire_template_id FROM hr_questionnaires WHERE business_group_id = &bg_id AND SYSDATE BETWEEN effective_start_date AND effective_end_date ORDER BY name;

Another critical scenario involves investigating data integrity or the impact of a template before modification. Developers or functional consultants often query this table to find the ID of a specific template, which is then used to examine its dependent structures, such as associated questions (HR_QUEST_FIELDS) or existing answers (HR_QUEST_ANSWERS). This is essential for understanding the full scope of a questionnaire's usage within the system.

Related Objects

The HR_QUESTIONNAIRES table is a central hub in the questionnaire data model. As indicated by the foreign key relationships, it is directly referenced by several key objects. The HR_QUEST_FIELDS table stores the individual questions and sections that comprise the template's structure. The HR_QUEST_ANSWERS table holds all the responses submitted for instances of the questionnaire. Crucially, the table is linked to the PER_APPRAISAL_TEMPLATES table twice: once via QUESTIONNAIRE_TEMPLATE_ID for the main appraisal questionnaire and again via MA_QUEST_TEMPLATE_ID for the manager's assessment questionnaire, highlighting its integral role in the performance management lifecycle. All these relationships enforce referential integrity, ensuring that questionnaires cannot be deleted while dependent data exists.