Search Results igf_aw_fisap_rep




Overview
Explore in AI Chat

Overview

IGF_AW_FISAP_REP is a Financial Aid table in the Oracle EBS IGF (Financial Aid) product family. It stores student-level records with FISAP-related attributes corresponding to Sections Part II's F and Part VI's A of the FISAP (Fiscal Operations Report and Application to Participate) submission. FISAP reporting is mandated for institutions participating in the Federal Perkins Loan, Federal Work-Study, and Federal Supplemental Educational Opportunity Grant programs, and this table serves as the staging and reporting vehicle for the data required to populate those sections.

The object is documented under the IGF module, which carries an "Obsolete" designation in current Oracle EBS documentation. Notes indicate it is not implemented in the reference database used by ETRM. Consequently, the table should be treated as a legacy or deprecated object within EBS 12.1.1 and 12.2.2, relevant primarily to historical data models and migrations rather than to active production configurations.

Based on the mined foreign-key structure, the heuristic Data Vault classification for this table is satellite-leaning. This reflects that the table hangs off parent keys (batch and ISIR references) and carries descriptive attributes, rather than acting as an independent business hub or a pure many-to-many link. This classification is offered as a modeling suggestion, not as a normative EBS designation.

Key Information Stored

The primary key is IGF_AW_FISAP_REP_PK, defined on the surrogate column FISAP_DTLS_ID, which uniquely identifies each FISAP detail record. Business-key candidates center on the relationships to parent records rather than a natural student identifier; the foreign keys BATCH_ID and ISIR_ID provide the contextual linkage to the batch run and to the matched ISIR data respectively.

Among the most significant columns:

Common Use Cases and Queries

Typical use cases involve extracting student populations for FISAP Sections Part II F and Part VI A, reconciling disbursement totals by program, and auditing records flagged for each section. Reporting queries commonly join to the batch parent to group and filter by processing run:

  • Retrieve all detail rows for a given batch: SELECT * FROM IGF_AW_FISAP_REP WHERE BATCH_ID = :p_batch_id;
  • Aggregate disbursements by section flag: SELECT PART_II_SECTION_F_FLAG, SUM(PERKINS_DISB_AMT), SUM(FWS_DISB_AMT), SUM(FSEOG_DISB_AMT) FROM IGF_AW_FISAP_REP GROUP BY PART_II_SECTION_F_FLAG;
  • Join to the matched ISIR parent for student-level context: SELECT r.FISAP_DTLS_ID, i.ISIR_ID FROM IGF_AW_FISAP_REP r, IGF_AP_ISIR_MATCHED_ALL i WHERE r.ISIR_ID = i.ISIR_ID;
  • Identify auto-zero EFC records: SELECT * FROM IGF_AW_FISAP_REP WHERE AUTO_ZERO_EFC_FLAG = 'Y';

Related Objects

  • IGF_AW_FISAP_BATCH — parent batch table; joined via IGF_AW_FISAP_REP.BATCH_ID = IGF_AW_FISAP_BATCH.BATCH_ID.
  • IGF_AP_ISIR_MATCHED_ALL — matched ISIR records; joined via IGF_AW_FISAP_REP.ISIR_ID.
  • Other IGF Financial Aid reporting and configuration tables that consume batch and ISIR data, including any FISAP summary or extract objects tied to the same batch process.
  • Concurrent program and request metadata referenced by PROGRAM_APPLICATION_ID and REQUEST_ID for process traceability.

Because the object is documented as obsolete and not implemented in the reference database, references to it should be validated against the target environment before reliance in new development or migration efforts.