Results for “igf_sl_rep_as_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGF_SL_REP_AS_V is a reporting view owned by the APPS schema within the Oracle E-Business Suite IGF (Financial Aid) product module. Its documented purpose is to support reporting of the Attending School tag in outbound XML generated for the United States Direct Loan program. In the context of the Title IV federal student aid processing flow, the Attending School represents the institution at which a student borrower is enrolled and is a required data element in Common Origination and Disbursement (COD) file transmissions. This view therefore serves as a presentation layer that isolates the specific identifiers needed to populate that tag, shielding downstream XML generation and reporting logic from the full structure of the underlying loan origination records.

The view carries a status of VALID and is documented in the ETRM repository for Oracle EBS 12.1.1 and 12.2.2. It is a read-only construct with no stored data of its own; all content is derived at query time from its base object.

Underlying Base Objects

The view is defined over a single base object, IGF_SL_LOR_LOC_ALL, which stores loan origination location-level data. The ETRM documentation does not enumerate additional referenced base objects beyond this one. The definition applies TRIM string functions to three character columns and groups by the trimmed results, which has the practical effect of consolidating rows that differ only by leading or trailing whitespace and eliminating duplicate combinations. Because the base object is a loan origination location table, the view inherits its data currency directly from that table; no materialization, snapshot, or scheduled refresh is involved.

Key Columns

• ATD_ENTITY_ID_TXT — The Attending School entity identifier in character form. This is the value mapped to the Attending School tag in the outbound Direct Loan XML.
• REP_ENTITY_ID_TXT — The reporting entity identifier in character form, identifying the entity responsible for the submission. This is the column most directly associated with the search term rep_entity_id_txt.
• DOCUMENT_ID_TXT — The document identifier in character form, associating the entity pair with a specific COD document or submission record.

All three columns are returned as trimmed character strings. Because the view is a grouped projection, there is no primary key and rows may repeat in the base table while appearing once in the view.

Common Use Cases and Queries

Typical usage involves verifying that the correct Attending School and reporting entity identifiers will be emitted during COD file generation, or reconciling those identifiers against institutional reference data. The following query retrieves all distinct combinations:

SELECT atd_entity_id_txt, rep_entity_id_txt, document_id_txt FROM apps.igf_sl_rep_as_v;

To isolate the reporting entity for a specific document:

SELECT rep_entity_id_txt FROM apps.igf_sl_rep_as_v WHERE document_id_txt = :document_id;

A join to reference tables on the trimmed entity identifier is also common when validating that the Attending School code exists in the institution setup. Because the view performs no filtering, callers should apply the appropriate predicate for the reporting period or document under investigation.