Search Results incarc_flag




Overview
Explore in AI Chat

Overview

APPS.IGF_GR_REP_PELL_V is a reporting view within the Oracle E-Business Suite (EBS) Financial Aid module, part of the Oracle Student System / Grants (IGF) schema associated with the Title IV federal student aid processing architecture. The naming convention indicates its purpose: "GR" denotes the Grants/Financial Aid subsystem, "REP" denotes a reporting construct, and "PELL" identifies the Federal Pell Grant program, the primary need-based grant administered under Title IV of the Higher Education Act in the United States.

The view consolidates Pell Grant award and disbursement detail into a flattened, presentation-ready projection intended for downstream reporting, extract generation, and integration with external systems such as the Common Origination and Disbursement (COD) processing interface. Because the underlying detail is consolidated through an aggregation and normalization layer, the view is best suited for read-only consumption in report definitions, concurrent program extracts, and business intelligence queries rather than for transactional processing.

Underlying Base Objects

The view is defined over a single documented base object, the table IGF_GR_COD_DTLS, which stores Common Origination and Disbursement detail records. Notably, the view does not join to any other documented base table; instead it derives its output entirely from this detail table using a combination of column trimming, decoding, date formatting, and a GROUP BY aggregation.

Among the referenced base objects, no additional tables are documented in the ETRM metadata for this view, which simplifies lineage analysis. The view acts as a light transformation layer over IGF_GR_COD_DTLS: it standardizes text columns with TRIM, normalizes the incarceration indicator into a boolean-style string, and renders the enrollment date as an ISO-8601 date literal. The presence of GROUP BY across every projected expression effectively serves as a DISTINCT operation, eliminating duplicate rows in the source detail set.

Key Columns

The view exposes the following columns, each carrying specific financial aid semantics:

  • DOCUMENT_ID_TXT and REP_ENTITY_ID_TXT — Trimmed identifier fields representing the COD document and reporting entity, used as the key carriers for origination records.
  • ATD_ENTITY_ID_TXT — The Academic/Attendance Entity identifier, distinguishing the institution or location associated with the award.
  • BASE_ID, AWARD_ID, FIN_AWARD_YEAR — Core awarding key: the base record identifier, the specific award identifier, and the financial aid award year.
  • CPS_TRANS_NUM — The Central Processing System transaction number, linking the record to the ISIR/EFC calculation cycle.
  • AWARD_AMT, COA_AMT, LOW_TUTION_FEE — Monetary attributes: Pell award amount, Cost of Attendance, and the low-tuition fee indicator value.
  • NOTE_MESSAGE — A free-text note or comment field carried from the detail record (the column referenced in the user's search term "note_message").
  • INCARC_FLAG — The incarceration indicator, decoded to the strings 'true' or 'false' from the stored 'Y'/'F' values for reporting clarity.
  • VER_STATUS_CODE, SEC_EFC_CODE — Verification status code and secondary Expected Family Contribution code.
  • ENROLLMENT_DATE — The enrollment date, converted to 'YYYY-MM-DD' format.

Common Use Cases and Queries

Typical uses include Pell disbursement reconciliation extracts, COD reporting extracts, and audits that examine award amount versus cost of attendance. Because the view is read-only, queries should avoid DML. A representative query retrieving active Pell records with notes is:

SELECT DOCUMENT_ID_TXT, AWARD_ID, FIN_AWARD_YEAR, AWARD_AMT, COA_AMT, NOTE_MESSAGE, VER_STATUS_CODE, ENROLLMENT_DATE FROM APPS.IGF_GR_REP_PELL_V WHERE FIN_AWARD_YEAR = :p_year AND NOTE_MESSAGE IS NOT NULL ORDER BY DOCUMENT_ID_TXT, AWARD_ID;

Other scenarios include filtering on INCARC_FLAG for special population reporting, joining SEC_EFC_CODE against EFC reference data, and exporting results to the COD file layout. Because GROUP BY across all columns is applied, queries returning broad column sets may incur higher sort costs on large data volumes, and developers should consider filtering early on financial award year or entity identifiers for performance.