Search Results igs_fi_fnd_src_rstn

Overview

The IGS_FI_FND_SRC_RSTN table is a core data entity within the Oracle E-Business Suite Student System (IGS) module. It functions as a configuration and validation table that defines the permissible funding sources for a specific academic course. Its primary role is to establish a controlled relationship between a course offering and the financial funding mechanisms that can be applied to it, such as government grants, scholarships, or institutional funds. By maintaining these rules, the table ensures that financial transactions and student fee assessments are associated with valid and authorized funding sources for that course. The ability to designate a default funding source at this level streamlines administrative processes for enrollment and billing.

Key Information Stored

The table's structure centers on the unique combination of a course and a funding source. The primary key consists of three columns: COURSE_CD, which holds the code identifying the academic course; VERSION_NUMBER, which specifies the particular version or iteration of that course; and FUNDING_SOURCE, which stores the code for the applicable financial source. This design enforces that a given course version can have multiple valid funding sources defined, but each source is recorded only once per course version. Additional attributes, implied by its functional description, likely include flags or columns to indicate the default funding source for the course and audit information such as creation date and last update details.

Common Use Cases and Queries

A primary use case is validating a funding source during student enrollment or financial aid packaging. The system can check if a proposed source is valid for the student's enrolled course. Another common scenario is generating reports on funding availability across the curriculum. Administrators may run queries to list all courses eligible for a specific grant or to identify courses lacking a defined default funding source. Sample SQL patterns include retrieving all valid funding sources for a course or finding the default source.

• SELECT funding_source FROM igs_fi_fnd_src_rstn WHERE course_cd = :1 AND version_number = :2;
• SELECT c.course_cd, c.version_number, r.funding_source FROM igs_ps_ver_all c LEFT JOIN igs_fi_fnd_src_rstn r ON c.course_cd = r.course_cd AND c.version_number = r.version_number WHERE r.funding_source IS NULL;

Related Objects

The IGS_FI_FND_SRC_RSTN table maintains critical foreign key relationships with master tables in the system, ensuring referential integrity. It is directly dependent on the Course Version and Funding Source master definitions.

• IGS_PS_VER_ALL: This table stores the master definition of all course versions. The foreign key relationship ensures that a funding source restriction can only be created for a valid, existing course. The join is performed on the composite key (COURSE_CD, VERSION_NUMBER).
• IGS_FI_FUND_SRC_ALL: This table is the master repository for all funding source codes and descriptions. The foreign key on the FUNDING_SOURCE column guarantees that any source referenced in a restriction is defined in the system's financial setup.