Search Results hr_quest_answers_uk1




Overview
Explore in AI Chat

Overview

The HR_QUEST_ANSWERS table is a core data repository within the Oracle E-Business Suite Human Resources (HRMS) module, specifically for the Questionnaire functionality. It serves as the master header record for a set of answers submitted in response to a specific questionnaire template. Each row represents a unique instance of a completed or in-progress questionnaire, linked to a particular business object within the application, such as an appraisal or a participant record. Its primary role is to establish the context (who, what, when) for a set of detailed answers, which are stored in the related HR_QUEST_ANSWER_VALUES table.

Key Information Stored

The table's structure is designed to capture the essential metadata for a questionnaire answer set. The system-generated primary key, QUESTIONNAIRE_ANSWER_ID, uniquely identifies each answer set. The QUESTIONNAIRE_TEMPLATE_ID foreign key links to the HR_QUESTIONNAIRES table, defining which questionnaire was used. Crucially, the combination of the TYPE and TYPE_OBJECT_ID columns identifies the specific business object (e.g., an appraisal, a participant) to which this answer set pertains, and this combination is enforced by the unique key HR_QUEST_ANSWERS_UK1. The BUSINESS_GROUP_ID provides security and data partitioning at the organizational level. Standard Oracle Applications "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) complete the record for auditability.

Common Use Cases and Queries

This table is central to reporting and data validation for any process utilizing questionnaires. A common scenario involves retrieving all answer sets for a specific type of object, such as all appraisals within a business group. Developers may also query it to validate data integrity or to link questionnaire responses back to their source transactions. A typical reporting query would join this header table with the detail lines and the questionnaire template.

  • Sample Query (Find answer sets for a specific appraisal):
    SELECT qa.* FROM hr_quest_answers qa WHERE qa.type = 'APPRAISAL' AND qa.type_object_id = :appraisal_id;
  • Sample Query (List all answer sets with template name):
    SELECT qa.questionnaire_answer_id, qa.type, q.name template_name, qa.creation_date FROM hr_quest_answers qa, hr_questionnaires q WHERE qa.questionnaire_template_id = q.questionnaire_template_id AND qa.business_group_id = :bg_id;

Related Objects

The HR_QUEST_ANSWERS table sits at the center of a key data relationship within the Questionnaire subsystem. It has defined foreign key dependencies to master tables and is a parent to detail records.

  • Referenced Foreign Keys (Parent Tables):
    • HR_QUESTIONNAIRES: Via QUESTIONNAIRE_TEMPLATE_ID. Links the answer set to its defining template.
    • HR_ALL_ORGANIZATION_UNITS: Via BUSINESS_GROUP_ID. Secures the data within an organization.
  • Referencing Foreign Key (Child Table):
    • HR_QUEST_ANSWER_VALUES: Via QUESTIONNAIRE_ANSWER_ID. This is the critical one-to-many relationship where the actual answers to individual questions are stored. Each row in HR_QUEST_ANSWERS can have multiple detail rows in HR_QUEST_ANSWER_VALUES.