Results for “fund_source_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The IGS_PE_FUND_SOURCE table resides in the IGS schema and belongs to the Oracle E-Business Suite IGS – Student System product family, delivered under the ETRM 12.1.1 physical schema and carried forward into 12.2.2. It stores details of a person's funding source information — the financial sponsors, agencies, employers, or government bodies that underwrite a student's tuition, fees, or related charges. Each row associates a funding source record with a party held in the Trading Community Architecture (TCA) via PERSON_ID, allowing Student System transactions such as billing, receivables, and financial aid disbursement to attribute balances to the correct sponsor.
From a Data Vault modeling perspective, the heuristic classification of this table is satellite-leaning. This suggests the table behaves primarily as a descriptive satellite keyed to a hub or link (the person/party), rather than as an independent hub of its own. Analysts designing a warehouse layer may treat FUND_SOURCE_ID as the driving surrogate while resolving PERSON_ID to the party hub.
Key Information Stored
The documented schema exposes 13 columns. The most significant include:
FUND_SOURCE_ID— surrogate primary key, enforced by the IGS_PE_FUND_SOURCE_PK constraint and additionally backed by the unique index IGS_PE_FUND_SOURCE_U1. Because a unique index also exists on this column, it is documented as the business-key candidate as well as the technical key.PERSON_ID— foreign key toHZ_PARTIES, tying the funding source to a TCA party record. This is the principal integration point between IGS funding data and the shared party model.FUND_SOURCE_CODE— a coded identifier used for classification and lookup of the funding type.NAME— the descriptive name of the funding source sponsor or program.AMOUNT— the monetary value associated with the funding source, used in billing and aid calculations.RELATIONSHIP_CODE— captures how the funding source relates to the person (for example, employer or agency relationship).DOCUMENT_IND— a flag indicating document-related status for the funding arrangement.NOTES— free-text supplementary information recorded by administrative staff.CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN— standard Oracle EBS WHO-column audit attributes tracking row provenance and change history.
Common Use Cases and Queries
Typical reporting scenarios include identifying all funding sources tied to a student or party, aggregating sponsored amounts, and reconciling funding data against deliverable records. A representative join to the party model follows:
SELECT f.FUND_SOURCE_ID, f.NAME, f.AMOUNT, p.PARTY_NAME FROM IGS_PE_FUND_SOURCE f, HZ_PARTIES p WHERE f.PERSON_ID = p.PARTY_ID;- Filtering by
FUND_SOURCE_CODEto group sponsors by category. - Auditing recent changes using
LAST_UPDATE_DATEandLAST_UPDATED_BY.
Because the unique index mirrors the primary key column, lookups by FUND_SOURCE_ID are index-driven and efficient.
Related Objects
The following objects are most significant in the relationship graph:
- HZ_PARTIES — referenced through
IGS_PE_FUND_SOURCE.PERSON_ID, the only documented outward foreign key. - AMS_DELIVERABLES_ALL_B — references this table via
FUND_SOURCE_ID, linking funding sources to deliverable records in the marketing/advanced module. - The IGS_PE_FUND_SOURCE_PK constraint and IGS_PE_FUND_SOURCE_U1 unique index, which enforce key integrity.
Together these relationships position IGS_PE_FUND_SOURCE as a focal reference point connecting student funding to both the TCA party hub and downstream deliverable tracking.
-
Holds details of a person's funding source information
-
View: IGSFV_FUND_SOURCES 12.1.1
This entity contains information about a person's international or residency funding sources.
APPS.IGSFV_FUND_SOURCES·↳ HZ_PARTIES·↳ IGS_PE_FUND_SOURCE·Explore IGS module →
-
View: IGS_PE_FUND_SOURCE_V 12.1.1
Holds Person's Fund Source details
APPS.IGS_PE_FUND_SOURCE_V·↳ FND_LOOKUP_VALUES·↳ IGS_LOOKUPS_VIEW·↳ IGS_PE_FUND_SOURCE·Explore IGS module →
-
View: IGSBV_FUND_SOURCES 12.1.1
This entity contains information about a person's international or residency funding sources.
APPS.IGSBV_FUND_SOURCES·↳ IGS_PE_FUND_SOURCE·Explore IGS module →
-
View: ASO_I_CAMPAIGNS_V 12.1.1
View based on Campaigns
APPS.ASO_I_CAMPAIGNS_V·↳ AMS_P_CAMPAIGNS_V·Explore ASO module →
-
View: ASO_I_CAMPAIGNS_V 12.2.2
View based on Campaigns
APPS.ASO_I_CAMPAIGNS_V·↳ AMS_P_CAMPAIGNS_V·Explore ASO module →
-
View: AMS_EVENT_HEADERS_V 12.2.2
This view returns the general information about marketing events (headers).
APPS.AMS_EVENT_HEADERS_V·↳ AMS_EVENT_HEADERS_VL·↳ AMS_LOOKUPS·↳ AMS_USER_STATUSES_VL·Explore AMS module →
-
View: AST_LS_CAMPAIGNS_V 12.2.2
APPS.AST_LS_CAMPAIGNS_V·↳ AMS_ACT_OFFERS·↳ AMS_ACT_PRODUCTS·↳ AMS_CAMPAIGNS_ALL_B·Explore AST module →
-
Stores the definition of a Marketing Event. (Master Event or Event Template)
-
Stores information about an Event Offering. .This table also holds the data for all the Agenda Items for the Event Offerings.
-
View: AMS_EVENT_HEADERS_V 12.1.1
This view returns the general information about marketing events (headers).
APPS.AMS_EVENT_HEADERS_V·↳ AMS_EVENT_HEADERS_VL·↳ AMS_LOOKUPS·↳ AMS_USER_STATUSES_VL·Explore AMS module →
-
APPS.AMS_DELIVERABLES_INFO_V·↳ AMS_CATEGORIES_TL·↳ AMS_DELIVERABLES_VL·↳ AMS_JTF_RS_EMP_V·Explore AMS module →
-
Stores the definition of a Marketing Event. (Master Event or Event Template)
-
APPS.AST_CAMP_DELV_ASSOCIATIONS_V·↳ AMS_DELIVERABLES_VL·↳ AMS_OBJECT_ASSOCIATIONS·↳ AMS_SOURCE_CODES·Explore AST module →
-
Stores information about an Event Offering. .This table also holds the data for all the Agenda Items for the Event Offerings.
-
View: AMS_P_DELIVERABLES_V 12.2.2
This public view returns the marketing deliverable information.
APPS.AMS_P_DELIVERABLES_V·↳ AMS_CATEGORIES_TL·↳ AMS_DELIVERABLES_VL·↳ AMS_JTF_RS_EMP_V·Explore AMS module →
-
This table stores the details about marketing deliverables/collaterals, collaterals are uniquely identified by deliverable name, language and version.
-
View: AMS_DELIVERABLES_VL 12.1.1
This view returns the marketing deliverable information.
APPS.AMS_DELIVERABLES_VL·↳ AMS_DELIVERABLES_ALL_B·↳ AMS_DELIVERABLES_ALL_TL·Explore AMS module →
-
View: AMS_CAMPAIGNS_V 12.2.2
This view returns all marketing campaigns and related information.
APPS.AMS_CAMPAIGNS_V·↳ AMS_CAMPAIGNS_ALL_TL·↳ AMS_CAMPAIGNS_VL·↳ AMS_USER_STATUSES_VL·Explore AMS module →
-
View: AMS_EVENT_HEADERS_VL 12.2.2
This view returns the general information about marketing events (headers).
APPS.AMS_EVENT_HEADERS_VL·↳ AMS_EVENT_HEADERS_ALL_B·↳ AMS_EVENT_HEADERS_ALL_TL·Explore AMS module →
-
View: AMS_CAMPAIGNS_V 12.1.1
This view returns all marketing campaigns and related information.
APPS.AMS_CAMPAIGNS_V·↳ AMS_CAMPAIGNS_ALL_TL·↳ AMS_CAMPAIGNS_VL·↳ AMS_USER_STATUSES_VL·Explore AMS module →
-
View: AMS_EVENT_OFFERS_V 12.2.2
This view returns the general information about marketing event offerings .
APPS.AMS_EVENT_OFFERS_V·↳ AMS_ACT_DELIVERY_METHODS_V·↳ AMS_EVENT_HEADERS_VL·↳ AMS_EVENT_OFFERS_VL·Explore AMS module →
-
Base table to store the details of a campaign.
-
APPS.AST_CAMP_DELV_ASSOCIATIONS_V·↳ AMS_DELIVERABLES_VL·↳ AMS_OBJECT_ASSOCIATIONS·↳ AMS_SOURCE_CODES·Explore AST module →
-
View: AMS_EVENT_OFFERS_VL 12.2.2
This view returns the general information about marketing event offerings.
APPS.AMS_EVENT_OFFERS_VL·↳ AMS_EVENT_OFFERS_ALL_B·↳ AMS_EVENT_OFFERS_ALL_TL·Explore AMS module →
-
View: AMS_P_DELIVERABLES_V 12.1.1
This public view returns the marketing deliverable information.
APPS.AMS_P_DELIVERABLES_V·↳ AMS_CATEGORIES_TL·↳ AMS_DELIVERABLES_VL·↳ AMS_JTF_RS_EMP_V·Explore AMS module →
-
This table stores the details about marketing deliverables/collaterals, collaterals are uniquely identified by deliverable name, language and version.
-
View: AMS_EVENT_OFFERS_V 12.1.1
This view returns the general information about marketing event offerings .
APPS.AMS_EVENT_OFFERS_V·↳ AMS_ACT_DELIVERY_METHODS_V·↳ AMS_EVENT_HEADERS_VL·↳ AMS_EVENT_OFFERS_VL·Explore AMS module →
-
This view returns the general information about marketing event offerings without event header information.
APPS.AMS_EVENT_OFFERS_ONLY_V·↳ AMS_ACT_DELIVERY_METHODS_V·↳ AMS_EVENT_OFFERS_VL·↳ AMS_LOOKUPS·Explore AMS module →
-
View: AMS_P_CAMPAIGNS_V 12.2.2
This public view returns all marketing campaigns and related information.
APPS.AMS_P_CAMPAIGNS_V·↳ AMS_CAMPAIGNS_VL·Explore AMS module →
-
View: AMS_P_CAMPAIGNS_V 12.1.1
This public view returns all marketing campaigns and related information.
APPS.AMS_P_CAMPAIGNS_V·↳ AMS_CAMPAIGNS_VL·Explore AMS module →
-
View: AST_LS_CAMPAIGNS_V 12.1.1
APPS.AST_LS_CAMPAIGNS_V·↳ AMS_ACT_OFFERS·↳ AMS_ACT_PRODUCTS·↳ AMS_CAMPAIGNS_ALL_B·Explore AST module →
-
View: AMS_DELIVERABLES_VL 12.2.2
This view returns the marketing deliverable information.
APPS.AMS_DELIVERABLES_VL·↳ AMS_DELIVERABLES_ALL_B·↳ AMS_DELIVERABLES_ALL_TL·Explore AMS module →
-
APPS.AMS_DELIVERABLES_INFO_V·↳ AMS_CATEGORIES_TL·↳ AMS_DELIVERABLES_VL·↳ AMS_JTF_RS_EMP_V·Explore AMS module →
-
View: AMS_EVENT_HEADERS_VL 12.1.1
This view returns the general information about marketing events (headers).
APPS.AMS_EVENT_HEADERS_VL·↳ AMS_EVENT_HEADERS_ALL_B·↳ AMS_EVENT_HEADERS_ALL_TL·Explore AMS module →
-
View: AMS_CAMPAIGNS_VL 12.1.1
This is the view for marketing campaigns.
APPS.AMS_CAMPAIGNS_VL·↳ AMS_CAMPAIGNS_ALL_B·↳ AMS_CAMPAIGNS_ALL_TL·Explore AMS module →
-
This view returns the general information about marketing event offerings without event header information.
APPS.AMS_EVENT_OFFERS_ONLY_V·↳ AMS_ACT_DELIVERY_METHODS_V·↳ AMS_EVENT_OFFERS_VL·↳ AMS_LOOKUPS·Explore AMS module →
-
View: AMS_CAMPAIGNS_VL 12.2.2
This is the view for marketing campaigns.
APPS.AMS_CAMPAIGNS_VL·↳ AMS_CAMPAIGNS_ALL_B·↳ AMS_CAMPAIGNS_ALL_TL·Explore AMS module →
-
View: AMS_EVENT_OFFERS_VL 12.1.1
This view returns the general information about marketing event offerings.
APPS.AMS_EVENT_OFFERS_VL·↳ AMS_EVENT_OFFERS_ALL_B·↳ AMS_EVENT_OFFERS_ALL_TL·Explore AMS module →
-
Base table to store the details of a campaign.
-
Table: IGS_PE_FUND_SOURCE 12.2.2
Holds details of a person's funding source information
Not implemented in this database·Explore IGS module →