Search Results fprg_id




Overview
Explore in AI Chat

Overview

The IGF_AW_FUND_PRG_ALL table is a core data object within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). Its primary function is to store the mapping between financial aid funds and the academic programs (specifically "Pays only Programs") for which those funds can be disbursed. This mapping is critical for enforcing institutional and regulatory rules that govern which types of aid can be applied to specific courses of study. The table supports the multi-org architecture of Oracle EBS, as indicated by the '_ALL' suffix and the presence of the ORG_ID column, allowing data to be partitioned by operating unit.

Key Information Stored

The table's structure is designed to manage the relationship between funds and programs with versioning and audit capabilities. The most critical columns include:

  • FPRG_ID: The system-generated, unique primary key identifier for each fund-program mapping record.
  • FUND_ID: A foreign key that references the master fund definition in IGF_AW_FUND_MAST_ALL, identifying the specific financial aid resource.
  • COURSE_CD: The identifier for the academic program or course code against which the fund is valid for disbursement.
  • VERSION_NUMBER: Works in conjunction with COURSE_CD to track different iterations or versions of the academic program, ensuring fund eligibility aligns with the correct program version.
  • ORG_ID: The organizational identifier that partitions the data by operating unit, a standard EBS multi-org feature.
  • Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): Provide essential audit trail information.

Common Use Cases and Queries

This table is central to processes that validate a student's aid eligibility against their enrolled program. A common operational use case is during the award packaging or disbursement process, where the system checks if a proposed fund allocation is permitted for the student's specific course of study. For reporting and troubleshooting, administrators often query this table to review or audit fund-program rules. A fundamental query to retrieve all mappings for a specific fund would be:

SELECT fprg.fprg_id, fprg.course_cd, fprg.version_number, fm.fund_code
FROM igf.igf_aw_fund_prg_all fprg,
     igf.igf_aw_fund_mast_all fm
WHERE fprg.fund_id = fm.fund_id
AND fm.fund_id = :p_fund_id
AND fprg.org_id = :p_org_id;

Another critical query involves identifying all funds eligible for a given program, which supports setup and configuration tasks.

Related Objects

The IGF_AW_FUND_PRG_ALL table has defined relationships with other key Financial Aid tables, primarily through foreign key constraints.

  • Primary Key: The table is uniquely identified by the IGF_AW_FUND_PRG_PK index on the FPRG_ID column.
  • Foreign Key (Outbound): The FUND_ID column is a foreign key that references the IGF_AW_FUND_MAST_ALL table. This links each program mapping record to its corresponding master fund definition, which contains details like fund code, description, and type.
  • Unique Constraint: The IGF_AW_FUND_PRG_U1 index enforces a unique combination of COURSE_CD, FUND_ID, ORG_ID, and VERSION_NUMBER, preventing duplicate fund-program mappings within an operating unit.