Search Results igf_sp_prg_all




Overview
Explore in AI Chat

Overview

The IGF_SP_PRG_ALL table is a core data repository within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). It is specifically designed to manage the program-level details associated with "sponsor pays only" tuition fee classes. In the context of financial aid, a sponsor pays arrangement involves a third-party organization (the sponsor) committing to pay tuition fees directly to the institution for a student. This table defines which academic programs (courses) are linked to a specific sponsor pays fee class, thereby establishing the scope of the sponsor's financial responsibility. Its role is critical for accurately tracking, billing, and reporting on sponsor-funded tuition obligations across different academic offerings within the institution.

Key Information Stored

The table's structure centers on linking a fee class to specific academic programs. The primary identifier is the FEE_CLS_PRG_ID column, which serves as the unique surrogate key. The logical uniqueness of a record is enforced by a separate unique key constraint on the combination of FEE_CLS_ID, COURSE_CD, and VERSION_NUMBER. This combination ensures that a given academic program (identified by its code and version) can be associated with a particular sponsor pays fee class only once. Therefore, the key columns store:

  • FEE_CLS_ID: Foreign key linking to the parent sponsor pays fee class definition in the IGF_SP_FC_ALL table.
  • COURSE_CD: The code identifying the academic course or program.
  • VERSION_NUMBER: The version of the specified academic course or program.

Common Use Cases and Queries

This table is primarily used in setups and operational reporting for sponsor billing. A common administrative task is to query all programs covered under a specific sponsor agreement to verify setup completeness or generate an invoice summary. For example, to list all programs for a given fee class ID:

SELECT course_cd, version_number
FROM igf.igf_sp_prg_all
WHERE fee_cls_id = <fee_class_id>
ORDER BY course_cd;

Conversely, to identify which sponsor pays fee class governs a particular academic program for a student, a join with the student's enrollment data would be necessary. The table is also essential for validation during the financial aid packaging process, ensuring charges are correctly allocated to the sponsor based on the student's enrolled program.

Related Objects

The IGF_SP_PRG_ALL table sits at the center of a key relationship hierarchy within the sponsor pays functionality. It has a direct foreign key dependency on the IGF_SP_FC_ALL table, which holds the master definition of the sponsor pays fee class (e.g., sponsor details, terms). Furthermore, it is a parent table to IGF_SP_UNIT_ALL, which holds more granular unit (subject) level details for the associated programs. This relationship indicates that a program record in IGF_SP_PRG_ALL can have multiple specific unit records defined under it, allowing for detailed breakdowns of sponsor-covered fees. These relationships are critical for any data integrity checks or cascading operations within the sponsor pays setup.

  • Table: IGF_SP_PRG_ALL 12.1.1

    owner:IGF,  object_type:TABLE,  fnd_design_data:IGF.IGF_SP_PRG_ALL,  object_name:IGF_SP_PRG_ALL,  status:VALID,  product: IGF - Financial Aid ,  description: Holds sponsor pays only program details for a pays only tuition fee class ,  implementation_dba_data: IGF.IGF_SP_PRG_ALL , 

  • View: IGF_SP_PRG 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGF.IGF_SP_PRG,  object_name:IGF_SP_PRG,  status:VALID,  product: IGF - Financial Aid ,  description: MO view based on IGF_SP_PRG_ALL table. ,  implementation_dba_data: APPS.IGF_SP_PRG , 

  • Table: IGF_SP_FC_ALL 12.1.1

    owner:IGF,  object_type:TABLE,  fnd_design_data:IGF.IGF_SP_FC_ALL,  object_name:IGF_SP_FC_ALL,  status:VALID,  product: IGF - Financial Aid ,  description: Holds pays only fee class details for a sponsor fund ,  implementation_dba_data: IGF.IGF_SP_FC_ALL , 

  • Table: IGF_SP_UNIT_ALL 12.1.1

    owner:IGF,  object_type:TABLE,  fnd_design_data:IGF.IGF_SP_UNIT_ALL,  object_name:IGF_SP_UNIT_ALL,  status:VALID,  product: IGF - Financial Aid ,  description: Holds pays only unit details for a pays only program ,  implementation_dba_data: IGF.IGF_SP_UNIT_ALL ,