Search Results hr_quest_fields_pk

Overview

The HR_QUEST_FIELDS table is a core data structure within the Oracle E-Business Suite (EBS) Human Resources (HR) module, specifically supporting the questionnaire functionality. It serves as the master definition table for all individual data entry fields that comprise a questionnaire template. Each record in this table defines a specific question or data point within a questionnaire, establishing its properties and its relationship to a parent questionnaire template. Its primary role is to store the metadata and configuration for questionnaire fields, which are then rendered for data capture in various HR processes, such as performance appraisals, candidate screenings, or employee surveys. The integrity of questionnaire data is enforced through its defined primary and foreign key relationships.

Key Information Stored

The table stores the structural definition of each questionnaire field. While the full column list is not provided in the excerpt, the documented keys indicate critical data points. The FIELD_ID column is the primary key, uniquely identifying each field definition. The QUESTIONNAIRE_TEMPLATE_ID is a foreign key linking the field to its parent template in the HR_QUESTIONNAIRES table, defining which questionnaire the field belongs to. Other typical columns in such a table, inferred from its purpose, would include the field's display sequence (SEQ), the question text or prompt (QUESTION), the data type (e.g., text, number, date, lookup), display format, whether a response is mandatory, and any validation rules. This metadata dictates how the field behaves and appears to the end-user.

Common Use Cases and Queries

This table is central to configuring, reporting on, and troubleshooting questionnaires. A common administrative use case is to review all fields defined for a specific questionnaire template to verify its setup. For reporting, analysts often join this table to answer tables to generate completed questionnaire data with meaningful field labels.

• Listing Fields for a Template: SELECT field_id, seq, question FROM hr_quest_fields WHERE questionnaire_template_id = &template_id ORDER BY seq;
• Data Integrity Check (Orphaned Fields): SELECT f.* FROM hr_quest_fields f WHERE NOT EXISTS (SELECT 1 FROM hr_questionnaires q WHERE q.questionnaire_template_id = f.questionnaire_template_id);
• Reporting Joined with Answers: SELECT f.question, a.answer_value FROM hr_quest_fields f, hr_quest_answer_values a WHERE f.field_id = a.field_id AND a.assessment_id = &assessment_id;

Related Objects

HR_QUEST_FIELDS is a pivotal object within the questionnaire data model, with direct relationships to several key tables.

• HR_QUESTIONNAIRES: The primary parent table. The foreign key HR_QUEST_FIELDS.QUESTIONNAIRE_TEMPLATE_ID references this table to define the questionnaire template to which a field belongs.
• HR_QUEST_ANSWER_VALUES: The primary child table. It stores the actual responses or data entered by users for each field instance. Its FOREIGN KEY column (FIELD_ID) references HR_QUEST_FIELDS.FIELD_ID, ensuring that every answer can be linked back to its correct field definition.
• HR_QUEST_FIELDS_PK: The primary key constraint on the FIELD_ID column, guaranteeing the uniqueness of each field definition record.