Search Results igf_gr_cod_dtls_pk

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

• ORIGINATION_ID — the surrogate primary key defined by IGF_GR_COD_DTLS_PK; uniquely identifies each COD record row.
• AWARD_ID — foreign key to IGF_AW_AWARD_ALL, linking the COD detail record to its parent financial aid award.
• DOCUMENT_ID_TXT and BASE_ID — COD document and base identifiers used to correlate the XML submission with federal records.
• FIN_AWARD_YEAR and CPS_TRANS_NUM — the financial aid award year and the CPS transaction number for which the Pell data was reported.
• AWARD_AMT, COA_AMT, SCHD_PELL_AMT, YTD_DISB_AMT, TOT_ELIG_USED, NEG_PEND_AMT, and LOW_TUTION_FEE — the core Pell award, cost of attendance, scheduled, and disbursement amounts transmitted to COD.
• PELL_STATUS and PELL_STATUS_DATE — the COD processing status and the date it was assigned.
• ENROLLMENT_DATE, VER_STATUS_CODE, CPS_VERIF_FLAG, and INCARC_FLAG — enrollment, verification, and incarceration indicators used in eligibility determination.
• S_SSN, S_LAST_NAME, FIRST_NAME, MIDDLE_NAME, S_DATE_OF_BIRTH — student identity fields carried in the COD submission.
• PERMT_ADDR_* columns (line 1–3, city, state, postal code, country, county) — the student's permanent address block.
• EMAIL_ADDRESS, PHONE_NUMBER_1/2/3, and CITZN_STATUS_CODE — contact and citizenship data.
• PROGRAM_APPLICATION_ID, PROGRAM_ID, REQUEST_ID, and PROGRAM_UPDATE_DATE — concurrent program execution context identifying the submission job.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Who columns providing audit lineage.

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.