Search Results coah_id




Overview
Explore in AI Chat

Overview

The IGF_AW_COA_HIST table is a critical audit and history table within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). Its primary role is to serve as a persistent log for all changes made to a student's Cost of Attendance (COA). The COA represents the total estimated cost for a student to attend an institution for a specific period and is a foundational element in calculating financial aid eligibility. This table captures every modification, including the old and new values, the date of the change, the specific COA item affected, and the academic period (load calendar) to which the change pertains. It is essential for compliance, audit trails, troubleshooting, and historical reporting on financial aid packaging decisions in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to capture the complete context of a COA change. The primary key is the system-generated COAH_ID. The BASE_ID column links the record to the specific person (student) whose COA was modified. The TRAN_DATE records when the edit occurred, while ITEM_CODE identifies the specific COA component (e.g., tuition, room, books). The academic context is stored via LD_CAL_TYPE and LD_SEQUENCE_NUMBER. The core audit data is held in OPERATION_TXT (e.g., INSERT, UPDATE), OLD_VALUE, and NEW_VALUE. The table also includes standard EBS "Who" columns (CREATED_BY, CREATION_DATE, etc.) and Concurrent Program columns for tracking automated processes.

Common Use Cases and Queries

A primary use case is auditing changes to a student's financial aid package for regulatory compliance or internal review. Analysts can trace the evolution of a COA for a specific student and term. Another key use is troubleshooting discrepancies in aid awards by identifying when and how COA values were altered. Common reporting queries include identifying all COA changes within a date range or for a specific load calendar. A sample query to retrieve the full change history for a student would be:

  • SELECT coah_id, tran_date, item_code, old_value, new_value, operation_txt
  • FROM igf.igf_aw_coa_hist
  • WHERE base_id = :student_base_id
  • AND ld_cal_type = :calendar_type
  • AND ld_sequence_number = :sequence_num
  • ORDER BY tran_date, coah_id;

Related Objects

IGF_AW_COA_HIST maintains defined relationships with other core EBS objects. Its primary key is enforced by the unique IGF_AW_COA_H_PK index on the COAH_ID column. It references two key tables via foreign keys: the IGS_CA_INST_ALL table (through LD_CAL_TYPE and LD_SEQUENCE_NUMBER) to validate the academic calendar instance, and the IGF_AW_ITEM table (through ITEM_CODE) to validate the specific COA item type being modified. These relationships ensure referential integrity between the history log and the master data for calendars and aid items.