Search Results p_middle_initial




Overview
Explore in AI Chat

Overview

IGF_SL_COD_REP_V is a reporting view owned by the APPS schema within the IGF (Financial Aid) product family of Oracle E-Business Suite. Its documented purpose is to report the various Direct Loan tags required in the outbound XML payload transmitted for Direct Loan processing. In practice, this view functions as a flattened, presentation-ready projection of loan origination and disbursement data, allowing the Financial Aid module to assemble Common Origination and Disbursement (COD) file content without additional application-side joins. The view is reported as VALID and is available in both EBS 12.1.1 and 12.2.2, where it is treated as a read-only reporting object.

Underlying Base Objects

The view text in the 12.2.2 ETRM metadata shows that IGF_SL_COD_REP_V is defined over a single base object: IGF_SL_LOR_LOC_ALL, the loan origination record table (LOC, or logical origination record) for the Financial Aid Direct Loan process. No additional base objects are documented as referenced by the view. Because the definition is a direct SELECT from one table, the view introduces no aggregation or joins; it exists primarily to rename columns into COD-tag-friendly aliases and to apply formatting transformations. Two notable transformations are present: date columns such as LOAN_PER_BEGIN_DATE, LOAN_PER_END_DATE, ACAD_YR_BEGIN_DATE, ACAD_YR_END_DATE, ORIG_BATCH_DATE, B_CHG_BIRTH_DATE, and P_DATE_OF_BIRTH are converted to the ISO 'YYYY-MM-DD' character format, and the recipient middle name is trimmed and reduced to its first character as P_MIDDLE_INITIAL.

Key Columns

The column list maps closely to COD outbound tags and to the identifiers users search on. The loan_number column is exposed as the alias LOAN_NUMBER_TXT, making it the principal column for lookups by loan number. A derived column, FIN_AWD_NUM, is computed as SUBSTR(LOAN_NUMBER, LENGTH(LOAN_NUMBER)-2, LENGTH(LOAN_NUMBER)), effectively extracting the trailing portion of the loan number, which typically corresponds to the financial award sequence referenced by COD. Other prominent columns include:

Because the view exposes the loan number directly, a lookup on LOAN_NUMBER_TXT is sufficient to retrieve all reported tags for a given loan.

Common Use Cases and Queries

Typical use cases include reconciliation of COD outbound content, troubleshooting failed or rejected Direct Loan transmissions, and ad hoc reporting on a specific loan. The following queries illustrate the common patterns:

  • Retrieve the COD-facing attributes for a known loan number:

    SELECT LOAN_NUMBER_TXT, FIN_AWD_NUM, LOAN_TYPE, LOAN_AMT_ACCEPTED, LOAN_STATUS, P_LAST_NAME, P_FIRST_NAME
    FROM  APPS.IGF_SL_COD_REP_V
    WHERE LOAN_NUMBER_TXT = :loan_number;
  • List all active loans for an award or person:

    SELECT LOAN_NUMBER_TXT, AWARD_ID, LOAN_STATUS, LOAN_PER_BEGIN_DATE, LOAN_PER_END_DATE
    FROM  APPS.IGF_SL_COD_REP_V
    WHERE AWARD_ID = :award_id
    AND   LOAN_STATUS = 'A';
  • Inspect origination batch and disclosure indicators:

    SELECT LOAN_NUMBER_TXT, ORIG_BATCH_DATE, PNOTE_PRINT_IND, DISCLOSURE_PRINT_IND, ORIG_FEE_PERCT
    FROM  APPS.IGF_SL_COD_REP_V
    WHERE ORIGINATION_ID IS NOT NULL;

Queries should be issued with the APPS schema context or through a synonym granting read access, and results should be filtered by award year or loan period to limit volume. Because the view performs only formatting, no performance penalty beyond that of the base table IGF_SL_LOR_LOC_ALL is expected.