Search Results igf_ap_efc_v




Overview
Explore in AI Chat

Overview

IGF_AP_EFC_V is a reporting view within the Oracle E-Business Suite IGF — Financial Aid product family. In the ETRM 12.2.2 metadata it is explicitly flagged as Obsolete, and the implementation note states it is "Not implemented in this database." Its purpose was to expose, in a single denormalised result set, the mapping between an Award Period batch (as defined in IGF_AP_BATCH_AW_MAP) and the corresponding academic calendar instance, together with the Expected Family Contribution (EFC) formula, rounding factors, and their human-readable lookup descriptions.

The view is a convenience join rather than a transactional entity. It does not store data; it projects the configured EFC calculation rules and the calendar instance attributes so that downstream financial-aid packaging, need-analysis, and reporting logic can identify which EFC formula and rounding conventions apply to a given award period. As an obsolete object, it should be treated as reference-only: any new development in 12.1.1 or 12.2.2 should avoid dependencies on it, and existing customisations referencing it should be reviewed during upgrades.

Underlying Base Objects

The view text is defined over exactly two tables:

  • IGF_AP_BATCH_AW_MAP (aliased BAM) — the driving table, holding the calendar type, sequence number, EFC formula code, number-of-days divisor, rounding factor, and standard WHO audit columns.
  • IGS_CA_INST (aliased CI) — the calendar instance table from the Student Systems/IGS schema, supplying the alternate code and the instance start and end dates.

The join is an equi-join on calendar type and sequence number: BAM.CI_CAL_TYPE = CI.CAL_TYPE AND BAM.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER. The ETRM metadata records no additional referenced base objects and names no view owner, so the object resides in the IGF/APPS schema context. Two scalar calls to IGF_AW_GEN.LOOKUP_DESC enrich the result with descriptive text for the formula and rounding-factor codes; these are function calls, not joined tables.

Key Columns

Common Use Cases and Queries

Typical usage was diagnostic and reporting-oriented: confirming which EFC formula and rounding rule applied to a specific award period, or producing a period-level listing of EFC configuration. A representative query is:

SELECT ci_cal_type, ci_sequence_number, ci_alternate_code, ci_start_dt, ci_end_dt, efc_frml, efc_frml_desc, roundoff_fact_desc FROM igf_ap_efc_v WHERE ci_cal_type = :cal_type AND ci_sequence_number = :seq ORDER BY ci_start_dt;

Because the object is obsolete and documented as not implemented, such queries will raise ORA-00942 or ORA-04063 in environments where it was never deployed. In those cases, developers should reproduce the logic directly against IGF_AP_BATCH_AW_MAP joined to IGS_CA_INST, or migrate to the supported successor objects provided by the current Financial Aid schema. Records returned through the audit columns also allow identification of the last user and date of EFC configuration changes for control and audit purposes.