Results for “igs_fi_ext_int_all”

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

Overview

IGS_FI_EXT_INT_ALL is a transactional interface table in the Oracle E-Business Suite Student System (IGS) product family. As its name implies, it functions as a staging and source table for the entry of external charges originating from any third party—examples include charges imported from external financial systems, partner institutions, government sponsors, or other non-student-accounts-receivable sources that must ultimately be processed through the Oracle Student Financials subsystem. The table resides in the IGS schema and carries a VALID status in ETRM 12.1.1; its structure is consistent across the 12.1.1 and 12.2.2 releases.

The table is documented with 55 columns and is a high-volume interface entity, meaning its primary purpose is to capture inbound data that will subsequently be validated, converted, and posted into the core student financial tables. In a Data Vault modeling context, the FK structure (references outward to HZ_PARTIES and IGS_FI_ACC_ALL) suggests a link classification—an associative table connecting a party (the payer or charged party) to financial accounting references. This is offered strictly as a heuristic suggestion mined from the foreign-key topology, not as a canonical data model assertion.

Key Information Stored

The table is anchored by the surrogate primary key IGS_FI_EXT_INT_PK, which is defined on the EXTERNAL_FEE_ID column. A unique index, IGS_FI_EXT_INT_ALL_U1, also exists on EXTERNAL_FEE_ID, reinforcing it as the business-key candidate for uniquely identifying each external charge record.

Among the most operationally significant columns are:

• EXTERNAL_FEE_ID — surrogate primary key and business-key candidate for the external charge.
• PERSON_ID — foreign key to HZ_PARTIES, identifying the party against whom the external charge is levied.
• STATUS — processing state of the interface record (e.g., entered, validated, posted, errored).
• FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER — classification of the fee and the calendar/sequence context in which it falls.
• COURSE_CD and CRS_VERSION_NUMBER — the academic course and version associated with the charge, where applicable.
• TRANSACTION_DT, TRANSACTION_TYPE, TRANSACTION_AMOUNT, CURRENCY_CD, EXCHANGE_RATE — the core financial transaction attributes.
• OVERRIDE_DR_REC_ACCOUNT_CD and OVERRIDE_CR_REV_ACCOUNT_CD — override accounting flexfield references, both foreign keys into IGS_FI_ACC_ALL.
• GL_DATE — the general ledger date for accounting entry.
• ERROR_MSG — diagnostic message populated when validation or posting fails.
• Standard WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, ORG_ID) and the concurrent program context (REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID).

Common Use Cases and Queries

Typical usage includes monitoring inbound external charge loads, reconciling third-party charges against posted student financials entries, and diagnosing records that failed conversion. A common pattern is to retrieve unprocessed or errored rows:

• Filtering by STATUS to isolate records pending validation or in error.
• Joining to HZ_PARTIES on PERSON_ID to surface the charged party's name.
• Joining to IGS_FI_ACC_ALL on the override account columns to confirm the accounting flexfield used.
• Querying by PROGRAM_ID or REQUEST_ID to trace records back to the concurrent program run that inserted them.
• Reporting on TRANSACTION_AMOUNT and CURRENCY_CD by GL_DATE for period close reconciliation.

Related Objects

The documented foreign-key relationships identify the most significant related objects:

• HZ_PARTIES — joined via IGS_FI_EXT_INT_ALL.PERSON_ID; identifies the party associated with the external charge.
• IGS_FI_ACC_ALL — referenced by OVERRIDE_DR_REC_ACCOUNT_CD, supplying the debit receivable override account.
• IGS_FI_ACC_ALL — also referenced by OVERRIDE_CR_REV_ACCOUNT_CD, supplying the credit revenue override account.
• IGS_FI_EXT_INT_PK — the primary key constraint supporting the table's surrogate key.
• IGS_FI_EXT_INT_ALL_U1 — the unique index enforcing uniqueness of EXTERNAL_FEE_ID.