Search Results igf_ap_css_fnar_all




Overview
Explore in AI Chat

Overview

The IGF_AP_CSS_FNAR_ALL table is a core data repository within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). It serves the critical function of storing detailed information from the Financial Need Analysis Report (FNAR), which is a key component of the financial aid assessment process. This report data is typically received alongside a student's College Board PROFILE information, a standardized financial aid application used by many institutions. The table's role is to persist this analyzed need data, enabling the institution to calculate and manage financial aid awards based on a standardized assessment of a student's financial situation. As an "ALL" table, it is designed to store data across multiple operating units, supporting the multi-org architecture of Oracle EBS.

Key Information Stored

While the provided metadata does not list specific columns, the table's primary purpose dictates the nature of its data. Based on its description, the table holds the calculated results and detailed breakdowns from the need analysis process. The primary key column, FNAR_ID, uniquely identifies each Financial Need Analysis Report record. The critical foreign key column, CSSP_ID, links each FNAR record to its source College Board PROFILE data in the IGF_AP_CSS_PROFILE_ALL table. Other columns would typically store calculated figures such as the student's expected family contribution (EFC), adjusted available income, total assessed need, and various allowances and assessments defined by the institutional methodology.

Common Use Cases and Queries

This table is central to financial aid packaging and reporting workflows. Common use cases include generating institutional reports on aggregate financial need, driving automated packaging rules based on calculated need, and providing auditors with a traceable record of the need analysis outcome for each applicant. A fundamental query involves joining the FNAR data to the student's PROFILE and base application information to review the complete financial picture.

Sample SQL Pattern:
SELECT s.FULL_NAME, p.PROFILE_ID, f.*
FROM IGF_AP_CSS_FNAR_ALL f,
IGF_AP_CSS_PROFILE_ALL p,
IGF_AP_FA_BASE_ALL b,
FND_USER s
WHERE f.CSSP_ID = p.CSSP_ID
AND p.BASE_ID = b.BASE_ID
AND b.PERSON_ID = s.USER_ID
AND b.AWARD_YEAR = '2024-2025';

Related Objects

The table maintains a direct and essential relationship with the PROFILE data table, as documented in the provided foreign key metadata.

  • Primary Key: IGF_AP_CSS_FNAR_PK on column FNAR_ID.
  • Foreign Key Relationship: The table IGF_AP_CSS_FNAR_ALL references the table IGF_AP_CSS_PROFILE_ALL via the foreign key column CSSP_ID. This ensures every Financial Need Analysis Report is associated with a specific PROFILE submission.

Consequently, this table is a child of IGF_AP_CSS_PROFILE_ALL and is a likely source for views and packages responsible for financial aid calculation and award letter generation within the IGF module.