Results for “igf_aw_award_v”

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

Overview

IGF_AW_AWARD_V is a reporting view within the Oracle E-Business Suite Financial Aid module (IGF), a product line that is documented as obsolete in the ETRM 12.2.2 repository. The view presents award-level financial aid data, consolidating attributes drawn from the award record, the fund master definition, the fund type and category setup, the academic calendar, and the student person record. Its stated purpose is simply to "show award details," which makes it a denormalized read model intended for inquiry screens, concurrent reports, and downstream extracts rather than for transactional processing.

Because the view is flagged as obsolete and listed as "Not implemented in this database" in the documented environment, it should be treated primarily as a historical artifact. Institutions running older financial aid implementations may still encounter it in legacy customizations, but it is not part of a supported, shipping feature set in 12.1.1 or 12.2.2.

Underlying Base Objects

The ETRM metadata does not document a definitive list of referenced base objects; the "Referenced base objects" field is empty. The view text, however, clearly joins several physical tables through their table aliases. These include AWD (the award table carrying ROW_ID and AWARD_ID), FMAST (fund master, supplying CI.CI_CAL_TYPE, CI.CI_SEQUENCE_NUMBER, FUND_CODE, and DESCRIPTION), FTYPE (fund type), FCAT (fund category, supplying FED_FUND_CODE, SYS_FUND_TYPE, and FUND_SOURCE), CI (the calendar instance resolved through FMAST), FACON (the award person/context table providing PERSON_ID), and PE (the person party entity for name and party number). It also dereferences RVSN for the revision description and PIT for the API person identifier. The student identifier (SSN, FULL_NAME, PERSON_NUMBER) therefore derives from the person model rather than from the award table itself.

Key Columns

The most frequently cited column in the context of this view is PACKAGING_TYPE, which records how a particular award was packaged relative to the student's overall aid package. Supporting columns include:

• AWD identifiers: ROW_ID, AWARD_ID, BASE_ID, and BATCH_ID, which link the award to its originating batch run and base award record.
• Amounts: OFFERED_AMT, ACCEPTED_AMT, and PAID_AMT, providing the full lifecycle of the award value.
• Status: AWARD_STATUS and its decoded form AWARD_STATUS_DESC, produced by IGF_AW_GEN.LOOKUP_DESC against the IGF_AWARD_STATUS lookup.
• Fund context: FUND_ID, FUND_CODE, FUND_TYPE, FED_FUND_CODE, SYS_FUND_TYPE, and FUND_SOURCE.
• Calendar: CI_CAL_TYPE, CI_SEQUENCE_NUMBER, CI_ALTERNATE_CODE, CI_START_DT, and CI_END_DT.
• Student: STUDENT_ID, PERSON_ID, PERSON_NUMBER, SSN, and FULL_NAME (concatenated last name and first name).
• Audit: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.
• Descriptive flexfields: ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE20.

Common Use Cases and Queries

Reporting use cases center on award tracking, packaging analysis, and student-level disbursement summaries. A typical query filters awards by packaging type and academic period:

• SELECT award_id, student_id, full_name, fund_code, packaging_type, offered_amt, accepted_amt, paid_amt FROM igf_aw_award_v WHERE packaging_type = :packaging_type AND ci_cal_type = :cal_type AND ci_sequence_number = :seq_num;
• SELECT award_status_desc, COUNT(*), SUM(offered_amt) FROM igf_aw_award_v GROUP BY award_status_desc;
• SELECT fund_code, fund_source, SUM(paid_amt) FROM igf_aw_award_v GROUP BY fund_code, fund_source;

Given the obsolete status of IGF and the absence of documented base objects, any query against this view should be validated against the actual database before being relied upon in production reporting.