Search Results igs_fi_fund_src_all




Overview
Explore in AI Chat

Overview

The table IGS_FI_FUND_SRC_ALL is a core data entity within the Oracle E-Business Suite Student System (IGS), specifically in the Financials module. It serves as the master repository for defining and managing all institutional funding sources. A funding source represents the origin of financial resources, such as government grants, private scholarships, institutional funds, or student loans, which are used to support student fees, charges, and other financial transactions. As an "ALL" table, it is designed to support multi-organization architecture (MOAC), storing data partitioned by the operating unit. Notably, the provided ETRM metadata indicates the Student System product is marked as "Obsolete," and the specific implementation note states "Not implemented in this database," suggesting this table may be part of a legacy or discontinued installation path.

Key Information Stored

While the provided metadata does not list specific columns beyond key fields, the table's primary purpose is to define the valid set of funding sources for a university. The primary key column is FUNDING_SOURCE, which uniquely identifies each source code. Based on standard EBS design patterns for "ALL" tables and the foreign key relationships, it is highly probable the table contains standard descriptive columns such as a name (e.g., FUNDING_SOURCE_NAME), an effective start and end date for validity, and attributes to control active status and usage. A critical foreign key column present is GOVT_FUNDING_SOURCE, which links to the IGS_FI_GOVT_FUND_SRC table, allowing for the classification of a funding source with specific government funding details and regulations.

Common Use Cases and Queries

The primary use case for this table is as a validation and reference source for financial transactions and student enrollment records. It ensures that any funding source applied to a student's application, program attempt, or fee assessment is defined and authorized within the system. Common reporting and operational queries would involve listing all active funding sources or tracing the usage of a specific source across student records. A typical query to retrieve active funding sources for a specific operating unit would follow this pattern:

  • SELECT funding_source, funding_source_name
  • FROM igs_fi_fund_src_all
  • WHERE sysdate BETWEEN start_date_active AND NVL(end_date_active, sysdate+1)
  • AND org_id = :p_org_id;

Another critical query would join to related transactional tables, such as IGS_EN_STDNT_PS_ATT_ALL, to analyze student enrollment by their primary funding source.

Related Objects

The IGS_FI_FUND_SRC_ALL table is a central reference point, as evidenced by its numerous foreign key relationships. Key related objects include:

  • IGS_FI_GOVT_FUND_SRC: Provides detailed government-specific attributes for a funding source (via GOVT_FUNDING_SOURCE).
  • IGS_EN_STDNT_PS_ATT_ALL: Links a student's program attempt to a primary funding source (via FUNDING_SOURCE).
  • IGS_AD_PS_APPL_INST_ALL: Stores the proposed funding source for a student's program application.
  • IGS_FI_FD_SRC_RSTN_H_ALL & IGS_FI_FND_SRC_RSTN: Track history and rules for restrictions placed on funding sources.
  • IGS_HE_POOUS_ALL: Relates funding sources to specific programs and organizational units.
  • Admissions Sub-Module Tables (IGS_AD_SBMAO_FN_AMTT, IGS_AD_SBMAO_FN_CTTT, etc.): Multiple tables in the admissions framework reference this table to manage funding amounts, country ties, unit of study links, and target figures.