Results for “funding_source”
50+ results
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.
-
This entity describes the history of changes for a funding source.
-
View: IGS_FI_FD_SRC_RSTN_H_V 12.1.1
This view is used to merge funding source restriction history with the current funding source restriction details enabling all details to be accessed over time, up till the current day. Each entry represents all column values over defined t
APPS.IGS_FI_FD_SRC_RSTN_H_V·↳ IGS_AU_GEN_002·↳ IGS_FI_FD_SRC_RSTN_H·↳ IGS_FI_FND_SRC_RSTN·Explore IGS module →
-
This entity describes the history of funding source restriction changes for a course version.
-
View: IGS_FI_FD_SRC_RSTN_H 12.1.1
APPS.IGS_FI_FD_SRC_RSTN_H·↳ IGS_FI_FD_SRC_RSTN_H_ALL·Explore IGS module →
-
View: IGS_OR_UNIT_FUNDSRC_V 12.1.1
View of all organization units joined to all funding source to use in ADMF2M44
APPS.IGS_OR_UNIT_FUNDSRC_V·↳ HZ_PARTIES·↳ IGS_FI_FUND_SRC·↳ IGS_PE_HZ_PARTIES·Explore IGS module →
-
View: IGS_AD_SBMAO_FN_CTTT_V 12.1.1
APPS.IGS_AD_SBMAO_FN_CTTT_V·↳ IGS_AD_SBMAO_FN_CTTT·↳ IGS_LOOKUP_VALUES·Explore IGS module →
-
View: IGS_FI_FUND_SRC 12.1.1
APPS.IGS_FI_FUND_SRC·↳ IGS_FI_FUND_SRC_ALL·Explore IGS module →
-
This entity describes the university set of funding sources.
-
Describes academic organizational unit targets
-
Holds intake target types and associated targets for submission period program version funding source.
-
View: IGS_FI_FUND_SRC_HIST 12.1.1
APPS.IGS_FI_FUND_SRC_HIST·↳ IGS_FI_FUND_SRC_HIST_ALL·Explore IGS module →
-
View: IGS_AD_SBMAO_FN_AMTT_V 12.1.1
APPS.IGS_AD_SBMAO_FN_AMTT_V·↳ IGS_AD_SBMAO_FN_AMTT·↳ IGS_LOOKUP_VALUES·Explore IGS module →
-
View: IGS_AD_SBMAO_FN_UITT_V 12.1.1
APPS.IGS_AD_SBMAO_FN_UITT_V·↳ IGS_AD_SBMAO_FN_UITT·↳ IGS_LOOKUP_VALUES·Explore IGS module →
-
Base business view to allow queries on student DLHE survey records.
APPS.IGSBV_ST_HESA_DLHE_SURVEY_RECS·↳ HZ_PARTIES·↳ IGS_HE_STDNT_DLHE·Explore IGS module →
-
This entity describes the funding sources which are available for a course. A default can be specified in this entity.
-
Holds submission period targets
-
Holds program version funding source and optional components that have one or more targets for a submission period
-
Describes submission period academic organizational unit targets
-
View: IGS_AD_SBM_AOU_FNDTT_V 12.1.1
APPS.IGS_AD_SBM_AOU_FNDTT_V·↳ IGS_AD_SBM_AOU_FNDTT·↳ IGS_LOOKUP_VALUES·Explore IGS module →
-
View: IGS_FI_FUND_SRC_HIST_V 12.1.1
This view is used to merge funding source history with the current funding source details enabling all details to be accessed over time, up till the current day. Each entry represents all column values over defined time periods.
APPS.IGS_FI_FUND_SRC_HIST_V·↳ IGS_AU_GEN_002·↳ IGS_FI_FUND_SRC·↳ IGS_FI_FUND_SRC_HIST·Explore IGS module →
-
Describes submission period academic organizational unit targets
-
View: IGS_AS_SCA_H_V 12.1.1
This view is used to merge student course attempt history with the current student course attempt details enabling all details to be accessed over time, up till the current day. Each entry represents all column values over defined time peri
APPS.IGS_AS_SCA_H_V·↳ IGS_AS_SC_ATTEMPT_H·↳ IGS_AU_GEN_003·↳ IGS_EN_STDNT_PS_ATT_ALL·Explore IGS module →
-
View: IGS_EN_PS_ATT_CH_OPT_V 12.1.1
This view describes the change course option of an enrolled student which also takes course code, location and attempt status into consideration.
APPS.IGS_EN_PS_ATT_CH_OPT_V·↳ IGS_EN_GEN_003·↳ IGS_EN_GEN_007·↳ IGS_EN_STDNT_PS_ATT_SV·Explore IGS module →
-
This table is a temporary table used by the process that creates the Enrolment Statistics Snapshot.
-
View: IGS_AD_SBMPS_FN_ITTT_V 12.1.1
APPS.IGS_AD_SBMPS_FN_ITTT_V·↳ IGS_AD_SBMPS_FN_ITTT·↳ IGS_LOOKUPS_VIEW·Explore IGS module →
-
This entity describes a snapshot of the current enrolment statistics at the institution. Based on the census date and used for various reporting purposes.
-
View: IGS_AS_SC_ATTEMPT_H 12.1.1
This view is multi org view
APPS.IGS_AS_SC_ATTEMPT_H·↳ IGS_AS_SC_ATTEMPT_H_ALL·Explore IGS module →
-
View: IGS_HE_POOUS 12.1.1
Program Offering Option Unit Set HESA Details
-
View: IGS_PR_STDNT_PS_ATT_V 12.1.1
APPS.IGS_PR_STDNT_PS_ATT_V·↳ HZ_PARTIES·↳ IGS_EN_STDNT_PS_ATT_SV·Explore IGS module →
-
View: IGS_EN_STDNT_PS_ATT 12.1.1
This view contains the data of student attempts for a given specific program structure.
APPS.IGS_EN_STDNT_PS_ATT·↳ IGS_EN_STDNT_PS_ATT_ALL·Explore IGS module →
-
No longer used
APPS.IGS_FI_SCAH_EFFECTIVE_H_CAT_V·↳ IGS_AS_SCAH_EFFECTIVE_H_V·↳ IGS_AU_GEN_003·↳ IGS_EN_GET_SCAEH_DTL·Explore IGS module →
-
Describes history of changes to student program attempt
-
Used to create effective student program attempt history records in recognition of back dating commencement and discontinuation dates.
APPS.IGS_AS_SCAH_EFFECTIVE_H_V·↳ IGS_AS_SCA_H_V·↳ IGS_AU_GEN_003·↳ IGS_EN_GET_SCAEH_DTL·Explore IGS module →
-
Holds Information about Admission Application Program Details
APPS.IGSBV_AD_ADM_PS_APPL_INST·↳ HZ_PARTIES·↳ HZ_PERSON_PROFILES·↳ IGS_AD_PS_APPL_INST_ALL·Explore IGS module →
-
View: IGS_HE_POOUS_DTLS_V 12.1.1
Program Offering Option Unit Set HESA Details
APPS.IGS_HE_POOUS_DTLS_V·↳ IGS_AS_GRD_SCHEMA·↳ IGS_CA_TYPE·↳ IGS_EN_UNIT_SET·Explore IGS module →
-
This entity describes a student's attempt at studying a particular course offered by the university.
APPS.IGSBV_STUDENT_PROGRAM_ATTEMPTS·↳ HZ_PARTIES·↳ IGS_EN_STDNT_PS_ATT_ALL·↳ IGS_PS_VER_ALL·Explore IGS module →
-
View of IGS_AD_PS_APPL_INST. Incorporates alternate codes and calendar instance start and end dates for both the Admission and Deferred Admission calendars. Also incorporates Admission Course Application details.
APPS.IGS_AD_PS_APPL_INST_APLINST_V·↳ HZ_PARTIES·↳ IGS_AD_APPL·↳ IGS_AD_BASIS_FOR_AD·Explore IGS module →
-
View: IGS_EN_PE_PRG_CTXT_V 12.1.1
This view holds the details of the program context information of a specific student. The information this view holds appears on each form where program units are described. This information is displayed as a context block.
APPS.IGS_EN_PE_PRG_CTXT_V·↳ IGS_EN_GEN_003·↳ IGS_EN_GEN_007·↳ IGS_EN_STDNT_PS_ATT_SV·Explore IGS module →
-
View: IGS_EN_SCA_V 12.1.1
This view would be used in the form.
APPS.IGS_EN_SCA_V·↳ IGS_CA_INST·↳ IGS_EN_STDNT_PS_ATT_SV·↳ IGS_LOOKUP_VALUES·Explore IGS module →
-
Describes history of changes to admission program application instance
-
Request for program entry for an admission period
APPS.IGS_AD_PS_APLINSTHST_APLHIST_V·↳ IGS_AD_PS_APLINSTHST·↳ IGS_AD_PS_APPL_HIST·↳ IGS_GE_DATE·Explore IGS module →
-
View: IGS_EN_STDNT_PS_ATT_SV 12.1.1
This view contains the secured rows in the student program attempt table.
APPS.IGS_EN_STDNT_PS_ATT_SV·↳ IGS_EN_STDNT_PS_ATT_ALL·Explore IGS module →
-
View: IGS_AD_PS_APPL_INST 12.1.1
APPS.IGS_AD_PS_APPL_INST·↳ IGS_AD_PS_APPL_INST_ALL·Explore IGS module →
-
View: IGS_AD_PS_APLINSTHST 12.1.1
APPS.IGS_AD_PS_APLINSTHST·↳ IGS_AD_PS_APLINSTHST_ALL·Explore IGS module →
-
This view describes and maintains the student course version of a specific program structure.
APPS.IGS_EN_STDNT_PS_ATT_CRV_V·↳ IGS_EN_STDNT_PS_ATT·↳ IGS_LOOKUPS_VIEW·↳ IGS_PS_VER·Explore IGS module →
-
This entity describes a student's attempt at studying a particular course offered by the university.
-
Program Offering Option Unit Set HESA Details
-
Stores the Student DLHE details for each Submission Return Qualifying Period
-
This entity describes a student's attempt at studying a particular course offered by the university.
APPS.IGSFV_STUDENT_PROGRAM_ATTEMPTS·↳ HZ_PARTIES·↳ IGS_AD_LOCATION_ALL·↳ IGS_CA_INST_ALL·Explore IGS module →
-
View: IGS_AD_STDNT_PS_ATT_V 12.1.1
APPS.IGS_AD_STDNT_PS_ATT_V·↳ IGS_EN_STDNT_PS_ATT·↳ IGS_PE_PERSON_BASE_V·Explore IGS module →