Search Results igs_fi_fnd_src_rstn




Overview
Explore in AI Chat

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.
  • Table: IGS_FI_FND_SRC_RSTN 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_FND_SRC_RSTN,  object_name:IGS_FI_FND_SRC_RSTN,  status:VALID,  product: IGS - Student System ,  description: This entity describes the funding sources which are available for a course. A default can be specified in this entity. ,  implementation_dba_data: IGS.IGS_FI_FND_SRC_RSTN , 

  • View: IGS_FI_FD_SRC_RSTN_H_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_FI_FD_SRC_RSTN_H_V,  object_name:IGS_FI_FD_SRC_RSTN_H_V,  status:VALID,  product: IGS - Student System ,  description: This view is used to merge funding source restriction history with the current funding source restriction details enabling all details to be accessed over time, up till the current day. Each entry represents all column values over defined t ,  implementation_dba_data: APPS.IGS_FI_FD_SRC_RSTN_H_V , 

  • Table: IGS_FI_FUND_SRC_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_FUND_SRC_ALL,  object_name:IGS_FI_FUND_SRC_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes the university set of funding sources. ,  implementation_dba_data: IGS.IGS_FI_FUND_SRC_ALL , 

  • Table: IGS_PS_VER_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_VER_ALL,  object_name:IGS_PS_VER_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes the versions of programs which are offered by the university, covering both award and non-award programs. ,  implementation_dba_data: IGS.IGS_PS_VER_ALL ,