Search Results igf_sl_lor_loc_all




Overview
Explore in AI Chat

Overview

The table IGF_SL_LOR_LOC_ALL is a core data repository within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). It serves as the system of record for all loan data at the precise moment of origination or when changes to an origination are transmitted to the Loan Origination Center (LOC). As per its documented description, this table always reflects the current data held in the LOC, making it the authoritative source for the most recent loan terms, amounts, and statuses as communicated to the external loan servicer. Its role is critical for tracking the lifecycle of student loans from the point they are officially originated and for maintaining synchronization between the institutional financial aid system and federal or private loan processors.

Key Information Stored

The table's structure is designed to uniquely identify and store comprehensive loan origination records. The primary keys and foreign keys outlined in the metadata reveal its critical data elements. The table uses a composite primary key (IGF_SL_LOR_LOC_ALL_PK) on LOAN_ID, ensuring each loan record is unique. Furthermore, it has a unique constraint (IGF_SL_LOR_LOC_ALL_U1/UK) on the ORIGINATION_ID column, which is the specific identifier for each distinct origination transaction or change sent to the LOC. Key columns include LOAN_ID, which links to the broader loan record, and ORIGINATION_ID, which is a foreign key to the IGF_SL_LOR_ALL table and serves as the transaction identifier. Other significant foreign keys are AWARD_ID, linking to the IGF_AW_AWARD_ALL table to associate the loan with a specific financial aid award, and BASE_ID, linking to IGF_AP_FA_BASE_REC_ALL to connect the loan to the student's base financial aid record.

Common Use Cases and Queries

A primary use case is auditing and reconciling the data sent to the Loan Origination Center. Users can query this table to verify the exact loan details (e.g., amount, interest rate, period) for a specific origination event. Given the user's search for "origination_id," a common query pattern involves retrieving all LOC data for a particular origination transaction or for a specific loan across all its origination events. For reporting, this table is essential for generating origination summaries, discrepancy reports between the EBS system and LOC data, and tracking the history of changes sent for a loan.

  • Retrieve all LOC data for a specific ORIGINATION_ID: SELECT * FROM igf.igf_sl_lor_loc_all WHERE origination_id = :1;
  • Find the most recent LOC record for a specific loan: SELECT * FROM igf.igf_sl_lor_loc_all WHERE loan_id = :1 ORDER BY creation_date DESC;
  • Join with the award table to report originated loan amounts by student and award year.

Related Objects

