Results for “im_p_bas_disc_net_worth”

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

Overview

IGF_AP_CSS_FNAR_V is a database view historically shipped within the Oracle E-Business Suite Financial Aid module (IGF), which is now classified as obsolete. The view exposed data derived from the CSS/FAFSA (Congressional Methodology / Free Application for Federal Student Aid) needs-analysis processing performed by Oracle's financial aid engine. Its naming convention — combining the "AP" (award processing) prefix with "CSS_FNAR" — indicates that it was intended to surface the calculated Federal Need Analysis Record (FNAR) values associated with a student's Institutional Methodology (IM) contribution calculation.

In practice, the object is not implemented in current Oracle EBS 12.1.1 or 12.2.2 databases. The ETRM metadata explicitly states "Not implemented in this database," meaning the view is documented for historical or reference purposes only and is not present in a standard installation of either release. The view would have functioned as a reporting and integration layer, allowing downstream forms, concurrent programs, or external interfaces to query consolidated need-analysis figures without joining the large set of underlying CSS calculation tables directly.

Underlying Base Objects

The ETRM metadata lists no documented referenced base objects for this view. However, the view text itself reveals the logic: it selects from the FNAR (Federal Need Analysis Record) entity, joining to a CSS processing table via CSSP_ID. The columns exposed are overwhelmingly prefixed with IM_P_BAS_ (Institutional Methodology, Parent, Base year) and IM_P_OPT_ (Institutional Methodology, Parent, Optional/prior year), which are the standard suffixes used by the CSS/IM calculation schema. The FNAR_ID primary key links the record back to the parent FNAR row, while CSSP_ID ties the calculation to a specific CSS processing instance. Because the view is obsolete, no corresponding base table DDL is shipped, and the dependent tables (such as the CSS processing and CSS parent data tables) are equally absent from a supported 12.1.1/12.2.2 instance.

Key Columns

The view exposes a comprehensive set of need-analysis figures:

• Identity columns — FNAR_ID and CSSP_ID uniquely identify the record and its processing context; R_S_EMAIL_ADDRESS identifies the student/contact.
• Demographic and household data — STU_AGE, STU_FAMILY_MEMBERS, STU_FAM_MEMBERS_IN_COLLEGE, PAR_MARITAL_STATUS, and the various PAR_*_IN_COLLEGE counts feed the dependency and household-size computations.
• Base-year income figures (IM_P_BAS_*) — AGI/taxable income, untaxed income and benefits, income adjustments, total income, and tax allowances (US and state/FICA), culminating in IM_P_BAS_AVAIL_INCOME and IM_P_BAS_TOTAL_CONT_INC.
• Base-year asset figures — cash and bank accounts, home equity, other real estate/investments, adjusted business/farm worth, net worth, education savings, and asset allowances, resolving to IM_P_BAS_TOTAL_CONT_ASSET and IM_P_BAS_TOTAL_CONT.
• Contribution results — IM_P_BAS_CONT_FOR_STU, IM_P_BAS_CONT_FROM_INCOME, and IM_P_BAS_CONT_FROM_ASSETS give the final expected family contribution split.
• Optional/prior-year equivalents (IM_P_OPT_*) — mirror the IM_P_BAS_ set for a secondary year, supporting year-over-year comparison.

Common Use Cases and Queries

Because the view is obsolete, it cannot be queried in a live 12.1.1/12.2.2 database; any attempt returns an ORA-00942 (table or view does not exist). Historical use cases would have included financial aid packaging reports, need-analysis extracts, and feeding award-processing logic. A representative query, valid only where the view exists, would be:

• SELECT FNAR_ID, CSSP_ID, IM_P_BAS_AVAIL_INCOME, IM_P_BAS_TOTAL_CONT FROM IGF_AP_CSS_FNAR_V WHERE CSSP_ID = :p_cssp_id;
• SELECT STU_AGE, STU_FAMILY_MEMBERS, IM_P_BAS_CONT_FOR_STU FROM IGF_AP_CSS_FNAR_V ORDER BY FNAR_ID;

Consultants maintaining legacy customizations should confirm whether this object ever existed in their environment and, if so, plan migration to the currently supported financial aid data model.