Search Results progress_twds_lmt




Overview
Explore in AI Chat

Overview

IGF_SE_WORK_AWD_PRG_V is a reporting view owned by the APPS schema within the IGF (Financial Aid) product module of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. The view presents student work award progress information for a given award year, specifically scoped to Federal Work-Study (FWS) funds. It consolidates award-level financial figures, fund master descriptive attributes, and student authorization details into a single denormalized result set, allowing institutions to monitor how awarded and accepted amounts translate into disbursed amounts and remaining balances over the life of a work-study award.

The view plays a reporting and integration role rather than a transactional one. Because it joins award, fund, fund category, and authorization data, it serves as a convenient source for operational reports, interfaces, and ad hoc extracts that need a current picture of work-study award consumption without reproducing the join logic across four base tables.

Underlying Base Objects

The documented view text defines the following base objects with an APPS owner:

  • IGF_AW_AWARD_ALL (alias AWD) — the award header, supplying base_id, award_id, fund_id, award_status, offered_amt, accepted_amt, paid_amt, and legacy_record_flag.
  • IGF_AW_FUND_MAST_ALL (alias FM) — the fund master, supplying fund_code and description.
  • IGF_AW_FUND_CAT (alias FC) — the fund category, supplying fed_fund_code.
  • IGF_SE_AUTH (alias SE) — the student work authorization, supplying auth_id, authorization_date, accepted_amnt, notification_date, and audit columns.

Joins link the authorization to the award by award_id, the award to the fund master by fund_id, and the fund master to the fund category by fund_code. Only funds whose fed_fund_code equals 'FWS' are returned. The award-to-authorization and award-to-flag joins are outer joins, so awards are retained even when no matching authorization row exists or no row carries the 'A' flag.

Key Columns

Common Use Cases and Queries

Typical scenarios include tracking remaining work-study balances, validating disbursement progress against accepted awards, and feeding downstream extracts. A representative query identifying awards with remaining balances is:

  • SELECT award_id, fund_code, accepted_amt, paid_amt, remaining_amt, progress_twds_lmt FROM apps.igf_se_work_award_prg_v WHERE remaining_amt > 0 ORDER BY award_id;

Additional uses include filtering by authorizations within a date range, aggregating paid and remaining totals by fund, and extracting the view for reconciliation against general ledger disbursements.