Search Results igs_fi_dsbr_spsht




Overview
Explore in AI Chat

Overview

The IGS_FI_DSBR_SPSHT table is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS) module. It was designed to store historical point-in-time snapshots of fee disbursement data, specifically tied to a particular fee type and a defined financial period calendar instance. This table's primary role was to provide an auditable trail and a historical record of how fee disbursements were calculated and distributed at specific moments, which was critical for financial reporting, reconciliation, and analysis within an educational institution's finance operations. It is critical to note that, per the provided ETRM documentation, this table is explicitly marked as Obsolete and was Not implemented in the referenced database instance for versions 12.1.1 and 12.2.2. This status indicates that while the table's structure is defined in the data model, it is not in active use, and its functionality may have been superseded or consolidated into other objects in these releases.

Key Information Stored

The table's structure centers on uniquely identifying a specific disbursement snapshot and its context. The primary key is a composite of four columns, which together define a unique snapshot record. The FEE_TYPE, FEE_CAL_TYPE, and FEE_CI_SEQUENCE_NUMBER columns collectively identify the specific fee calendar instance to which the disbursement data pertains. The CREATE_DT column records the precise date and time the snapshot was captured. While the full column list is not detailed in the excerpt, the logical implication is that the table would have contained aggregated or summarized disbursement amounts, statuses, or other financial metrics valid as of the CREATE_DT for the specified fee calendar instance.

Common Use Cases and Queries

Given its obsolete status, direct operational or reporting use of this table in EBS 12.1.1/12.2.2 is not expected. Historically, its intended use cases would have included generating audit reports on fee disbursement calculations over time, comparing disbursement snapshots between different financial periods, and supporting financial period-end closing processes. A typical historical query pattern to retrieve all snapshots for a given fee calendar instance might have resembled:

  • SELECT * FROM IGS_FI_DSBR_SPSHT WHERE FEE_TYPE = :p_fee_type AND FEE_CAL_TYPE = :p_cal_type AND FEE_CI_SEQUENCE_NUMBER = :p_seq_num ORDER BY CREATE_DT DESC;

Any current reporting or interface requirements related to fee disbursement history should be fulfilled by consulting the active tables or views that have replaced this obsolete object's functionality.

Related Objects

Based on the documented foreign key relationships, IGS_FI_DSBR_SPSHT was part of a specific data hierarchy within the Student System's financial schema.

  • Parent Table (Referenced Foreign Key): The table references IGS_FI_F_TYP_CA_INST_ALL via the composite key (FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER). This establishes that each disbursement snapshot must be associated with a valid, pre-existing fee type calendar instance.
  • Child Table (Referencing Foreign Key): The table IGS_FI_DSB_SPSHT_DTL references IGS_FI_DSBR_SPSHT using the full primary key (FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, CREATE_DT). This indicates a one-to-many relationship where a header snapshot in IGS_FI_DSBR_SPSHT could have multiple detailed line items stored in the detail table.

As the parent table is obsolete, any related child objects like IGS_FI_DSB_SPSHT_DTL would also be expected to share the same obsolete status in these EBS versions.