Search Results full_resp_code




Overview
Explore in AI Chat

Overview

The IGF_GR_COD_TOP_V view is an Oracle E-Business Suite database object owned by the APPS schema within the IGF (Financial Aid) product module. It is a reporting view designed to support the generation of document-level tags in the outbound XML used for Pell Grant processing, specifically supporting the Common Origination and Disbursement (COD) interface. In EBS 12.1.1 and 12.2.2, the Federal Pell Grant program requires institutions to transmit structured data to the U.S. Department of Education's COD system, and this view supplies the top-level identifying elements that accompany the outbound XML payload. The view presents a distinct, de-duplicated set of document identifiers, source entity identifiers, and full responsibility codes, which together form the header context for the transmitted records.

Underlying Base Objects

The view is defined over a single base table, IGF_GR_COD_DTLS, which stores the detailed COD transmission records for financial aid processing. The view text is:

The GROUP BY clause on all three selected expressions ensures the view returns only unique combinations, effectively producing the header-level or "top" record set required for the outbound file. The TRIM functions remove any residual whitespace that may exist in the underlying character columns, ensuring clean values are emitted into the XML. Although the ETRM metadata documents no additional referenced base objects, transactionally the detail table draws its content from the broader IGF financial aid datamodel, including student, award, and disbursement data.

Key Columns

  • DOCUMENT_ID_TXT — A character-format document identifier representing the unique COD document being transmitted. This value anchors the outbound XML record to a specific Pell Grant document instance.
  • SOURCE_ENTITY_ID_TXT — The source entity identifier in text form, typically identifying the reporting institution or originating entity (for example, the school's Federal School Code or entity reference). This is the column most commonly associated with the search term source_entity_id_txt, and it is central to routing and validating the outbound Pell transmission.
  • FULL_RESP_CODE — The full responsibility code that indicates the role or responsibility under which the document is submitted or reported, used by COD to determine processing ownership.

Common Use Cases and Queries

This view is primarily consumed by the outbound XML generation logic for Pell COD reporting, where the top-level document tag must be constructed once per unique document/entity/responsibility combination. A typical diagnostic or extraction query might be:

  • SELECT document_id_txt, source_entity_id_txt, full_resp_code FROM igf_gr_cod_top_v WHERE source_entity_id_txt = :entity_id; — retrieves the driver rows for a specific reporting entity.
  • SELECT COUNT(*) FROM igf_gr_cod_top_v; — counts distinct top-level document records destined for transmission.
  • A join back to IGF_GR_COD_DTLS on all three columns reconstructs the full detail under each header, which is useful when troubleshooting the outbound XML structure or validating that every detail row is correctly grouped under its top-level document tag.

Because the view performs no filtering, it returns all distinct header combinations present in the detail table, making it suitable both for production report generation and for reconciling what will be emitted in the outbound Pell XML.