Search Results fee_as_item_dtl_id

Overview

The IGS_FI_FAI_DTLS table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) or Campus Solutions modules. It functions as the Fee Assessment Item Detail table, storing granular, unit-level information associated with a student's fee assessment. Its primary role is to record the specific academic components—such as enrolled units, unit sets, and their attributes—for which fees have been calculated and assessed. This table provides the essential link between a high-level fee assessment item and the detailed academic enrollment data, enabling precise fee allocation, auditing, and reporting.

Key Information Stored

The table's columns capture a comprehensive set of identifiers and attributes related to the assessed academic unit. The primary key, FEE_AS_ITEM_DTL_ID, is a unique system-generated identifier for each detail record. The FEE_ASS_ITEM_ID is a critical foreign key linking the detail to its parent record in the IGS_FI_FEE_AS_ITEMS table. Key academic identifiers include:

• UOO_ID: Links to the specific unit offering option (IGS_PS_UNIT_OFR_OPT_ALL).
• COURSE_CD and CRS_VERSION_NUMBER: Identify the student's program of study.
• UNIT_SET_CD and US_VERSION_NUMBER: Identify the unit set, linked to IGS_EN_UNIT_SET_ALL.
• UNIT_ATTEMPT_STATUS, ORG_UNIT_CD, LOCATION_CD, CLASS_STANDING: Provide contextual attributes of the unit attempt at the time of assessment.
• CHG_ELEMENTS: Stores the count of charge elements assessed for the unit.
• Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for audit tracking.

Common Use Cases and Queries

This table is central to inquiries and reports detailing the breakdown of assessed fees by academic unit. A common use case is tracing the composition of a fee invoice or charge back to the individual enrolled units. Support and functional teams often query this table to verify fee calculations or diagnose discrepancies by joining it to the parent fee assessment and student enrollment data. A typical reporting query pattern involves selecting detail records for a specific fee assessment item or student.

SELECT dtl.*
FROM igs.igs_fi_fai_dtls dtl,
     igs.igs_fi_fee_as_items fai
WHERE dtl.fee_ass_item_id = fai.fee_ass_item_id
  AND fai.person_id = :student_id
  AND fai.fee_cal_type = :cal_type
  AND fai.fee_ci_sequence_number = :ci_seq_num;

Another critical use case is data validation, ensuring that for every assessed unit (UOO_ID) recorded in enrollment tables, corresponding fee assessment details exist where applicable.

Related Objects

The IGS_FI_FAI_DTLS table maintains defined foreign key relationships with several key tables in the IGS schema, establishing its place in the data model.

• Primary Key: IGS_FI_FAI_DTLS_PK on FEE_AS_ITEM_DTL_ID.
• Foreign Key (Parent): FEE_ASS_ITEM_ID references IGS_FI_FEE_AS_ITEMS. This is the primary relationship, connecting the unit detail to its overarching fee assessment item.
• Foreign Key (Academic Data): UNIT_SET_CD and US_VERSION_NUMBER reference IGS_EN_UNIT_SET_ALL, linking to the unit set definition.
• Foreign Key (Unit Offering): UOO_ID references IGS_PS_UNIT_OFR_OPT_ALL, linking to the specific instance of a unit offering in which the student enrolled.

These relationships ensure referential integrity between financial assessments and the academic enrollment structures within Oracle EBS.