Search Results unbkd_net

Overview

IGF_DB_YTD_SMR is an Oracle E-Business Suite view owned by the APPS schema within the IGF (Financial Aid) product module. It is documented as VALID and describes the summary of year-to-date disbursement data. Functionally, it exposes aggregated disbursement totals — most notably booked and unbooked gross, fee, interest rebate, and net amounts — for reporting, reconciliation, and downstream integration. The view is the secured, organization-filtered projection of its underlying "ALL" table, and is the object most commonly referenced by Financial Aid reports, concurrent programs, and extracts that need a consolidated, period-to-date picture of disbursement activity.

Underlying Base Objects

The documented base object is IGF_DB_YTD_SMR_ALL, which the view selects from with the alias YTDS. Every column returned by the view is a direct projection of a column from the _ALL table, with no joins, unions, or derived expressions in the SELECT list. The only logic is a multi-org security predicate applied in the WHERE clause. That predicate derives the current organization identifier from the USERENV('CLIENT_INFO') session value — reading the first ten bytes after stripping a leading blank — converts it to a number, and compares it against the ORG_ID on the _ALL table. Both sides of the comparison fall back to the literal -99 via NVL when no value is derivable. This is the standard EBS "ORG_ID = client info" pattern generated for multi-org secured objects. The metadata lists no other referenced base objects, and because the view text references only IGF_DB_YTD_SMR_ALL, the view has no documented dependencies beyond that single table.

Key Columns

• YTDS_ID — Primary identifier for the year-to-date summary row.
• BATCH_ID, SCHOOL_CODE — Batch and institution context for the summarized disbursement set.
• STAT_END_DT, PROCESS_DT — Statistical period end date and the date the row was processed.
• DISB_SMR_TYPE, RECORD_TYPE — Classification of the disbursement summary and record.
• BKD_GROSS, BKD_FEE, BKD_INT_REBATE, BKD_NET — Booked gross, fee, interest rebate, and the resulting net amounts.
• UNBKD_GROSS, UNBKD_FEE, UNBKD_INT_REBATE, UNBKD_NET — The corresponding unbooked amounts. UNBKD_NET is the unbooked net disbursement figure, matching the searched term unbkd_net.
• REGION_CODE, STATE_CODE — Geographic grouping attributes.
• REC_COUNT — Count of records aggregated into the summary row.
• DL_VERSION — Data-load version stamp for the record.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS auditing columns.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Standard concurrent program / who-column context identifying the run that produced the row.

Common Use Cases and Queries

The view is typically queried to reconcile booked versus unbooked disbursement positions for a school, batch, or statistical period. Sample query returning the net positions for a period:

SELECT ytds.batch_id,
       ytds.school_code,
       ytds.stat_end_dt,
       ytds.bkd_net,
       ytds.unbkd_net
  FROM apps.igf_db_ytd_smr ytds
 WHERE ytds.stat_end_dt BETWEEN :start_date AND :end_date
   AND ytds.school_code = :school_code
 ORDER BY ytds.stat_end_dt;

To compute the total unbooked net exposure across all summaries, summing the searched column:

SELECT SUM(NVL(ytds.unbkd_net,0)) total_unbkd_net
  FROM apps.igf_db_ytd_smr ytds
 WHERE ytds.process_dt = :process_dt;

To review unbooked gross, fee, and rebate components for a batch:

SELECT ytds.batch_id, ytds.record_type,
       ytds.unbkd_gross, ytds.unbkd_fee,
       ytds.unbkd_int_rebate, ytds.unbkd_net
  FROM apps.igf_db_ytd_smr ytds
 WHERE ytds.batch_id = :batch_id;

Because multi-org security is enforced through the ORG_ID predicate, queries must run in a session whose CLIENT_INFO is initialized to the appropriate organization (for example via FND_GLOBAL.APPS_INITIALIZE). These patterns support period-end reporting, disbursement reconciliation, and downstream extracts that require both booked and unbooked net totals.