Search Results enrl_total_cp

Overview

The IGF_AP_FA_BASE_H view resides in the APPS schema and belongs to the IGF (Financial Aid) product family within Oracle E-Business Suite. Per the documented ETRM metadata, this view is obsolete. It was originally designed to expose a single, organization-scoped projection of financial aid base/application data held in the underlying IGF_AP_FA_BASE_H_ALL table, applying Oracle's standard multi-org security predicate rather than a business logic filter.

The view returns the full set of columns from the base table, including the ROWID pseudo-column, and is filtered so that only rows whose ORG_ID matches the operating unit derived from the session's CLIENT_INFO are visible. This makes it a Multi-Org secured (ORG_ID–based) reporting view. The search term prog_att_course_cd corresponds directly to one of the columns exposed by this view — PROG_ATT_COURSE_CD — which records the program-attempt course code associated with an applicant's record. Because the view is obsolete, it should not appear in new customizations; the column nevertheless documents the historic data model naming conventions used throughout the IGF financial aid schema.

Underlying Base Objects

The ETRM metadata lists no separately documented referenced base objects, but the view definition itself is explicit: it selects from a single table, IGF_AP_FA_BASE_H_ALL (aliased FABH). No joins, unions, or subqueries are present, so the view is essentially a secured synonym-style projection of that table.

• IGF_AP_FA_BASE_H_ALL — the _ALL table that stores the multi-org-partitioned financial aid base records; it carries the ORG_ID column that drives the view's security predicate.
• IGF_AP_FA_BASE_H — the org-secured view over the _ALL table, which is the object described here.

The security predicate resolves the operating unit from USERENV('CLIENT_INFO'), extracting the first ten characters and comparing it to ORG_ID; rows with a null ORG_ID are compared against a sentinel value of -99. This is the classic Oracle EBS 11i/12.1 multi-org view pattern. Note that in 12.2.2 the recommended replacement is the MOAC-based VPD model, which is one of the reasons this stub view is marked obsolete.

Key Columns

The view exposes a broad set of admission, enrollment, and financial aid attributes. The most significant include:

• PROG_ATT_COURSE_CD and PROG_ATT_VER_NUM — course code and version for the program attempt; accompanied by PROG_ATT_ATTEND_MODE, PROG_ATT_ATTEND_TYPE, and PROG_ATT_START_DT.
• FABH_ID, BASE_ID, PERSON_ID — primary identifiers linking the record to the person and base entities.
• ADMISSION_APPL_NUMBER, ADM_APPL_STATUS, S_ADM_APPL_STATUS — admission application number and current/derived status.
• PROGRAM_APPLICATION_ID, PROGRAM_ID, ENRL_PRIMARY_PROG_COURSE_CD — program and enrollment context.
• CURRENT_GPA, CUMULATIVE_GPA, ACHEIVED_CR_PTS, CLASS_STANDING — academic performance attributes.
• ORG_ID plus the standard WHO/audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID) — multi-org and audit context.

Common Use Cases and Queries

Historically the view was used to report and integrate financial aid base records filtered by operating unit, and to join applicant data to program-attempt and enrollment information. Given its obsolete status, use is limited to legacy reporting or audit tracing. A representative query retrieving the searched column would appear as:

SELECT fabh_id,
       person_id,
       prog_att_course_cd,
       prog_att_ver_num,
       adm_application_number,
       cumulative_gpa
  FROM apps.igf_ap_fa_base_h
 WHERE person_id = :p_person_id;

For aggregation by course or program attempt, a legacy report might group as follows:

SELECT prog_att_course_cd,
       COUNT(*) AS record_count
  FROM apps.igf_ap_fa_base_h
 GROUP BY prog_att_course_cd;

Because the view enforces org security through CLIENT_INFO, such queries must be executed under an initialized EBS session so that the correct operating unit context is established. For new developments on 12.1.1 or 12.2.2, the base table IGF_AP_FA_BASE_H_ALL or the current replacement objects should be used instead of this obsolete view.