Results for “igs_fi_fund_src_hist_pk”

4 results




Overview
Explore in AI Chat

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

Overview

IGS_FI_FUND_SRC_HIST_ALL is a history-tracking table within the Oracle E-Business Suite Student System (IGS) module. It records the temporal evolution of funding source records, capturing each change to a funding source as a dated historical row. The "ALL" suffix indicates the table is partitioned by operating unit or organization, consistent with the multi-org architecture used throughout Oracle EBS 12.1.1 and 12.2.2.

In Oracle EBS, funding sources represent the origins of financial aid or sponsorship applied to student accounts — for example government grants, external sponsorships, or institutional aid. The IGS_FI_FUND_SRC_HIST_ALL table preserves an audit trail of how these funding source definitions changed over time, allowing institutions to reconstruct the state of any funding source as of a given date.

Under a heuristic Data Vault classification, this object is best modeled as a satellite. It carries descriptive, time-variant attributes (DESCRIPTION, GOVT_FUNDING_SOURCE, CLOSED_IND) attached to a funding source business key (FUNDING_SOURCE), with HIST_START_DT and HIST_END_DT defining validity windows. The metadata classifies the table as standalone based on its foreign key structure, meaning it does not itself act as a hub or link.

Note that ETRM flags this table as "Not implemented in this database" for the documented release, and the IGS module is marked obsolete. Installations still running IGS should treat the schema as legacy.

Key Information Stored

The primary key is IGS_FI_FUND_SRC_HIST_PK, composed of FUNDING_SOURCE and HIST_START_DT. A unique index, IGS_FI_FUND_SRC_HIST_ALL_U1, also covers these two columns, confirming them as the business-key candidates that uniquely identify a historical version.

  • FUNDING_SOURCE — the business identifier of the funding source being tracked; part of both the primary key and the unique index.
  • HIST_START_DT — the date the historical version became effective; the second half of the primary key.
  • HIST_END_DT — the date the version ceased to be effective, enabling point-in-time reconstruction.
  • HIST_WHO — identifies the user or process that created the historical version.
  • DESCRIPTION — the descriptive name of the funding source at that point in time.
  • GOVT_FUNDING_SOURCE — indicates whether the funding source is a government source.
  • CLOSED_IND — flags whether the funding source was closed as of that version.
  • ORG_ID — the operating unit, supporting multi-org data security.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS audit columns used for change tracking and concurrency control.

Common Use Cases and Queries

The primary use case is temporal reporting: determining the state of a funding source on any historical date, or auditing changes for compliance and financial aid reconciliation.

A point-in-time query uses the validity window:

  • SELECT * FROM igs_fi_fund_src_hist_all WHERE funding_source = :p AND :d BETWEEN hist_start_dt AND NVL(hist_end_dt, SYSDATE);

A change-audit query lists all versions of a funding source:

  • SELECT funding_source, hist_start_dt, hist_end_dt, description, closed_ind FROM igs_fi_fund_src_hist_all WHERE funding_source = :p ORDER BY hist_start_dt;

Reporting may also filter by ORG_ID to respect operating-unit security, or segment records by GOVT_FUNDING_SOURCE to analyze government versus non-government aid over time. Because the table is flagged as not implemented in the documented database, queries should be validated against the actual installation before production use.

Related Objects

As a standalone satellite keyed on FUNDING_SOURCE, this table is referenced by the current funding source definition and its dependent financial aid objects. The most significant related objects include:

  • IGS_FI_FUND_SOURCES_ALL — the current (non-historical) funding source master, joined on FUNDING_SOURCE.
  • IGS_FI_FUND_SRC_HIST_PK — the primary key constraint object enforcing uniqueness on (FUNDING_SOURCE, HIST_START_DT).
  • IGS_FI_FUND_SRC_HIST_ALL_U1 — the unique index supporting business-key lookups.
  • IGS_FI_AWARD_* objects — award and disbursement records that reference funding sources for aid tracking.
  • IGS_FI_* financial aid tables — broader financial aid entities consuming funding source values.

Join predicates typically use FUNDING_SOURCE and, where temporal accuracy is required, HIST_START_DT to align historical versions with the reporting date.