Search Results igf_ap_fund_outcm_pk

Overview

The table IGF_AP_FUND_OUTCM is a core data object within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). It functions as a junction or mapping table, establishing a critical relationship between financial aid funds and specific Satisfactory Academic Progress (SAP) outcomes. Its primary role is to define which SAP outcome codes are applicable to a given fund, thereby linking the fund's eligibility and disbursement rules to the student's academic standing. This table is essential for enforcing regulatory and institutional policies where the availability or continuation of a specific type of financial aid is contingent upon the student meeting defined academic progress standards.

Key Information Stored

The table's structure is defined by a composite primary key, meaning each unique record is identified by the combination of two columns. The key columns and their significance are:

• FUND_ID: A foreign key column that uniquely identifies a financial aid fund from its master definition table. This links the SAP outcome rule to a specific source of aid.
• OUTCOME_NAME: A foreign key column that stores a code representing a specific SAP outcome or status (e.g., 'WARNING', 'SUSPENSION', 'PROBATION'). This references the master list of valid outcomes defined in the IGF_AP_SAP_OUTCM table.

Common Use Cases and Queries

A primary use case is during the packaging or disbursement process, where the system validates a student's SAP status against the outcomes permitted for each fund in their award package. For instance, a fund may be restricted to students with an outcome of 'SATISFACTORY' and cannot be awarded if the student is in 'SUSPENSION' status. Common queries involve listing all SAP outcomes applicable to a specific fund for setup or audit purposes, or identifying all funds that are restricted by a particular SAP outcome. A typical reporting query would join this table to the fund master and SAP outcome description tables.

SELECT f.fund_code, o.outcome_name, o.description
FROM igf_ap_fund_outcm fo,
     igf_aw_fund_mst f,
     igf_ap_sap_outcm o
WHERE fo.fund_id = f.fund_id
  AND fo.outcome_name = o.outcome_name
ORDER BY f.fund_code;

Related Objects

Based on the provided ETRM metadata, IGF_AP_FUND_OUTCM has the following documented key relationships:

• Primary Key: IGF_AP_FUND_OUTCM_PK on (FUND_ID, OUTCOME_NAME).
• Foreign Keys (Referenced By):
  • Table IGF_AP_FUND_OTCM_EF references this table via its columns (FUND_ID, OUTCOME_NAME). This suggests an extension or additional effective-dated rules related to the fund-outcome mapping.
• Foreign Keys (References):
  • Column FUND_ID references a fund master table (the specific table name is obscured in the metadata as '%').
  • Column OUTCOME_NAME references the primary key of table IGF_AP_SAP_OUTCM, which holds the master list of SAP outcome codes and descriptions.