Results for “ed_use_flags”

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

Overview

IGFFV_PELL_DISBURSEMENTS is a read-only view owned by the APPS schema within the Oracle E-Business Suite Financial Aid module (IGF). It presents a denormalized, reporting-oriented projection of Federal Pell Grant disbursement activity, joining disbursement records to their parent award, award year, batch, and party (person) contexts. The view is registered as VALID in Oracle EBS 12.1.1 and 12.2.2 and carries the read-only clause, meaning it is intended strictly for query, extraction, and integration use rather than as a transaction target.

Its practical role is to expose Pell disbursement data in a flat structure suitable for downstream reporting, reconciliation against the Common Origination and Disbursement (COD) process, and institutional financial aid extracts. The description recorded in ETRM refers to Application Review Groups, which is a metadata artifact; the column set and view text confirm the object is a Pell disbursement entity view.

Underlying Base Objects

The view is defined over six base tables and aliases, all in the APPS schema:

• IGF_GR_RFMS_DISB_ALL (RFMD) — the primary disbursement table, contributing reference numbers, dates, amounts, debit/credit indicators, acknowledgement status, and edit codes.
• IGF_GR_RFMS_ALL (RFMS) — the student/award record set keyed by ORIGINATION_ID, providing BASE_ID, AWARD_ID, and the calendar instance linkage.
• IGF_GR_RFMS_BATCH_ALL (RFMB) — the batch header, joined via RFMB_ID in an outer join that permits disbursement rows with no batch.
• IGS_CA_INST_ALL (CI) — the calendar instance table, supplying the award year (calendar type and sequence number) and its description.
• IGF_AW_AWARD_ALL (AWD) — the award header, used to resolve BASE_ID to the award.
• IGF_AP_FA_BASE_REC_ALL (FACON) — the financial aid base record, resolving BASE_ID to PERSON_ID.
• HZ_PARTIES — the trading community party table, joined on PARTY_ID = PERSON_ID to return PARTY_NUMBER and PARTY_NAME.

Referenced base objects are not separately enumerated in the 12.2.2 ETRM metadata, but they are fully visible in the documented view text.

Key Columns

• DISBURSEMENT_REF_NUMBER (RFMD.DISB_REF_NUM) — the COD disbursement reference.
• DISBURSEMNT_DATE, DISBURSEMNT_STATUS_DATE, ACCPTED_DISBURSEMNT_DATE — origination, status, and acceptance dates for the disbursement.
• DISBURSEMENT_AMOUNT (RFMD.DISB_AMT) — the disbursement amount; this is the column most commonly searched as disbursement_amount.
• DISBURSEMENT_ACCPT_AMOUNT — the accepted or adjusted disbursement amount.
• DISBURSEMENT_YTD_AMOUNT — year-to-date disbursement total for the student.
• DEBIT_CREDIT_FLAG / ACCPT_DEBIT_CREDIT_FLAG — indicate credit (disbursement) versus debit (return/adjustment) activity.
• PAYMENT_PERIOD_START_DATE / PAYMENT_ACCEPTED_START_DATE — payment period boundaries.
• PERSON_NUMBER, PERSON_NAME, PERSON_ID — the student party identity.
• AWARD_YEAR, AWARD_YEAR_DESCRIPTION, AWARD_YEAR_CALENDAR_TYPE, AWARD_YEAR_CAL_SEQ_NUMBER — the academic award year context.
• DISBUR_ACK_ACT_STATUS — a lookup-keyed acknowledgement status resolved through IGF_LOOKUPS_VIEW.
• RFMB_ID, BATCH_ID, RFMS_PROCESS_DATE, ORIGINATION_ID, RFMD_ID — batch and internal keys useful for joins and audit.
• EDIT_CODE, ED_USE_FLAGS — COD edit results and federal use flags.
• Standard WHO columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE.

Common Use Cases and Queries

The view is typically queried to reconcile Pell disbursements against COD accepted amounts, to extract student-level disbursement detail for financial aid reporting, and to identify disbursement rows requiring attention based on edit codes or acknowledgement status.

Positive disbursements for an award year:

SELECT person_number, person_name, award_year, disbursement_ref_number, disbursemnt_date, disbursement_amount FROM apps.igffv_pell_disbursements WHERE disbursement_amount > 0 AND debit_credit_flag = 'C' AND award_year = :year ORDER BY person_number, disbursemnt_date;

Accepted-versus-originated variance:

SELECT person_number, disbursement_ref_number, disbursement_amount, disbursement_accpt_amount, (disbursement_amount - disbursement_accpt_amount) variance FROM apps.igffv_pell_disbursements WHERE disbursement_amount <> NVL(disbursement_accpt_amount,0) ORDER BY variance DESC;

Batch reconciliation by award year and batch:

SELECT batch_id, award_year, COUNT(*) disb_count, SUM(disbursement_amount) total_amt FROM apps.igffv_pell_disbursements WHERE rfmb_id IS NOT NULL GROUP BY batch_id, award_year;

Because the view is read-only, all access is limited to SELECT statements. Large institutions should qualify queries by award year or person to avoid full scans across the underlying disbursement and party tables.