Search Results igw_questions_pk

Overview

The IGW_QUESTIONS table is a core data object within the Oracle E-Business Suite Grants Proposal module (IGW). It serves as the master repository for defining questions that can be associated with various entities in the grants management lifecycle. Its primary role is to standardize and centralize the definition of inquiries pertaining to individuals (e.g., key personnel), proposals, and organizations. This table enables the configuration of compliance and eligibility questionnaires, ensuring consistent data collection across all grant proposals. The table's integrity is enforced by the primary key IGW_QUESTIONS_PK on the QUESTION_NUMBER column, making it the authoritative source for question definitions.

Key Information Stored

While the provided metadata does not list specific columns beyond the primary key, the table's description and relational context indicate it stores the fundamental attributes of a question. The central column is QUESTION_NUMBER, a unique identifier for each question record. Based on standard practice for master data tables in Oracle EBS, other likely columns include fields to define the question text (or a pointer to translated text in the related IGW_QUESTIONS_TL table), the data type of the expected answer (e.g., text, number, date), response constraints, display instructions, and active status flags. The table essentially holds the metadata that defines what is being asked, separate from the actual answers provided for specific proposals, persons, or organizations.

Common Use Cases and Queries

This table is primarily accessed for configuration, reporting, and data validation. Administrators may query it to audit the set of active questions or to identify questions used across the system. A common technical use case involves joining this master table with its transactional counterparts to retrieve a complete question-and-answer set for a specific proposal. For example, to list all questions and answers for a particular proposal, a query would join IGW_QUESTIONS to IGW_PROP_QUESTIONS using QUESTION_NUMBER. Sample SQL to find all active questions might resemble: SELECT question_number FROM igw_questions WHERE active_flag = 'Y' ORDER BY question_number;. Reporting on question utilization across different entity types (proposals, persons, organizations) also relies heavily on this table as the central reference point.

Related Objects

The IGW_QUESTIONS table has defined foreign key relationships with several transactional tables, as documented in the metadata. These relationships demonstrate how master questions are applied to specific entities:

• IGW_PROP_QUESTIONS: Links questions to specific proposals. Join Column: IGW_PROP_QUESTIONS.QUESTION_NUMBER
• IGW_PROP_PERSON_QUESTIONS: Links questions to individuals (key personnel) associated with a proposal. Join Column: IGW_PROP_PERSON_QUESTIONS.QUESTION_NUMBER
• IGW_ORG_QUESTIONS: Links questions to organizations involved in proposals. Join Column: IGW_ORG_QUESTIONS.QUESTION_NUMBER
• IGW_QUESTIONS_TL: A Translation table that provides multilingual support for the question text. Join Column: IGW_QUESTIONS_TL.QUESTION_NUMBER

These relationships form the structural basis for the module's questionnaire functionality, ensuring referential integrity between question definitions and their application.