Results for “igf_ap_css_fnar_all”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGF.IGF_AP_CSS_FNAR_ALL table is a core operational data store within the Oracle E-Business Suite Financial Aid (IGF) module, available in releases 12.1.1 and 12.2.2. It holds the Financial Need Analysis Report (FNAR) information produced by the College Board's CSS/Profile service, which institutions use to determine a student's eligibility for institutional need-based financial aid. Each row represents a single need-analysis calculation, either baseline or optional, for a specific student and parent configuration submitted through the College Board profile.

The table is exceptionally wide, with 393 documented columns at the 12.1.1 physical schema level, reflecting the depth of the need-analysis algorithm: it captures institutional methodology (IM) results, federal methodology (FM) results, parent and student asset and income components, budget constructs, and narrative message codes returned by the processor.

From a Data Vault modeling perspective, the mined relationship data classifies this object as satellite-leaning. Its structure — a surrogate primary key, a single foreign key to a parent profile entity, and a large body of descriptive measures — is consistent with a satellite attached to the CSS profile hub, rather than a hub or link in its own right.

Key Information Stored

The principal identifier is FNAR_ID, which constitutes the primary key constraint IGF_AP_CSS_FNAR_PK. The unique index IGF_AP_CSS_FNAR_U1 also covers FNAR_ID, while IGF_AP_CSS_FNAR_U2 covers CSSP_ID, making both documented business-key candidates. CSSP_ID is simultaneously the sole documented foreign key to IGF_AP_CSS_PROFILE_ALL. ORG_ID supports multi-organization partitioning.

Among the most business-significant columns:

• FNAR_ID — surrogate primary key for the need-analysis record.
• CSSP_ID — foreign key to the College Board CSS profile; the natural parent link.
• COMP_CSS_DEPENDENCY_STATUS — dependency status used to select the calculation methodology.
• IM_P_BAS_AVAIL_INCOME and IM_P_BAS_TOTAL_CONT — parent baseline available income and total parental contribution under the institutional methodology.
• IM_S_BAS_AVAIL_INCOME and IM_S_BAS_TOTAL_CONT — equivalent student baseline measures.
• FM_P_TOTAL_CONTRIBUTION and FM_S_TOTAL_CONT — federal methodology contribution amounts for parent and student.
• IM_INST_1_EST_FINANCIAL_NEED and FM_INST_1_FEDERAL_EFC — estimated financial need and federal expected family contribution for the primary institutional budget.
• INSTITUTIONAL_1_BUDGET_NAME and IM_INST_1_TOT_EXPENSES — the institutional budget applied and its total expense load.
• FNAR_MESSAGE_1 through FNAR_MESSAGE_77 — processor-returned narrative and validation codes displayed to aid officers.
• LEGACY_RECORD_FLAG and RECORD_MARK — record provenance and processing markers.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard EBS audit columns.

Common Use Cases and Queries

The most frequent access pattern is retrieval of need-analysis results for a given applicant profile, followed by reporting on institutional budgets and federal eligibility. A representative join is:

• SELECT f.FNAR_ID, f.IM_INST_1_EST_FINANCIAL_NEED, f.FM_INST_1_FEDERAL_EFC
FROM IGF_AP_CSS_FNAR_ALL f, IGF_AP_CSS_PROFILE_ALL p
WHERE f.CSSP_ID = p.CSSP_ID AND p.ORG_ID = :org_id;
• Comparing baseline versus optional parental contribution: aggregate IM_P_BAS_TOTAL_CONT and IM_P_OPT_TOTAL_CONT side by side to identify the effect of optional allowances such as medical or elementary/secondary tuition deductions.
• Auditing narrative messages returned by the College Board, filtering on FNAR_MESSAGE_* and ASSUMPTION_MESSAGE_* columns to surface data-integrity warnings to counselors.
• Institutional budget analysis using IM_INST_1_TOT_EXPENSES, IM_INST_1_VA_BENEFITS, and FM_INST_1_FED_ELIGIBILITY for packaging and awarding decisions.
• Legacy migration reconciliation via LEGACY_RECORD_FLAG and RECORD_MARK.

Related Objects

The following objects are the most significant dependencies:

• IGF_AP_CSS_PROFILE_ALL — parent profile table; joined on IGF_AP_CSS_FNAR_ALL.CSSP_ID = IGF_AP_CSS_PROFILE_ALL.CSSP_ID, the sole documented foreign key.
• IGF_AP_CSS_FNAR_ALL unique indexes IGF_AP_CSS_FNAR_U1 and IGF_AP_CSS_FNAR_U2 — enforce uniqueness on FNAR_ID and CSSP_ID.
• Financial aid application and applicant tables in the IGF schema that reference the CSS profile, and therefore the FNAR indirectly through CSSP_ID.
• Institutional need-analysis and award packaging concurrent programs in the Financial Aid module that read FNAR rows to derive eligibility.
• Reporting views and extracts for federal and institutional need reporting, driven by FNAR_ID and CSSP_ID.