Search Results igf_aw_award_lvl_hist_pk

Overview

The IGF_AW_AWARD_LEVEL_HIST table is a core data object within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). It functions as a historical audit trail, systematically recording all changes made to the attributes of a student's financial aid award at the award level. Its primary role is to ensure data integrity and provide a complete, auditable history of an award's evolution over time, which is critical for compliance, troubleshooting, and reporting in financial aid operations. Each modification to an award's key characteristics generates a new record in this history table, capturing the state before and after the change.

Key Information Stored

The table stores change details using a composite primary key and columns that capture both the context of the change and the specific data altered. The primary key uniquely identifies each historical transaction for a given award attribute: AWARD_ID (links to the main award), AWARD_HIST_TRAN_ID (a transaction identifier grouping all changes from a single event), and AWARD_ATTRIB_CODE (specifies which award attribute was modified, e.g., status, amount, or disbursement plan). Crucially, the table employs an "old value" and "new value" pattern for storing data. This is exemplified by the columns OLD_ADPLANS_ID and NEW_ADPLANS_ID, which store the previous and updated disbursement plan identifiers, respectively, when the AWARD_ATTRIB_CODE pertains to the disbursement plan. Other columns typically include timestamps, user IDs, and the old and new values for the modified attribute code.

Common Use Cases and Queries

A primary use case is auditing the complete change history for a specific award or student. For instance, to trace all modifications to the disbursement plan for award ID 1001, one would query using the AWARD_HIST_TRAN_ID to group related changes from a single transaction. The column AWARD_HIST_TRAN_ID, as referenced in the user's search, is essential for correlating multiple attribute changes that occurred simultaneously. A common reporting scenario involves reconstructing the state of an award at a specific point in time by analyzing the chronological sequence of historical records. Sample SQL often involves joining to the main award table (IGF_AW_AWARD_ALL) and filtering by AWARD_ID and transaction date ranges to generate compliance or operational reports.

Related Objects

The IGF_AW_AWARD_LEVEL_HIST table maintains defined foreign key relationships with other critical Financial Aid tables, ensuring referential integrity. The documented relationships are as follows:

• IGF_AW_AWARD_ALL: The table references the master award table via the AWARD_ID column. This is the fundamental link to the core award record.
• IGF_AW_AWD_DIST_PLANS: The table references the disbursement plans table twice—once for the old value and once for the new value. It joins via OLD_ADPLANS_ID to show the previous plan and via NEW_ADPLANS_ID to show the updated plan.

These relationships are vital for constructing meaningful queries that join historical change data with descriptive information from the parent tables.