Search Results igs_fi_credits_all

Overview

The IGS_FI_CREDITS_ALL table is a core data repository within the Oracle E-Business Suite's now-obsolete Student System (IGS) module, specifically for Student Finance. It serves as the central ledger for recording all credit and payment transactions applied to student accounts. This includes payments, refunds, waivers, and other credit adjustments. As an "ALL" table, it is multi-org enabled, storing data partitioned by operating unit (ORG_ID). Its primary role is to maintain a complete, auditable history of all financial credits, which is essential for account reconciliation, financial reporting, and managing student financial holds.

Key Information Stored

The table's structure is designed to capture the essential attributes of a credit transaction. The primary identifier is the system-generated CREDIT_ID. Key transactional data includes CREDIT_NUMBER, PARTY_ID (linking to the student/customer in HZ_PARTIES), and the CREDIT_TYPE_ID (linking to IGS_FI_CR_TYPES_ALL for categorization). Financial details such as the credit amount and date are stored, along with the SUBACCOUNT_ID for accounting purposes. The table also tracks the source of the credit through columns like SOURCE_INVOICE_ID (linking to IGS_FI_INV_INT_ALL for invoice-based credits) and RECEIPT_LOCKBOX_NUMBER (for batch payments). For credits related to specific fees or waivers, it references FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, and WAIVER_NAME.

Common Use Cases and Queries

This table is central to financial inquiries and reconciliation processes. Common operational and reporting use cases include generating student account statements, reconciling daily payment batches from lockboxes, auditing waiver applications, and identifying credits that released financial holds. A typical query might join to party and invoice tables to analyze payment history for a student or a cohort.

• Sample Query: Retrieve Credits for a Student
  SELECT c.credit_number, c.credit_date, c.amount, ct.type_code, i.invoice_number
FROM igs_fi_credits_all c,
igs_fi_cr_types_all ct,
igs_fi_inv_int_all i
WHERE c.party_id = 12345
AND c.org_id = 101
AND c.credit_type_id = ct.credit_type_id
AND c.source_invoice_id = i.invoice_id(+)
ORDER BY c.credit_date DESC;

Related Objects

The IGS_FI_CREDITS_ALL table has extensive relationships with other Student Finance entities, as shown by its foreign key constraints. It is a parent table to several key transactional tables, including IGS_FI_APPLICATIONS (for applying credits to charges), IGS_FI_CR_ACTIVITIES (for tracking actions on the credit), and IGS_FI_PP_INS_APPLS (for payment plan installments). It is also referenced by IGS_FI_PERSON_HOLDS as a credit that may release a financial hold. Crucially, it draws reference data from master tables: HZ_PARTIES for the student/customer, IGS_FI_CR_TYPES_ALL for the credit type, IGS_FI_SUBACCTS_ALL for the accounting sub-account, and IGS_FI_INV_INT_ALL for the source invoice.