Search Results hr_quest_answer_values

Overview

The HR_QUEST_ANSWER_VALUES table is a core data structure within the Oracle E-Business Suite Human Resources (PER) module, specifically supporting the questionnaire functionality. It serves as a transactional repository for the specific values entered by users in response to questions on configured questionnaires. This table acts as the detailed line-level storage for answers, linking each discrete piece of data to its corresponding questionnaire answer header and the specific field on the questionnaire form. Its role is critical for capturing, persisting, and enabling the reporting of structured qualitative and quantitative data gathered through the EBS questionnaire framework, which is used across various HR processes like performance management, surveys, and candidate evaluations.

Key Information Stored

The table stores the linkage and value for each answered field. Its primary columns, as defined by the documented keys, are QUEST_ANSWER_VAL_ID (the surrogate primary key), QUESTIONNAIRE_ANSWER_ID (linking to the answer header in HR_QUEST_ANSWERS), and FIELD_ID (linking to the specific question field definition in HR_QUEST_FIELDS). While the exact value column is not explicitly named in the provided metadata, based on standard EBS design patterns, it typically includes a column such as ANSWER_VALUE or a similar field to store the actual textual or numeric response. The uniqueness constraint (HR_QUEST_ANSWER_VALUES_UK1) on QUESTIONNAIRE_ANSWER_ID and FIELD_ID ensures that for a given questionnaire answer instance, each field can only have one recorded value.

Common Use Cases and Queries

A primary use case is extracting completed questionnaire data for analysis or reporting, such as compiling performance review responses or survey results. Technical consultants often query this table to troubleshoot data issues or build custom integrations. A typical SQL pattern joins to the related header and field tables to produce a readable report:

• SELECT qa.questionnaire_answer_id, qf.name field_name, qav.answer_value
• FROM hr_quest_answer_values qav,
• hr_quest_answers qa,
• hr_quest_fields qf
• WHERE qav.questionnaire_answer_id = qa.questionnaire_answer_id
• AND qav.field_id = qf.field_id
• AND qa.questionnaire_template_id = :template_id;

This pattern is foundational for creating custom extracts, audit reports, or populating downstream data warehouses with granular questionnaire responses.

Related Objects

HR_QUEST_ANSWER_VALUES has defined foreign key relationships with two key parent tables, forming the core of the questionnaire answer model. It is a child of HR_QUEST_ANSWERS, which stores the header-level information for each questionnaire instance (e.g., who completed it and for which context). It is also a child of HR_QUEST_FIELDS, which defines the metadata for each question, such as its prompt, data type, and valid values. This table is likely referenced by various Oracle HR APIs and is essential for the underlying logic of the questionnaire engine. Custom reports and interfaces frequently join through these relationships to present a complete view of questionnaire data.