Search Results igf_sl_lor_all




Overview
Explore in AI Chat

Overview

The IGF_SL_LOR_ALL table is a core data repository within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). It is a multi-org enabled table, as indicated by the "_ALL" suffix, designed to store the origination details for student loan application records. This table serves as a critical junction point in the loan lifecycle, capturing the formal initiation and key contractual parameters of a loan. Its role is to persist data generated during the loan origination process, linking the core loan record to associated parties and downstream processes such as promissory note tracking and location-specific origination data.

Key Information Stored

The table's primary purpose is to manage the origination lifecycle of a loan, which is reflected in its key columns and constraints. The central identifier is the ORIGINATION_ID, which serves as the table's primary key (IGF_SL_LOR_ALL_PK). Each origination record is fundamentally tied to a specific loan via the LOAN_ID column, which is both a foreign key to the IGF_SL_LOANS_ALL table and a unique key (IGF_SL_LOR_ALL_U1, IGF_SL_LOR_ALL_UK). This enforces a direct one-to-one or one-to-many relationship between a loan and its origination records. The table also establishes relationships to external entities, notably linking to the HZ_PARTIES table for person/party information via the P_PERSON_ID foreign key and to the IGF_SL_CL_RECIPIENT table for defining the recipient relationship via the RELATIONSHIP_CD column.

Common Use Cases and Queries

This table is essential for reporting and auditing the loan origination process. Common use cases include generating origination reports for regulatory compliance, tracking the status of loans in the origination pipeline, and reconciling data sent to external loan servicers or the U.S. Department of Education. A typical query might join this table to the loan master and party tables to retrieve a comprehensive origination summary. For example:

  • SELECT lor.origination_id, lor.loan_id, loan.loan_number, party.party_name FROM igf_sl_lor_all lor, igf_sl_loans_all loan, hz_parties party WHERE lor.loan_id = loan.loan_id AND lor.p_person_id = party.party_id;
  • Another critical use case involves tracing the history of a promissory note, as the table is referenced by the IGF_SL_PNOTE_STAT_H (Promissory Note Status History) table via the LOAN_ID.

Related Objects

The IGF_SL_LOR_ALL table is centrally connected to several other key objects in the Financial Aid schema, as defined by its foreign key relationships. It is a child of the IGF_SL_LOANS_ALL table, drawing its core loan definition. It references the HZ_PARTIES table (TCA - Trading Community Architecture) for borrower/party details and the IGF_SL_CL_RECIPIENT lookup for relationship codes. Furthermore, it acts as a parent table to at least two important objects: the IGF_SL_LOR_LOC_ALL table, which stores location-specific origination details linked by ORIGINATION_ID, and the IGF_SL_PNOTE_STAT_H table, which tracks status changes for promissory notes associated with the loan.