Search Results igf_aw_awd_frml_all

Overview

The table IGF_AW_AWD_FRML_ALL is a core data object within the Oracle E-Business Suite's Financial Aid module (IGF). It functions as the central repository for defining the specific order, or sequence, in which financial aid funds are allocated to students. This allocation is governed by the rules of a packaging process for a defined target group. Crucially, the table also stores the configuration for any award-level rule overrides that should be applied to individual funds within that sequence. Its role is to provide the structured, rule-driven logic that determines how financial aid packages are automatically assembled, ensuring compliance with institutional policies and donor restrictions during the automated awarding process.

Key Information Stored

The table's structure centers on defining a formula for a specific academic context and target group. The primary key consists of FORMULA_CODE, CI_CAL_TYPE (Calendar Type), and CI_SEQUENCE_NUMBER, uniquely identifying an allocation sequence for a given award year or period. A critical column is GROUP_CD, which links the formula to a specific target group defined in the IGF_AW_TARGET_GRP_ALL table, specifying which set of students the allocation rules apply to. Other essential columns would typically include the FUND_CODE to identify the financial aid fund being allocated, a SEQUENCE_ORDER or similar column to dictate the precise order of fund allocation, and columns controlling rule overrides for attributes like maximum award amounts, eligibility criteria, or locking flags for each fund in the sequence. The ORG_ID column supports multi-organization security.

Common Use Cases and Queries

The primary use case is the execution and analysis of the automated financial aid packaging process. Administrators configure formulas in this table to model different packaging philosophies (e.g., need-based first, then merit). Common queries involve listing all allocation formulas for a specific award year or target group to verify setup, or tracing which funds and rules are applied to a student's package. A typical reporting SQL pattern joins this table to the target group and fund master tables.

SELECT frml.formula_code,
       frml.group_cd,
       tgp.group_desc,
       frml.fund_code,
       fund.fund_name,
       frml.sequence_order
  FROM igf_aw_awd_frml_all frml,
       igf_aw_target_grp_all tgp,
       igf_aw_fund_mast_all fund
 WHERE frml.group_cd = tgp.group_cd
   AND frml.fund_code = fund.fund_code
   AND frml.ci_cal_type = :p_cal_type
   AND frml.ci_sequence_number = :p_seq_num
 ORDER BY frml.formula_code, frml.sequence_order;

Related Objects

• IGF_AW_TARGET_GRP_ALL: This table holds the definition of the student target groups. IGF_AW_AWD_FRML_ALL is linked to it via a foreign key relationship on the GROUP_CD and ORG_ID columns. A formula is defined for a specific target group.
• IGF_AW_FUND_MAST_ALL: While not listed in the provided foreign keys, this is a fundamentally related table. The FUND_CODE in the formula table would typically reference the master list of funds defined in IGF_AW_FUND_MAST_ALL.
• IGF_AW_AWD_FRML_DET_ALL: Based on common module patterns, a detail table with this or a similar name may exist to store the individual fund sequence lines and override rules, linked back to the header record in IGF_AW_AWD_FRML_ALL.