Search Results fund_source_id




Overview
Explore in AI Chat

Overview

The IGS_PE_FUND_SOURCE table is a core data repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Oracle's legacy Higher Education product) module. It functions as the master table for storing detailed funding source information associated with a person, typically a student. Its primary role is to maintain a comprehensive record of financial sponsorships, scholarships, or other external funding that supports an individual within the academic institution. This data is critical for financial aid management, student billing, compliance reporting, and understanding a student's financial profile.

Key Information Stored

The table's structure captures essential attributes of a funding source. The primary key, FUND_SOURCE_ID, provides a unique identifier for each record. The PERSON_ID column links the funding source to a specific individual within the system. Key descriptive columns include FUND_SOURCE_CODE, which classifies the type of funding (e.g., scholarship, grant, employer), and NAME, which holds the source's name. The AMOUNT column stores the monetary value, and RELATIONSHIP_CODE defines the association between the person and the funding entity. A critical column for compliance and verification is DOCUMENT_IND, a flag (Y/N) indicating whether supporting documentation for the funding has been received. The NOTES column allows for additional comments, and standard WHO columns (CREATED_BY, CREATION_DATE, etc.) track audit information.

Common Use Cases and Queries

This table is central to operations involving student financial support. Common use cases include generating reports on students with external funding, verifying documentation completion for audit purposes, and calculating net tuition liabilities after accounting for external sponsorships. A frequent query involves identifying students with undocumented funding sources, leveraging the DOCUMENT_IND column. For example:

  • Document Verification Report: SELECT person_id, name, fund_source_code, amount FROM igs.igs_pe_fund_source WHERE document_ind = 'N';
  • Funding Summary by Person: SELECT person_id, SUM(amount) total_funding FROM igs.igs_pe_fund_source GROUP BY person_id;
  • Retrieving All Data for a Specific Person: The standard query provided in the ETRM metadata serves as the foundational SELECT statement for most integrations or data extracts related to a person's funding.

Related Objects

Based on the provided dependency information, the IGS_PE_FUND_SOURCE table is referenced by an object named IGS_PE_FUND_SOURCE within the APPS schema. This is most likely a public synonym or a view that provides a non-owner access point to the underlying IGS table, a standard EBS architecture practice. The table itself does not reference other objects. The presence of a unique index (IGS_PE_FUND_SOURCE_U1) on FUND_SOURCE_ID and a non-unique index (IGS_PE_FUND_SOURCE_N1) on PERSON_ID indicates the primary key structure and a common access path for queries filtering by person, respectively. The PERSON_ID column typically serves as a foreign key to a core person or party table, though this specific relationship is not detailed in the provided excerpt.