Search Results paid_adj_num

Overview

The IGF_AW_AWD_HIST table is a critical audit and history table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Institutional Grants and Funds (IGF) module. Its primary role is to serve as a historical ledger, capturing all changes made to student financial aid awards. Whenever an award's offered, accepted, or paid amounts are modified, this table records a snapshot of the change, including the delta values and the operation performed. This provides a complete audit trail for compliance, reporting, and troubleshooting purposes, ensuring financial aid operations are transparent and traceable.

Key Information Stored

The table's structure is designed to capture both the state of a change and its context. The primary key, AWDH_ID, is a unique, sequence-driven identifier for each historical record. The core functional columns include AWARD_ID, which links to the main award record (IGF_AW_AWARD_ALL), and TRAN_DATE, which records when the change occurred. The OPERATION_TXT column documents the Data Manipulation Language (DML) operation (e.g., INSERT, UPDATE) that triggered the history entry. For financial tracking, the table stores new amounts (OFFERED_AMT_NUM, ACCEPTED_AMT_NUM, PAID_AMT_NUM) alongside the corresponding adjustment deltas (OFF_ADJ_NUM, ACC_ADJ_NUM, PAID_ADJ_NUM), which represent the difference between the new and old values. Standard EBS WHO columns (CREATED_BY, CREATION_DATE, etc.) and Concurrent Processing columns (REQUEST_ID, PROGRAM_ID) provide additional audit context.

Common Use Cases and Queries

This table is essential for generating audit reports, reconciling award amounts, and analyzing award adjustment trends. A common use case is tracing the complete lifecycle of a specific award to understand all adjustments made to its offered, accepted, and paid components. For reporting, one might join this history table with the main award and student tables to produce a comprehensive audit trail report. A typical query pattern involves filtering by AWARD_ID and ordering by TRAN_DATE to see the chronological sequence of changes:

• SELECT awdh.TRAN_DATE, awdh.OPERATION_TXT, awdh.OFFERED_AMT_NUM, awdh.OFF_ADJ_NUM FROM igf.igf_aw_awd_hist awdh WHERE awdh.AWARD_ID = :p_award_id ORDER BY awdh.TRAN_DATE;

Another critical use case is calculating the cumulative adjustments for a set of awards over a specific period for financial analysis or regulatory reporting.

Related Objects

The IGF_AW_AWD_HIST table has a direct and singular foreign key relationship with the core awards table, as documented in the provided metadata. This relationship is fundamental to its purpose.

• Primary Key: IGF_AW_AWD_HIST_PK on column AWDH_ID.
• Foreign Key (References): The column AWARD_ID is a foreign key that references the IGF_AW_AWARD_ALL table. This establishes that every history record must be associated with a valid parent award record in the IGF schema.

There are no other documented foreign key relationships where this table references other objects. The table is referenced by the APPS synonym IGF_AW_AWD_HIST, which is the standard access point for all application code and queries within the EBS environment.