Results for “igf_aw_item”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGF_AW_ITEM is a core reference table in the Oracle E-Business Suite Financial Aid (IGF) module, present in releases 12.1.1 and 12.2.2. It stores the master list of cost of attendance (COA) items — the individual budget components used to calculate a student's anticipated educational expenses, such as tuition, fees, books, supplies, room, board, transportation, and personal expenses. These items form the building blocks from which cost of attendance groups, rate structures, and historical award budgets are assembled across the Financial Aid subsystem.

The table resides in the IGF schema and is registered as VALID in the EBS data dictionary. It is a low-volume, slowly changing reference object that is queried frequently during packaging, budgeting, and disbursement processing. From a Data Vault modeling perspective, the mined foreign-key structure classifies IGF_AW_ITEM as hub-leaning: its primary key ITEM_CODE is a stable business key referenced by multiple dependent tables, which is the classic signature of a hub entity.

Key Information Stored

The table contains nine documented columns. The most significant are:

• ITEM_CODE — The primary key of the table (constraint IGF_AW_ITEM_PK) and the only unique business-key candidate (index IGF_AW_ITEM_U1). It serves as the surrogate/business identifier propagated to all child tables.
• DESCRIPTION — The user-facing name of the cost of attendance item displayed in Financial Aid setup and inquiry forms.
• ITEM_CATEGORY_CODE — Classifies the item into a category, enabling grouping and reporting of budget components.
• ACTIVE — A flag indicating whether the item is currently available for use in COA groups and rate calculations. Inactive items are retained for historical awards but excluded from new setup.
• CREATED_BY, CREATION_DATE — Standard audit columns recording the user and timestamp of row creation.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit columns capturing the most recent modification, supporting change tracking and reconciliation.

The distinction between the surrogate key (ITEM_CODE as PK) and business-key candidate (ITEM_CODE under the unique index) is notable: the same column serves both roles, meaning referential integrity and business uniqueness are enforced through one attribute.

Common Use Cases and Queries

Typical scenarios include COA setup validation, active-item lookups for packaging, and audit reporting. A common query retrieves active items by category:

• SELECT item_code, description, item_category_code FROM igf.igf_aw_item WHERE active = 'Y' ORDER BY item_category_code, item_code;
• Joining to child tables to list group membership: SELECT i.item_code, i.description, g.group_code FROM igf.igf_aw_item i, igf.igf_aw_coa_grp_item_all g WHERE i.item_code = g.item_code;
• Audit queries reconciling recently maintained items using LAST_UPDATE_DATE and LAST_UPDATED_BY.
• Historical rate analysis via igf_aw_coa_rate_det to track how per-item rates changed over time.

Related Objects

IGF_AW_ITEM is referenced by four documented child tables through the ITEM_CODE foreign key column:

• IGF_AW_COA_GRP_ITEM_ALL (ITEM_CODE) — associates items with cost of attendance groups.
• IGF_AW_COA_ITEMS (ITEM_CODE) — links items to COA definitions.
• IGF_AW_COA_HIST (ITEM_CODE) — stores historical COA item data for prior award years.
• IGF_AW_COA_RATE_DET (ITEM_CODE) — holds item-level rate detail used in budget calculations.

These relationships position IGF_AW_ITEM as the parent reference object for the COA item hierarchy in the Financial Aid module.