Search Results pell_status_date

Overview

The IGF.IGF_GR_COD_DTLS table is a core staging and archival structure within the Oracle E-Business Suite Financial Aid module (IGF). It stores Pell Grant records that have been transmitted to the Common Origination and Disbursement (COD) system in XML file format. In Oracle EBS 12.1.1 and 12.2.2, this table serves as the persistent record of origination data exchanged with the U.S. Department of Education, capturing the student-level Pell award details required for federal reporting and reconciliation.

The object resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and is registered under FND Design Data as IGF.IGF_GR_COD_DTLS. Based on the foreign key structure — a single reference from AWARD_ID to IGF_AW_AWARD_ALL and a primary key on ORIGINATION_ID — the heuristic Data Vault classification is satellite-leaning. This suggests the table behaves as a descriptive attribute store keyed to an award hub, rather than an independent hub or an associative link. Modelers should treat ORIGINATION_ID as the surrogate primary key and AWARD_ID as the foreign key linking to the award dimension.

Key Information Stored

The table contains 60 documented columns in the 12.1.1 physical schema. The most business-significant columns include:

• ORIGINATION_ID — VARCHAR2(30); the unique identifier for the Pell record and the enforced primary key via IGF_GR_COD_DTLS_PK.
• AWARD_ID — NUMBER; foreign key to IGF_AW_AWARD_ALL, tying the COD record to the local award.
• PELL_STATUS — the Pell record processing status; this is the column most frequently searched (as "pell_status"), reflecting its role in tracking COD acceptance and reconciliation states.
• PELL_STATUS_DATE — the date the Pell status was assigned or last changed.
• BASE_ID — student identifier within the award year.
• FIN_AWARD_YEAR — the award year the record pertains to.
• CPS_TRANS_NUM and HIGH_CPS_TRANS_NUM — ISIR transaction numbers used in award calculation.
• AWARD_AMT — total Pell award amount the student is eligible to receive.
• COA_AMT — cost of attendance used in the Pell calculation.
• VER_STATUS_CODE and CPS_VERIF_FLAG — verification status indicators.
• ENROLLMENT_DATE — first enrollment date in an eligible program for the award year.
• DOCUMENT_ID_TXT — identifier for the transmitted document.
• INCARC_FLAG and LOW_TUTION_FEE — special-condition indicators affecting eligibility.
• REQUEST_ID — links the record to the concurrent request that generated or processed it.

The unique index IGF_GR_COD_DTLS_PK on ORIGINATION_ID establishes the business-key candidate, distinct from the surrogate AWARD_ID relationship.

Common Use Cases and Queries

Typical scenarios include reconciling transmitted Pell records against COD responses and auditing status progression. A representative query retrieves all records for an award year in a given status:

• SELECT ORIGINATION_ID, AWARD_ID, PELL_STATUS, PELL_STATUS_DATE FROM IGF.IGF_GR_COD_DTLS WHERE FIN_AWARD_YEAR = :year AND PELL_STATUS = :status;
• Joining to IGF_AW_AWARD_ALL on AWARD_ID to enrich COD records with local award attributes.
• Filtering by REQUEST_ID to trace records produced by a specific concurrent process.
• Reporting on AWARD_AMT versus COA_AMT for compliance review.

Related Objects

• IGF.IGF_AW_AWARD_ALL — joined via IGF_GR_COD_DTLS.AWARD_ID = IGF_AW_AWARD_ALL.AWARD_ID; the primary parent of the COD detail record.
• IGF_AW_AWARD_ALL related child award and disbursement tables that consume ORIGINATION_ID for downstream COD processing.
• COD transmission and response concurrent programs that write PELL_STATUS and PELL_STATUS_DATE.
• ISIR and verification tables referenced via CPS_TRANS_NUM and BASE_ID.
• FND concurrent request tables linked through REQUEST_ID.