Search Results part_vi_section_a_flag

Overview

IGF.IGF_AW_FISAP_REP is a transaction data table in the Oracle E-Business Suite 12.1.1 / 12.2.2 IGF (Financial Aid) schema. It stores all students with FISAP (Fiscal Operations Report and Application to Participate) related attributes for Part II's Section F and Part VI's Section A. FISAP is the annual report submitted to the U.S. Department of Education by institutions participating in Title IV federal student aid programs, reporting prior-year expenditures for the Federal Perkins Loan, Federal Work-Study (FWS), and Federal Supplemental Educational Opportunity Grant (FSEOG) programs, along with requests for future-year funding. The table resides in the APPS_TS_TX_DATA tablespace and is registered under FND Design Data as IGF.IGF_AW_FISAP_REP.

Under a heuristic Data Vault classification derived from its foreign key structure, this table is satellite-leaning: it carries descriptive, batch-scoped FISAP attributes keyed to the related batch and ISIR records rather than acting as an independent hub. In a formal Data Vault model it would most naturally resolve to a satellite hanging off a student/batch hub or link.

Key Information Stored

• FISAP_DTLS_ID — Surrogate primary key (IGF_AW_FISAP_REP_PK); unique identifier for each FISAP detail record.
• BATCH_ID — Foreign key to IGF_AW_FISAP_BATCH; identifies the FISAP batch to which the record belongs and is the only indexed column (IGF_AW_FISAP_REP_N1, nonunique).
• ISIR_ID — Foreign key to IGF_AP_ISIR_MATCHED_ALL; links the record to the matched ISIR student record.
• DEPENDENCY_STATUS — Whether the student is Dependent or Independent.
• CAREER_LEVEL — FISAP reporting career level (UG with degree, UG without degree, Graduate, or Professional).
• AUTO_ZERO_EFC_FLAG — Whether the student carries an Auto Zero EFC flag.
• FISAP_INCOME_AMT — Student's FISAP income amount.
• ENROLLMENT_STATUS — Enrollment status used for FISAP reporting.
• PERKINS_DISB_AMT, FWS_DISB_AMT, FSEOG_DISB_AMT — Total disbursement amounts for Perkins, FWS, and FSEOG respectively.
• PART_II_SECTION_F_FLAG — Flag marking the record as belonging to Part II reporting.
• PART_VI_SECTION_A_FLAG — Flag marking the record as belonging to Part VI Section A reporting; this is the column most directly associated with the search term.
• Standard Who columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID) — audit and concurrent-program context.

No unique business-key index is documented; the sole index is nonunique on BATCH_ID, indicating BATCH_ID plus flags function as a practical query key rather than a declared uniqueness constraint.

Common Use Cases and Queries

The primary use case is generating FISAP output extracts segmented by Part II Section F and Part VI Section A. The PART_VI_SECTION_A_FLAG column filters records for Part VI reporting:

• Selecting all Part VI Section A records for a batch: SELECT * FROM IGF.IGF_AW_FISAP_REP WHERE BATCH_ID = :batch_id AND PART_VI_SECTION_A_FLAG = 'Y';
• Aggregating program disbursements for FISAP totals: SELECT SUM(PERKINS_DISB_AMT), SUM(FWS_DISB_AMT), SUM(FSEOG_DISB_AMT) FROM IGF.IGF_AW_FISAP_REP WHERE BATCH_ID = :batch_id;
• Breaking down population by dependency and career level for Part VI reporting.
• Reconciling FISAP income and Auto Zero EFC counts against ISIR data via ISIR_ID.

Related Objects

• IGF.IGF_AW_FISAP_BATCH — Joined on IGF_AW_FISAP_REP.BATCH_ID = IGF_AW_FISAP_BATCH.BATCH_ID; the parent batch controlling the FISAP reporting run.
• IGF.IGF_AP_ISIR_MATCHED_ALL — Joined on IGF_AW_FISAP_REP.ISIR_ID; supplies matched ISIR student detail.
• IGF_AW_FISAP_REP_PK — Primary key constraint on FISAP_DTLS_ID.
• IGF_AW_FISAP_REP_N1 — Nonunique index on BATCH_ID supporting batch-scoped access.
• FISAP report concurrent programs and extract logic that read PART_II_SECTION_F_FLAG and PART_VI_SECTION_A_FLAG to segregate output sections.