Results for “disbursement_date”

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

Overview

The view IGFBV_PELL_YTD_DISBURSEMENTS is a base view within the Oracle E-Business Suite IGF – Financial Aid module, a product line that is documented as Obsolete in Oracle EBS 12.1.1 and 12.2.2. Its stated purpose is to present the entity holding year-to-date (YTD) disbursement data, providing a read-only projection of the underlying YTD disbursement records for reporting and inquiry purposes. The view exposes instructional cross-reference codes, disbursement reference numbers, accepted disbursement amounts, debit/credit indicators, and associated date and audit columns, making it suitable for Pell Grant disbursement reconciliation and financial aid disbursement analysis.

Because the underlying module is obsolete, the view is not implemented in the current database. The ETRM metadata explicitly records “Not implemented in this database,” meaning the view definition exists only as documented reference material and does not generate a physical object in a supported environment.

Underlying Base Objects

The view text selects exclusively from a single base table, IGF_GR_YTD_DISB_ALL, aliased as YTDDS, and is defined with the WITH READ ONLY clause. No additional base objects are documented in the ETRM metadata; the referenced base object list is empty beyond the one table identified in the view text.

The naming convention of the base table follows the IGF Grants (GR) object family, with the _ALL suffix indicating a multi-organization or reporting-enabled table. The view is named with the IGFBV prefix, denoting a base view (as opposed to a security or summary view), and its relationship to the base table is a direct, non-joined projection: every column in the view maps to a column in IGF_GR_YTD_DISB_ALL. Because the view is read only and definitionally bound to a single table, it introduces no aggregation or transformation logic beyond the _LA lookup substitution described below.

Key Columns

The view exposes the following principal columns:

• INST_CROSS_REF_CODE — Institution cross-reference code identifying the reporting institution.
• “_LA:ACTION_CODE” — A lookup-aliased column substituting ACTION_CODE via the lookup view IGF_LOOKUPS_VIEW using lookup type IGF_GR_ACTION_CODE, returning the meaning of the action code. This is the mechanism that surfaces the ACTION_CODE semantic in place of the raw code.
• DISBURSEMENT_REFERENCE_NUMBER (DISB_REF_NUM) — Reference number uniquely identifying the disbursement.
• DISBURSEMENT_ACCPTED_AMOUNT (DISB_ACCPT_AMT) — The accepted disbursement amount.
• DEBIT_CREDIT_FLAG (DB_CR_FLAG) — The debit or credit indicator. This is the column most relevant to users searching for debit_credit_flag, indicating whether the disbursement record represents a debit or a credit posting.
• DISBURSEMENT_DATE (DISB_DT) — Date the disbursement was made.
• PAYMENT_PERD_START_DATE (PYMT_PRD_START_DT) — Start date of the payment period for the disbursement.
• DISBURSEMENT_BATCH_ID (DISB_BATCH_ID) — Identifier of the batch to which the disbursement belongs.
• ORIGINATION_ID — Origination identifier for the disbursement.
• YTDDS_ID — Primary identifier for the YTD disbursement record.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE.

Common Use Cases and Queries

Typical use cases include YTD disbursement reporting, Pell Grant disbursement reconciliation, and analysis of debit/credit activity for accepted disbursements by institution and batch. A representative query filtering on the debit/credit flag is:

• SELECT inst_cross_ref_code, disbursement_reference_number, disbursement_accpted_amount, debit_credit_flag, disbursement_date FROM igfbv_pell_ytd_disbursements WHERE debit_credit_flag = 'C';
• Aggregation of accepted amounts by payment period start date for a given origination identifier.
• Joining to the lookup meaning returned by the _LA action code column for action reporting.

Because the object is obsolete and not implemented, these queries are illustrative of the documented structure rather than executable in current EBS 12.1.1 or 12.2.2 installations.