Results for “igf_sl_lor_loc_all”

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

Overview

IGF_SL_LOR_LOC_ALL is a Financial Aid module table in Oracle EBS Release 12.1.1 and 12.2.2, owned by the IGF schema. The ETRM documentation classifies the product area as IGF – Financial Aid (Obsolete), and the metadata notes that the object is "Not implemented in this database." Despite this status, the table definition remains documented and is retained for reference and upgrade compatibility.

The table stores the complete set of loan data for every student loan as it stood at the time the origination record or an origination change was transmitted to the Loan Origination Center (LOC). The content therefore represents a snapshot of the loan as currently reflected at the LOC, covering borrower and student demographics, guarantor and lender assignments, promissory note status, disbursement-related attributes, and financial aid award linkage.

The physical definition contains 206 documented columns, making this a wide, denormalized satellite-style table. The heuristic Data Vault classification derived from the foreign key structure is satellite-leaning. In modeling terms, IGF_SL_LOR_LOC_ALL is best understood as a satellite attached to the loan origination hub represented by IGF_SL_LOR_ALL, with descriptive loan, borrower, and LOC response attributes keyed by the originating business identifier.

Key Information Stored

The table carries three documented primary key constraints, which together reveal both the surrogate and business-key structure:

• IGF_SL_LOR_LOC_ALL_PK — primary key on LOAN_ID, the surrogate identifier for each loan record.
• IGF_SL_LOR_LOC_ALL_U1 — unique index on ORIGINATION_ID, a business-key candidate linking the record to its originating loan origination entry.
• IGF_SL_LOR_LOC_ALL_UK — unique index also on ORIGINATION_ID, reinforcing the origination identifier as the natural business key.

Among the 206 columns, the following are most significant:

• LOAN_NUMBER, LOAN_TYPE, LOAN_AMT_OFFERED, LOAN_AMT_ACCEPTED — core loan identity and awarded/accepted amounts.
• LOAN_STATUS, LOAN_STATUS_DATE, LOAN_CHG_STATUS, LOAN_CHG_STATUS_DATE — current and prior status of the loan at the LOC.
• ORIG_STATUS_FLAG, ORIG_BATCH_ID, ORIG_BATCH_DATE, ORIG_ACK_DATE — origination transmission and acknowledgement tracking.
• GUARANTOR_ID, LENDER_ID, BORW_LENDER_ID — foreign-key references to guarantor and lender dimension tables.
• AWARD_ID, BASE_ID — foreign keys tying the loan to the financial aid award and base record.
• PNOTE_STATUS, PNOTE_ID, PNOTE_ACCEPT_AMT — promissory note lifecycle data.
• P_LAST_NAME, P_SSN, P_DATE_OF_BIRTH, S_LAST_NAME, S_SSN — borrower (P_) and student (S_) identity attributes.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, ORG_ID — standard EBS audit and multi-org columns.

Common Use Cases and Queries

Because the table mirrors the LOC's current view of a loan, it is used to reconcile internal origination records against LOC-confirmed data, to report loan pipeline status, and to track origination change acknowledgements.

A typical reconciliation query joins the table to its origination parent:

• SELECT l.LOAN_NUMBER, l.LOAN_STATUS, o.ORIGINATION_ID FROM IGF_SL_LOR_LOC_ALL l, IGF_SL_LOR_ALL o WHERE l.ORIGINATION_ID = o.ORIGINATION_ID;
• Status reporting by batch: filter on ORIG_BATCH_ID and ORIG_BATCH_DATE to analyze origination transmission volumes.
• Award linkage: join on AWARD_ID to IGF_AW_AWARD_ALL to attribute loans back to the underlying award.
• Change-history comparison: join LOAN_ID to IGF_SL_LOR_LOC_HISTORY to detect origination changes over time.

Related Objects

Key related objects, per the documented foreign key relationships, include:

• IGF_SL_LOR_ALL — referenced via ORIGINATION_ID; the parent origination table.
• IGF_AW_AWARD_ALL — referenced via AWARD_ID; the financial aid award record.
• IGF_AP_FA_BASE_REC_ALL — referenced via BASE_ID; the financial aid base record.
• IGF_SL_GUARANTOR — referenced via GUARANTOR_ID.
• IGF_SL_LENDER — referenced via LENDER_ID.
• IGF_SL_LOR_LOC_HISTORY — references this table via LOAN_ID, storing historical state per loan.