Search Results wk_inst_time_calc_pymt




Overview
Explore in AI Chat

Overview

APPS.IGF_GR_YTD_ORIG is a database view in the Oracle E-Business Suite Financial Aid subsystem, registered under the APPS schema with the FND Design Data reference IGF.IGF_GR_YTD_ORIG. The object name reflects its function: IGF denotes the Financial Aid (IGF) product family, GR refers to grant-related processing, YTD indicates year-to-date aggregation, and ORIG denotes origination records. The view is documented as VALID in all supported releases and is classified as a multi-org view — it retrieves data only for the current operating unit, automatically filtering out records belonging to other operating units. This behavior is enforced through the ORG_ID column, which participates in the multi-org security predicate generated by the Multi-Org architecture.

In release 12.1.1 and 12.2.2, this view serves reporting and integration purposes for the federal Pell Grant origination process. It consolidates year-to-date origination data — including origination identifiers, student identifiers, disbursement amounts, and calendar context — into a single addressable object. Financial aid administrators and downstream interfaces query it to reconcile origination records against disbursement activity.

Underlying Base Objects

The ETRM metadata for this view does not document any referenced base objects. In practice, views of this naming pattern in the IGF schema are defined over the base origination tables and year-to-date transaction tables maintained by the Grant Origination (Pell) module. Because the dependency list is empty in the supplied metadata, the view should be treated as an interface object: consumers should rely on its exposed columns rather than assuming a specific join path to underlying tables. Any customization or extension should be implemented against the view itself, not against assumed base tables, since column-level dependencies are not published.

Key Columns

Common Use Cases and Queries

Typical usage involves reconciling origination records and validating disbursement timing. A representative query retrieving records for the current operating unit follows:

SELECT ytdor_id, origination_id, original_ssn, accpt_awd_amt, ytd_disb_amt, wk_inst_time_calc_pymt
FROM apps.igf_gr_ytd_orig
WHERE origination_id = :p_origination_id;

To review all disbursement dates associated with an award, select the ACCPT_DISB_DT1 through ACCPT_DISB_DT15 columns alongside the calendar columns. Note that the multi-org view automatically restricts results to the session's operating unit, so no explicit ORG_ID predicate is required for standard calls. When reporting across operating units, use the _ALL organization security profile or query the underlying table directly where authorized.