Search Results igf_aw_coa_group_all_uk

Overview

The IGF_AW_COA_GROUP_ALL table is a core data structure within the now-obsolete Financial Aid (IGF) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. Its primary function is to establish and manage the linkage between a defined Cost of Attendance (COA) code and a specific academic calendar period, represented by a financial year. This linkage is fundamental for calculating financial aid awards, as it ensures that the appropriate cost structure is applied to a student based on their enrollment period. The table is designed as a multi-organization table, as indicated by the "_ALL" suffix, meaning it can store data partitioned by operating unit. Notably, the provided metadata states this specific object is "Not implemented in this database," which may indicate it was part of a data model that was not fully deployed in some instances or is a legacy artifact.

Key Information Stored

The table's structure centers on three primary identifiers and a critical sequencing column. The COA_CODE column stores the unique identifier for a defined Cost of Attendance, which outlines estimated expenses. The CI_CAL_TYPE and CI_SEQUENCE_NUMBER columns together form a foreign key to the IGS_CA_INST_ALL (Calendar Instance) table, precisely identifying the academic period or financial year. The most significant column in the context of the user's search is RULE_ORDER. This column is part of a unique key (IGF_AW_COA_GROUP_ALL_UK) and is used to establish a precedence or sequence among multiple COA codes that might be applicable to a single calendar instance, allowing the system to process or select rules in a deterministic order.

Common Use Cases and Queries

A primary use case involves querying the valid Cost of Attendance codes for a given academic period, ordered by their processing sequence. This is essential for batch processes that calculate aid eligibility. For instance, a financial aid administrator might need to review all COA groupings for the upcoming year. A typical query would join to the IGF_AW_COA table to get the COA description. Furthermore, processes that evaluate financial aid packaging rules would reference this table to determine the correct COA to apply based on the student's enrollment term and the established rule order.

Sample SQL to retrieve ordered COA groups for a calendar:

• SELECT g.coa_code, c.description, g.ci_cal_type, g.ci_sequence_number, g.rule_order
• FROM igf_aw_coa_group_all g, igf_aw_coa c
• WHERE g.coa_code = c.coa_code
• AND g.ci_cal_type = '<CAL_TYPE>'
• AND g.ci_sequence_number = <SEQ_NUM>
• ORDER BY g.rule_order;

Related Objects

The IGF_AW_COA_GROUP_ALL table sits at the center of several key relationships, as documented by its foreign keys. It is a parent table to detail tables that rely on the specific COA-calendar grouping.

• IGS_CA_INST_ALL: The table validates the academic calendar instance via columns (CI_CAL_TYPE, CI_SEQUENCE_NUMBER).
• IGF_AW_COA: The table validates the Cost of Attendance code via column (COA_CODE).
• IGF_AW_COA_GRP_ITEM_ALL: A child table that likely stores the individual line-item components (e.g., tuition, room, board) for a specific COA group, joined on (COA_CODE, CI_CAL_TYPE, CI_SEQUENCE_NUMBER).
• IGF_AW_COA_LD_ALL: A child table, potentially for loan-specific details or limits tied to a COA group, joined on the same three key columns.