Search Results igf_ap_fa_base_h_all




Overview
Explore in AI Chat

Overview

The IGF.IGF_AP_FA_BASE_H_ALL table belongs to the IGF (Financial Aid) product family within Oracle E-Business Suite and is documented in the ETRM repository for releases 12.1.1 and 12.2.2. Its documented description is explicit and unambiguous: the table is obsolete. Oracle retains the definition in the data dictionary and in the ETRM object inventory for historical and upgrade-compatibility reasons, but it is no longer the active repository for financial aid base processing. Organizations performing upgrades from earlier releases may still encounter populated rows, which is why the object remains visible in the schema even though its functional role has been retired.

Where the table was once used, it served as the header or base-record store for financial aid applicant data, carrying admissions, enrollment, academic-standing, and need-analysis attributes keyed to a person. The primary key is defined as IGF_AP_FA_BASE_H_ALL_PK over the FABH_ID column, and a unique index IGF_AP_FA_BASE_H_ALL_U1 also exists on the same column. The table holds 76 documented columns. A heuristic Data Vault classification derived from its foreign-key structure places it as satellite-leaning, meaning it most closely resembles an attribute-bearing dependent of a parent record rather than a standalone hub or a pure associative link. This classification should be treated as a modeling suggestion, not a documented Oracle designation.

Key Information Stored

The most significant columns fall into several functional clusters:

Common Use Cases and Queries

Because the object is obsolete, its practical uses are almost entirely archaeological: auditing historical aid records, validating a pre-upgrade data snapshot, or confirming row counts before an archive or purge decision. Any query should be written defensively against a table that may or may not be populated in a given environment.

  • Volume and currency check: SELECT COUNT(*), MIN(CREATION_DATE), MAX(LAST_UPDATE_DATE) FROM IGF.IGF_AP_FA_BASE_H_ALL;
  • Join back to the parent base record to confirm referential coverage: SELECT h.FABH_ID, h.BASE_ID, r.* FROM IGF.IGF_AP_FA_BASE_H_ALL h JOIN IGF.IGF_AP_FA_BASE_REC_ALL r ON r.BASE_ID = h.BASE_ID;
  • Identify active persons in the historical data: SELECT PERSON_ID, COUNT(*) FROM IGF.IGF_AP_FA_BASE_H_ALL GROUP BY PERSON_ID HAVING COUNT(*) > 1;
  • Extract audit trails for a given update window: filter on LAST_UPDATED_BY and LAST_UPDATE_DATE, and correlate to concurrent requests via REQUEST_ID.

The recommended reporting posture is to treat this table as read-only and to source current aid data from its replacement objects.

Related Objects

The documented relationship data identifies one foreign-key dependency and several columns that imply conventional EBS joins:

  • IGF.IGF_AP_FA_BASE_REC_ALL — referenced by IGF_AP_FA_BASE_H_ALL.BASE_ID; this is the only documented foreign key and the most important join partner.
  • PER_ALL_PEOPLE_F — join on PERSON_ID to resolve the individual's name and current record.
  • HR_ALL_ORGANIZATION_UNITS — join on ORG_UNIT_CD values carried in ADM_ORG_UNIT_CD and ENRL_ORG_UNIT_CD.
  • FND_CONCURRENT_REQUESTS — join on REQUEST_ID to trace the process that created or last touched the row.
  • CS_CP_STUDENT and related Student System tables — historically the source of enrollment and program attributes surfaced in the ENRL_* and PROG_ATT_* columns.
  • Replacement or successor IGF financial aid base tables introduced after the retirement of this header, which should be identified in the target release before any extract is commissioned.