Search Results igf_aw_fseog_match




Overview
Explore in AI Chat

Overview

The IGF_AW_FSEOG_MATCH view is a Financial Aid (IGF) reporting and integration object owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. As documented in the ETRM repository, its purpose is to retrieve the Matching Fund and its Match Order for specific Award Years. This places the view within the Federal Supplemental Educational Opportunity Grant (FSEOG) processing area of Oracle Financial Aid, where institutions must demonstrate that a defined proportion of FSEOG funds is matched by institutional or other eligible contributions. The view exposes the ordered relationship between an award year and the funds designated to satisfy that matching requirement, allowing downstream reports, validation logic, and integrations to determine which fund applies at each position in the match sequence. Because it is a view rather than a base table, it does not store data; it presents a filtered, organization-secured projection of the underlying match definition data maintained in the Financial Aid setup tables.

Underlying Base Objects

The view is defined over a single documented base object, IGF_AW_FSEOG_MATCH_ALL, which is the multi-organization (partitioned by operating unit) table holding FSEOG matching fund definitions. The "_ALL" suffix indicates that the base table stores rows across all operating units, with the ORG_ID column distinguishing the owning organization. The view applies an organization security predicate that compares the row's ORG_ID against the client information passed through the USERENV('CLIENT_INFO') session context, using the standard Oracle multi-org convention of decoding the first ten characters of the client info string. The NVL wrapping around both sides of the comparison permits rows with a null ORG_ID to be treated as belonging to the default (-99) organization context. The ETRM documentation records no additional referenced base objects, so all columns exposed by the view derive directly from IGF_AW_FSEOG_MATCH_ALL.

Key Columns

  • ROW_ID / ROWID — The physical row identifier of the underlying base table row, usable for direct row access and locking.
  • FUND_ID — Identifier of the matching fund defined for the FSEOG match requirement. Joins to the fund definition tables to resolve fund codes and descriptions.
  • MATCH_ORDER — The ordinal position of the fund within the match sequence, determining the order in which matching contributions are applied. This is the column most directly associated with the "match_order" search term.
  • CI_CAL_TYPE / CI_SEQUENCE_NUMBER — The calendar type and sequence number identifying the award year (academic calendar instance) to which the match definition applies.
  • ORG_ID — The operating unit that owns the match definition; drives the multi-org security filter described above.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns recording creation and last modification metadata.

Common Use Cases and Queries

Typical usage involves listing the matching funds for an award year in application order, or resolving the fund to use at a given match position. Because the view enforces organization security through CLIENT_INFO, queries executed from a multi-org session automatically return only the current operating unit's rows; in a reporting context, the client info must be set appropriately or the query run against IGF_AW_FSEOG_MATCH_ALL directly.

Retrieve all matching funds for a specific award year, ordered by match sequence:

  • SELECT fund_id, match_order, ci_cal_type, ci_sequence_number, org_id
  • FROM igf_aw_fseog_match
  • WHERE ci_cal_type = :p_cal_type
  • AND ci_sequence_number = :p_seq_number
  • ORDER BY match_order;

Determine the first fund in the match order for the current organization:

  • SELECT fund_id
  • FROM igf_aw_fseog_match
  • WHERE ci_cal_type = :p_cal_type
  • AND ci_sequence_number = :p_seq_number
  • AND match_order = 1;

These patterns support FSEOG disbursement validation, award-year setup verification, and integration extracts that must communicate the ordered match fund set to external financial aid systems.