Search Results igf_aw_fund_unit_u1




Overview
Explore in AI Chat

Overview

The IGF_AW_FUND_UNIT_ALL table is a core data object within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). Its primary function is to define the specific academic units (courses or modules) against which a particular financial aid fund can be disbursed. This table enforces a critical business rule: to receive an award from a fund, a student must be enrolled in the associated unit. The table is multi-org enabled, as indicated by the '_ALL' suffix and the presence of the ORG_ID column, allowing it to store data for multiple operating units within a single installation. It serves as a fundamental link between the definition of financial aid funds and the academic structure.

Key Information Stored

The table's structure is designed to map funds to academic units uniquely within an operating unit. The key columns are:

  • FUNIT_ID: The system-generated primary key (sequence) uniquely identifying each record.
  • FUND_ID: References the specific financial aid fund (IGF_AW_FUND_MAST_ALL.FUND_ID) for which the unit requirement is defined.
  • UNIT_CD: The code representing the academic unit or course into which a student must enroll.
  • VERSION_NUMBER: Tracks the version of the associated unit code, accommodating changes over time.
  • ORG_ID: The operating unit identifier, segregating data by business entity.
  • Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): Audit columns tracking the creation and modification history of each record.
The unique constraint IGF_AW_FUND_UNIT_U2 on (FUND_ID, ORG_ID, UNIT_CD, VERSION_NUMBER) ensures that a fund cannot be linked to the same unit version more than once within an operating unit.

Common Use Cases and Queries

This table is central to eligibility validation and award packaging processes. A common use case is determining all permissible disbursement units for a given fund to validate student course enrollment during packaging. For reporting, administrators may query which funds are restricted to specific units. A typical query to retrieve the fund-to-unit mapping for a specific operating unit would be: SELECT f.fund_code, fu.unit_cd, fu.version_number
FROM igf_aw_fund_mast_all f,
igf_aw_fund_unit_all fu
WHERE f.fund_id = fu.fund_id
AND f.org_id = fu.org_id
AND fu.org_id = :p_org_id
ORDER BY f.fund_code; Another critical pattern involves checking a student's enrolled units against this table to confirm eligibility for a packaged award, often performed within the core financial aid packaging engine.

Related Objects

The table maintains defined relationships with other key Financial Aid tables, primarily through foreign key constraints:

  • Primary Key: The table's primary key is IGF_AW_FUND_UNIT_PK on the column FUNIT_ID.
  • Foreign Key (Outbound): The FUND_ID column references the FUND_ID in the IGF_AW_FUND_MAST_ALL table. This links the unit requirement back to the master definition of the financial aid fund.
  • Indexes: Two unique indexes support data integrity and performance: IGF_AW_FUND_UNIT_U1 (on FUNIT_ID) and IGF_AW_FUND_UNIT_U2 (on FUND_ID, ORG_ID, UNIT_CD, VERSION_NUMBER).
While the provided dependency information states no objects reference this table, in practice, it is logically referenced by award calculation and disbursement logic within the IGF module's packages and views that determine student eligibility based on enrolled units.