Search Results igf_ap_fa_base_rec_all

Overview

The table IGF_AP_FA_BASE_REC_ALL is a core data repository within the Oracle E-Business Suite's Financial Aid module (IGF), which is designated as obsolete in the provided ETRM documentation for versions 12.1.1 and 12.2.2. It serves as the primary summary record for a student's entire financial aid application and processing lifecycle for a specific academic year. Each record acts as a foundational header, uniquely identifying a student's financial aid case for a given calendar instance (academic period). This table is central to the financial aid data model, as evidenced by its extensive foreign key relationships with numerous supporting detail tables.

Key Information Stored

The table's structure is defined by its primary and unique keys, which identify the critical data points it holds. The primary key is the system-generated BASE_ID, serving as the unique identifier for the financial aid base record. A unique key constraint enforces the logical combination of PERSON_ID (linking to HZ_PARTIES to identify the student), CI_CAL_TYPE, and CI_SEQUENCE_NUMBER (together linking to IGS_CA_INST_ALL to identify the academic calendar instance). While specific descriptive column metadata is not provided, the table's purpose and relationships indicate it likely stores high-level status flags, process dates, calculated summary figures like total cost of attendance or expected family contribution (EFC), and other roll-up information derived from detailed transactional processes.

Common Use Cases and Queries

This table is pivotal for reporting and process orchestration. Common use cases include generating a summary of all financial aid applicants for an academic year, serving as the driving table for award packaging processes, and providing the header context for student-specific correspondence and documentation. A fundamental query pattern involves joining this table to student and calendar data to establish the base population, then left-joining to related detail tables for comprehensive reporting.

SELECT base.person_id,
       base.ci_cal_type,
       base.ci_sequence_number,
       awd.award_id,
       awd.offered_amt
  FROM igf_ap_fa_base_rec_all base,
       igf_aw_award_all awd
 WHERE base.base_id = awd.base_id
   AND base.ci_cal_type = '&CAL_TYPE'
   AND base.ci_sequence_number = &SEQ_NUM;

Given the module's obsolete status, primary operational use would be for historical data inquiry, legacy reporting, and data migration support.

Related Objects

As documented in the ETRM metadata, IGF_AP_FA_BASE_REC_ALL has a central relationship with numerous Financial Aid tables. The BASE_ID column is the foreign key in the following key child tables, illustrating its role as a header record:

• IGF_AW_AWARD_ALL and IGF_AW_COA_ITEMS: For award details and cost of attendance items.
• IGF_AP_EFC_DET and IGF_AP_FA_ANT_DATA: For detailed Expected Family Contribution and antecedent financial data.
• IGF_AP_APPL_STATUS_ALL and IGF_AW_CORRESP_ALL: For tracking application status and correspondence.
• IGF_AP_ISIR_MATCHED_ALL and IGF_AP_CSS_PROFILE_ALL: For external data imports (ISIR, CSS Profile).
• IGF_AP_ST_INST_APPL_ALL and IGF_SP_STDNT_REL_ALL: For institutional application and student relationship data.
• IGF_GR_RFMS_ALL and IGF_SL_LOR_LOC_ALL: For grant request forms and loan originator records.

It directly references parent tables IGS_CA_INST_ALL (via CI_CAL_TYPE, CI_SEQUENCE_NUMBER) for the academic calendar and HZ_PARTIES (via PERSON_ID) for the student entity.