Search Results tp_alternate_code




Overview
Explore in AI Chat

Overview

IGF_AW_TP_INSTMT_V is a supplementary view owned by the APPS schema in Oracle E-Business Suite, registered under FND Design Data as IGF.IGF_AW_TP_INSTMT_V. It belongs to the Oracle Financial Aid (IGF) product family and is classified in the ETRM repository with a status of VALID. The view was created to simplify forms coding, granting Oracle Forms-based regions a single, denormalized access path to teaching period installment configuration data without requiring the form to join the underlying transaction tables directly.

Because the object is a view rather than a table, it carries no independent storage. It projects rows from its underlying base objects and exposes a stable column interface for the form layer. Oracle's standard warning applies: this view is not intended as a public integration or reporting surface. The documentation explicitly states that Oracle does not recommend querying or altering data through this view, and that its definition may change dramatically in subsequent minor or major releases. Any dependency built against it in a custom report or interface should therefore be treated as fragile and version-sensitive.

Underlying Base Objects

The ETRM metadata records that APPS.IGF_AW_TP_INSTMT_V references the following objects: APPS.IGF_AW_TP_INSTMT and IGS_CA_INST. The view is not referenced by any other database object, confirming it sits at the top of its own dependency chain and serves only as a read interface.

  • IGF_AW_TP_INSTMT — the primary base table holding teaching period installment records. It supplies the calendar type, sequence number, start and end dates, offset day, percentage, and minimum credit points that describe an installment rule.
  • IGS_CA_INST — the calendar instance table, which supplies the linked calendar instance data. The LD_ prefixed columns in the view derive from this connection, distinguishing the "load" or linked-instance calendar context from the TP_ (teaching period) context supplied by the installment table.

The join between these two sources produces the paired LD_ and TP_ column families visible in the view definition, allowing a single row to carry both the linked calendar instance attributes and the teaching period installment attributes.

Key Columns

The view exposes twenty-one columns. The ROW_ID column is a ROWID identifying the underlying row. FUND_ID and FINST_ID are numeric identifiers linking the row to fund and installment instance records respectively.

Common Use Cases and Queries

Typical usage is confined to form support and diagnostic inspection of teaching period installment configuration. A developer investigating a specific alternate code might run:

  • SELECT fund_id, tp_cal_type, tp_sequence_number, tp_alternate_code, tp_start_dt, tp_end_dt, tp_perct, min_credit_pts FROM apps.igf_aw_tp_instmt_v WHERE tp_alternate_code = '&code';
  • SELECT fund_id, finst_id, ld_cal_type, tp_cal_type, tp_offset_da FROM apps.igf_aw_tp_instmt_v WHERE fund_id = :fund_id ORDER BY tp_sequence_number;

Because the view is flagged as subject to significant change, any reporting requirement should be redirected to the base tables IGF_AW_TP_INSTMT and IGS_CA_INST, which offer a documented and more durable interface.