Search Results hr_quest_answers




Overview
Explore in AI Chat

Overview

The HR_QUEST_ANSWERS table is a core data repository within the Oracle E-Business Suite (EBS) Human Resources (HR) module, specifically under the PER product family. Its primary function is to store the master record of a completed questionnaire instance. In the context of Oracle EBS 12.1.1 and 12.2.2, questionnaires are flexible tools used to capture structured qualitative data for various entities, such as job applications, performance appraisals, or competency assessments. This table acts as the header record, defining who or what the questionnaire is for and which template was used, while the specific answers are stored in the related HR_QUEST_ANSWER_VALUES table. It is a critical component for enabling configurable data collection and reporting on employee or candidate information beyond standard HR forms.

Key Information Stored

The table's structure is designed to link a questionnaire response to its context within the HRMS system. Key columns include QUESTIONNAIRE_ANSWER_ID, the system-generated primary key for each response set. The TYPE and TYPE_OBJECT_ID columns work together to identify the subject of the questionnaire (e.g., a person, a vacancy, or an organization) by storing a lookup code and the corresponding identifier from the relevant base table. QUESTIONNAIRE_TEMPLATE_ID is a foreign key to HR_QUESTIONNAIRES, defining the structure and questions used. BUSINESS_GROUP_ID, a standard HRMS column, links the answer record to the appropriate security and data group, ensuring multi-organization support. The table's unique key constraint (HR_QUEST_ANSWERS_UK1) on TYPE and TYPE_OBJECT_ID helps enforce data integrity for the subject.

Common Use Cases and Queries

A primary use case is extracting completed questionnaire data for reporting, such as aggregating candidate responses from a recruitment drive or compiling performance feedback. A typical query joins HR_QUEST_ANSWERS to HR_QUESTIONNAIRES for template details and to HR_QUEST_ANSWER_VALUES for the actual responses. For example, to find all questionnaire answers for a specific person (TYPE_OBJECT_ID = 1234), one might use:

  • SELECT qa.questionnaire_answer_id, q.name questionnaire_name, qav.answer_value
  • FROM hr_quest_answers qa,
  • hr_questionnaires q,
  • hr_quest_answer_values qav
  • WHERE qa.type_object_id = 1234
  • AND qa.questionnaire_template_id = q.questionnaire_id
  • AND qa.questionnaire_answer_id = qav.questionnaire_answer_id;

This table is also central when APIs or custom programs are written to programmatically create or update questionnaire responses for integration or data migration purposes.

Related Objects

HR_QUEST_ANSWERS has integral relationships with several other EBS HR objects. As per the provided metadata, it has a foreign key relationship with HR_QUESTIONNAIRES, which stores the template definitions. It is also linked to HR_ALL_ORGANIZATION_UNITS via BUSINESS_GROUP_ID for organizational context. Most significantly, it has a one-to-many relationship with the HR_QUEST_ANSWER_VALUES table, which holds the detailed answers for each question. This relationship is enforced by the foreign key from HR_QUEST_ANSWER_VALUES.QUESTIONNAIRE_ANSWER_ID back to HR_QUEST_ANSWERS. While not listed in the excerpt, this table is also commonly referenced by HR-specific views and is accessed by standard Oracle HRMS APIs for questionnaire functionality.