Search Results im_p_opt_elem_sec_tuit




Overview
Explore in AI Chat

Overview

The IGF_AP_CSS_FNAR view is a Financial Aid module database object owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. Its documented purpose is to retrieve Financial Need Analysis Report (FNAR) information as collected through the College Board's CSS/Profile data submission. The view consolidates need-analysis attributes that describe a student's family circumstances, dependency status, and calculated need, alongside two parallel sets of parental income and asset computation columns—one reflecting a "base" methodology (prefixed IM_P_BAS_) and one reflecting an "optional" methodology (prefixed IM_P_OPT_).

In practice, the view functions as a reporting and integration surface. Rather than forcing downstream consumers to reach directly into the CSS Profile staging or transactional tables, the view presents a denormalized, report-ready projection. This is consistent with the ETRM classification of the object as a VALID view under the IGF – Financial Aid product, and it places the view in the family of College Board integration objects used by institutions to reconcile institutional need-analysis results with the ISIR and institutional methodology outputs.

Underlying Base Objects

The ETRM metadata for release 12.2.2 records no documented referenced base objects for this view. The published view text confirms that it is a single-table projection rather than a join: the SELECT list is composed entirely of direct column references plus ROWID, with no joins, unions, or subqueries visible in the excerpted definition. The leading identifiers—FNAR_ID, CSSP_ID, and the surrounding descriptive columns—indicate the underlying table is a Financial Need Analysis Report entity keyed by a surrogate identifier, with a foreign key relationship (CSSP_ID) to the related CSS Profile record.

Because the SQL is not schema-qualified in the excerpt and no base object is documented, the precise physical table name is not authoritative from the metadata provided. What is authoritative is the structural relationship: the view adds no logic and exists as a column-level exposure of the underlying FNAR storage, which means any column added to the base entity can be surfaced here without transformation.

Key Columns

The columns exposed by IGF_AP_CSS_FNAR divide into four practical groups.

Common Use Cases and Queries

The view supports need-analysis reporting, institutional methodology verification, and interface extracts feeding student financial planning or packaging. A typical query retrieves the report identity and key computed need figures for a given student:

  • SELECT FNAR_ID, CSSP_ID, COMP_CSS_DEPENDENCY_STATUS FROM IGF_AP_CSS_FNAR WHERE CSSP_ID = :p_cssp_id;
  • SELECT FNAR_ID, IM_P_BAS_AVAIL_INCOME, IM_P_BAS_TOTAL_CONT, IM_P_OPT_AVAIL_INCOME, IM_P_OPT_TOTAL_CONT FROM IGF_AP_CSS_FNAR WHERE FNAR_ID = :p_fnar_id;

The second pattern is the most common reconciliation use case, comparing base and optional methodology outcomes. Users searching for the term "im_inst_1_tot_expenses" are seeking an instance-level expense total within the institutional methodology calculation; that specific column does not appear in the published view text for IGF_AP_CSS_FNAR. Only the IM_P_BAS_ and IM_P_OPT_ parental prefixes are documented. The institutional (student-side) computation columns are therefore expected in a companion view or the underlying FNAR entity rather than in this view, and the FNAR_ID or CSSP_ID from this view serves as the join key to reach them.