Search Results igf_aw_fund_tp_v




Overview
Explore in AI Chat

Overview

IGF_AW_FUND_TP_V is an APPS-owned database view within the Oracle E-Business Suite IGF — Financial Aid product. Its documented purpose is to list all valid teaching periods during which a given financial aid fund may be applied. The view joins fund award configuration data to the teaching period calendar instance and the award (award year) calendar instance, producing a denormalized result set suitable for reporting, concurrent processing, and integration extracts.

In release 12.1.1 and 12.2.2 the object carries a VALID status in the APPS schema. Because the view exposes both the teaching period alternate code and the award-year alternate code, it is frequently used by functional consultants and technical developers searching for the string tp_alternate_code. That search term maps to the column exposed as TP_ALTERNATE_CODE in the documented column list (and ALTERNATE_CODE in the raw view text). This column returns the human-readable teaching period identifier, such as a term or semester code, rather than the internal TP_SEQUENCE_NUMBER.

Underlying Base Objects

The view is defined over four base objects. The driving table is IGF_AW_FUND_TP (aliased FTP), which stores the fund-to-teaching-period association and the applicable percentage. It is joined to IGF_AW_FUND_MAST (FMAST), the fund master table holding the fund code, description, and the award-year calendar instance reference.

Two instances of IGS_CA_INST are used, one aliased CI and one aliased AWD. IGS_CA_INST is the calendar instance table shared across student system products; CI resolves the teaching period calendar type and sequence number, while AWD resolves the award-year calendar instance via FMAST.CI_CAL_TYPE and FMAST.CI_SEQUENCE_NUMBER. The join predicates are:

The ETRM metadata documents no additional referenced base objects beyond these four.

Key Columns

The view exposes the following columns, grouped by origin:

Common Use Cases and Queries

Typical scenarios include validating which funds may be disbursed in a term, building fund eligibility extracts for downstream systems, and reconciling award-year versus teaching-period mappings.

  • List period codes for a fund: SELECT fund_code, tp_alternate_code, tp_perct FROM igf_aw_fund_tp_v WHERE fund_code = :p_fund;
  • Find all funds active in a term: SELECT fund_code, awd_alternate_code FROM igf_aw_fund_tp_v WHERE tp_alternate_code = :p_tp;
  • Audit recent changes: SELECT fund_code, tp_alternate_code, last_update_date FROM igf_aw_fund_tp_v ORDER BY last_update_date DESC;

Because the view is a join of configuration and calendar data, no DML is permitted; it should be treated strictly as a read-only reporting and integration source.