Search Results igf_ap_appl_setup_all




Overview
Explore in AI Chat

Overview

The table IGF_AP_APPL_SETUP_ALL is a core data object within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). It serves as the master repository for user-defined questions configured for financial aid applications. Its primary role is to define the specific set of questions that an applicant must answer, which are tailored to each academic institution (organization) and its associated calendar instance (term). This table enables the flexible customization of the application process, allowing different questions to be presented based on the organizational and academic context. As a multi-org table, denoted by the "_ALL" suffix, it stores data for multiple operating units, segregating records by the ORG_ID column.

Key Information Stored

The table's structure is designed to uniquely identify and define each application question within a specific context. The primary key column, QUESTION_ID, is a unique identifier for each question record. The table enforces uniqueness through a separate unique key constraint on the combination of CI_CAL_TYPE (Calendar Type), CI_SEQUENCE_NUMBER (Calendar Sequence Number), ORG_ID (Operating Unit Identifier), and QUESTION (the text of the question itself). This ensures that within a given academic calendar and organization, the same question text cannot be duplicated. The QUESTION column stores the actual text of the user-defined question presented to the applicant. The CI_CAL_TYPE and CI_SEQUENCE_NUMBER columns link the question to a specific academic period or term within the IGS_CA_INST_ALL (Calendar Instances) table.

Common Use Cases and Queries

A primary use case is the administration and reporting of the financial aid application questionnaire. System administrators utilize this table to create, modify, or deactivate application questions for specific terms and organizations. Common queries involve retrieving the full set of active questions for a given aid year and operating unit to display on an application form or to audit the application setup. For example, to list all questions for a specific calendar and organization, one might use: SELECT question_id, question FROM igf_ap_appl_setup_all WHERE ci_cal_type = '&CAL_TYPE' AND ci_sequence_number = &SEQ_NUM AND org_id = &ORG_ID ORDER BY question_id;. Another critical use case is data integration, where external systems may query this table to understand the structure of required applicant data before submission.

Related Objects

IGF_AP_APPL_SETUP_ALL has defined relationships with several other key Financial Aid tables, primarily through foreign key constraints. It references the IGS_CA_INST_ALL table on the columns CI_CAL_TYPE and CI_SEQUENCE_NUMBER to validate the academic calendar instance. Most importantly, it is referenced as a parent table by IGF_AP_ST_INST_APPL_ALL. The foreign key from IGF_AP_ST_INST_APPL_ALL.QUESTION_ID to IGF_AP_APPL_SETUP_ALL.QUESTION_ID indicates that the latter stores the master question definitions, while the former (IGF_AP_ST_INST_APPL_ALL) stores the individual applicant's responses to those specific questions. This relationship is fundamental to the application data model, linking question setup to applicant answers.