Search Results igf_ap_fa_base_h_all_pk

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:

• Identity: FABH_ID is the surrogate primary key and the sole documented business-key candidate via the unique index. BASE_ID is the foreign key to IGF_AP_FA_BASE_REC_ALL, and PERSON_ID identifies the individual to whom the record pertains.
• Admissions: ADMISSION_APPL_NUMBER, ADM_APPL_STATUS, ADMISSION_CAT, ADMISSION_PROCESS_TYPE, DECISION_DATE, and the offer-response pair ADM_OFFER_RESP_STATUS and ACTUAL_RESPONSE_DATE capture the application lifecycle.
• Enrollment: CUR_ENROL_CREDIT_POINTS, ENRL_LOAD_CAL_TYPE, ENRL_LOAD_SEQ_NUM, ENRL_PRIMARY_PROG_COURSE_CD, and ENRL_ATTEND_MODE describe the current registration context.
• Academic standing: CLASS_STANDING, CURRENT_GPA, CUMULATIVE_GPA, ACADEMIC_INDEX, and SAP_SELECTED_FLAG support satisfactory-academic-progress evaluation.
• Demographics and eligibility: VISA_TYPE, CITIZENSHIP_STATUS, RESIDENCY_STATUS, MIL_SERVICE_TYPE, and ATB.
• Program context: PROGRAM_ID, PROGRAM_APPLICATION_ID, KEY_PROGRAM, and PROGRAM_UPDATE_DATE.
• Audit: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, and ORG_ID.

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.