Search Results igf_sl_cod_top_v

Overview

The view IGF_SL_COD_TOP_V belongs to the IGF product family, historically designated "Financial Aid", which Oracle classifies as obsolete within the E-Business Suite 12.1.1 and 12.2.2 releases. Its documented purpose is to expose the Direct Loan top-level tags that are transmitted to the Common Origination and Disbursement (COD) system, the federal processing platform used for Title IV student aid in the United States. In the integration chain that moves Direct Loan origination and disbursement data from Oracle EBS to COD, the top-level tags form the outer envelope of an outbound message: the document identity, the originating entity, and the response or status code that the COD system returns against that document. The view therefore functions as a narrow, purpose-built projection used by the financial aid interface layer rather than as a general reporting object.

The ETRM record explicitly states that this view is not implemented in the documented database. In practice this means the object may exist only in environments where the legacy IGF financial aid module was installed, and that any reference to it in a 12.1.1 or 12.2.2 instance must be validated against the actual data dictionary before use.

Underlying Base Objects

The view text documented in the ETRM metadata is a grouped select over a single source object:

• IGF_SL_LOR_LOC_ALL — the underlying table supplying document identifiers, source entity identifiers, and full response codes. "SL" indicates the student loan domain and "LOR" the loan origination record area; the "_ALL" suffix conventionally denotes a table holding records across organizations or processing states.

No other referenced base objects are documented, and the view performs no joins. It is a pure aggregation: the three selected columns are passed through a GROUP BY on the identical three columns, which collapses duplicate rows in the source table into a distinct set of document, entity, and response code combinations. This ensures that each COD top-level tag combination is emitted exactly once per interface run, preventing duplicate envelope records in the outbound file.

Key Columns

• DOCUMENT_ID_TXT — the text identifier of the COD document. In the Direct Loan context this corresponds to the document or record identifier that uniquely identifies the origination or disbursement submission to COD.
• SOURCE_ENTITY_ID_TXT — the text identifier of the source entity, that is, the institution or reporting entity from which the document originates. It anchors the tag to the correct school or campus within the COD envelope.
• FULL_RESP_CODE — the full response code associated with the document. This carries the COD acknowledgment or processing result, which downstream financial aid processes use to determine whether a submission was accepted, rejected, or requires correction.

All three columns are character-typed, as indicated by the _TXT suffix on the identifier columns.

Common Use Cases and Queries

Because the view is obsolete and not implemented in the documented database, its practical role is limited to legacy support: diagnosing historic COD extracts, auditing which documents were submitted for a given entity, and reviewing response codes retained from prior processing cycles. A representative query is:

• SELECT document_id_txt, source_entity_id_txt, full_resp_code FROM igf_sl_cod_top_v WHERE source_entity_id_txt = :entity ORDER BY document_id_txt;
• SELECT full_resp_code, COUNT(*) FROM igf_sl_cod_top_v GROUP BY full_resp_code;

Organizations still running the obsolete IGF module should treat these queries as read-only diagnostics. New development should target the replacement financial aid integration objects, since Oracle neither maintains nor supports this view in current 12.2.2 environments.