Search Results igf_ap_css_profile_all




Overview
Explore in AI Chat

Overview

The table IGF_AP_CSS_PROFILE_ALL is a core data repository within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). Its primary function is to store the detailed profile information received from the College Board for students who have submitted a CSS (College Scholarship Service) Profile. This standardized financial aid application form is critical for determining a student's eligibility for non-federal institutional aid. In the EBS architecture, this table serves as the central point for persisting imported or manually entered CSS Profile data, enabling the financial aid office to assess need, package awards, and ensure compliance with institutional methodologies.

Key Information Stored

While the full column list is not provided in the excerpt, the documented primary key, CSSP_ID, is the unique system-generated identifier for each CSS Profile record. This surrogate key is essential for all data relationships. The table's structure is designed to hold the comprehensive set of financial, demographic, and asset data elements captured by the CSS Profile. Crucially, the table includes the column BASE_ID, which is a foreign key linking the profile to a specific financial aid application year and student via the IGF_AP_FA_BASE_REC_ALL table. This establishes the fundamental relationship between a student's base financial aid record and their detailed CSS Profile data.

Common Use Cases and Queries

A primary use case is the integration and validation of CSS Profile data received electronically from the College Board. System processes populate this table, after which financial aid administrators can query the data for review and analysis. Common reporting scenarios include identifying discrepancies between institutional data and the CSS submission, calculating the institutional Expected Family Contribution (EFC), and generating lists of applicants with complete profiles for packaging. A foundational query often involves joining to the base application table to retrieve student context.

SELECT cssp.cssp_id, cssp.base_id, base.person_id, base.award_year
FROM igf_ap_css_profile_all cssp,
     igf_ap_fa_base_rec_all base
WHERE cssp.base_id = base.base_id
AND base.award_year = '2024-2025';

Related Objects

The table participates in defined relational integrity constraints within the Financial Aid schema, as documented by its foreign keys.

  • Primary Key: IGF_AP_CSS_PROFILE_PK on column CSSP_ID.
  • Parent Table (Foreign Key Reference): IGF_AP_FA_BASE_REC_ALL. The column BASE_ID in IGF_AP_CSS_PROFILE_ALL references the primary key of this table, linking a profile to a specific student's financial aid application record.
  • Child Table (Referenced by Foreign Key): IGF_AP_CSS_FNAR_ALL. This child table holds detailed financial need analysis results derived from the CSS Profile. Its column CSSP_ID is a foreign key referencing IGF_AP_CSS_PROFILE_ALL.CSSP_ID, creating a one-to-many relationship where a single profile can have multiple associated need analysis records.