Search Results igs_fi_govt_fund_src

Overview

The IGS_FI_GOVT_FUND_SRC table is a core reference entity within the Oracle E-Business Suite Student System (IGS). It functions as a master repository for government-defined funding sources. Its primary role is to establish and maintain a standardized, controlled list of funding classifications, such as specific grants, subsidies, or loan programs, as mandated by governmental education or financial authorities. This table ensures data integrity and consistency across the financial modules of the Student System by providing a singular source of valid codes for government-related funding. It is a critical component for institutions that must track, report, and reconcile student financial data against official government funding schemes in releases 12.1.1 and 12.2.2.

Key Information Stored

While the provided metadata does not list all columns, the structure centers on the primary key, which is the definitive identifier for a government funding source. The most critical field is GOVT_FUNDING_SOURCE, which serves as the unique code for each funding source. This column is the table's primary key (IGS_FI_GOVT_FUND_SRC_PK). Based on standard practice for such reference tables, it likely includes descriptive columns such as a name or description field (e.g., DESCRIPTION), effective dates (START_DATE, END_DATE), and potentially attributes for enabling or disabling the code. The table's purpose is to store the discrete set of valid values that can be assigned to transactions and student financial records to denote their government funding origin.

Common Use Cases and Queries

This table is primarily used for validation, reporting, and setup. Administrators use it to maintain the list of active government funding sources available for assignment during fee assessment or financial aid processing. Common operational scenarios include generating reports to analyze revenue by government funding source, validating data imports, and ensuring compliance with funding rules. A typical query would join this table to transactional data to produce a readable report.

Sample Query Pattern:
SELECT gfs.govt_funding_source,
gfs.description,
COUNT(fsa.fund_source_id) AS transaction_count
FROM igs.igs_fi_govt_fund_src gfs,
igs.igs_fi_fund_src_all fsa
WHERE gfs.govt_funding_source = fsa.govt_funding_source(+)
AND gfs.end_date IS NULL -- Get active sources
GROUP BY gfs.govt_funding_source, gfs.description
ORDER BY 1;

Related Objects

The IGS_FI_GOVT_FUND_SRC table has a direct parent-child relationship with the primary funding source table, as documented in the provided foreign key metadata. The key related object is:

• IGS_FI_FUND_SRC_ALL: This is the main transactional table for funding sources. It contains a foreign key column, GOVT_FUNDING_SOURCE, which references IGS_FI_GOVT_FUND_SRC.GOVT_FUNDING_SOURCE. This relationship enforces that any government funding source code used in a general funding source record must already be defined in the government funding source master table.

This relationship is fundamental, meaning IGS_FI_GOVT_FUND_SRC acts as a validated lookup for the broader IGS_FI_FUND_SRC_ALL entity within the financial architecture.