Search Results igf_aw_coa_itm_terms_pk

Overview

The table IGF_AW_COA_ITM_TERMS is a core data object within the Oracle E-Business Suite's Financial Aid module (IGF). Its primary function is to manage the distribution of financial aid funding across academic periods. Specifically, it stores the setup rules for splitting a student's total cost of attendance (COA) item amount into discrete portions for individual terms or load calendars within an academic year. This table is essential for ensuring that awarded aid is correctly allocated and reported according to institutional policies and regulatory requirements, forming a critical link between a student's overall financial need and the term-based disbursement process in releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is defined by its composite primary key, which uniquely identifies a term split for a specific cost item. The key columns are BASE_ID, which links to the student's base financial aid record; ITEM_CODE, identifying the specific cost of attendance item (e.g., tuition, books); and LD_CAL_TYPE and LD_SEQUENCE_NUMBER, which together identify the academic term or load calendar for which a portion of the item amount is allocated. While the provided metadata focuses on keys, typical columns in such a setup table would include a percentage or fixed amount field dictating how the total item cost is divided for the specified term. The integrity of this data is enforced by its primary key constraint (IGF_AW_COA_ITM_TERMS_PK).

Common Use Cases and Queries

This table is central to processes that calculate and disburse financial aid on a per-term basis. A primary use case is the generation of a student's term-specific financial aid package, where the system queries this table to determine how much of each COA item budget is available for a given period. For reporting, it enables analysis of cost distribution patterns. Common SQL queries involve joining to the cost items table to retrieve details. For example, to find all term splits for a specific student and item, one might use: SELECT * FROM igf_aw_coa_itm_terms WHERE base_id = :1 AND item_code = :2. Another critical pattern is aggregating split amounts by term for a student's total cost of attendance, which directly feeds into award calculation and disbursement scheduling.

Related Objects

IGF_AW_COA_ITM_TERMS maintains defined foreign key relationships with other core Financial Aid and Student System tables, ensuring referential integrity. The documented relationships are:

• IGF_AW_COA_ITEMS: This is the parent table for cost of attendance items. The foreign key from IGF_AW_COA_ITM_TERMS (BASE_ID, ITEM_CODE) references IGF_AW_COA_ITEMS, linking a term split back to its master cost item definition for a student.
• IGS_CA_INST_ALL: This table defines academic calendar instances. The foreign key using columns LD_CAL_TYPE and LD_SEQUENCE_NUMBER references IGS_CA_INST_ALL, ensuring that the term specified in the split corresponds to a valid, defined academic period in the system.

These relationships position IGF_AW_COA_ITM_TERMS as a junction table connecting a student's cost items to the institutional academic calendar.