IGF_SL_LOR_LOC_ALL is centrally connected to several key Financial Aid tables, as defined by its foreign key constraints. Its most direct relationship is with IGF_SL_LOR_ALL via the ORIGINATION_ID column, which holds the master origination header information. It links to the core award (IGF_AW_AWARD_ALL) and base application (IGF_AP_FA_BASE_REC_ALL) tables to provide student and award context for the originated loan. Furthermore, it has a one-to-many relationship with the IGF_SL_LOR_LOC_HISTORY table, which likely stores a historical audit trail of changes to the LOC data, with HISTORY.LOAN_ID referencing the LOAN_ID in this table.

  • Table: IGF_SL_LOR_LOC_ALL 12.1.1

    owner:IGF,  object_type:TABLE,  fnd_design_data:IGF.IGF_SL_LOR_LOC_ALL,  object_name:IGF_SL_LOR_LOC_ALL,  status:VALID,  product: IGF - Financial Aid ,  description: Contains all the loan data for each loan at the time of origination/origination changes were sent. This always reflects the data currently in the Loan Origination Center. ,  implementation_dba_data: IGF.IGF_SL_LOR_LOC_ALL , 

  • View: IGF_SL_REP_SMRY_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGF.IGF_SL_REP_SMRY_V,  object_name:IGF_SL_REP_SMRY_V,  status:VALID,  product: IGF - Financial Aid ,  description: View used for reproting the financial summary tag in the outbound XML for Direct Loan ,  implementation_dba_data: APPS.IGF_SL_REP_SMRY_V , 

  • View: IGF_SL_REP_RS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGF.IGF_SL_REP_RS_V,  object_name:IGF_SL_REP_RS_V,  status:VALID,  product: IGF - Financial Aid ,  description: View used for reporting the Common Record tag in the outbound XML for Direct Loan ,  implementation_dba_data: APPS.IGF_SL_REP_RS_V , 

  • View: IGF_SL_REP_AS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGF.IGF_SL_REP_AS_V,  object_name:IGF_SL_REP_AS_V,  status:VALID,  product: IGF - Financial Aid ,  description: View used for reporting the Attending School tag in the outbound XML for Direct Loan ,  implementation_dba_data: APPS.IGF_SL_REP_AS_V , 

  • View: IGF_SL_COD_TOP_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGF.IGF_SL_COD_TOP_V,  object_name:IGF_SL_COD_TOP_V,  status:VALID,  product: IGF - Financial Aid ,  description: View containing the Direct Loan Top level tags to be sent to COD ,  implementation_dba_data: APPS.IGF_SL_COD_TOP_V , 

  • Table: IGF_SL_LOR_LOC_HISTORY 12.1.1

    owner:IGF,  object_type:TABLE,  fnd_design_data:IGF.IGF_SL_LOR_LOC_HISTORY,  object_name:IGF_SL_LOR_LOC_HISTORY,  status:VALID,  product: IGF - Financial Aid ,  description: Loans History Table. This table stores the information that is sent out to external agencies for processing ,  implementation_dba_data: IGF.IGF_SL_LOR_LOC_HISTORY , 

  • Table: IGF_SL_LOR_ALL 12.1.1

    owner:IGF,  object_type:TABLE,  fnd_design_data:IGF.IGF_SL_LOR_ALL,  object_name:IGF_SL_LOR_ALL,  status:VALID,  product: IGF - Financial Aid ,  description: Contains origination details of loan application records ,  implementation_dba_data: IGF.IGF_SL_LOR_ALL , 

  • Table: IGF_AP_FA_BASE_REC_ALL 12.1.1

    owner:IGF,  object_type:TABLE,  fnd_design_data:IGF.IGF_AP_FA_BASE_REC_ALL,  object_name:IGF_AP_FA_BASE_REC_ALL,  status:VALID,  product: IGF - Financial Aid ,  description: Holds the summarized information of all the financial aid processes for a student for an academic year ,  implementation_dba_data: IGF.IGF_AP_FA_BASE_REC_ALL , 

  • View: IGF_SL_COD_LOANKEY_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGF.IGF_SL_COD_LOANKEY_V,  object_name:IGF_SL_COD_LOANKEY_V,  status:VALID,  product: IGF - Financial Aid ,  description: View containing the Loan Key level tags ,  implementation_dba_data: APPS.IGF_SL_COD_LOANKEY_V , 

  • Table: IGF_AW_AWARD_ALL 12.1.1

    owner:IGF,  object_type:TABLE,  fnd_design_data:IGF.IGF_AW_AWARD_ALL,  object_name:IGF_AW_AWARD_ALL,  status:VALID,  product: IGF - Financial Aid ,  description: Stores all details of awards given to students ,  implementation_dba_data: IGF.IGF_AW_AWARD_ALL , 

  • View: IGF_SL_COD_REP_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGF.IGF_SL_COD_REP_V,  object_name:IGF_SL_COD_REP_V,  status:VALID,  product: IGF - Financial Aid ,  description: View used for reporting the various Direct Loan tags in the outbound XML for Direct Loan ,  implementation_dba_data: APPS.IGF_SL_COD_REP_V , 

  • View: IGF_SL_REP_STDNT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGF.IGF_SL_REP_STDNT_V,  object_name:IGF_SL_REP_STDNT_V,  status:VALID,  product: IGF - Financial Aid ,  description: View used for reporting the Student tag in the outbound XML for Direct Loan ,  implementation_dba_data: APPS.IGF_SL_REP_STDNT_V , 

  • View: IGF_SL_LOR_LOC 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGF.IGF_SL_LOR_LOC,  object_name:IGF_SL_LOR_LOC,  status:VALID,  product: IGF - Financial Aid ,  implementation_dba_data: APPS.IGF_SL_LOR_LOC ,