Results for “tran_date”

19 results




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

Overview

IGF_AW_COA_HIST is a history table in the IGF (Financial Aid) product module of Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the audit trail of all changes made to cost of attendance (COA) records maintained by the financial aid subsystem. Cost of attendance values drive the calculation of student aid eligibility budgets, including tuition, fees, books, supplies, room and board, and personal expenses. Because these figures directly affect disbursement and packaging amounts, Oracle maintains a full before-and-after history so that institutions can demonstrate compliance with Title IV and other regulatory audit requirements.

Under a heuristic Data Vault classification mined from its foreign-key structure, this object is best modeled as a link: it carries no independent business identity of its own and exists to associate an operational event (a dated COA change) with the parent cost-of-attendance record and the change item that was affected. Its grain is one row per change occurrence, making it a transactional bridge between the referenced item and calendar instance entities.

Key Information Stored

The surrogate primary key of the table is COAH_ID, enforced by the unique index IGF_AW_COA_H_PK. No separate business-key unique index is documented beyond this primary key, so COAH_ID is the only guaranteed unique identifier for a history row. The most significant columns are:

Common Use Cases and Queries

The primary use case is audit and reconciliation reporting. Aid administrators reconstruct the value of a cost-of-attendance component at any point in time, or prove that an adjustment was authorized. A typical query answers “what changed on this COA record and when”:

  • SELECT item_code, old_value, new_value, operation_txt, tran_date FROM igf.igf_aw_coa_hist WHERE base_id = :p_base_id ORDER BY tran_date DESC;
  • Joining to IGF_AW_ITEM on item_code yields human-readable cost component names for reporting.
  • Joining to IGS_CA_INST_ALL on ld_cal_type and ld_sequence_number places changes within an academic period, supporting term-based history extracts.
  • Grouping by request_id isolates rows generated by a specific concurrent program run, useful for batch troubleshooting.

Because the table is insert-oriented and never overwritten, it is also a reliable source for data-warehouse feeds that require slowly changing dimension history for COA attributes.

Related Objects

  • IGF_AW_ITEM — referenced on ITEM_CODE; holds the master definition of each cost-of-attendance component.
  • IGS_CA_INST_ALL — referenced on LD_CAL_TYPE and LD_SEQUENCE_NUMBER; provides the calendar instance (term) context.
  • IGF_AW_COA (parent COA entity) — related through BASE_ID, the operational record whose changes are logged.
  • FND_CONCURRENT_REQUESTS — related through REQUEST_ID, for tracing the originating concurrent process.
  • FND_USER / per-audit tables — related through CREATED_BY and LAST_UPDATED_BY for user attribution.

In most implementations the table is populated by the cost-of-attendance maintenance screens and concurrent programs within the Financial Aid module, and is queried rather than updated directly.