Search Results formula_code




Overview
Explore in AI Chat

Overview

The table IGF_AW_AWD_FRML_DET_ALL is a core data structure within the Oracle E-Business Suite's Financial Aid module (IGF). It is designed to store the detailed, sequential instructions for applying financial aid funds according to a predefined award formula. Its primary role is to define the precise order and rules for distributing funds from a financial aid package to a student's account. This table acts as the execution blueprint for the automated packaging process in Oracle Financial Aid, ensuring funds are applied consistently and in compliance with institutional and regulatory policies. The table supports the multi-org architecture in both EBS 12.1.1 and 12.2.2, as indicated by the '_ALL' suffix, meaning it stores data for multiple operating units.

Key Information Stored

The table's structure centers on linking a formula to specific funds and defining their application sequence. The primary key uniquely identifies a record and consists of four columns: FORMULA_CODE, CI_CAL_TYPE, CI_SEQUENCE_NUMBER, and SEQ_NO. The FORMULA_CODE, along with the calendar type and sequence (CI_CAL_TYPE, CI_SEQUENCE_NUMBER), identifies the parent award formula. The SEQ_NO column dictates the order in which the fund is applied. Other critical columns include FUND_ID, which is a foreign key to the IGF_AW_FUND_MAST_ALL table and specifies the actual financial aid resource (e.g., a specific loan or grant). Additional columns like PE_GROUP_ID (linking to a person/student group) and ADPLANS_ID (linking to an award distribution plan) provide further conditional logic for fund application within the sequence.

Common Use Cases and Queries

A primary use case is auditing and troubleshooting the financial aid packaging process. Administrators may query this table to verify the fund sequence for a specific award formula. A common reporting need is to list all funds associated with a formula, ordered by their application sequence. For example, to analyze the formula 'FED_DIRECT_LOAN', one might use the following SQL pattern:

  • SELECT det.seq_no, fm.fund_code, fm.description FROM igf_aw_awd_frml_det_all det, igf_aw_fund_mast_all fm WHERE det.formula_code = 'FED_DIRECT_LOAN' AND det.fund_id = fm.fund_id ORDER BY det.seq_no;

This query is essential for validating packaging rules, ensuring high-cost funds are applied first, or checking for dependencies between grants and loans. Custom reports for regulatory compliance often join this table with fund master and award data to demonstrate the methodology of aid distribution.

Related Objects

IGF_AW_AWD_FRML_DET_ALL is centrally connected to several key Financial Aid tables via documented foreign key relationships. Its primary parent is the award formula header table, referenced by the composite key (FORMULA_CODE, CI_CAL_TYPE, CI_SEQUENCE_NUMBER). It has two distinct foreign key relationships to IGF_AW_FUND_MAST_ALL via the FUND_ID column, defining the source funds. It also relates to IGS_PE_PERSID_GROUP_ALL via PE_GROUP_ID, allowing formula details to target specific student populations. Finally, it links to IGF_AW_AWD_DIST_PLANS via ADPLANS_ID, connecting the formula detail to a specific disbursement schedule. These relationships are critical for any data integrity checks, impact analysis, or complex integrations involving the award packaging engine.