Search Results tot_rep_awd_amt




Overview
Explore in AI Chat

Overview

IGF_GR_REP_SMRY_V is a reporting view belonging to the IGF (Financial Aid) product family, which is documented as obsolete in Oracle EBS Release 12.1.1 and 12.2.2. The view is designed to produce the financial summary tag within the outbound XML payload associated with Pell Grant processing. In the context of the U.S. Department of Education's Common Origination and Disbursement (COD) system, institutions report aggregated award and disbursement figures for Pell-eligible students on a per-entity and per-award-year basis. IGF_GR_REP_SMRY_V serves precisely this aggregation purpose: rather than exposing individual grant records, it rolls up award counts, accepted award amounts, and accepted disbursement amounts into a single summarized row per reporting entity and financial award year. The view is a read-only, reporting-oriented construct rather than a transactional object, and its output is consumed by the ETRM outbound XML generation logic for Pell reporting.

Underlying Base Objects

The documented view text references two IGF source objects. The primary base is IGF_GR_COD_DTLS, aliased LOC1, which holds COD grant detail records keyed by DOCUMENT_ID_TXT, REP_ENTITY_ID_TXT, FIN_AWARD_YEAR, AWARD_ID, and BASE_ID. The second is IGF_AW_DB_COD_DTLS, aliased DISB2, which stores COD disbursement detail, including DISB_ACCEPTED_AMT, linked to the award through AWARD_ID. The view joins these through an inline aggregate subquery (DISB1) that pre-sums accepted disbursement amounts by AWARD_ID, then joins back to LOC1 on AWARD_ID. Because the view nests a derived table, the effective lineage includes three logical data sets even though only two physical tables are named. The ETRM metadata notes that the view is not implemented in the documented database and lists no additional referenced base objects, so any extension of its lineage would require direct inspection of the customer's IGF schema.

Key Columns

  • DOCUMENT_ID_TXT — The COD document identifier text associated with the grant record; part of the grouping key.
  • REP_ENTITY_ID_TXT — The reporting entity identifier, trimmed in the projection; identifies the institution or reporting unit; part of the grouping key.
  • FIN_AWARD_TYPE — A literal value, always 'PELL', identifying the award program.
  • FIN_AWARD_YEAR — The financial aid award year being summarized; part of the grouping key.
  • TOT_CNT_NUM — The count of distinct BASE_ID values, representing the total number of students or base records summarized for the group. This is the column most commonly referenced in search queries.
  • TOT_REP_AWD_AMT — The sum of AWARD_AMT across the grouped records, i.e. total reported award amount.
  • TOT_REP_DISB_AMT — The sum of accepted disbursement amounts derived from the inline DISB1 aggregate, i.e. total reported disbursement amount.

Common Use Cases and Queries

The view is typically queried to validate or extract the summary figures that will populate the Pell financial summary tag prior to XML transmission. A representative query filtering on the reporting entity and award year is:

  • SELECT document_id_txt, rep_entity_id_txt, fin_award_year, tot_cnt_num, tot_rep_awd_amt, tot_rep_disb_amt FROM igf_gr_rep_smr_y_v WHERE rep_entity_id_txt = :entity AND fin_award_year = :year;
  • Reconciliation: compare TOT_CNT_NUM against a count of distinct students in the grant detail tables to confirm no records are dropped by the inner join on AWARD_ID.
  • Disbursement verification: compare TOT_REP_DISB_AMT to the COD disbursement detail to confirm accepted amounts are fully captured.
  • NULL handling checks: because the view uses inner joins, awards with no matching disbursement rows will not appear in the aggregate; verify coverage where expected.

Because the object is obsolete and not implemented in the documented database, any query should be preceded by a check of USER_VIEWS or ALL_VIEWS in the target instance. Where the view is absent, equivalent aggregation must be written directly against IGF_GR_COD_DTLS and IGF_AW_DB_COD_DTLS, preserving the same grouping and literal 'PELL' projection.