Results for “igs_fi_fund_src_all”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_FI_FUND_SRC_ALL is a reference table within the Oracle E-Business Suite Student System (IGS) product family, historically positioned at the foundation of student financial aid and funding data. Its documented purpose is to describe the university set of funding sources — the authoritative catalog of every source from which a student's education may be funded, including government programs, institutional aid, sponsorship arrangements, and private awards. In Oracle EBS 12.1.1 and 12.2.2, the object is registered under the IGS product with a note that it is not implemented in this database; the Student System module is obsolete, meaning the table persists only in legacy installations or archived schemas rather than in a fresh 12.2.2 provisioning. Implementations that migrated student data forward may still encounter the object during data archaeology, integration mapping, or historical reporting.

The heuristic Data Vault classification derived from the foreign-key structure is hub-leaning. This is a modeling suggestion rather than a physical fact: the table behaves as a durable business-key registry — a hub — because it holds a stable natural identifier (FUNDING_SOURCE) that is referenced by many downstream transactional and association tables, while itself referencing only one parent table. No satellite-style descriptive churn dominates the schema, and it is not a pure link table since it carries its own descriptive attributes.

Key Information Stored

The documented physical schema for 12.1.1 contains ten columns under owner IGS. The most significant are:

• FUNDING_SOURCE — the business key and primary key component (index IGS_FI_FUND_SRC_ALL_U1, table constraint IGS_FI_FUND_SRC_PK). It is the natural identifier propagated to every dependent table.
• DESCRIPTION — the human-readable label presented to staff and applicants when selecting a funding source.
• GOVT_FUNDING_SOURCE — a self-referencing foreign key to IGS_FI_GOVT_FUND_SRC, classifying a source as governmental and linking it to the government funding master.
• CLOSED_IND — the active/inactive flag controlling whether the source remains selectable in admissions and enrollment processes.
• ORG_ID — the multi-org operating unit discriminator, indicating the table is organization-partitioned.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle EBS WHO audit columns, establishing row provenance and supporting change tracking.

Because the unique index covers FUNDING_SOURCE alone, the surrogate and business key are effectively the same value; there is no synthetic integer key in the documented schema.

Common Use Cases and Queries

Typical usage centers on resolving funding-source codes into readable descriptions and validating referential integrity across admissions and enrollment records.

• Listing active funding sources for a lookup: SELECT funding_source, description FROM igs_fi_fund_src_all WHERE closed_ind = 'N' ORDER BY description;
• Joining student application instances to their declared funding source: SELECT a.student_id, f.description FROM igs_ad_ps_appl_inst_all a, igs_fi_fund_src_all f WHERE a.funding_source = f.funding_source;
• Identifying government-funded cohorts via the self-referencing link: SELECT funding_source, govt_funding_source FROM igs_fi_fund_src_all WHERE govt_funding_source IS NOT NULL;
• Catching orphaned references before a migration or purge by checking dependent tables such as IGS_EN_STDNT_PS_ATT_ALL and IGS_HE_POOUS_ALL for funding_source values absent from this registry.

Related Objects

The table sits at the center of a broad referencing network, which confirms its hub-leaning character. The following are the most significant relationships:

• IGS_FI_GOVT_FUND_SRC — parent of GOVT_FUNDING_SOURCE, the only table this object references.
• IGS_AD_PS_APPL_INST_ALL — joins on FUNDING_SOURCE; links prospective-student application instances to their funding source.
• IGS_EN_STDNT_PS_ATT_ALL — joins on FUNDING_SOURCE; associates enrolled student program attempts with funding.
• IGS_HE_POOUS_ALL — joins on FUNDING_SOURCE for higher-education program offering data.
• IGS_FI_FND_SRC_RSTN and IGS_FI_FD_SRC_RSTN_H_ALL — join on FUNDING_SOURCE to apply funding-source restrictions and their historical versions.
• IGS_AD_SBMAO_FN_AMTT, IGS_AD_SBMAO_FN_CTTT, IGS_AD_SBMAO_FN_UITT, IGS_AD_SBM_AOU_FNDTT, and IGS_AD_SBM_PS_FNTRGT — secondary application and marketing target tables that all carry FUNDING_SOURCE as a foreign key.

Across Oracle EBS 12.1.1 and 12.2.2, the pattern is identical: this table is a legacy IGS hub that must be treated as read-only reference data wherever it survives.