Results for “default_value”

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

Overview

IGF_AW_COA_GRP_ITEM_ALL is a Financial Aid (IGF) module table in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the total values of cost of attendance (COA) for each individual budget item within a defined award year. In practical terms, the table functions as the intersection between a cost of attendance group and the award items that make up that group, holding the monetary amounts and cost-behavior attributes that drive need analysis and award packaging.

The table is owned by the IGF schema and is reported as VALID. It carries eighteen documented columns and a composite primary key, IGF_AW_COA_GRP_ITEM_ALL_PK, defined over COA_CODE, CI_CAL_TYPE, CI_SEQUENCE_NUMBER, and ITEM_CODE. The heuristic Data Vault classification mined from the foreign-key structure is link. This classification is offered as a modeling suggestion rather than a documented fact: the table resolves a many-to-many relationship between COA groups and award items, which is the classic role of a link entity. It also carries descriptive measures such as DEFAULT_VALUE and FIXED_COST, so a strict Data Vault implementation might additionally treat those attributes as satellite content.

Key Information Stored

The primary key is a composite business key rather than a generated surrogate. It combines four columns that together identify one budget item line within one COA group for one award year:

• COA_CODE — Identifies the cost of attendance group to which the item line belongs; foreign key to IGF_AW_COA_GROUP_ALL.
• CI_CAL_TYPE and CI_SEQUENCE_NUMBER — Identify the award year (calendar type and sequence) in which the COA item is effective; the pair participates in the foreign key to IGF_AW_COA_GROUP_ALL.
• ITEM_CODE — Identifies the award/budget item, foreign key to IGF_AW_ITEM.

A documented unique index, IGF_AW_COA_GRP_ITEM_ALL_U1, is defined over the same four columns, confirming them as the business-key candidates. Beyond the key, the most significant attribute columns are:

• DEFAULT_VALUE — The default cost amount applied to the item within the group.
• FIXED_COST and PELL_COA — Flags governing whether the item cost is fixed and whether it participates in Pell COA calculations.
• PELL_AMOUNT and PELL_ALTERNATE_AMT — Pell-specific amount values maintained for the item.
• ITEM_DIST — The distribution or allowance treatment applied to the item.
• ACTIVE — Enables or disables the item line without deleting it.
• ORG_ID — Multi-org operating unit context.
• LOCK_FLAG — Indicates whether the row is locked against modification.

Standard EBS audit columns are also present: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical scenarios include reconstructing a cost of attendance budget group for a given award year, auditing Pell-eligible item amounts, and driving need-analysis calculations. A representative query retrieves all items in a group for a year:

• SELECT item_code, default_value, fixed_cost, pell_coa, pell_amount FROM igf.igf_aw_coa_grp_item_all WHERE coa_code = :coa_code AND ci_cal_type = :cal_type AND ci_sequence_number = :seq AND active = 'Y';

Joining to the item master enriches reporting with item descriptions:

• SELECT g.item_code, i.description, g.default_value FROM igf.igf_aw_coa_grp_item_all g, igf.igf_aw_item i WHERE g.item_code = i.item_code AND g.coa_code = :coa_code;

Reporting use cases commonly aggregate PELL_AMOUNT and PELL_ALTERNATE_AMT across groups to reconcile institutional Pell COA totals, and filter on LOCK_FLAG to identify configurations frozen for a processing cycle.

Related Objects

The foreign-key metadata identifies the principal referenced objects, which are the most significant related entities:

• IGF_AW_COA_GROUP_ALL — Referenced through COA_CODE, CI_CAL_TYPE, and CI_SEQUENCE_NUMBER; the parent cost of attendance group definition.
• IGF_AW_ITEM — Referenced through ITEM_CODE; the award item master supplying item descriptions and categories.
• IGF_AW_COA_GRP_ITEM_ALL_PK — The primary key constraint on the four key columns.
• IGF_AW_COA_GRP_ITEM_ALL_U1 — The unique index reinforcing the business key.

Because IGF_AW_COA_GRP_ITEM_ALL is a link table, dependent reporting views and need-analysis processes in the Financial Aid module resolve their budget item details through it, joining back to IGF_AW_COA_GROUP_ALL and IGF_AW_ITEM on the columns listed above.