Search Results loan_chg_status_date




Overview
Explore in AI Chat

Overview

IGF_SL_LOANS is a VALID view owned by the APPS schema within the IGF — Financial Aid product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents loan-level records associated with financial aid awards, exposing the loan identifier, award linkage, disbursement period boundaries, and the full audit and status-tracking columns maintained by the underlying loan table. The view functions as the multi-organization (MOAC) compliant access layer over student loan data, allowing reporting, inquiry, and integration components to retrieve loan records scoped to the operating unit of the current session rather than querying the base table directly.

Because it resolves the organization security predicate at runtime, the view is the preferred object for concurrent programs, OAF pages, and custom reports that must respect organizational access. The search term loan_chg_status corresponds directly to the LOAN_CHG_STATUS column exposed by this view, which records the most recent change-of-status value applied to a loan record.

Underlying Base Objects

The view is defined over a single documented base object, IGF_SL_LOANS_ALL, aliased as LAR in the view text. IGF_SL_LOANS_ALL is the multi-organization table that physically stores loan rows for all operating units; IGF_SL_LOANS filters that table by comparing its ORG_ID against the operating unit derived from the session's CLIENT_INFO value.

The filtering predicate uses USERENV('CLIENT_INFO') with SUBSTRB positioning to extract the ten-character organization identifier, and applies NVL logic on both sides of the comparison so that rows with a null ORG_ID are treated consistently. The literal -99 serves as the fallback value when no organization context is available. This construction is the standard MOAC pattern used throughout the Financial Aid schema. The view is read-only in practical terms: DML must be directed at IGF_SL_LOANS_ALL, and inserts must supply a valid ORG_ID. The ROW_ID column is supplied by LAR.ROWID and provides a physical row locator for the underlying table.

Key Columns

Common Use Cases and Queries

Typical usage includes loan status monitoring, reconciliation against lender files, and extracting loans whose change-of-status indicator has been updated. Because the view enforces organizational context, sessions must initialize CLIENT_INFO before results are meaningful.

  • List loans with a specific change-of-status:
    SELECT loan_id, loan_number, loan_status, loan_chg_status, loan_chg_status_date FROM igf_sl_loans WHERE loan_chg_status = :p_status;
  • Retrieve loans for an award:
    SELECT loan_id, seq_num, loan_status, active FROM igf_sl_loans WHERE award_id = :p_award_id ORDER BY seq_num;
  • Audit loans changed within a date range:
    SELECT loan_id, loan_chg_status, last_updated_by, last_update_date FROM igf_sl_loans WHERE loan_chg_status_date BETWEEN :p_from AND :p_to;

Joins to award and person tables are normally performed on AWARD_ID and LOAN_ID. For updates, applications must target IGF_SL_LOANS_ALL and supply ORG_ID explicitly.