Search Results igs_fi_fai_dtls




Overview
Explore in AI Chat

Overview

The IGS_FI_FAI_DTLS table is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS) module, specifically for versions 12.1.1 and 12.2.2. It functions as the Fee Assessment Item Detail table, designed to store granular unit-level information associated with a student's fee assessment. Its primary role is to provide a detailed breakdown of the specific academic components—such as individual units or unit sets—that are linked to a broader fee assessment item. This table is essential for accurately attributing charges to the precise academic activities a student undertakes, enabling detailed financial tracking, reporting, and reconciliation within the institution's student financial management framework.

Key Information Stored

The table's structure is centered on linking fee items to academic entities. The primary key, FEE_AS_ITEM_DTL_ID, uniquely identifies each detail record. The most critical foreign key column is FEE_ASS_ITEM_ID, which ties each detail line back to its parent fee assessment in the IGS_FI_FEE_AS_ITEMS table. To define the academic component being charged, the table references two key objects: the UOO_ID (Unit Offering Option ID) links to a specific unit offering instance in IGS_PS_UNIT_OFR_OPT_ALL, while the UNIT_SET_CD and US_VERSION_NUMBER together link to a defined unit set in IGS_EN_UNIT_SET_ALL. This design allows the system to record whether a fee is assessed against a discrete unit or a collection of units (a unit set).

Common Use Cases and Queries

This table is pivotal for generating detailed fee statements, auditing charge calculations, and supporting student inquiries about specific fees. A common operational use case involves drilling down from a summarized fee invoice to see which courses or units each line item represents. For reporting, analysts frequently join this table to student, unit, and fee master data to analyze revenue by academic program or unit. A typical SQL pattern retrieves all unit details for a given fee assessment:

  • SELECT fdtls.* FROM igs_fi_fai_dtls fdtls WHERE fdtls.fee_ass_item_id = :p_fee_item_id;

Another critical query supports reconciliation by joining to the unit and unit set master tables to validate that all charged academic components are active and correctly configured.

Related Objects

The IGS_FI_FAI_DTLS table sits at the intersection of financial and academic data, with defined foreign key relationships to core EBS Student System tables. It is a child table of IGS_FI_FEE_AS_ITEMS, linked via the FEE_ASS_ITEM_ID column. For academic data, it references IGS_PS_UNIT_OFR_OPT_ALL on the UOO_ID column to tie fees to specific unit offerings. It also references IGS_EN_UNIT_SET_ALL using the composite key of UNIT_SET_CD and US_VERSION_NUMBER for fees associated with an entire unit set. These relationships ensure referential integrity between a student's financial charges and their enrolled academic curriculum.

  • Table: IGS_FI_FAI_DTLS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_FAI_DTLS,  object_name:IGS_FI_FAI_DTLS,  status:VALID,  product: IGS - Student System ,  description: Fee Assessment Item Detail table, which stores Unit Information of a fee assessment item record. ,  implementation_dba_data: IGS.IGS_FI_FAI_DTLS , 

  • Table: IGS_FI_FEE_AS_ITEMS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_FEE_AS_ITEMS,  object_name:IGS_FI_FEE_AS_ITEMS,  status:VALID,  product: IGS - Student System ,  description: This entity stores an itemized list of assessment items that have contributed to the student's assessment. ,  implementation_dba_data: IGS.IGS_FI_FEE_AS_ITEMS , 

  • Table: IGS_EN_UNIT_SET_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_EN_UNIT_SET_ALL,  object_name:IGS_EN_UNIT_SET_ALL,  status:VALID,  product: IGS - Student System ,  description: This field describes a unit-set, being a logical sub-grouping of course. e.g. Major, Minor, Stream, Strand. A unit-set is typically related to the rules which govern its completion via the Rules Sub-system. ,  implementation_dba_data: IGS.IGS_EN_UNIT_SET_ALL , 

  • Table: IGS_PS_UNIT_OFR_OPT_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_UNIT_OFR_OPT_ALL,  object_name:IGS_PS_UNIT_OFR_OPT_ALL,  status:VALID,  product: IGS - Student System ,  description: This entity describes the available options for each unit offering. ,  implementation_dba_data: IGS.IGS_PS_UNIT_OFR_OPT_ALL ,