Results for “offered_amt_num”

5 results




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

Overview

IGF_AW_AWD_HIST is a table within the IGF (Financial Aid) product module of Oracle E-Business Suite, documented as VALID in the IGF schema. Its stated purpose is to store history data for all Award changes, making it the audit and versioning repository for award records maintained in the Oracle financial aid award cycle. Rather than holding only the current state of an award, this table captures each modification event — offers, adjustments, acceptances, and disbursement activity — as discrete historical rows tied back to the parent award.

From a modeling perspective, the ETRM metadata classifies this object as satellite-leaning based on its foreign key structure. This heuristic suggests the table functions as a descriptive, change-tracking satellite attached to the IGF_AW_AWARD_ALL hub, with AWARD_ID serving as the link back to the award entity and AWDH_ID providing the unique row identity for each historical snapshot. In Oracle EBS 12.1.1 and 12.2.2, this pattern is typical of audit-style tables that preserve point-in-time values alongside standard WHO columns for change attribution.

Key Information Stored

The table contains 19 documented columns in the ETRM 12.1.1 physical schema. The most significant are:

  • AWDH_ID — the surrogate primary key, enforced by IGF_AW_AWD_HIST_PK. This is the only documented unique index and therefore the sole business-key candidate; it uniquely identifies each history row.
  • AWARD_ID — the foreign key to IGF_AW_AWARD_ALL, linking each history record to its parent award. This is the principal join column for all historical queries.
  • TRAN_DATE — the transaction date on which the award change occurred, essential for sequencing and point-in-time reporting.
  • OPERATION_TXT — a textual descriptor of the operation performed, identifying the nature of the change captured in the row.
  • OFFERED_AMT_NUM and OFF_ADJ_NUM — the offered award amount and its associated adjustment value.
  • ACCEPTED_AMT_NUM and ACC_ADJ_NUM — the accepted award amount and any adjustment applied to it.
  • PAID_AMT_NUM and PAID_ADJ_NUM — the disbursed amount and related adjustment.
  • REQUEST_ID — the concurrent request identifier, enabling traceability to the batch or process that produced the row.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — standard WHO audit columns recording who and when the record was created and last modified.
  • PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE — the standard EBS program columns identifying the concurrent program and application responsible for the row.

Note that the supported amount columns pair each monetary value (offered, accepted, paid) with a corresponding adjustment, allowing the history table to reconstruct both the base and adjusted award position at each transaction point.

Common Use Cases and Queries

Because IGF_AW_AWD_HIST preserves every award change, it is the primary source for award audit trails, point-in-time reconciliation, and variance analysis. Typical reporting includes reconstructing the evolution of an award from offered through accepted and paid states, identifying who changed amounts and when, and reconciling the sum of adjustments against the current award balance in IGF_AW_AWARD_ALL.

A representative query retrieves the full change history for a given award in chronological order:

  • SELECT AWDH_ID, TRAN_DATE, OPERATION_TXT, OFFERED_AMT_NUM, ACCEPTED_AMT_NUM, PAID_AMT_NUM, CREATED_BY FROM IGF.IGF_AW_AWD_HIST WHERE AWARD_ID = :p_award_id ORDER BY TRAN_DATE

For batch auditing, filtering on REQUEST_ID isolates all rows produced by a specific concurrent request. The WHO and PROGRAM columns support standard EBS audit reports and troubleshooting of unexpected amount changes.

Related Objects

The most significant related object is the parent award table, joined on the documented foreign key:

  • IGF_AW_AWARD_ALL — referenced via IGF_AW_AWD_HIST.AWARD_ID → IGF_AW_AWARD_ALL, the hub entity for which this table stores change history.
  • IGF_AW_AWD_HIST_PK — the primary key index on AWDH_ID, the only documented unique index.

Beyond these documented relationships, IGFAW award history is typically consumed alongside award disbursement and fund records in the IGF module, which share the AWARD_ID lineage. Any query joining historical rows to current award state should use AWARD_ID as the common key, with TRAN_DATE or CREATION_DATE providing the effective-dating sequence for point-in-time reconstruction.