Results for “borw_detrm_code”

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

Overview

IGF_SL_LOANS_ALL is the master transaction table for student loan records within the Oracle E-Business Suite Financial Aid module (IGF). It resides in the IGF schema and stores one row per loan application, capturing the full lifecycle of a loan from origination through disbursement, status changes, and servicing. In EBS 12.1.1 and 12.2.2, this table is central to the federal and private student loan processing flows, including Direct Loan (DL) originations, promissory note generation, and disbursement manifests.

From a Data Vault modeling perspective, IGF_SL_LOANS_ALL serves as a hub. It carries a stable business key (LOAN_ID) and is referenced by numerous downstream link and satellite tables such as disbursement manifests, promissory notes, loan origination records, and alternative borrower data. This hub-style classification reflects the table's role as the anchor point for loan identity, with detailed attributes distributed across related satellite structures.

Key Information Stored

The table contains 25 documented columns. The most significant are:

• LOAN_ID — Surrogate primary key (IGF_SL_LOANS_ALL_PK) and the canonical identifier used by all dependent tables.
• LOAN_NUMBER — Business-facing loan number; unique index IGF_SL_LOANS_ALL_U2 enforces uniqueness.
• AWARD_ID — Foreign key to IGF_AW_AWARD_ALL, linking the loan to the underlying financial aid award; unique index IGF_SL_LOANS_ALL_U3 enforces one loan per award.
• SEQ_NUM — Sequence number distinguishing multiple loans within an award context.
• LOAN_PER_BEGIN_DATE / LOAN_PER_END_DATE — Loan period boundaries used for term-based reporting and disbursement scheduling.
• LOAN_STATUS / LOAN_STATUS_DATE — Current loan status and the date it was set.
• LOAN_CHG_STATUS / LOAN_CHG_STATUS_DATE — Prior status and change timestamp, supporting status history tracking.
• ACTIVE / ACTIVE_DATE — Record-level active flag and activation date.
• BORW_DETRM_CODE — Borrower determination code used in eligibility rules.
• ORG_ID — Multi-org operating unit identifier, enabling OU-level security and reporting.
• EXTERNAL_LOAN_ID_TXT — External system loan identifier for integration with Common Origination and Disbursement (COD) or servicers.
• LEGACY_RECORD_FLAG — Marks records migrated from legacy systems.

Standard EBS audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and concurrent program columns (REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE) are also present.

Common Use Cases and Queries

Typical reporting scenarios include loan status dashboards, disbursement reconciliation, promissory note tracking, and award-to-loan cross-verification. A representative query joining the award hub:

SELECT l.loan_id, l.loan_number, l.loan_status, a.award_number
FROM igf_sl_loans_all l, igf_aw_award_all a
WHERE l.award_id = a.award_id
AND l.org_id = :p_org_id
AND l.active = 'Y';

Status history analysis can leverage LOAN_CHG_STATUS and LOAN_CHG_STATUS_DATE to reconstruct transitions. Disbursement reconciliation joins to IGF_SL_DL_MANIFEST_ALL and promissory note tables via LOAN_ID. Integration extracts match on EXTERNAL_LOAN_ID_TXT to reconcile with external servicers.

Related Objects

• IGF_AW_AWARD_ALL — Parent award table; join on AWARD_ID.
• IGF_SL_LOR_ALL — Loan origination records; join on LOAN_ID.
• IGF_SL_DL_MANIFEST_ALL — Direct Loan disbursement manifests; join on LOAN_ID.
• IGF_SL_DL_PNOTE_P_P_ALL and IGF_SL_DL_PNOTE_S_P_ALL — Promissory note tables (parent and student); join on LOAN_ID.
• IGF_SL_ALT_BORW_ALL — Alternative borrower records; join on LOAN_ID.
• IGF_SL_CLCHSN_DTLS — Collection/disbursement details; join on LOAN_NUMBER_TXT to LOAN_ID.

These relationships establish IGF_SL_LOANS_ALL as the authoritative loan hub in the IGF Financial Aid data model.