Results for “igs_fi_fd_src_rstn_h_all”

27 results




Overview
Explore in AI Chat

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

Overview

The IGS_FI_FD_SRC_RSTN_H_ALL table belongs to the IGS (Student System) product family within Oracle E-Business Suite, a module now classified as obsolete in the ETRM reference. It is a historical, date-tracked entity that records the full lifecycle of funding source restriction changes applied to a course version. Each time the restriction status of a funding source attached to a course version is modified, a new effective-dated row is created, preserving the prior condition through the HIST_START_DT and HIST_END_DT interval columns. This design allows institutions to reconstruct, at any point in time, which funding sources were restricted or defaulted for a given course version.

From a Data Vault modeling perspective, the mined foreign-key structure suggests a link classification. The table connects three business concepts: a course version (via COURSE_CD and VERSION_NUMBER), a funding source (via FUNDING_SOURCE), and a temporal validity window (via HIST_START_DT). The combination of these relationships, plus historical tracking, positions the table as a transactional link that captures state transitions rather than descriptive attributes alone.

Key Information Stored

The table contains fourteen documented columns. The most significant are outlined below, distinguishing business keys from audit and history attributes:

  • COURSE_CD and VERSION_NUMBER — Together identify the course version to which the funding source restriction applies. Both are foreign-keyed to IGS_PS_VER_ALL.
  • FUNDING_SOURCE — The funding source being restricted, foreign-keyed to IGS_FI_FUND_SRC_ALL.
  • HIST_START_DT and HIST_END_DT — Define the effective dating interval for each historical record.
  • DFLT_IND — Indicates whether the funding source is the default for the course version.
  • RESTRICTED_IND — Flags whether the funding source is restricted for that course version.
  • HIST_WHO — Identifies the user or process that initiated the historical change.
  • ORG_ID — Multi-org operating unit context, where applicable.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns tracking row creation and modification.

The primary key is IGS_FI_FD_SRC_RSTN_H_PK, defined over (COURSE_CD, VERSION_NUMBER, HIST_START_DT, FUNDING_SOURCE). A unique index, IGS_FI_FD_SRC_RSTN_H_ALL_U1, exists on (COURSE_CD, VERSION_NUMBER, FUNDING_SOURCE, HIST_START_DT), reinforcing the same business-key combination and ensuring no duplicate effective-dated records exist for the same course version and funding source.

Common Use Cases and Queries

Typical reporting scenarios include auditing funding restriction changes over time and determining which funding sources were restricted for a course version during a specific academic period. A common query pattern retrieves the currently active restriction by filtering on the open-ended history interval:

  • SELECT COURSE_CD, VERSION_NUMBER, FUNDING_SOURCE, RESTRICTED_IND, HIST_START_DT FROM IGS_FI_FD_SRC_RSTN_H_ALL WHERE HIST_END_DT IS NULL OR HIST_END_DT > SYSDATE;
  • Joining to IGS_FI_FUND_SRC_ALL to resolve the funding source description for a point-in-time report.
  • Point-in-time analysis using HIST_START_DT <= :as_of_date AND (HIST_END_DT IS NULL OR HIST_END_DT > :as_of_date) to reconstruct historical restriction states.
  • Aggregation by COURSE_CD to count restricted versus default funding sources per course version.

Related Objects

The table participates in two documented foreign-key relationships, both of which define its business identity:

  • IGS_PS_VER_ALL — The course version entity; joined via COURSE_CD and VERSION_NUMBER.
  • IGS_FI_FUND_SRC_ALL — The funding source reference table; joined via FUNDING_SOURCE.
  • IGS_FI_FD_SRC_RSTN_ALL — The presumed current-state counterpart holding the non-historical funding source restriction records.
  • IGS_PS_COURSE_VERSION and related course catalog views — commonly joined for reporting on course-version funding attributes.
  • Student funding and fee assessment APIs that consult restriction flags when determining allowable funding sources for enrolment.

Because the object is marked obsolete and not implemented in the ETRM database, teams working on 12.1.1 or 12.2.2 should treat this table primarily as legacy reference material and validate presence against the actual IGS installation before relying on it.