Search Results igw_prop_questions_pk

Overview

The IGW_PROP_QUESTIONS table is a core data object within the Oracle E-Business Suite (EBS) Grants Proposal module (IGW). It functions as the central repository for storing answers to specific questions associated with a grant proposal. This table is critical for capturing detailed, structured information beyond the basic proposal header, enabling organizations to comply with complex funding agency requirements, internal governance policies, and due diligence questionnaires. Its role is to maintain a formal, auditable link between a proposal (IGW_PROPOSALS_ALL) and the predefined questions (IGW_QUESTIONS) that must be addressed during the submission process.

Key Information Stored

While the provided metadata does not list all columns, the defined primary and foreign keys reveal the essential structure. The table's composite primary key, consisting of PROPOSAL_ID and QUESTION_NUMBER, ensures that each question is answered only once per proposal. The PROPOSAL_ID column links the answer directly to a specific proposal record. The QUESTION_NUMBER column links to the master list of available questions defined in the IGW_QUESTIONS table. Although not detailed in the excerpt, typical columns in such a table would include fields to store the actual ANSWER_TEXT or ANSWER_VALUE, along with standard EBS audit columns like CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY to track data history.

Common Use Cases and Queries

A primary use case is generating a complete proposal dossier that includes all submitted question-and-answer pairs for review or archival purposes. System administrators may query this table to analyze compliance, identifying proposals missing mandatory answers. A common reporting query involves joining the table to the proposal and question master tables to present user-friendly information.

Sample Query Pattern:
SELECT pq.PROPOSAL_ID, p.SHORT_TITLE, q.QUESTION_TEXT, pq.ANSWER_TEXT
FROM IGW_PROP_QUESTIONS pq,
IGW_PROPOSALS_ALL p,
IGW_QUESTIONS q
WHERE pq.PROPOSAL_ID = p.PROPOSAL_ID
AND pq.QUESTION_NUMBER = q.QUESTION_NUMBER
AND p.PROPOSAL_ID = :1;

Related Objects

• IGW_PROPOSALS_ALL (Table): This is the master proposal header table. The foreign key relationship (IGW_PROP_QUESTIONS.PROPOSAL_ID references IGW_PROPOSALS_ALL.PROPOSAL_ID) enforces that every answered question must belong to a valid, existing proposal.
• IGW_QUESTIONS (Table): This table defines the universe of questions that can be asked. The foreign key relationship (IGW_PROP_QUESTIONS.QUESTION_NUMBER references IGW_QUESTIONS.QUESTION_NUMBER) ensures that proposal answers correspond to predefined, controlled questions, maintaining data integrity and consistency across proposals.
• IGW_PROP_QUESTIONS_PK (Primary Key Constraint): The primary key constraint on the PROPOSAL_ID and QUESTION_NUMBER columns guarantees the uniqueness of each question-answer pair within a proposal.