Results for “fixed_cost”

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

Overview

IGF_AW_COA_GRP_ITEM_V is a database view within the Oracle E-Business Suite Financial Aid module (product code IGF). The view exposes cost of attendance group item data — a category of setup that, within the historic Oracle Student System / Financial Aid architecture, defines the individual budget items (tuition, fees, books, living allowances, and similar) that roll up into a Cost of Attendance (COA) group assigned to a student's award period.

In ETRM documentation the product is explicitly flagged as obsolete, and the object is recorded as "Not implemented in this database" in the reference implementation. This annotation is significant: the view exists as a documented artifact and would only be present in environments where the legacy Financial Aid product has been deployed and its schema objects have been created. Release context matters as well — the documented metadata is drawn from ETRM 12.2.2, while the same object name appears in 12.1.1 environments that carry the legacy Financial Aid product tier, so compatibility should always be verified against the actual data dictionary rather than assumed.

The view's role is predominantly read-only reporting and downstream integration: providing a denormalized, descriptive picture of group item configuration without requiring the caller to join the three underlying tables manually.

Underlying Base Objects

The view text is defined as a three-table equijoin, and ETRM records no separately documented base objects beyond those referenced in the SQL itself:

• IGF_AW_COA_GRP_ITEM COAGI — the driving table holding cost of attendance group item rows, including item code, default value, fixed cost, Pell amounts, distribution, active status, and audit columns.
• IGF_AW_ITEM ITEM — the item master, joined on ITEM_CODE = ITEM.ITEM_CODE, supplying the DESCRIPTION displayed for each item.
• IGS_CA_INST CI — the calendar instance table, joined on CI.CAL_TYPE = COAGI.CI_CAL_TYPE AND CI.SEQUENCE_NUMBER = COAGI.CI_SEQUENCE_NUMBER, supplying the alternate code and the start and end dates of the academic period.

The joins are inner joins, so a group item row will not appear in the view unless a matching item definition and a matching calendar instance both exist. Because the ETRM entry lists no owner or documented referenced base objects, the view text itself is the authoritative definition of its lineage.

Key Columns

• ROW_ID — unique identifier of the underlying group item record.
• COA_CODE — the cost of attendance code to which the item belongs.
• CI_CAL_TYPE, CI_SEQUENCE_NUMBER — the calendar type and sequence identifying the academic period; carried through from the base table for join transparency.
• CI_ALTERNATE_CODE, CI_START_DT, CI_END_DT — human-readable period identifier and its effective dates, sourced from IGS_CA_INST.
• ITEM_CODE, DESCRIPTION — the item identifier and its descriptive name from IGF_AW_ITEM.
• DEFAULT_VALUE, FIXED_COST — the standard amount proposed for the item and the flag indicating whether that amount is fixed rather than adjustable.
• PELL_AMOUNT, PELL_ALTERNATE_AMT — Pell-specific amounts applied when the item is used in Pell award calculations.
• ITEM_DIST, ACTIVE, LOCK_FLAG — distribution treatment, whether the item is currently active, and whether the configuration is locked against change.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns for change tracking.

Common Use Cases and Queries

Typical uses include reviewing cost of attendance configuration for an academic year, auditing Pell amount assignments, and feeding external budgeting or reconciliation extracts with a single flat query.

List active group items for a cost of attendance code:

• SELECT coa_code, ci_alternate_code, item_code, description, default_value, fixed_cost FROM igf_aw_coa_grp_item_v WHERE coa_code = :coa_code AND active = 'Y' ORDER BY item_code;

Compare Pell amounts across periods:

• SELECT item_code, ci_alternate_code, pell_amount, pell_alternate_amt FROM igf_aw_coa_grp_item_v WHERE ci_cal_type = :cal_type ORDER BY item_code, ci_start_dt;

Audit recently modified configuration:

• SELECT coa_code, item_code, last_updated_by, last_update_date FROM igf_aw_coa_grp_item_v WHERE last_update_date >= TRUNC(SYSDATE) - 30 ORDER BY last_update_date DESC;

Before relying on any of these queries, confirm the view exists in the target instance, since ETRM documents it as obsolete and unimplemented in the reference database.