Search Results igs_fi_special_fees_n1

Overview

The IGS_FI_SPECIAL_FEES table is a core transactional data store within the Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) or Campus Solutions modules. Owned by the IGS schema, its primary role is to record non-standard or exceptional fee transactions assessed to students. This includes special administrative fees and retention-related charges that fall outside the scope of regular tuition or standard course fees. The table serves as the system of record for these financial transactions, linking them to specific students, their academic programs, and unit attempts. Its data is critical for generating accurate student invoices, financial reporting, and auditing.

Key Information Stored

The table's structure captures the essential dimensions of a special fee transaction. The SPECIAL_FEE_ID column acts as the unique primary key identifier for each transaction record. Key entity columns include PERSON_ID (the student), COURSE_CD (the academic program), and UOO_ID (the specific unit section). The financial details are stored in FEE_TYPE, FEE_AMT, and TRANSACTION_DATE. Crucially, the S_TRANSACTION_TYPE_CODE distinguishes whether the record is for a 'Special Fee' or a 'Retention' charge. The table also maintains context within the academic calendar via FEE_CAL_TYPE and FEE_CI_SEQUENCE_NUMBER, and integrates with the invoicing system through INVOICE_ID. Standard EBS WHO and concurrent program columns track creation and modification metadata.

Common Use Cases and Queries

This table is central to processes involving the assessment and inquiry of ad-hoc student charges. Common use cases include generating reports of all special fees for a given student or academic period, reconciling invoice line items, and auditing retention fee assessments. A typical query to retrieve special fee transactions for a specific student and fee calendar would be:

• SELECT special_fee_id, fee_type, fee_amt, transaction_date, s_transaction_type_code, invoice_id
• FROM igs.igs_fi_special_fees
• WHERE person_id = :p_student_id
• AND fee_cal_type = :p_cal_type
• AND fee_ci_sequence_number = :p_sequence_num
• ORDER BY transaction_date DESC;

Another frequent reporting pattern involves joining to person (HZ_PARTIES) and course (IGS_PS_COURSE) tables to include descriptive information for operational reports.

Related Objects

The IGS_FI_SPECIAL_FEES table has defined relationships with other key EBS objects. The IGS_FI_SPECIAL_FEES_PK index on SPECIAL_FEE_ID enforces primary key integrity. The IGS_FI_SPECIAL_FEES_N1 non-unique index optimizes queries filtering by the combination of PERSON_ID, COURSE_CD, UOO_ID, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, and S_TRANSACTION_TYPE_CODE. The table is intrinsically linked to the invoicing subsystem via the INVOICE_ID column, which likely references a key in an invoice header table. It also relates foundationally to person (HZ_PARTIES), program (IGS_PS_COURSE), and unit offering (IGS_PS_UNIT_OFR) tables to resolve the identifiers stored in PERSON_ID, COURSE_CD, and UOO_ID, respectively.