Results for “offered_amt”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

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

• REMAINING_AMT — computed as NVL(ACCEPTED_AMT,0) minus NVL(PAID_AMT,0). This is the column users most frequently search for; it represents the accepted work-study amount still available to disburse.
• OFFERED_AMT, ACCEPTED_AMT, PAID_AMT — the original award offer, the amount the student accepted, and the amount actually disbursed. AUTHORIZED_AMT is documented as a column, though the excerpted view text derives accepted amounts from both the award and the authorization.
• PROGRESS_TWDS_LMT — percentage of the accepted award already paid, computed as ROUND(PAID_AMT * 100 / ACCEPTED_AMT), or 0 when the accepted amount is zero.
• FUND_CODE, FUND_CODE_DESC, FED_FUND_CODE — fund identifiers and description; FED_FUND_CODE is always 'FWS' in this view.
• AWARD_STATUS, AUTH_ID, AUTHORIZATION_DATE, NOTIFICATION_DATE, LEGACY_RECORD_FLAG — status and audit context for the award and its authorization.

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.