Search Results igf_ap_fa_base_h_all_u1

Overview

IGF.IGF_AP_FA_BASE_H_ALL is a table in the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment, owned by the IGF schema and registered under FND Design Data as IGF.IGF_AP_FA_BASE_H_ALL. It belongs to the Oracle Student System / Financial Aid integration area, where IGF objects support the exchange of student information between Oracle Student System (OSS) and Oracle Financial Aid. The table stores a historical snapshot of student "base" records relevant to financial aid processing, capturing admissions, enrollment, program, and status attributes as retrieved from OSS.

The ETRM documentation explicitly notes that this table is obsolete. In practice, the table remains present and valid in the data dictionary of supported 12.x releases, but its contents are typically retained only for archival or upgrade purposes. It is physically stored in the APPS_TS_ARCHIVE tablespace, reinforcing its historical/archival nature.

The documented physical schema shows 76 columns. From a Data Vault modeling perspective, the mined relationship structure suggests this object behaves as a satellite-leaning table: it carries descriptive, time-stamped attributes (the "H" indicating history) that hang off the business key BASE_ID, which itself references a parent base record table. The primary key is a surrogate (FABH_ID), while BASE_ID functions as the principal business-key reference.

Key Information Stored

The table centers on the surrogate primary key FABH_ID (NUMBER(15)), a sequence-generated identifier defined by the primary key constraint, with the unique index IGF_AP_FA_BASE_H_ALL_U1 enforcing uniqueness on this column. This index is the documented business-key candidate at the physical level.

The most important attributes include:

• BASE_ID – Unique identifier for the student financial aid base record; the join key to IGF_AP_FA_BASE_REC_ALL and supported by the non-unique index IGF_AP_FA_BASE_H_ALL_N1.
• PERSON_ID – The person identifier, linking the snapshot to a party/person.
• PRIMARY_REC – Flag (Y/N) indicating the latest OSS details for the student; only one record per FA Base ID may be primary.
• REC_LAST_UPDATED – Timestamp showing when the details were extracted from OSS.
• CLASS_STANDING, CURRENT_GPA, CUMULATIVE_GPA – Academic standing and performance measures used in aid eligibility.
• ENCUMBRANCE_TYPE, VISA_TYPE, CITIZENSHIP_STATUS, RESIDENCY_STATUS, MIL_SERVICE_TYPE – Status attributes frequently required for aid rules and compliance.
• ADMISSION_APPL_NUMBER, ADM_APPL_STATUS, S_ADM_APPL_STATUS, APPL_DT – Admission application identifiers, user- and system-defined statuses, and application date.
• ENRL_LOAD_CAL_TYPE, ENRL_LOAD_SEQ_NUM – Enrollment load calendar and sequence referencing enrollment periods.
• ORG_ID and WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) – Multi-org and standard audit context.

Common Use Cases and Queries

Because the table is obsolete, primary usage is historical reporting, data migration verification, and auditing of prior OSS-to-FA exchanges rather than live transactional processing. Typical patterns include retrieving the current snapshot per base record using the PRIMARY_REC flag:

• Identify the latest OSS snapshot: SELECT * FROM igf.igf_ap_fa_base_h_all WHERE base_id = :p_base_id AND primary_rec = 'Y';
• Point-in-time historical reporting: filter on rec_last_updated between two dates.
• Joining to the parent record: SELECT b.*, h.* FROM igf.igf_ap_fa_base_rec_all b JOIN igf.igf_ap_fa_base_h_all h ON h.base_id = b.base_id;
• Aggregation for aid analytics: count of students by class_standing, current_gpa bands, or residency_status.

All queries should be scoped by org_id in a multi-org context.

Related Objects

The principal dependency is the foreign key from BASE_ID to IGF.IGF_AP_FA_BASE_REC_ALL, the parent student financial aid base record table. Related tables, views, and APIs in the same integration domain typically include:

• IGF_AP_FA_BASE_REC_ALL – parent base record; joined on BASE_ID.
• Additional IGF_AP_FA_* satellite tables that hold related FA attributes keyed by BASE_ID.
• Oracle Student System (OSS) admission and enrollment tables, which are the upstream sources of the snapshot columns.
• Financial Aid (FA) base APIs and concurrent programs that previously populated PRIMARY_REC snapshots.

Because the object is obsolete, new development should avoid extended dependencies and rely on currently supported FA/OSS integration objects instead.