Search Results progress_to_limit

Overview

IGF_SE_EARNINGS_SUMMARY_V is a reporting view owned by the APPS schema within the IGF (Financial Aid) product family of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. It exposes computed figures describing a student's fund payment and disbursement activity for the Federal Work Study (FWS) program, and is consumed by the Student Employment component to present awarded amounts, cumulative earnings, remaining balances, and the percentage of the award that has been disbursed. Rather than storing data, the view performs the aggregation at query time, returning one summarized row per award base record, fund, and load calendar period. Its role is therefore primarily read-only reporting and integration: downstream pages, concurrent programs, and custom extracts can select from it without replicating the award-versus-disbursement arithmetic themselves.

Underlying Base Objects

The view text identifies three referenced objects: IGF_AW_AWARD_V, IGF_AW_AWD_DISB, and IGS_CA_INST. IGF_AW_AWARD_V supplies the award header context, contributing BASE_ID and FUND_ID together with the FED_FUND_CODE used as a filter. IGF_AW_AWD_DISB supplies the disbursement detail rows from which gross, accepted, and paid amounts are aggregated. IGS_CA_INST supplies the calendar instance attributes CAL_TYPE, SEQUENCE_NUMBER, and ALTERNATE_CODE, joined to the disbursement rows on LD_CAL_TYPE and LD_SEQUENCE_NUMBER. The three objects are joined on AWARD_ID between the award view and the disbursement table, and on calendar type and sequence number between the disbursement table and the calendar instance. The ETRM metadata documents no additional base objects beyond these.

Key Columns

• BASE_ID, FUND_ID — identify the award base record and the fund to which the earnings summary belongs.
• LD_CAL_TYPE, LD_SEQUENCE_NUMBER, LD_ALTERNATE_CODE — identify the load calendar period and its friendly alternate code.
• AWARD_AMOUNT — the accepted disbursement total where any accepted amount exists, otherwise the gross disbursement total, defaulting to zero.
• EARNINGS_TILL_DATE — the sum of DISB_PAID_AMT, representing funds actually paid to date.
• REMAINING_AMOUNT — the arithmetic difference between AWARD_AMOUNT and EARNINGS_TILL_DATE.
• PROGRESS_TO_LIMIT — the percentage of the award consumed, computed as ROUND(EARNINGS_TILL_DATE/AWARD_AMOUNT) * 100.
• NOTIFICATION_SENT, NOTIFICATION_DATE — placeholder columns projected as NULL.
• AUTH_ID, AUTH_DATE — authorization columns projected as NULL in the outer query. These placeholders are relevant to users searching on "auth_id," since the view exposes the column but does not populate it.

Common Use Cases and Queries

Typical usage centers on monitoring FWS disbursement against award ceilings. Because the FED_FUND_CODE filter is fixed to 'FWS' inside the inline view, only work study awards are returned. A simple listing of outstanding balances can be produced as follows:

• SELECT fund_id, ld_alternate_code, award_amount, earnings_till_date, remaining_amount, progress_to_limit FROM igf_se_earnings_summary_v WHERE remaining_amount > 0 ORDER BY fund_id;
• SELECT base_id, fund_id, progress_to_limit FROM igf_se_earnings_summary_v WHERE progress_to_limit >= 100; — identifies students who have reached or exceeded their award limit.
• SELECT auth_id, auth_date FROM igf_se_earnings_summary_v; — will always return NULL for both columns, confirming that authorization data is not sourced by this view.

Queries should account for the possibility of a zero AWARD_AMOUNT, which can cause a division-by-zero condition in the PROGRESS_TO_LIMIT expression; filtering or NVL protection is advisable in production extracts.