Search Results pit_2




Overview
Explore in AI Chat

Overview

IGF_AP_FA_BASE_RESULTS_V is a reporting view in the Oracle E-Business Suite application schema (APPS) that consolidates financial aid applicant data drawn from the Oracle Student System (IGS) and Oracle Trading Community Architecture (HZ) tables. The view is part of the IGF module family, which supports financial aid processing, and its name indicates that it exposes the results of the "AP/FA base" (Applicant/Financial Aid base) record set. In practice, IGF_AP_FA_BASE_RESULTS_V joins base financial aid records to party, person profile, and calendar instance data, and enriches each row with an alternate person identifier — specifically the SSN-type identifier — where one exists. This makes the view a convenient single source for downstream reporting, extracts, and integration processes that need applicant identity, demographic, and calendar context in one query. Because it is a view and not a table, it carries no independent storage; every execution re-derives its result set from the underlying base tables at query time.

Underlying Base Objects

Per the documented view text, IGF_AP_FA_BASE_RESULTS_V is defined over the following physical base tables and derive sets:

The outer joins link FA.PERSON_ID = PE.PARTY_ID and PE.PARTY_ID = PIT.PE_PERSON_ID (+). The (+) notation makes the SSN lookup an outer join, so applicants without a current SSN alternate identifier are still returned, with NULL in API_PERSON_ID.

Key Columns

  • PERSON_ID — party identifier of the applicant, originating from the base financial aid record.
  • BASE_ID — identifier of the financial aid base record itself.
  • PERSON_NUMBER — the party number from HZ_PARTIES, the externally recognizable person reference.
  • PERSON_LAST_NAME||', '||PERSON_FIRST_NAME — concatenated display name. Note the documented preformatted variant lacks the space after the comma while the HTML-formatted variant includes it.
  • API_PERSON_ID — the alternate (SSN-type) person identifier value returned by the PIT derived set; NULL when no effective SSN record exists.
  • DATE_OF_BIRTH — birth date from the current, date-effective HZ_PERSON_PROFILES row.
  • CI_CAL_TYPE and CI_SEQUENCE_NUMBER — the calendar type and sequence number identifying the academic calendar instance associated with the financial aid record.

Common Use Cases and Queries

The view is typically used for applicant extracts, financial aid reconciliation, and integrations that require SSN matching against external systems, since the outer join guarantees complete applicant coverage even when the SSN is absent. A representative query follows:

SELECT person_id, base_id, person_number, api_person_id, date_of_birth, ci_cal_type, ci_sequence_number FROM apps.igf_ap_fa_base_results_v WHERE ci_cal_type = :p_cal_type AND ci_sequence_number = :p_seq;

Because both HZ_PERSON_PROFILES and the PIT derived set are filtered by SYSDATE, results reflect only currently effective demographics and identifiers; historical or future-dated rows are excluded. Queries should therefore not be relied upon for point-in-time reconstruction without querying the base tables directly. As with all APPS views, appropriate responsibility-based grants or a custom synonym are required for direct access.