Search Results award_year_description




Overview
Explore in AI Chat

Overview

IGFFV_STU_INST_APPLICATIONS is an Oracle E-Business Suite (EBS) Business Intelligence System (BIS) view owned by the APPS schema and registered under FND Design Data IGF.IGFFV_STU_INST_APPLICATIONS. Its status is VALID in both EBS 12.1.1 and 12.2.2. The view belongs to the Oracle Financial Aid / Student Information functional area and exposes the student-entered responses to institution-defined questions captured during an institutional application process.

Functionally, the view presents the values for all user-defined questions configured by an institution, joined to student identity and application context data. Each row represents a single question-and-answer pair for a given person, award year, and institutional application. The view is intended for reporting, BI Publisher extracts, and downstream integration where institutions need to inspect or transmit applicant questionnaire responses without navigating the underlying normalized financial aid tables. Because it is a view rather than a table, it carries no storage of its own and inherits the security profile of the APPS schema.

Underlying Base Objects

According to the documented dependency information, IGFFV_STU_INST_APPLICATIONS references the following objects in the APPS schema:

  • HZ_PARTIES — the Trading Community Architecture (TCA) party registry, supplying person-level identity attributes.
  • IGF_AP_APPL_SETUP_ALL — institution application setup, defining the application configuration per award year.
  • IGF_AP_FA_BASE_REC_ALL — the financial aid base record (ISIR student record) that anchors the applicant.
  • IGF_AP_ST_INST_APPL_ALL — the student institutional application header, providing the institutional application identifier.
  • IGS_CA_INST_ALL — the institution/calendar instance, providing award year and institutional context.

The view is not referenced by any other database object, so it functions as a terminal reporting layer. Documented referenced base objects for the 12.2.2 metadata record are listed as none, indicating that dependency mapping is maintained through the view source rather than a separate repository entry.

Key Columns

  • PERSON_NAME (VARCHAR2 360) — the applicant's full name.
  • PERSON_NUMBER (VARCHAR2 30) — the person's unique identifier in the TCA model.
  • PERSON_ID (NUMBER 15) — the surrogate key linking to HZ_PARTIES.
  • QUESTION (VARCHAR2 200) — the text of the question set by the institution.
  • QUESTION_VALUE (VARCHAR2 200) — the student's answer to that question.
  • QUESTION_ID (NUMBER 15) — the identifier of the user-defined question.
  • AWARD_YEAR (VARCHAR2 10) — the award year alternate code.
  • AWARD_YEAR_DESCRIPTION (VARCHAR2 30) — the descriptive name of the award year. This is the column users search for when reporting by award year label rather than code.
  • INST_APP_ID (NUMBER 15) — identifier for the institutional application.
  • BASE_ID (NUMBER 10) — identifier for the ISIR student record.
  • APPLICATION_CODE (VARCHAR2 30) — code identifying the application.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard Who columns for audit traceability.

Common Use Cases and Queries

Typical uses include applicant question-response extracts, award-year reporting, and audit of institutional questionnaire data. Because AWARD_YEAR_DESCRIPTION is frequently the reported attribute, users typically filter or group on it rather than the code.

Example query retrieving applicant responses by award year:

SELECT PERSON_NAME, PERSON_NUMBER, AWARD_YEAR, AWARD_YEAR_DESCRIPTION, QUESTION, QUESTION_VALUE FROM APPS.IGFFV_STU_INST_APPLICATIONS WHERE AWARD_YEAR_DESCRIPTION = :p_award_year ORDER BY PERSON_NAME, QUESTION;

Example aggregation of responses per award year:

SELECT AWARD_YEAR_DESCRIPTION, COUNT(DISTINCT PERSON_ID) applicants, COUNT(*) responses FROM APPS.IGFFV_STU_INST_APPLICATIONS GROUP BY AWARD_YEAR_DESCRIPTION;

Joining to application context:

SELECT a.PERSON_NUMBER, a.PERSON_NAME, a.AWARD_YEAR_DESCRIPTION, a.QUESTION, a.QUESTION_VALUE, a.APPLICATION_CODE FROM APPS.IGFFV_STU_INST_APPLICATIONS a WHERE a.INST_APP_ID = :p_inst_app_id;

All queries should honor the standard APPS security model when exposed to end users, and results should be validated against award-year setup before distribution.