Search Results igf_aw_coa_grp_item_all




Overview
Explore in AI Chat

Overview

The table IGF_AW_COA_GRP_ITEM_ALL is a core data object within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). It serves as a junction table that stores the total monetary values for specific cost of attendance (COA) items associated with a defined COA group for an award year. Its primary role is to enable the detailed breakdown of a student's total cost of attendance, which is a fundamental calculation in determining financial aid eligibility and packaging. By linking COA groups to specific item codes and storing their associated amounts, the table provides the granular data necessary for accurate award processing and regulatory compliance within the financial aid lifecycle.

Key Information Stored

The table's structure is defined by its composite primary key and the value it stores. The key columns establish the unique relationship: COA_CODE, CI_CAL_TYPE, and CI_SEQUENCE_NUMBER together identify the specific cost of attendance group (tying to IGF_AW_COA_GROUP_ALL). The ITEM_CODE identifies the specific line item or expense category (tying to IGF_AW_ITEM). The primary data point stored for each unique combination of these keys is the total monetary value for that item within the context of that COA group for the award year. This amount is critical for summing total costs and performing need analysis.

Common Use Cases and Queries

This table is central to queries that report on or validate the composition of cost of attendance budgets. A common use case is generating a detailed COA breakdown for a student based on their assigned COA group. This involves joining to student and COA group assignment tables. Another critical scenario is during the packaging process, where the system aggregates these item amounts to calculate a student's total budget. A typical reporting query would join this table to the COA group and item description tables:

  • Sample Query for COA Group Details:
    SELECT cig.coa_code, cig.ci_cal_type, cig.ci_sequence_number,
    ai.item_code, ai.description, cigi.amount
    FROM igf_aw_coa_grp_item_all cigi,
    igf_aw_coa_group_all cig,
    igf_aw_item ai
    WHERE cigi.coa_code = cig.coa_code
    AND cigi.ci_cal_type = cig.ci_cal_type
    AND cigi.ci_sequence_number = cig.ci_sequence_number
    AND cigi.item_code = ai.item_code
    AND cig.coa_code = '&COA_CODE';

Data integrity checks, such as ensuring all mandatory COA items have a value populated, also rely on queries against this table.

Related Objects

IGF_AW_COA_GRP_ITEM_ALL is intrinsically linked to two primary master tables via foreign key constraints, forming the backbone of the COA structure:

  • IGF_AW_COA_GROUP_ALL: This is the parent table for the COA group definition. The foreign key relationship is on the columns (COA_CODE, CI_CAL_TYPE, CI_SEQUENCE_NUMBER). This ensures every item value record belongs to a valid, existing cost of attendance group.
  • IGF_AW_ITEM: This is the parent table defining valid cost items (e.g., tuition, room, board, books). The foreign key relationship is on the ITEM_CODE column. This ensures that every value recorded is for a predefined and valid expense category within the system.

This table is also a likely source for views that present simplified COA data to other modules or for reporting purposes, and it is fundamental to the APIs responsible for creating and maintaining COA groups.