Search Results igf_ap_efc_mult_fct_v




Overview
Explore in AI Chat

Overview

IGF_AP_EFC_MULT_FCT_V is a database view historically shipped within the Oracle E-Business Suite IGF (Financial Aid) product family. In the ETRM 12.2.2 metadata, the object carries the description "OBSOLETE" and is explicitly flagged as "Not implemented in this database." This indicates the view is a legacy artifact retained in the data dictionary for backward-compatibility references rather than a functional runtime object in current 12.1.1 or 12.2.2 environments. Its name suggests it was intended to present Expected Family Contribution (EFC) data joined to multiple factor or method-type attributes, supporting financial aid need-analysis calculations and downstream reporting.

Because the object is obsolete and not implemented, it does not participate in active EBS reporting, concurrent programs, or integrations in supported releases. Any reference to it in custom code, Discoverer workbooks, or legacy BI Publisher reports should be treated as a candidate for remediation.

Underlying Base Objects

The documented view text defines the object over three underlying sources:

  • IGF_AP_EFC_V (aliased EFC) — The primary Expected Family Contribution view, supplying calendar type and sequence number keys along with the EFC context.
  • IGF_AP_NEED_MTH_TYP (aliased NMT) — The need methodology type base table, supplying method code, method description, and standard WHO audit columns.
  • IGS_CA_INST (aliased CI) — The calendar instance base table from the Student Systems (IGS) schema, supplying the alternate code and the start and end dates of the calendar instance.

The join is an equi-join between EFC and CI on CI_CAL_TYPE / CAL_TYPE and CI_SEQUENCE_NUMBER / SEQUENCE_NUMBER, combined with a cross-join to NMT. The ETRM metadata records no documented referenced base objects for this view, and the practical definition is derived entirely from the embedded view text.

Key Columns

  • ROW_ID — Exposes the ROWID of the need methodology type row; useful only in legacy row-level addressing.
  • CI_CAL_TYPE / CI_SEQUENCE_NUMBER — Composite keys identifying the calendar instance associated with the EFC record.
  • CI_ALTERNATE_CODE — The alternate (human-readable) code of the calendar instance, typically representing an academic period or aid year.
  • CI_START_DT / CI_END_DT — Effective start and end dates of the calendar instance, enabling date-bounded reporting.
  • METHOD_CODE / METHOD_DESC — The need-analysis methodology identifier and description drawn from IGF_AP_NEED_MTH_TYP.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns inherited from the methodology type table.

Common Use Cases and Queries

In legacy deployments the view would have supported inquiries listing EFC records alongside their calendar instance and need methodology context. A representative query follows, though it will fail in environments where the object is not implemented:

  • SELECT ci_alternate_code, ci_start_dt, ci_end_dt, method_code, method_desc FROM igf_ap_efc_mult_fct_v WHERE ci_cal_type = :cal_type ORDER BY ci_start_dt;
  • Joining to IGS_CA_INST to resolve additional calendar attributes for a given aid year.
  • Filtering by method_code to segregate need-analysis results by methodology.

Given the OBSOLETE designation, the recommended practice is to confirm object existence via ALL_VIEWS before use, and to refactor any dependent customizations against supported IGF or IGS equivalents.