Search Results igf_ap_css_profile




Overview
Explore in AI Chat

Overview

IGF_AP_CSS_PROFILE is a VALID database view owned by the APPS schema within the IGF – Financial Aid product of Oracle E-Business Suite. The view is designated as retrieving CSS Profile records, where CSS Profile refers to the College Scholarship Service Profile, a standardized financial aid application form administered by the College Board and used extensively by postsecondary institutions to determine eligibility for institutional need-based aid. In EBS 12.1.1 and 12.2.2, the view functions as a reporting and integration surface through which CSS Profile data captured in the financial aid module can be queried, extracted, and consumed by downstream processes such as need analysis, packaging, and institutional reporting.

The view exposes a broad, denormalized projection of profile data, including student biographical identifiers, registration and receipt dates, and an extensive set of financial variables covering income, assets, liabilities, household composition, and parental contribution data. Because it is a view rather than a table, it presents a read-oriented interface suitable for concurrent reporting workloads without imposing additional storage.

Underlying Base Objects

The ETRM 12.2.2 metadata documents no referenced base objects and lists no owner for the underlying definition, so the base tables composing this view are not enumerated in the supplied reference. What is documented is the view text itself, which is a single SELECT statement projecting a fixed column list and generating a synthetic key via ROWID ROW_ID as the first projected column.

The column naming conventions strongly indicate lineage to CSS Profile staging or detail tables within the IGF schema, with the view consolidating multiple related record groups into one horizontal row: student-level data (LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, DATE_OF_BIRTH, SOCIAL_SECURITY_NUMBER), tax and income figures, asset and debt fields (HOME_VALUE, INVEST_VALUE, BUS_FARM_VALUE), and parental fields prefixed with P_. The leading column CSSP_ID functions as the CSS Profile record identifier, while ORG_ID and BASE_ID provide organizational and base-record context. Because the view relies on ROWID, it should be treated as a non-updatable, read-only reporting object; DML should be directed at the underlying tables.

Key Columns

Common Use Cases and Queries

The view is most commonly used to locate and audit active CSS Profile records for a given operating unit and award year, to feed need-analysis extracts, and to reconcile profile receipt milestones against aid applications. Because ACTIVE_PROFILE is exposed as a discrete column, the canonical query filters on it directly:

  • Retrieve all active profiles for an award year and operating unit:

    SELECT cssp_id, org_id, college_code, academic_year, last_name, first_name, financial_aid_status
    FROM apps.igf_ap_css_profile
    WHERE active_profile = 'Y'
    AND academic_year = :academic_year
    AND org_id = :org_id;

  • Report profiles by receipt date for workload monitoring:

    SELECT academic_year, application_receipt_date, registration_receipt_date, active_profile, COUNT(*)
    FROM apps.igf_ap_css_profile
    WHERE org_id = :org_id
    GROUP BY academic_year, application_receipt_date, registration_receipt_date, active_profile;

  • Extract financial variables for need-analysis staging by CSSP_ID, joining back to aid application tables on CSSP_ID and ORG_ID.

All queries should be constrained by ORG_ID to respect multi-org access, and by ACADEMIC_YEAR where historical volume is significant. As a view, it carries no indexes of its own; performance depends entirely on the underlying base tables and the predicates applied.