Search Results igf_gr_cod_dtls




Overview
Explore in AI Chat

Overview

IGF_GR_COD_DTLS is a Financial Aid (IGF) transaction table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores Pell Grant records transmitted to the Common Origination and Disbursement (COD) system in XML file format. It functions as the staging and audit repository for outbound COD Pell submissions, capturing origination-level award data, CPS transaction information, disbursement amounts, and student demographic attributes required by the U.S. Department of Education's COD interface.

From a Data Vault modeling perspective, the heuristic classification of this table is satellite-leaning. Its structure centers on descriptive, context-rich attributes (award amounts, enrollment dates, address and identity fields) attached to a business key represented by the award relationship, with the surrogate primary key acting as a technical identifier rather than a true hub. The table therefore behaves less like a hub of independent business entities and more like a descriptive satellite of award and origination activity.

Key Information Stored

The documented physical schema contains 60 columns. ORIGINATION_ID is the only documented unique index and therefore the sole business-key candidate; other identifiers such as DOCUMENT_ID_TXT and BASE_ID are attributes rather than guaranteed unique keys.

Common Use Cases and Queries

Typical scenarios include reconciling Pell origination submissions against COD acknowledgements, auditing which awards were transmitted in a given award year, and producing financial aid reporting extracts for disbursement and eligibility reviews.

  • Retrieving all COD detail rows for a specific award: SELECT * FROM IGF.IGF_GR_COD_DTLS WHERE AWARD_ID = :award_id;
  • Auditing submissions for an award year: SELECT ORIGINATION_ID, AWARD_ID, CPS_TRANS_NUM, PELL_STATUS, AWARD_AMT FROM IGF.IGF_GR_COD_DTLS WHERE FIN_AWARD_YEAR = :year;
  • Joining to the parent award for student context: SELECT d.ORIGINATION_ID, a.STUDENT_ID, d.SCHD_PELL_AMT FROM IGF.IGF_GR_COD_DTLS d JOIN IGF.IGF_AW_AWARD_ALL a ON a.AWARD_ID = d.AWARD_ID;
  • Tracking concurrent program runs: filtering on REQUEST_ID or PROGRAM_ID to diagnose failed or partial XML transmissions.
  • Verification and status reporting: grouping by PELL_STATUS and PELL_STATUS_DATE to monitor COD response turnaround.

Related Objects

  • IGF_AW_AWARD_ALL — the parent award table; joined via IGF_GR_COD_DTLS.AWARD_ID = IGF_AW_AWARD_ALL.AWARD_ID, the only documented foreign key relationship.
  • IGF_GR_COD_DTLS_PK — the primary key index on ORIGINATION_ID, enforcing row uniqueness.
  • CPS and COD interface programs within the IGF module that populate this table during Pell origination processing.
  • Concurrent program definitions referenced through PROGRAM_APPLICATION_ID, PROGRAM_ID, and REQUEST_ID, enabling traceability to the originating submission job.
  • Financial aid disbursement and award reporting views that consume IGF_GR_COD_DTLS as a source of transmitted Pell amounts.

Oracle proprietary and confidential information — refer to official ETRM documentation and legal notices for authoritative guidance.