Search Results igf_aw_amount_offered

Overview

The APPS.IGF_AW_AWARD_LEVEL_HIST_V view is a reporting and inquiry object within the Oracle E-Business Suite Financial Aid (IGF) module, which forms part of the Student Systems / Oracle Student Financial Planning family of applications. Its purpose is to present a human-readable, denormalized audit trail of award-level changes recorded against student financial aid awards. Where the underlying history table stores raw codes, identifiers, and numeric amounts, this view joins and decodes those values so that reports and forms can display meaningful descriptions such as award attribute labels, award status meanings, distribution plan names, and the source of each change.

This view is particularly relevant to users who search on the term igf_award_status, because the view resolves the OLD_AWARD_STATUS_CODE and NEW_AWARD_STATUS_CODE columns into descriptive text through the IGF_AW_GEN.LOOKUP_DESC function using the IGF_AWARD_STATUS lookup type. It therefore serves as the canonical audit window into how an award's status, amounts, lock flag, and disbursement plan evolved over time. Its role in EBS reporting and integration is primarily informational: it supports award history inquiries, discrepancy investigation, and downstream extracts that require before-and-after values for each award attribute change.

Underlying Base Objects

The view text is defined over the award-level history table, aliased as AWD_HIST (the award-level history entity within the IGF award schema). The ETRM metadata for this object documents no additional referenced base objects, so the view is understood to be built directly on that single history table, supplemented at runtime by server-side functions.

Two helper elements are invoked within the SELECT rather than joined as physical objects: IGF_AW_GEN.LOOKUP_DESC, which translates lookup codes into their descriptions, and IGF_AW_GEN.GET_CONCURRENT_PROG_NAME, which resolves a concurrent program identifier to a program name. Note also the decode over PROGRAM_ID: when that column is null the change source and update date are derived from user-driven updates, and when populated they are derived from the concurrent program and request. This distinction is central to interpreting any historical record returned by the view.

Key Columns

• AWARD_ID and AWARD_HIST_TRAN_ID — identify the award and the specific history transaction.
• AWARD_ATTRIB_CODE and AWARD_ATTRIBUTE_DESC — the attribute that changed and its translated label (for example amount offered, amount accepted, amount paid, award status, distribution plan, or lock status).
• OLD_AWARD_STATUS_CODE / NEW_AWARD_STATUS_CODE — the raw status codes, resolved into OLD_VALUE / NEW_VALUE as status descriptions via the IGF_AWARD_STATUS lookup.
• OLD_OFFERED_AMT, NEW_OFFERED_AMT, OLD_ACCEPTED_AMT, NEW_ACCEPTED_AMT, OLD_PAID_AMT, NEW_PAID_AMT — monetary before/after values.
• OLD_LOCK_AWARD_FLAG / NEW_LOCK_AWARD_FLAG — lock status transitions, decoded through IGF_AW_LOCK_STATUS.
• OLD_ADPLANS_ID / NEW_ADPLANS_ID — distribution plan identifiers.
• AWARD_CHANGE_SOURCE_DESC and DERIVED_AWARD_UPDATE_DATE — the origin of the change and the effective timestamp.
• Audit columns including USER_NAME, CREATED_BY, and CREATION_DATE.

Common Use Cases and Queries

Typical scenarios include auditing an award's status progression, reconciling amount changes against disbursements, and identifying changes made by batch processes versus users.

• Retrieve the full change history for a given award, including attribute descriptions and user names.
• Filter to status changes only by constraining AWARD_ATTRIB_CODE = 'IGF_AW_AWARD_STATUS'.
• Compare old and new amounts for offered, accepted, and paid values over a date range.

A representative query is:

SELECT award_id, award_hist_tran_id, award_attribute_desc,
       old_value, new_value, award_change_source_desc,
       derived_award_update_date, user_name
FROM   apps.igf_aw_award_level_hist_v
WHERE  award_attribute_code = 'IGF_AW_AWARD_STATUS'
AND    award_id = :award_id
ORDER BY derived_award_update_date;