Search Results fee_cls_id




Overview
Explore in AI Chat

Overview

The IGF.IGF_SP_PRG_ALL table is a core data structure within the Oracle E-Business Suite (EBS) Student Financials module, specifically for versions 12.1.1 and 12.2.2. It is designed to manage "Sponsor Pays" or "Pays Only" program details associated with specific tuition fee classes. This table's primary function is to define the financial parameters under which a sponsor (e.g., an employer or government agency) agrees to pay for a student's tuition for a particular academic program. It acts as a junction table, linking a fee class designated for sponsor payment (FEE_CLS_ID) to a specific academic program (COURSE_CD and VERSION_NUMBER) and detailing the sponsor's financial commitment for that program.

Key Information Stored

The table stores the relationship and financial rules between sponsor fee classes and academic programs. Key columns include:

  • FEE_CLS_PRG_ID: The primary key, a unique sequence-generated identifier.
  • FEE_CLS_ID: A mandatory foreign key linking to the unique identifier of a "pays only" fee class. This is a critical column for queries filtering by sponsor fee class.
  • COURSE_CD and VERSION_NUMBER: Together, these identify the specific academic program (course) to which the sponsor agreement applies.
  • FEE_PERCENT: Defines the percentage of the program's tuition charges the sponsor will pay.
  • MAX_AMOUNT: Specifies the maximum monetary amount the sponsor will pay for the program, providing a cap on the financial liability.
  • ORG_ID: Supports the Multi-Org architecture, segregating data by operating unit.
The table also includes standard WHO columns (CREATED_BY, CREATION_DATE, etc.) for auditing.

Common Use Cases and Queries

This table is central to configuring and reporting on sponsor-funded tuition agreements. A common operational use case is defining or modifying the terms of a sponsor's payment plan for a specific degree program. For reporting, it is used to analyze sponsor liabilities and generate billing data. A typical query to retrieve all sponsor program details for a specific fee class, as indicated by the user's search for "fee_cls_id", would be: 

SELECT COURSE_CD,
       VERSION_NUMBER,
       FEE_PERCENT,
       MAX_AMOUNT
FROM IGF.IGF_SP_PRG_ALL
WHERE FEE_CLS_ID = :p_fee_cls_id
AND ORG_ID = :p_org_id;
Another frequent pattern involves joining with course and fee class tables to produce a comprehensive sponsor agreement report, listing all programs covered under various sponsor fee classes along with their respective payment terms.

Related Objects

Based on the provided metadata, the IGF.IGF_SP_PRG_ALL table has explicit dependencies through its unique indexes. The IGF_SP_PRG_ALL_U1 index enforces uniqueness on the primary key (FEE_CLS_PRG_ID), while the IGF_SP_PRG_ALL_U2 index ensures that the combination of FEE_CLS_ID, COURSE_CD, and VERSION_NUMBER is unique, preventing duplicate program assignments for a sponsor fee class. The table is referenced by the APPS synonym IGF_SP_PRG_ALL, which is the standard access point for all application code and queries within EBS. While the documentation excerpt states it does not reference other objects, it is logically related to the base tables for Fee Classes (likely IGF_FEE_CLASS) and Academic Programs (likely IGS_PS_COURSE_VER).