Results for “igs_fi_special_fees”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGS.IGS_FI_SPECIAL_FEES table is a core transactional object within the Oracle E-Business Suite Student System (IGS) product family. It stores Student Special Fees transactions — discrete fee assessments levied against a specific student, often outside the standard enrollment-driven fee calculation. Records in this table capture the person assessed, the fee type and calendar context, the amount, the transaction date, and the resulting receivables invoice reference. The table is documented as VALID in the IGS schema in both Oracle EBS 12.1.1 and 12.2.2, and its physical schema comprises 20 columns.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign-key structure is link. This classification is a modeling suggestion: the table's primary identity is a surrogate key on a single transaction, but its most significant columns are foreign keys that connect a party, a fee type, a use-of-organization record, and an invoice. It therefore behaves as an associative link between those business entities, with the surrogate key providing row-level identification.

Key Information Stored

The surrogate primary key is SPECIAL_FEE_ID, enforced by the unique index IGS_FI_SPECIAL_FEES_PK. This is the only documented unique index and thus the sole business-key candidate identified in the metadata; all other columns are descriptive or foreign-key attributes.

The most important columns are:

• SPECIAL_FEE_ID — surrogate primary key uniquely identifying each special fee transaction.
• PERSON_ID — the student or party assessed the fee; references both HZ_PARTIES and IGS_EN_STDNT_PS_ATT_ALL.
• COURSE_CD — the course code associated with the student enrollment context for the fee.
• UOO_ID — the use-of-organization identifier linking to IGS_PS_USEC_SP_FEES, indicating the organizational unit or offering under which the fee is defined.
• FEE_TYPE — the fee category, referencing IGS_FI_F_TYP_CA_INST_ALL.
• FEE_CAL_TYPE and FEE_CI_SEQUENCE_NUMBER — the fee calendar type and calendar instance sequence that qualify the fee type.
• FEE_AMT — the assessed amount for the special fee transaction.
• TRANSACTION_DATE — the effective date of the fee transaction.
• S_TRANSACTION_TYPE_CODE — the transaction type code classifying the event.
• INVOICE_ID — reference to the receivables invoice generated, linking to IGS_FI_INV_INT_ALL.
• Audit columns CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO columns capturing row lifecycle.
• Concurrent program columns REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE — identifying the process that created or updated the row.

Common Use Cases and Queries

Typical reporting scenarios include listing all special fees assessed to a student, reconciling assessed fees to invoices, and auditing fee activity by fee type or calendar. The following pattern returns fee details for a given person with fee type and invoice information:

• SELECT s.SPECIAL_FEE_ID, s.FEE_TYPE, s.FEE_AMT, s.TRANSACTION_DATE, s.INVOICE_ID FROM IGS.IGS_FI_SPECIAL_FEES s WHERE s.PERSON_ID = :person_id ORDER BY s.TRANSACTION_DATE DESC;
• A reconciliation query joining to the invoice interface table: SELECT s.SPECIAL_FEE_ID, i.INVOICE_ID FROM IGS.IGS_FI_SPECIAL_FEES s, IGS.IGS_FI_INV_INT_ALL i WHERE s.INVOICE_ID = i.INVOICE_ID;
• Aggregation by fee type: SELECT FEE_TYPE, COUNT(*), SUM(FEE_AMT) FROM IGS.IGS_FI_SPECIAL_FEES GROUP BY FEE_TYPE;

These queries are commonly used in student financial statements, fee audit reports, and integration extracts feeding Oracle Receivables.

Related Objects

The table participates in the following documented relationships:

• IGS_FI_F_TYP_CA_INST_ALL — joined on FEE_TYPE, FEE_CAL_TYPE, and FEE_CI_SEQUENCE_NUMBER; defines the fee type and calendar instance.
• IGS_EN_STDNT_PS_ATT_ALL — joined on PERSON_ID and COURSE_CD; the student program/attempt record.
• IGS_PS_USEC_SP_FEES — joined on UOO_ID and FEE_TYPE; special fees defined at the use-of-organization level.
• HZ_PARTIES — joined on PERSON_ID; the party master record for the assessed person.
• IGS_FI_INV_INT_ALL — joined on INVOICE_ID; the student invoice interface carrying the resulting receivable.

Together these objects form the linkage between a student, the organizational fee definition, and the receivables invoice, confirming the link classification of IGS_FI_SPECIAL_FEES within the IGS financial data model.