Search Results cumulative_gpa




Overview
Explore in AI Chat

Overview

APPS.IGF_AP_FA_BASE_H is a reporting and integration view in Oracle E-Business Suite (12.1.1 / 12.2.2) that exposes a denormalized, security-filtered projection of the base table IGF_AP_FA_BASE_H_ALL. It belongs to the Oracle Student System / Financial Aid functional area (the IGF / IG* prefix family) and is used to surface a consolidated, single-row-per-financial-aid-base record for a person, combining admission, program, enrollment, and residency/citizenship attributes. Because the underlying object is "_ALL", it is a multi-org (Operating Unit) table; the view applies an ORG_ID predicate based on the session's CLIENT_INFO, thereby enforcing Operating Unit data security at the database level. This makes IGF_AP_FA_BASE_H the preferred read-only access point for financial aid base records for any user whose session context is correctly established, while centralizing the multi-org filter and eliminating the need for callers to repeat it.

Underlying Base Objects

The published view text shows the view is defined exclusively over IGF_AP_FA_BASE_H_ALL FABH. No other base objects are documented, and the ETRM metadata lists no additional referenced objects. The view is a straight column projection (it exposes nearly every column of the table, including ROWID and all standard WHO/audit columns) plus the multi-org WHERE clause. The descriptive "_H" suffix indicates a header or "base" record level, as opposed to a detail/child level; relationships to person (PERSON_ID) and program (PROGRAM_ID, PROGRAM_APPLICATION_ID, BASE_ID) are carried as keys in this single row rather than resolved by joins within the view.

Key Columns

Common Use Cases and Queries

The view is used for admissions/financial-aid reporting, student program-of-study analysis, and extracts feeding downstream systems. The search term enrl_primary_prog_course_cd identifies the column carried as ENRL_PRIMARY_PROG_COURSE_CD, which represents the code of the program the student is primarily enrolled in.

List primary enrolled programs per person (Operating Unit filter applied automatically):

  • SELECT person_id, enrl_primary_prog_course_cd, enrl_primary_prog_ver_num
  • FROM apps.igf_ap_fa_base_h
  • WHERE enrl_primary_prog_course_cd IS NOT NULL
  • ORDER BY person_id;

Current financial-aid base record with GPA and standing:

  • SELECT fabh_id, person_id, base_id, current_gpa, cumulative_gpa, class_standing
  • FROM apps.igf_ap_fa_base_h
  • WHERE person_id = :p_person_id AND primary_rec = 'Y';

Admissions outcome extract joined to person for reporting:

  • SELECT f.admission_appl_number, f.adm_outcome_status, f.decision_date, p.full_name
  • FROM apps.igf_ap_fa_base_h f, apps.per_all_people_f p
  • WHERE f.person_id = p.person_id AND f.adm_outcome_status IS NOT NULL;

Because ORG_ID security is embedded in the view, there is no need to add an Operating Unit predicate to these queries; callers must simply ensure the correct session context is initialized before querying.