Search Results igs_fi_fd_src_rstn_h_all




Overview
Explore in AI Chat

Overview

The table IGS_FI_FD_SRC_RSTN_H_ALL is a historical data entity within the Oracle E-Business Suite (EBS) Student System (IGS), which is now marked as obsolete. Its primary function is to maintain a historical audit trail of changes made to funding source restrictions associated with specific course versions. This table captures the state of a funding restriction at a point in time, allowing the system to reconstruct which funding sources were eligible or ineligible for a course at any given historical date. It plays a critical role in ensuring data integrity for financial and academic reporting by preserving a complete record of restriction changes over the lifecycle of a course.

Key Information Stored

The table's structure is designed to uniquely identify a specific historical record for a funding source restriction on a course. The primary key is a composite of four columns: COURSE_CD, VERSION_NUMBER, HIST_START_DT, and FUNDING_SOURCE. This combination ensures that for each course version and funding source, a distinct historical entry is created whenever a restriction change occurs, with the HIST_START_DT marking the effective date of that change. The core data stored includes the identifiers for the course (COURSE_CD and VERSION_NUMBER) and the specific funding source (FUNDING_SOURCE). While the provided metadata does not list all columns, typical historical tables in this context would also include an end date, a creation date, and columns indicating the type of restriction or change action.

Common Use Cases and Queries

The primary use case for this table is auditing and historical reporting. Analysts can query it to determine the funding eligibility for a course version as of a past date, which is essential for resolving student financial aid inquiries or conducting compliance audits. A common query pattern involves joining to the course and funding source master tables to retrieve descriptive information. For example, to see all historical restrictions for a specific course, one might use a query such as: SELECT h.* FROM igs_fi_fd_src_rstn_h_all h WHERE h.course_cd = :p_course_cd AND h.version_number = :p_version ORDER BY h.hist_start_dt;. Reporting use cases include generating timelines of funding policy changes for academic programs or validating that funding rules were applied correctly to historical student enrollment and fee assessments.

Related Objects

IGS_FI_FD_SRC_RSTN_H_ALL maintains defined foreign key relationships with core master tables in the Student System, ensuring referential integrity. The documented relationships are:

  • IGS_PS_VER_ALL (Course Versions): The table references IGS_PS_VER_ALL via the columns COURSE_CD and VERSION_NUMBER. This links each historical restriction record to a specific academic course version.
  • IGS_FI_FUND_SRC_ALL (Funding Sources): The table references IGS_FI_FUND_SRC_ALL via the FUNDING_SOURCE column. This links the record to the master definition of the funding source, such as a government body or scholarship fund.
These relationships are essential for constructing meaningful queries that include course titles and funding source names, forming a complete data model for historical financial aid analysis.