Search Results fsa_code_1

Overview

IGF_GR_RESP_DTLS_V is a reporting view within the Oracle E-Business Suite IGF (Financial Aid) product family, historically associated with the U.S. Department of Education Pell Grant processing flow. Its documented purpose is to present Pell response detail records received from the federal Common Origination and Disbursement (COD) system and the Central Processing System (CPS). The view consolidates the four-tier hierarchy of a Pell response document — the top-level COD response document, the reporting-school response, the attended-school response, and the individual student response — into a single flat rowset, joined to the grant-level Pell response detail table IGF_GR_RESP_DTLS.

In ETRM metadata for 12.2.2 the view is flagged as obsolete and is documented as "Not implemented in this database." This status is significant: the view is retained as reference documentation for legacy implementations rather than as a live object in current releases. Institutions that ran earlier IGF Financial Aid releases, or that migrated data forward, may still encounter references to it in custom reports, extracts, and reconciliation scripts.

The user query "fin_awd_yr" maps directly to the FIN_AWD_YR column exposed by this view. FIN_AWD_YR is the Financial Aid Award Year — the federal award year designator (for example, 2012 for the 2012–2013 processing cycle) used to key Pell records to a specific funding period.

Underlying Base Objects

The view is defined over five IGF base tables joined on their natural parent-child keys:

• IGF_SL_CR_RESP_DTLS (alias CR) — the COD response document header, keyed by DOCUMENT_ID_TXT.
• IGF_SL_RS_RESP_DTLS (alias RS) — the reporting-school response block, joined to CR on DOCUMENT_ID_TXT.
• IGF_SL_AS_RESP_DTLS (alias AST) — the attended-school response block, joined to RS on REP_SCHL_RESP_ID.
• IGF_SL_ST_RESP_DTLS (alias ST) — the student response block, joined to AST on ATD_SCHL_RESP_ID.
• IGF_GR_RESP_DTLS (alias GR) — the grant (Pell) response detail, joined to ST on STDNT_RESP_ID.

The join chain therefore enforces a strict document → reporting school → attended school → student → grant traversal. No additional base objects are documented in the ETRM metadata for 12.2.2.

Key Columns

• DOCUMENT_ID_TXT — the unique COD document identifier linking the response hierarchy.
• FIN_AWD_YR — the Pell award year, the primary filter for period-specific reporting.
• PELL_RESP_ID — surrogate key of the grant-level Pell response row.
• CPS_TRANS_NUM / HIGH_CPS_TRANS_NUM — CPS transaction numbers used to sequence ISIR corrections.
• S_SSN, FIRST_NAME, S_LAST_NAME, S_DATE_OF_BIRTH — student identifiers from the student response block.
• AWARD_AMT, COA_AMT, SCHD_PELL_AMT, YTD_DISB_AMT, TOT_ELIG_USED, NEG_PEND_AMT — award, cost of attendance, scheduled, disbursed, and pending amounts.
• LOW_TUTION_FEE, INCARC_FLAG, ENROLLMENT_DATE, SEC_EFC_CODE, VER_STATUS_CODE, CPS_VERIF_FLAG — eligibility and verification attributes.
• FSA_CODE_1/2/3 — Federal School Codes associated with the response.
• RESP_CODE columns — response status at each hierarchy level (rep, attended, student, Pell).

Common Use Cases and Queries

Typical usage centres on reconciling Pell award years, validating CPS transaction sequencing, and auditing disbursement amounts against scheduled awards.

• Extract all Pell responses for a specific award year.
• List students with a verification flag but no response code.
• Compare scheduled versus disbursed amounts.
• Trace a document through all four hierarchy levels.

Sample SQL:

• SELECT FIN_AWD_YR, S_SSN, FIRST_NAME, S_LAST_NAME, AWARD_AMT, YTD_DISB_AMT FROM IGF_GR_RESP_DTLS_V WHERE FIN_AWD_YR = '2012';
• SELECT DOCUMENT_ID_TXT, PELL_RESP_ID, CPS_TRANS_NUM, SCHD_PELL_AMT, TOT_ELIG_USED FROM IGF_GR_RESP_DTLS_V WHERE CPS_VERIF_FLAG = 'Y';
• SELECT FIN_AWD_YR, COUNT(*), SUM(AWARD_AMT) FROM IGF_GR_RESP_DTLS_V GROUP BY FIN_AWD_YR ORDER BY FIN_AWD_YR;

Because the view is documented as obsolete and not implemented in 12.2.2, any query should first confirm object existence in ALL_VIEWS before execution.