Search Results fund_code_desc

Overview

The view APPS.IGF_SE_WORK_AWD_PRG_V is a reporting and integration construct within the Oracle E-Business Suite (EBS) financial aid module, part of the Oracle iGovernment / Student Financial Aid component. It exposes a consolidated, denormalized projection that joins awards, fund masters, fund category definitions, and student employment authorizations. The view is characterized as an inner-plus-outer join composite: award records drive the result set, while the student employment authorization (IGF_SE_AUTH) portion is applied through outer joins via the (+) operator, and only authorizations whose FLAG equals 'A' are included.

The view name encodes its purpose: Student Employment (SE) work-study award progress. Its result set is filtered specifically to Federal Work-Study (FWS) funds through the predicate FC.FED_FUND_CODE = 'FWS'. Because the source embeds business logic (progress percentage calculation, remaining amounts, FWS restriction), it presents a ready-made data set suitable for upstream reporting, page regions in Oracle Forms/OAF, concurrent program output, and integration extraction. The presence of audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) indicates it is designed to surface standard EBS Who columns alongside financial metrics.

Underlying Base Objects

The view is defined over four documented base objects:

• IGF_AW_AWARD_ALL (aliased AWD) — the award header, driving the join and supplying base, award, fund, status, and monetary measures.
• IGF_AW_FUND_MAST_ALL (aliased FM) — fund master, joined on AWD.FUND_ID = FM.FUND_ID, supplying FUND_CODE and DESCRIPTION.
• IGF_AW_FUND_CAT (aliased FC) — fund category, joined on FM.FUND_CODE = FC.FUND_CODE, supplying FED_FUND_CODE and enforcing the FWS filter.
• IGF_SE_AUTH (aliased SE) — student employment authorization, outer-joined on SE.AWARD_ID(+) = AWD.AWARD_ID with the restrictive outer predicate SE.FLAG(+) = 'A'.

Award rows therefore always appear (subject to the FWS category constraint), while authorization columns are populated only where a matching "active" authorization exists.

Key Columns

Monetary and status columns from the award include AWARD_STATUS, OFFERED_AMT, ACCEPTED_AMT, and PAID_AMT. The fund description column most relevant to the searched term is FUND_CODE_DESC, which is the alias given to FM.DESCRIPTION. A parallel student-employment figure, SE.ACCEPTED_AMNT, is exposed separately. Derived columns include REMAINING_AMT (accepted minus paid, using NVL guards) and PROGRESS_TWDS_LMT, which computes the paid percentage of accepted amount with DECODE to avoid division by zero. Authorization columns include AUTH_ID, AUTHORIZATION_DATE, and NOTIFICATION_DATE. The LEGACY_RECORD_FLAG identifies migrated historical records.

Common Use Cases and Queries

Typical usage retrieves FWS work-study progress per award and fund description. The search term fund_code_desc maps directly to the exposed alias:

SELECT award_id, fund_code, fund_code_desc,
       accepted_amt, paid_amt, remaining_amt, progress_twds_lmt
FROM   apps.igf_se_work_awd_prg_v
WHERE  award_status = 'A';

Because the view already restricts to FED_FUND_CODE = 'FWS', no additional category filter is required. Analysts commonly aggregate paid versus accepted amounts by fund_code_desc, or join the view back to IGF_AW_AWARD_ALL for attributes not projected here.