Search Results igs_fi_dsb_spsht_dtl




Overview
Explore in AI Chat

Overview

The IGS_FI_DSB_SPSHT_DTL table is a core data entity within the now-obsolete Oracle Student System (IGS) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It was designed to store the detailed line items for a fee assessment income disbursement journal. Each record in this table represents a specific allocation of disbursed fee income to a particular organizational unit and its associated general ledger account. The table's primary role was to support the detailed accounting and financial reporting of student fee revenue distribution across different organizational units within the institution. It is critical to note that the metadata explicitly labels this table and its parent module as obsolete, indicating its functional replacement in later application designs or its decommissioning in favor of alternative financial structures.

Key Information Stored

The table's structure is defined by a composite primary key and stores data essential for linking fee assessments to financial accounts. The key columns include identifiers for the fee assessment itself and the target organizational unit account. The primary key comprises FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, and CREATE_DT, which together uniquely identify the parent disbursement spreadsheet header. The remaining primary key columns—ACCOUNT_CD, ORG_UNIT_CD, OU_START_DT, and CLASSIFICATION_CD—uniquely identify the specific organizational unit account to which the income is disbursed. While the provided metadata does not list non-key attribute columns (such as monetary amounts), the table's purpose implies it would store detail-level financial data like disbursed amounts, quantities, or calculated values for the given account and fee assessment combination.

Common Use Cases and Queries

This table would have been central to generating detailed audit trails and financial reports for disbursed student fee income. Common operational use cases included reconciling total assessed fees against the sum of all disbursements to various departments and producing account-level journals for posting to the general ledger. A typical analytical query would join this detail table to its header and account master to summarize disbursements. For example:

  • Identifying Disbursement Details for a Fee Run: SELECT * FROM igs_fi_dsb_spsht_dtl d WHERE d.fee_type = :p_fee_type AND d.fee_cal_type = :p_cal_type AND d.fee_ci_sequence_number = :p_ci_seq;
  • Summarizing Disbursed Amounts by Organizational Unit: SELECT d.org_unit_cd, d.account_cd, SUM([AMOUNT_COLUMN]) FROM igs_fi_dsb_spsht_dtl d GROUP BY d.org_unit_cd, d.account_cd; (Note: The specific amount column name is not provided in the metadata).

Given the object's obsolete status, its primary use in EBS 12.1.1/12.2.2 would be for historical data reference, legacy reporting, or data migration projects.

Related Objects

The table exists within a defined relational schema, as evidenced by its foreign key relationships. It is a child table of the disbursement spreadsheet header and references master data for organizational unit accounts.

  • Referenced Tables (Foreign Keys from IGS_FI_DSB_SPSHT_DTL):
    • IGS_FI_DSBR_SPSHT: The parent header table. A foreign key relationship exists on the columns (FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, CREATE_DT).
    • IGS_OR_UNIT_AC: The organizational unit account master. A foreign key relationship exists on the columns (ACCOUNT_CD, ORG_UNIT_CD, OU_START_DT, CLASSIFICATION_CD).
  • Referencing Tables (Foreign Keys to IGS_FI_DSB_SPSHT_DTL):
    • IGS_FI_DSB_DTL_ALC: A child or allocation table that further breaks down the disbursement detail. It references IGS_FI_DSB_SPSHT_DTL's primary key columns (FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, CREATE_DT, ACCOUNT_CD, ORG_UNIT_CD, OU_START_DT, CLASSIFICATION_CD), likely adding an additional dimension such as a financial period via FIN_CAL_TYPE and FIN_CI_SEQUENCE_NUMBER.