Search Results igf_sl_lor_loc




Overview
Explore in AI Chat

Overview

The IGF_SL_LOR_LOC view belongs to the Oracle EBS IGF — Financial Aid product family, a module now classified as Obsolete in current Oracle documentation. In EBS 12.1.1 and 12.2.2, the IGF schema historically supported the administration of Title IV federal student financial aid, including the management of Stafford, PLUS, and consolidated loan records. The IGF_SL_LOR_LOC object is a reporting and integration view whose name can be parsed as "Student Loan — Loan Origination Record — Location." It exposes loan origination data (LOR) joined with location-level context, allowing downstream reporting, extract programs, and interface processes to query consolidated student loan information without navigating the underlying normalized tables directly.

Per the ETRM metadata, the view is documented but not implemented in this database, and no owner or referenced base objects are recorded for the 12.2.2 environment. This is consistent with the retirement of the IGF module, which was superseded by Oracle Student Financial Planning and third-party financial aid systems. Organizations still running legacy IGF code should treat this view as read-only reference metadata.

Underlying Base Objects

The ETRM record explicitly documents none as the referenced base objects, and the view is marked "Not implemented in this database." The view text, however, is fully preserved in the documentation and reveals its composition. The SELECT list is dominated by the alias LORL, indicating the primary source is a loan origination location table (conventionally IGF_SL_LOR_LOC_ALL or a similarly named LOR location entity). The leading LORL.ROWID pseudo-column confirms a single-base-table-driven view rather than a multi-table join, though the alias implies an underlying "LOC" (location) segment separate from the LOR master.

Because the view is not implemented, DBAs cannot inspect its DDL in the data dictionary in the 12.2.2 instance described. Any dependency analysis, impact assessment, or upgrade planning must rely on the documented view text rather than live ALL_VIEWS or ALL_DEPENDENCIES queries.

Key Columns

The view exposes a comprehensive loan origination record. Principal identifiers include LOAN_ID, ORIGINATION_ID, and LOAN_NUMBER. Loan financial attributes include LOAN_TYPE, LOAN_AMT_OFFERED, LOAN_AMT_ACCEPTED, LOAN_PER_BEGIN_DATE, LOAN_PER_END_DATE, ACAD_YR_BEGIN_DATE, and ACAD_YR_END_DATE.

Status and lifecycle tracking columns include LOAN_STATUS, LOAN_STATUS_DATE, LOAN_CHG_STATUS, ORIG_STATUS_FLAG, ORIG_BATCH_ID, and ORIG_ACK_DATE. Promissory note handling is represented extensively by PNOTE_STATUS, PNOTE_ID, PNOTE_ACCEPT_AMT, PNOTE_ACCEPT_DATE, PNOTE_MPN_IND, and signature code/date fields. Guarantor, lender, and recipient data appear through GUARANTOR_ID, LENDER_ID, LEND_STATUS_CODE, BORW_LENDER_ID, RECIPIENT_ID, and RECIPIENT_TYPE. Several columns are returned as literal NULL placeholders, indicating slots reserved for future or conditional data.

Common Use Cases and Queries

In legacy IGF deployments, this view supported financial aid extract reports, lender/guarantor interfaces, and reconciliation of origination batches. A representative query extracting active loans follows:

  • SELECT loan_number, loan_type, loan_amt_offered, loan_status FROM igf_sl_lor_loc WHERE active = 'Y';
  • SELECT origination_id, orig_batch_id, orig_ack_date FROM igf_sl_lor_loc WHERE orig_status_flag = 'A';
  • SELECT loan_id, pnote_status, pnote_accept_date FROM igf_sl_lor_loc WHERE pnote_mpn_ind = 'Y';

Because the object is obsolete and unimplemented, these queries will fail in a current 12.2.2 instance unless the legacy schema has been retained. They remain useful as migration reference for mapping historical loan fields to a replacement system.