Search Results hr_quest_feilds_fk

Overview

The HR.HR_QUEST_FIELDS table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 Human Resources (HR) module. It serves as the master definition table for the individual fields that comprise a questionnaire template. In the context of Oracle EBS's flexible questionnaire functionality, this table stores the metadata that defines each question or input field, including its data type, behavior, and source of valid values. Its primary role is to support the creation of configurable questionnaires used across various HR processes, such as performance reviews, surveys, and candidate assessments, enabling organizations to capture structured, user-defined information.

Key Information Stored

The table's columns define the properties and behavior of each questionnaire field. The primary identifier, FIELD_ID, is a system-generated key from the sequence HR_QUEST_FIELDS_S. The QUESTIONNAIRE_TEMPLATE_ID column links the field to its parent template in the HR_QUESTIONNAIRES table. The NAME and TYPE columns store the field's display label and its data type (e.g., text, number, date, poplist), respectively. Critical for dynamic value sets are the SQL_REQUIRED_FLAG and SQL_TEXT columns, which indicate and contain the SQL statement used to generate available values for the field. The HTML_TEXT column of type LONG allows for embedding custom HTML to further define field rendering. Standard EBS audit columns (OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) track row history and changes.

Common Use Cases and Queries

This table is central to administering and reporting on questionnaire structures. Common scenarios include auditing all fields within a specific questionnaire template, troubleshooting field value lists, and generating documentation of active questionnaires. A typical query retrieves the field definitions for a known template, often joining to HR_QUESTIONNAIRES for context:

SELECT qf.name,
       qf.type,
       qf.sql_required_flag,
       qf.sql_text
FROM   hr_quest_fields qf,
       hr_questionnaires q
WHERE  qf.questionnaire_template_id = q.questionnaire_template_id
AND    q.name = 'Performance Review 2024';

For technical support, queries often examine fields using dynamic SQL to validate the SQL_TEXT logic. Integration or data migration scripts may reference this table to understand the target data structure before populating questionnaire responses, which are stored in related tables like HR_QUEST_ANSWER_VALUES.

Related Objects

• Primary Key: The table is uniquely identified by the HR_QUEST_FIELDS_PK index on the FIELD_ID column.
• Parent Table (Foreign Key Reference): HR_QUEST_FIELDS.QUESTIONNAIRE_TEMPLATE_ID is a foreign key referencing HR_QUESTIONNAIRES. This enforces that every field must belong to a valid questionnaire template.
• Child Table (Referenced by Foreign Key): The HR_QUEST_ANSWER_VALUES table references HR_QUEST_FIELDS via its FIELD_ID column. This relationship links stored answer values back to their field definition.
• Supporting Index: The HR_QUEST_FEILDS_FK index (non-unique) on QUESTIONNAIRE_TEMPLATE_ID supports efficient joins to the parent questionnaire table.