Search Results bkd_int_rebate

Overview

IGF_DB_YTD_SMR is an Oracle E-Business Suite view owned by the APPS schema and registered in FND Design Data as IGF.IGF_DB_YTD_SMR. It is classified as a Multi-Org view, meaning that queries executed against it are automatically restricted to the operating unit of the current session, and rows belonging to other operating units are excluded. The view stores the summary of year-to-date disbursement data, and it is part of the Oracle Student Financial Aid / Financial Aid module. Its principal role is to expose aggregated disbursement figures — both booked and unbooked — for reporting and interface generation, notably in support of the Direct Loan reporting framework. This view is documented as VALID and is present in both Oracle EBS 12.1.1 and 12.2.2.

The view carries no documented dependency information in the ETRM extract; the referenced base objects section is empty. Functionally, however, its columns indicate that it is defined over the underlying disbursement summary entity, whose primary key is YTDS_ID and whose design data object name matches the view name (IGF_DB_YTD_SMR).

Underlying Base Objects

The ETRM documentation for this object lists no referenced base tables or views. The view is nevertheless identified in FND Design Data as IGF.IGF_DB_YTD_SMR and the owning application is IGF (Oracle Financial Aid). Its columns expose the same attributes expected of the underlying disbursement summary table, including the unique key YTDS_ID and the standard Who columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) plus concurrent program audit columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID). In the absence of documented base objects, the view should be treated as a reporting projection over the financial aid disbursement summary data, filtered by operating unit through the Multi-Org mechanism.

Key Columns

• ROW_ID — ROWID identifying the row in the underlying object.
• YTDS_ID — Primary identifier for the year-to-date disbursement summary record.
• DL_VERSION — Direct Loan file format version associated with the record.
• RECORD_TYPE — Distinguishes Year-To-Date Summary from Monthly Summary information.
• BATCH_ID — Identifier of the processing batch.
• SCHOOL_CODE — Institution code for the reporting entity.
• STAT_END_DT / PROCESS_DT — Statement end date and process date for the reporting period.
• DISB_SMR_TYPE — Disbursement summary type.
• BKD_GROSS — Gross amount booked; the column most often targeted when searching for "bkd_gross".
• BKD_FEE, BKD_INT_REBATE, BKD_NET — Fee, interest rebate and net amount for booked disbursements.
• UNBKD_GROSS, UNBKD_FEE, UNBKD_INT_REBATE, UNBKD_NET — Equivalent amounts for disbursements not yet booked.

Common Use Cases and Queries

The view is typically queried to reconcile booked versus unbooked disbursement totals and to feed Direct Loan year-to-date or monthly summary reporting. Because it is a Multi-Org view, results are limited to the current operating unit.

SELECT ytds_id,
       batch_id,
       school_code,
       stat_end_dt,
       disb_smr_type,
       bkd_gross,
       bkd_fee,
       bkd_int_rebate,
       bkd_net
  FROM apps.igf_db_ytd_smr
 WHERE record_type = 'YTD';

SELECT disb_smr_type,
       SUM(bkd_gross)   AS total_bkd_gross,
       SUM(unbkd_gross) AS total_unbkd_gross
  FROM apps.igf_db_ytd_smr
 WHERE stat_end_dt BETWEEN :start_date AND :end_date
 GROUP BY disb_smr_type;

Users searching for "bkd_gross" will find the column on this view, representing the gross amount booked for the reporting period. Joining to the batch or disbursement summary source by BATCH_ID or YTDS_ID supports detailed-to-summary reconciliation within the current operating unit.