Results for “fee_2”

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

Overview

IGF_SL_AWD_DISB_LOC_ALL is a Financial Aid module table owned by the IGF schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores loan disbursement data for each student loan, captured at the time of origination or whenever changes are transmitted to the Loan Origination Center (LOC). A defining characteristic of this table is that it always reflects the data currently held by the LOC, making it the authoritative local mirror of disbursement activity as recognized by the external lending authority.

Because it records disbursement events tied to a parent award rather than descriptive award attributes themselves, the table functions primarily as an event or transaction record that evolves with each disbursement or adjustment. Under the heuristic Data Vault classification derived from its foreign key structure, IGF_SL_AWD_DISB_LOC_ALL is characterized as satellite-leaning — that is, it behaves like a satellite attached to a parent hub (the award), capturing changing descriptive and measurable attributes over time rather than acting as an independent hub or a pure link between entities.

Key Information Stored

The table is documented with 20 columns. The most operationally significant are:

• AWARD_ID — Identifier of the parent award; also the foreign-key link to IGF_AW_AWARD_ALL and part of the composite primary key.
• DISB_NUM — Disbursement sequence number within the award; the second component of the composite primary key.
• DISB_GROSS_AMT — Gross disbursement amount before fees.
• FEE_1 and FEE_2 — Origination or guarantee fees applied to the disbursement.
• DISB_NET_AMT — Net disbursement amount after fee deductions.
• DISB_DATE — Scheduled or actual disbursement date.
• HOLD_REL_IND — Indicator controlling whether a disbursement hold has been released.
• FEE_PAID_1 and FEE_PAID_2 — Amounts actually paid against the corresponding fees.
• ORG_ID — Operating unit context, supporting multi-org data partitioning.
• REQUEST_ID — Concurrent request identifier associated with the record's creation or update.

The composite primary key IGF_SL_AWD_DISB_LOC_ALL_PK is defined on (AWARD_ID, DISB_NUM), and the unique index IGF_SL_AWD_DISB_LOC_ALL_U1 mirrors that same column pair, confirming it as the business-key candidate. Audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and program/application tracking columns (PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) provide the standard EBS WHO column and concurrent-program traceability.

Common Use Cases and Queries

Typical reporting and reconciliation scenarios include displaying all disbursements for a given award, reconciling net-versus-gross amounts, and auditing fee recovery. A representative query joins the table to its parent award:

• SELECT d.AWARD_ID, d.DISB_NUM, d.DISB_DATE, d.DISB_GROSS_AMT, d.FEE_1, d.FEE_2, d.DISB_NET_AMT FROM IGF_SL_AWD_DISB_LOC_ALL d WHERE d.AWARD_ID = :award_id ORDER BY d.DISB_NUM;
• Reconciling fee payment completeness: filter where DISB_NET_AMT plus FEE_PAID_1 and FEE_PAID_2 do not equal DISB_GROSS_AMT.
• Identifying held disbursements not yet released by testing HOLD_REL_IND.
• Auditing changes transmitted to the LOC using LAST_UPDATE_DATE and REQUEST_ID within a given operating unit via ORG_ID.

Related Objects

• IGF_AW_AWARD_ALL — Parent award table; joined on IGF_SL_AWD_DISB_LOC_ALL.AWARD_ID = IGF_AW_AWARD_ALL.AWARD_ID, the only documented foreign key relationship.
• IGF_SL_AWD_DISB_LOC_ALL_PK and IGF_SL_AWD_DISB_LOC_ALL_U1 — The primary key constraint and unique index enforcing (AWARD_ID, DISB_NUM) integrity.
• IGF_SL_* LOC-facing sibling tables — Other loan tables in the IGF Financial Aid module sharing the same award-based context and LOC synchronization pattern.
• Award and disbursement inquiry pages — EBS forms and OAF pages in the Financial Aid module that read this table to display disbursement detail.
• Concurrent programs — Processes identified through REQUEST_ID, PROGRAM_APPLICATION_ID, and PROGRAM_ID that load or refresh LOC disbursement data.

Because the table is the LOC's authoritative reflection of disbursement state, it is central to loan reconciliation, fee accounting, and external reporting within the Financial Aid module.