Results for “igf_aw_coa_group_all”

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

Overview

IGF_AW_COA_GROUP_ALL is a Financial Aid (IGF) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that links the Cost of Attendance (COA) code with each financial year. It defines, per academic calendar instance, the ordered set of rules and attributes that govern how a student's Cost of Attendance budget is assembled and applied. The table acts as the grouping header for COA rule items and rule detail lines, providing the parent context for the itemized components that make up a financial aid award year.

From a Data Vault modeling perspective, the mined foreign-key structure suggests a satellite-leaning classification. The table holds descriptive and rule-order attributes attached to the CI calendar instance and COA code, rather than acting as an independent business hub or a pure many-to-many link. Analysts designing an analytical vault should treat it as a dependent satellite keyed by the calendar instance and COA code, with the audit columns supporting change tracking.

Key Information Stored

The table is owned by the IGF schema and contains 15 documented columns. The physical primary key, IGF_AW_COA_GROUP_ALL_PK, is a composite business key rather than a surrogate: it comprises COA_CODE, CI_CAL_TYPE, and CI_SEQUENCE_NUMBER. A unique index, IGF_AW_COA_GROUP_ALL_U1, was also documented over the same three columns (COA_CODE, CI_CAL_TYPE, CI_SEQUENCE_NUMBER); the metadata additionally lists a unique constraint IGF_AW_COA_GROUP_ALL_UK over CI_CAL_TYPE, CI_SEQUENCE_NUMBER, and RULE_ORDER, enforcing that rule ordering is unique within a given calendar instance. The most significant columns are:

• COA_CODE — the Cost of Attendance code identifying the funding/attendance configuration.
• CI_CAL_TYPE — the calendar type of the academic instance (join to IGS_CA_INST_ALL).
• CI_SEQUENCE_NUMBER — the sequence number identifying the specific calendar instance (financial year).
• RULE_ORDER — the sequence in which the grouping rule is evaluated relative to other rules.
• S_RULE_CALL_CD — the rule call code used by the rules engine to invoke the associated logic.
• RUL_SEQUENCE_NUMBER — sequence number tying the row to a specific rule definition.
• PELL_COA and PELL_ALT_EXP — Pell-specific COA and alternate expected-contribution attributes.
• COA_GRP_DESC — the descriptive name of the COA group.
• ORG_ID — the multi-org operating unit context.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.

Together, COA_CODE, CI_CAL_TYPE, and CI_SEQUENCE_NUMBER form the business-key candidate that uniquely identifies a group per financial year.

Common Use Cases and Queries

Typical use cases include reviewing the COA rule groups configured for a financial aid year, tracing itemized COA components back to their group, and validating that rule ordering is unique within a calendar instance. Reporting often joins to IGS_CA_INST_ALL to resolve the calendar instance and to IGF_AW_COA for the COA definition.

A representative pattern retrieves all groups for a given financial year:

• SELECT g.COA_CODE, g.CI_CAL_TYPE, g.CI_SEQUENCE_NUMBER, g.RULE_ORDER, g.COA_GRP_DESC FROM IGF.IGF_AW_COA_GROUP_ALL g WHERE g.CI_CAL_TYPE = :cal_type AND g.CI_SEQUENCE_NUMBER = :seq ORDER BY g.RULE_ORDER;

A second common query lists the itemized lines belonging to a group by joining to IGF_AW_COA_GRP_ITEM_ALL on COA_CODE, CI_CAL_TYPE, and CI_SEQUENCE_NUMBER, exposing how each COA group is decomposed into component items and rule detail lines in IGF_AW_COA_LD_ALL.

Related Objects

The following objects are the most significant dependencies, based on the documented foreign-key relationships:

• IGS_CA_INST_ALL — the calendar instance master; joined on CI_CAL_TYPE and CI_SEQUENCE_NUMBER.
• IGF_AW_COA — the COA definition; joined on COA_CODE.
• IGF_AW_COA_GRP_ITEM_ALL — child table of COA group items; references this table on COA_CODE, CI_CAL_TYPE, and CI_SEQUENCE_NUMBER.
• IGF_AW_COA_LD_ALL — child table of COA rule detail lines; references this table on COA_CODE, CI_CAL_TYPE, and CI_SEQUENCE_NUMBER.

These relationships establish IGF_AW_COA_GROUP_ALL as the parent grouping entity for Cost of Attendance configuration within a financial aid year.