Search Results acad_yr_begin_date




Overview
Explore in AI Chat

Overview

IGF_SL_COD_LOANKEY_V is a reporting view in the Oracle E-Business Suite (EBS) financial aid module, belonging to the IGF (Financial Aid) schema and exposed under the APPS application schema. It presents loan key configuration data that governs the origination and disclosure of student loan records within the Oracle Student Financial Aid (SFAS) functionality. The view consolidates document-level loan key attributes — including entity identifiers, base identifiers, loan keys, rebate percentages, loan and academic period dates, print indicators, origination fee percentages, and grade level codes — into a single read-consistent result set suitable for reporting, integration, and downstream processing.

The view's primary role is to provide a denormalized, group-consistent presentation of loan key parameters so that reports, interfaces, and dependent logic can retrieve one representative row per distinct combination of loan attributes. Because it applies a GROUP BY across every projected column, it effectively performs a DISTINCT operation, filtering out duplicate rows from the underlying source while preserving all documented columns.

Underlying Base Objects

The view text defines a single base object: IGF_SL_LOR_LOC_ALL, an intersection and location table storing student loan origination and location information. All columns exposed by IGF_SL_COD_LOANKEY_V are projected directly from this table — no joins, unions, or subqueries appear in the documented definition. The GROUP BY clause lists the same fourteen columns that appear in the SELECT list, so the view does not aggregate numeric or date values; rather, it deduplicates identical rows.

Documented ETRM metadata for this view records no additional referenced base objects beyond IGF_SL_LOR_LOC_ALL. Because the view is owned by APPS in typical EBS deployments, access is granted through the APPS schema synonym or direct grants. The base table itself is populated as part of the loan origination lifecycle, and the view therefore reflects the current state of loan key data at query time.

Key Columns

Common Use Cases and Queries

The view is typically used to report loan key parameters by base identifier, entity, or loan key, and to drive promissory note and disclosure printing logic based on the PNOTE_PRINT_IND and DISCLOSURE_PRINT_IND flags. A common query filters by BASE_ID to retrieve the loan configuration tied to a specific base record:

  • SELECT DOCUMENT_ID_TXT, BASE_ID, LOAN_KEY_NUM, GRADE_LEVEL_CODE FROM APPS.IGF_SL_COD_LOANKEY_V WHERE BASE_ID = :p_base_id;
  • SELECT BASE_ID, LOAN_PER_BEGIN_DATE, LOAN_PER_END_DATE, ORIG_FEE_PERCT FROM APPS.IGF_SL_COD_LOANKEY_V WHERE PNOTE_PRINT_IND = 'Y';
  • SELECT SOURCE_ENTITY_ID_TXT, COUNT(*) FROM APPS.IGF_SL_COD_LOANKEY_V GROUP BY SOURCE_ENTITY_ID_TXT;

These queries support reporting, reconciliation, and interface extracts where loan key attributes must be retrieved per base identifier or entity.