Search Results full_resp_code




Overview
Explore in AI Chat

Overview

IGF_SL_COD_TOP_V is a reporting view in the Oracle E-Business Suite (EBS) Grants Management (IGF) module, belonging to the student loan and grants sub-ledger object family. Its name, combining "SL" (student loan) and "COD_TOP," reflects its role in surfacing coded top-level responsibility and source-assignment information documented in the ETRM repository under version 12.2.2. The view presents a distinct, de-duplicated list of document identifiers, source entity identifiers, and full responsibility codes drawn from the underlying grants transaction data. Because grants and student loan processing generate large volumes of coded transactions, this view is designed to feed reporting, reconciliation, and integration routines that require a clean, grouped projection of the responsibility coding applied at the source-document level.

In the EBS reporting and integration layer, such views are commonly referenced by concurrent programs, Oracle XML Publisher (BI Publisher) report templates, and outbound interfaces that export grants data to downstream systems. The view provides a stable, read-only surface that abstracts column naming and filtering/grouping logic from the application's base tables, which is the standard pattern for ETRM and Grants Management views.

Underlying Base Objects

The view text documented in the ETRM metadata is concise and explicit:

The sole referenced base object is IGF_SL_LOR_LOC_ALL, a sub-ledger "line of responsibility / location" style table whose ALL suffix conventionally indicates a table containing multiple organization or responsibility records without an operating-unit filter. Although the ETRM "documented base objects" field lists none, the embedded view text confirms IGF_SL_LOR_LOC_ALL as the definitive source. No joins are present, meaning the view is a pure projection with a GROUP BY clause applied to eliminate duplicate rows. The absence of joins makes the view inexpensive to query and easy to reason about, since every exposed value originates directly from a single column in the base table.

Key Columns

  • DOCUMENT_ID_TXT — The text representation of the grants or student loan document identifier. Used to correlate the responsibility record back to its originating transaction, award, or loan document.
  • SOURCE_ENTITY_ID_TXT — The text representation of the source entity identifier, typically the responsibility or entity (such as a student, institution, or program) from which the coded transaction originates.
  • FULL_RESP_CODE — The complete responsibility code associated with the transaction. This is the column matching the user's search term "full_resp_code"; it carries the fully qualified grant or funding responsibility value used for classification and reporting.

The combination of these three attributes, enforced by the GROUP BY, produces a unique set of coded responsibility rows per document and source entity.

Common Use Cases and Queries

Typical uses include validating that each document carries the expected responsibility code, exporting a distinct responsibility list for reconciliation, and driving parameter lists (LOVs) in concurrent programs. A representative query filtered on the searched column is:

  • SELECT document_id_txt, source_entity_id_txt, full_resp_code FROM apps.igf_sl_cod_top_v WHERE full_resp_code = :p_resp_code;
  • SELECT full_resp_code, COUNT(*) FROM apps.igf_sl_cod_top_v GROUP BY full_resp_code ORDER BY full_resp_code;
  • SELECT * FROM apps.igf_sl_cod_top_v WHERE document_id_txt = :p_document_id;

Because the view already applies GROUP BY and exposes no operating-unit column, callers requiring organization-level filtering must join back to IGF_SL_LOR_LOC_ALL or a related table. All access should be read-only via the APPS schema.