Results for “packaging_type”

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

Overview

IGFBV_STUDENT_AWARDS is a read-only base view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the IGF (Financial Aid) product family. Its documented purpose is to expose the entity that holds information about awards granted to students, consolidating award-level financial figures, status flags, and the linkage between an award and the student base record. In Oracle EBS 12.1.1 and 12.2.2, the view is marked VALID and functions as a reporting and integration surface, presenting decoded lookup values and descriptive flexfield context rather than raw coded identifiers. Because the view text carries the WITH READ ONLY clause, it is intended strictly for query access; no DML is permitted against it.

Underlying Base Objects

The view is defined over two documented base objects joined on the base identifier. The primary object is IGF_AW_AWARD_ALL, aliased AWD, which supplies the award transaction rows. The second is IGF_AP_FA_BASE_REC_ALL, aliased FABASE, which supplies the person identifier. The join predicate is AWD.BASE_ID = FABASE.BASE_ID, meaning each award row is resolved to its financial aid base record and, through it, to the student person. The documented reference notes list no additional referenced base objects, so reconstruction of dependent objects beyond these two tables should be verified against the specific patch level in use.

p>The view text also embeds two EBS metadata directives. The _LA token denotes lookup decoding, where a coded column is translated through a lookup view such as IGF_LOOKUPS_VIEW using lookup types including IGF_AP_YES_NO and IGF_AWARD_STATUS to return the MEANING. The _DF token denotes descriptive flexfield context, here _DF:IGF:IGF_AW_AWARD_ALL_FLEX:AWD, which signals that the award flexfield is available for inclusion in queries.

Key Columns

• AWARD_ID — Primary identifier for the award row.
• OFFERED_AMOUNT, ACCEPTED_AMOUNT, PAID_AMOUNT — Financial measures of the award at offered, accepted, and disbursed stages.
• PACKAGING_TYPE — Classification of how the award was packaged.
• "_LA:MANUAL_UPDATE_FLAG" — Decoded yes/no indicator reflecting whether the award was manually updated.
• AWARD_CREATION_DATE — Date the award was created.
• "_LA:AWARD_STATUS" — Decoded award status, resolved through IGF_AWARD_STATUS.
• ALTERNATE_PELL_SCHEDULE — Alternate Pell schedule reference where applicable.
• "_LA:LEGACY_RECORD_FLAG" — Decoded yes/no indicator identifying legacy records.
• REVISION_REASON — Reason associated with the award revision, mapped from AWD.RVSN_ID; this is the column most directly relevant to revision auditing.
• AWARD_REFERENCE_NUMBER — External award reference, sourced from AWD.AWARD_NUMBER_TXT.
• BATCH_NUMBER — Batch identifier for the award.
• "_DF" — Descriptive flexfield context for the award.
• "_LA:PUBLISH_IN_SS_FLAG" — Decoded yes/no indicator controlling publication to self-service.
• FUND_ID, BASE_ID — Fund and base record references.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard audit columns.
• PERSON_ID — Student person identifier from the base record.

Common Use Cases and Queries

Typical usage includes award status reporting, disbursement reconciliation between offered, accepted, and paid amounts, and revision auditing. Because the view surfaces REVISION_REASON, it is well suited to tracing why an award changed. A representative query retrieving revision details for a student follows:

• SELECT awd.award_id, awd.award_reference_number, awd.revision_reason, awd."_LA:AWARD_STATUS" award_status, awd.offered_amount, awd.paid_amount FROM igfbv_student_awards awd WHERE awd.person_id = :p_person_id ORDER BY awd.award_creation_date DESC;
• Reconciliation query: SELECT person_id, SUM(offered_amount), SUM(accepted_amount), SUM(paid_amount) FROM igfbv_student_awards GROUP BY person_id;
• Revision audit query: SELECT award_id, revision_reason, last_updated_by, last_update_date FROM igfbv_student_awards WHERE revision_reason IS NOT NULL ORDER BY last_update_date;

Queries should reference the decoded alias columns using their exact quoted identifiers, since the lookup and flexfield columns are exposed under directive-based names rather than plain column labels.