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:
- COAH_ID — surrogate primary key for each history row.
- BASE_ID — reference back to the underlying cost-of-attendance record whose change is being logged.
- ITEM_CODE — the cost component affected, resolving to IGF_AW_ITEM.
- OLD_VALUE / NEW_VALUE — the value before and after the change, enabling delta reporting.
- OPERATION_TXT — description of the operation performed (for example insert, update, or delete).
- TRAN_DATE — the effective date of the transaction.
- LD_CAL_TYPE / LD_SEQUENCE_NUMBER — the academic calendar type and sequence identifying the load calendar instance, joined to IGS_CA_INST_ALL.
- PROGRAM_APPLICATION_ID / PROGRAM_ID — the program application and program context for the change.
- PROGRAM_UPDATE_DATE — the date the program-level record was updated.
- REQUEST_ID — the concurrent request that produced the row, useful for tracing batch processes.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns identifying who created and last touched the row.
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_ITEMonitem_codeyields human-readable cost component names for reporting. - Joining to
IGS_CA_INST_ALLonld_cal_typeandld_sequence_numberplaces changes within an academic period, supporting term-based history extracts. - Grouping by
request_idisolates 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.
-
History data for all cost of attendance related changes
-
History data for all Award changes
-
View: IGF_AW_COA_HIST_V 12.1.1
Cost of Attendance History View
APPS.IGF_AW_COA_HIST_V·↳ FND_USER·↳ HZ_PARTIES·↳ IGF_AP_FA_BASE_REC·Explore IGF module →
-
VIEW: APPS.IGF_AW_COA_HIST_V 12.1.1
-
TABLE: IGF.IGF_AW_AWD_HIST 12.1.1
-
TABLE: IGF.IGF_AW_COA_HIST 12.1.1
-
View: IGF_AW_COA_HIST_V 12.2.2
Cost of Attendance History View
Not implemented in this database·Explore IGF module →
-
eTRM - IGF Tables and Views 12.1.1
Holds pays only unit details for a pays only program