Search Results tot_spnsr_amount




Overview
Explore in AI Chat

Overview

The IGF.IGF_SP_STDNT_REL_ALL table is a core data repository within the Oracle E-Business Suite (EBS) Student Financials module, specifically for Release 12.1.1 and 12.2.2. It functions as the master table for managing sponsor-student relationships. Its primary role is to store the detailed contractual and eligibility parameters that govern how a sponsor's funds are allocated and disbursed to individual students. This table is central to the sponsored student functionality, enabling institutions to track external funding commitments, such as those from employers or government agencies, against specific student enrollments and academic terms. The inclusion of the '_ALL' suffix and the ORG_ID column indicates it is a multi-organization enabled table, capable of storing data partitioned by operating unit.

Key Information Stored

The table's columns can be categorized into key functional areas. The primary relationship is defined by the FUND_ID (the sponsor's fund) and BASE_ID (the student's award year record), which together form a unique constraint. Critical disbursement and eligibility rules are captured in several columns: TOT_SPNSR_AMOUNT defines the total award, while MIN_CREDIT_POINTS and MIN_ATTENDANCE_TYPE establish the minimum academic load and enrollment status a student must maintain to remain eligible for disbursement. The latter is the specific field referenced in the user's search. The link to a specific academic period is established through LD_CAL_TYPE and LD_SEQUENCE_NUMBER. Standard technical columns (CREATED_BY, LAST_UPDATE_DATE, ORG_ID) provide audit trails and multi-org context. The table is indexed for performance on its key identifiers (SPNSR_STDNT_ID, and a composite key on FUND_ID, BASE_ID, LD_CAL_TYPE, LD_SEQUENCE_NUMBER).

Common Use Cases and Queries

A primary use case is validating a student's eligibility for a sponsor payment run. A batch process would query this table to check if a student meets the defined MIN_CREDIT_POINTS and MIN_ATTENDANCE_TYPE thresholds for their enrolled term before generating a disbursement. Another common scenario is reporting on total sponsor commitments by fund or student. Sample queries include retrieving all eligibility rules for a specific fund or student. For instance, to find the minimum attendance requirement for a student (PERSON_ID = 1000) under a specific fund (FUND_ID = 500), one would use:

  • SELECT MIN_ATTENDANCE_TYPE FROM igf.igf_sp_stdnt_rel_all WHERE person_id = 1000 AND fund_id = 500;

Reporting often involves joins to person (PER_ALL_PEOPLE_F), fund (IGF_SP_FUNDS), and calendar tables to produce human-readable summaries of sponsor obligations and student eligibility statuses.

Related Objects

While the provided dependency information is limited, based on standard EBS design patterns, this table is intrinsically linked to several key objects. It likely has a foreign key relationship to IGF_SP_FUNDS (via FUND_ID) to access sponsor fund details and to IGF_AW_BASE (via BASE_ID) for the student's base financial aid record. The PERSON_ID column typically relates to PER_ALL_PEOPLE_F. The LD_CAL_TYPE and LD_SEQUENCE_NUMBER columns reference term calendars, likely in tables like IGS_CA_INST. The table is also the probable base for key views within the Student Financials module, which present a simplified or combined interface for forms and reports. Data is typically created and maintained via Oracle Forms in the Sponsor Student Relations functional area.