Results for “coa_code”

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

Overview

IGF_AW_COA is a Financial Aid module table in Oracle E-Business Suite that stores Cost of Attendance (COA) groups. In the financial aid domain, a Cost of Attendance represents the total estimated student expense budget — encompassing tuition, fees, books, housing, and living costs — used to determine a student's eligibility for need-based aid. The IGF_AW_COA table serves as the master definition repository for these COA groups, forming the reference backbone against which student-level cost of attendance assignments are validated.

The object belongs to the IGF (Financial Aid) product family, which is flagged as obsolete in Oracle EBS 12.1.1 and 12.2.2. Notably, the ETRM metadata indicates the table is "not implemented in this database," meaning it may exist only in upgraded or legacy environments, or exists purely as a historical schema remnant. Consultants migrating from earlier releases or auditing legacy financial aid data should treat this object as deprecated and avoid new dependencies on it.

From a Data Vault modeling perspective, the heuristic classification for IGF_AW_COA is hub-leaning. This suggests the table behaves as a business key reference hub, anchored by the COA_CODE business key, with descriptive attributes perhaps better suited to a satellite structure in a modernized warehouse design.

Key Information Stored

The documented metadata identifies a restricted set of columns, centered on the primary key structure:

• COA_CODE — The business key and sole documented column. This code uniquely identifies a Cost of Attendance group. It is both the primary key column and the foreign key join column referenced by dependent child tables.

The primary key is defined as IGF_AW_COA_PK, anchored on COA_CODE. In Oracle EBS convention, this table would typically also carry surrogate and audit columns such as COA_ID, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY, but these are not enumerated in the provided metadata and should not be assumed without direct catalog inspection. The distinguishing structural fact is that COA_CODE functions simultaneously as the surrogate primary key and the business key candidate — there is no documented secondary unique index separating the two roles.

Common Use Cases and Queries

The table is primarily referenced during COA group validation and financial aid packaging. Typical reporting queries resolve the COA code to its group definition:

• Listing all active COA codes for a given institution or aid year.
• Joining to IGF_AW_COA_GROUP_ALL to resolve group-level attributes for student awards.
• Auditing orphaned COA codes during data migration from obsolete IGF environments.

A representative query pattern joins the parent to the child on the shared business key:

SELECT c.COA_CODE, g.* FROM IGF_AW_COA c, IGF_AW_COA_GROUP_ALL g WHERE c.COA_CODE = g.COA_CODE;

Because the table is obsolete and reportedly unimplemented, these queries are generally used for historical reconciliation rather than active production reporting.

Related Objects

The documented foreign key relationship identifies the most significant dependent object:

• IGF_AW_COA_GROUP_ALL — References IGF_AW_COA via the column IGF_AW_COA_GROUP_ALL.COA_CODE. This is the primary child table capturing COA group assignments and their institutional/attribute detail.

Additional related Financial Aid objects commonly encountered alongside this table include IGF_AW_COA_RULES (COA rule definitions), IGF_AW_STUDENT_COA (student-level COA assignment), and IGF_AW_ISIR_COA (ISIR-driven COA associations), though these are not enumerated in the provided metadata. Where legacy data integration is required, the join column of record remains COA_CODE across the COA table family.