Search Results igf_gr_resp_dtls_pk

Overview

The IGF_GR_RESP_DTLS table resides in the IGF schema and belongs to the IGF - Financial Aid product within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the Pell Record Response Elements parsed from the response XML file returned by the Common Origination and Disbursement (COD) system. Each row captures the federal Pell Grant response data associated with a student's grant record, providing institutions with the authoritative award amounts, disbursement eligibility, verification status, and edit codes issued by the U.S. Department of Education.

The table is keyed by the primary key constraint IGF_GR_RESP_DTLS_PK on PELL_RESP_ID, a surrogate identifier generated by the application. Based on the documented foreign key structure, the object exhibits hub-leaning characteristics under a Data Vault modeling heuristic: it holds a stable, uniquely identified business entity (the Pell response) referenced by dependent tables. In practice, however, the table also carries numerous descriptive attributes, so it may be modeled more accurately as a hybrid hub with satellite-like payload columns. This classification is offered as a modeling suggestion only, not a mandated design.

Key Information Stored

The table contains 32 columns. The most significant are summarized below. PELL_RESP_ID serves as the surrogate primary key and the target of inbound foreign keys. STDNT_RESP_ID links the record to the student-level response structure and is itself a documented foreign key column. FIN_AWD_YR identifies the financial aid award year, while CPS_TRANS_NUM and HIGH_CPS_TRANS_NUM record the CPS transaction number and its high-water mark, which drive Pell recalculation tolerance logic.

• AWARD_AMT, SCHD_PELL_AMT, COA_AMT, LOW_TUTION_FEE — core award, scheduled Pell, cost of attendance, and tuition/fee amounts used in payment calculations.
• YTD_DISB_AMT, TOT_ELIG_USED, NEG_PEND_AMT — year-to-date disbursed amount, total eligibility consumed, and negative pending amounts.
• VER_STATUS_CODE, CPS_VERIF_FLAG, INCARC_FLAG — verification status, CPS verification flag, and incarceration indicator affecting eligibility.
• SEC_EFC_CODE, ENROLLMENT_DATE — secondary EFC code and enrollment date.
• FSA_CODE_1 through FSA_CODE_3 — Federal Student Aid codes associated with the response.
• RESP_CODE, STATUS_CODE, NOTE_MESSAGE — response disposition, processing status, and message text.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

Typical usage centers on reconciliation of Pell awards, verification reporting, and audit of COD responses. A standard query returns all response elements for a given student aid year:

• SELECT pell_resp_id, cps_trans_num, award_amt, schd_pell_amt, ver_status_code, status_code FROM igf.igf_gr_resp_dtls WHERE fin_award_yr = :year AND stdnt_resp_id = :resp_id;
• Comparing YTD_DISB_AMT against TOT_ELIG_USED to detect over-disbursement or remaining eligibility.
• Filtering on INCARC_FLAG, VER_STATUS_CODE, or CPS_VERIF_FLAG to build exception reports for financial aid compliance review.
• Joining to results tables to trace edit rejections affecting the response.

Related Objects

The table participates in the following documented relationships:

• IGF_GR_DB_RESP_DTLS — references IGF_GR_RESP_DTLS.PELL_RESP_ID, holding detail-level disbursement response data.
• IGF_SL_ED_PRC_RSLTS — references IGF_GR_RESP_DTLS.EDIT_ID, storing edit processing results generated against the response.
• IGF_GR_RESP_DTLS.STDNT_RESP_ID — the outbound reference tying each Pell response to its parent student response record.

These relationships confirm the table's role as a central hub linking student-level responses to their disbursement details and validation outcomes within the Financial Aid module.