Search Results awd_end_dt

Overview

APPS.IGF_AW_FUND_TP_V is a supplementary Oracle EBS view within the Financial Aid (IGF) product family, specifically associated with the Awards (AW) functional area. According to its FND design data designation of IGF.IGF_AW_FUND_TP_V, the view presents a denormalized combination of fund definitions and teaching period (term) calendar instances within an operating unit. ETRM explicitly classifies the object as "a supplementary view used to simplify forms coding," with the standard Oracle warning that direct queries or data manipulation against the view are discouraged because its definition may change substantially across minor or major releases.

In the 12.1.1 and 12.2.2 environments the view is registered as VALID and owned by the APPS schema. Its role is largely presentational: it supplies a single flattened recordset that a form or concurrent process can consume without embedding complex multi-table joins against the award fund and calendar tables. The user search term AWD_START_DT corresponds directly to one of the view's award-period date columns, indicating that a common access pattern is to retrieve award start dates alongside fund and teaching period attributes.

Underlying Base Objects

The documented dependency for IGF_AW_FUND_TP_V is APPS.IGF_A, listed under the view's dependency block. The ETRM excerpt does not enumerate the complete set of base tables joined beneath this view, and the 12.2.2 view metadata shows no separately documented referenced base objects. The view name itself is informative: the FUND segment points to the award fund definition entities, while the TP segment points to teaching period calendar instances and their associated calendar categories.

Because the view exposes both fund identity columns (FUND_ID, FUND_CODE, FUND_DESC) and calendar instance columns (TP_CAL_TYPE, TP_SEQUENCE_NUMBER, CI_CAL_TYPE, CI_SEQUENCE_NUMBER), the underlying definition almost certainly joins a fund table to a teaching-period calendar instance table and, at minimum, a calendar category reference. The presence of two distinct calendar-type columns, TP_CAL_TYPE and CI_CAL_TYPE, suggests the view distinguishes the calendar category of the teaching period from a related calendar instance attribute.

Key Columns

• ROW_ID — ROWID pseudocolumn; useful for row addressing only and not a stable business key.
• FUND_ID / FUND_CODE / FUND_DESC — Unique numeric identifier, unique short code, and descriptive name for each award fund.
• TP_CAL_TYPE / TP_SEQUENCE_NUMBER / TP_ALTERNATE_CODE — Teaching period calendar type, its unique instance identifier, and the short alternate reference code for that instance.
• TP_START_DT / TP_END_DT — Teaching period start and end dates. ETRM annotates both with the same description text, an apparent documentation duplication.
• TP_PERCT — Installment percentage applicable to the particular teaching term, used in fund disbursement or allocation calculations.
• CI_CAL_TYPE / CI_SEQUENCE_NUMBER — Calendar instance type and sequence for the related calendar instance.
• AWD_ALTERNATE_CODE / AWD_START_DT / AWD_END_DT — Short reference code and start/end dates for the award period. AWD_START_DT is the column matching the user's search term.
• CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS WHO columns for audit traceability.

Common Use Cases and Queries

Typical usage centers on reporting fund allocations against award and teaching periods. Analysts frequently need to know which funds are active for a given award start date, or to reconcile teaching period percentages against award windows. A representative query filtering on the searched column is:

SELECT fund_code, fund_desc, tp_cal_type, tp_sequence_number, tp_start_dt, tp_end_dt, awd_start_dt, awd_end_dt, tp_perct FROM apps.igf_aw_fund_tp_v WHERE awd_start_dt >= :p_start_date AND awd_start_dt < :p_end_date ORDER BY fund_code, tp_start_dt;

A second pattern retrieves teaching period installments for a specific fund instance:

SELECT fund_id, tp_alternate_code, tp_perct, tp_start_dt FROM apps.igf_aw_fund_tp_v WHERE fund_code = :p_fund_code AND tp_cal_type = :p_cal_type;

Because the view is explicitly documented as being maintained for forms coding rather than for external reporting, custom development should treat column presence and semantics as release-dependent and validate results against the underlying base tables before relying on the view for integration or persistent extracts.