Search Results pell_id




Overview
Explore in AI Chat

Overview

The view IGF_AP_FA_SETUP_V is an Oracle E-Business Suite database object owned by the APPS schema within the IGF (Financial Aid) product family. It exposes the financial aid setup configuration used by the institution for federal and state student aid processing. Functionally, the view is a thin projection over a single base table, forwarding institution-level identifiers and processing options such as the Office of Postsecondary Education (OPE) identifier, Pell identifier, DUNS number, and Central Processing System (CSS) identifier.

The view's documentation describes it as derived from FA126_3102439_CS_DP2.doc and marks the underlying reference as Obsolete. Despite this status, the object remains VALID in the dictionary, and its role in reporting and integration persists in environments where legacy financial aid setups have not been migrated. Because the view is a simple SELECT without joins, it is inexpensive to query and is well suited to lookups and reporting joins against other financial aid tables.

Underlying Base Objects

The view is defined entirely over the table IGF_AP_FA_SETUP, aliased as FAS. The ETRM metadata documents no additional referenced base objects, and the view text confirms a single-table projection with no WHERE clause. Every column in the view maps one-to-one to a column in the base table, preserving the original data types and nullability. Consequently, filtering, joining, and sorting behavior is determined by indexing and constraints on IGF_AP_FA_SETUP, and the view introduces no aggregation, function application, or derived expressions that would change the semantics of the underlying data.

Key Columns

Common Use Cases and Queries

A frequent requirement is retrieving the CSS and related federal identifiers for an institution's financial aid setup. The following query returns the setup identifiers by financial aid office:

SELECT fas_id, fao_id, fao_name, party_id,
       ope_id, pell_id, duns_id, css_id
  FROM apps.igf_ap_fa_setup_v
 WHERE css_id IS NOT NULL;

The view is also used to join setup attributes onto transactional financial aid data, for example when populating reports that require the OPE or Pell identifier alongside student award records. Because it is a single-table projection, queries should apply selective predicates on FAO_ID or FAS_ID where possible. Note the metadata's Obsolete designation: implementations should treat this view as a legacy access path and validate the corresponding base table lookup against current financial aid configuration before relying on it for regulatory reporting.