Search Results question_value




Overview
Explore in AI Chat

Overview

IGFBV_STU_INST_APPLICATIONS is a Business Intelligence System (BIS) view owned by the APPS schema in Oracle E-Business Suite. It is registered in FND Design Data under the application module IGF (Financial Aid). The view exposes student answers to institution-defined application questions captured during the financial aid application process. Its stated purpose within the ETRM metadata is to contain "the values for all the user-defined questions" associated with a student's institutional application, making it the reporting and integration surface for question-response data that would otherwise be scattered across transactional base tables.

Because it is a BIS view rather than a transactional entity, it is intended for read-only access: extraction, ad hoc inquiry, dashboards, and downstream integration. The view does not carry its own storage; all values are resolved at query time from the underlying financial aid application tables. In EBS 12.1.1 and 12.2.2 the view remains marked VALID, and its structure is consistent across both releases.

Underlying Base Objects

The ETRM dependency listing documents that IGFBV_STU_INST_APPLICATIONS references two APPS objects: IGF_AP_FA_BASE_REC_ALL and IGF_AP_ST_INST_APPL_ALL. The view joins these sources to associate a student's institutional application record with the base ISIR record and the specific question/answer pairs captured for that application.

  • IGF_AP_ST_INST_APPL_ALL — supplies the institution application context (INST_APP_ID, APPLICATION_CODE, PERSON_ID).
  • IGF_AP_FA_BASE_REC_ALL — supplies the base student record context (BASE_ID) against which question responses are stored.

The ETRM documentation notes the view is not referenced by any other database object, confirming it is a terminal reporting layer with no downstream dependents inside the schema.

Key Columns

  • INST_APP_ID (NUMBER, 15) — Identifier for the institution application. Primary join key back to the application header.
  • BASE_ID (NUMBER, 10) — Identifier for the ISIR student base record that anchors the applicant's financial aid data.
  • QUESTION_ID (NUMBER, 15) — Identifier for the user-defined (institution-defined) question being answered.
  • QUESTION_VALUE (VARCHAR2, 200) — The student's answer for the defined question. This is the column most commonly filtered or selected when searching on "question value."
  • APPLICATION_CODE (VARCHAR2, 30) — Code identifying the application, useful for distinguishing between application types or cycles.
  • PERSON_ID (NUMBER, 15) — Party/person identifier linking the response to a specific individual.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard WHO audit columns recording creation and last modification metadata.

Common Use Cases and Queries

Typical uses include extracting all answers for a given applicant, auditing responses to a specific institution question across a population, and feeding question-value data into reporting or integration pipelines. Because QUESTION_VALUE is a free-form VARCHAR2(200), lookups are frequently performed with LIKE predicates or exact-match filters on the student's response.

Retrieve all answers for one institution application:

SELECT INST_APP_ID, BASE_ID, QUESTION_ID, QUESTION_VALUE,
       APPLICATION_CODE, PERSON_ID
FROM   APPS.IGFBV_STU_INST_APPLICATIONS
WHERE  INST_APP_ID = :p_inst_app_id;

Search for a specific answer value across applicants:

SELECT PERSON_ID, INST_APP_ID, QUESTION_ID, QUESTION_VALUE
FROM   APPS.IGFBV_STU_INST_APPLICATIONS
WHERE  QUESTION_VALUE LIKE '%Yes%';

List all responses for a person ordered by question:

SELECT QUESTION_ID, QUESTION_VALUE, LAST_UPDATE_DATE
FROM   APPS.IGFBV_STU_INST_APPLICATIONS
WHERE  PERSON_ID = :p_person_id
ORDER  BY QUESTION_ID;

Queries should be executed with APPS-level read privileges, and standard WHO columns can be used to restrict results to recently changed answers.