Search Results bkd_net

Overview

IGF_DB_YTD_SMR is a view owned by the APPS schema in Oracle E-Business Suite, registered under FND Design Data identifier IGF.IGF_DB_YTD_SMR and reported with a status of VALID. It belongs to the Oracle Financials product family associated with the IGF (Financial Aid / Direct Loan) application module and presents summarized year-to-date disbursement information for federal student financial aid processing.

The view is documented as a multi-organization view: queries executed against it return data only for the current operating unit session context and ignore rows belonging to other operating units. This behavior is enforced transparently through the standard multi-org mechanism, so report and concurrent program consumers do not need to add explicit operating unit predicates.

Functionally, the view stores the summary of year-to-date data for disbursement. It exposes two related categories of summary records: year-to-date summary information and monthly summary information, distinguished by the RECORD_TYPE column. The row-level identifier YTDS_ID provides uniqueness across summary records within a batch and statement period. The view is typically consumed by Direct Loan reporting and extract processes rather than by interactive forms, and the presence of standard concurrent program Who columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID) indicates that rows are commonly produced or refreshed by batch programs.

The user search term "bkd_net" maps directly to the BKD_NET column documented in this view, the net amount booked.

Underlying Base Objects

The ETRM documentation excerpt for IGF_DB_YTD_SMR does not enumerate any referenced base tables or views; the "Referenced base objects" entry is listed as none documented. As a consequence, the precise FROM clause and any join or union logic used to construct the view cannot be stated authoritatively from the supplied metadata.

What is documented is the view's role and shape. Its columns mirror a persistent summary entity identified by YTDS_ID, with batch-level context (BATCH_ID), school context (SCHOOL_CODE), statement and process dates (STAT_END_DT, PROCESS_DT), and paired booked and unbooked monetary measures. This structure is consistent with a view defined over one or more disbursement summary base tables in the IGF schema, possibly joined to reference data for school or batch attributes.

Because the view is a multi-org view, its definition will incorporate the operating unit security construct used across EBS, filtering rows according to the organization associated with the underlying disbursement records. Administrators should treat the view as read-oriented and avoid direct DML through it unless a corresponding key-preserved table and instead-of trigger are known to exist.

Key Columns

• ROW_ID — ROWID of the underlying row.
• DL_VERSION — Direct Loan file format version, identifying the layout used for the extract.
• YTDS_ID — Unique identifier for the year-to-date disbursement summary record.
• RECORD_TYPE — Distinguishes Year-To-Date Summary records from Monthly Summary records.
• BATCH_ID — Unique identifier for the batch associated with the summary.
• SCHOOL_CODE — School code for the reporting entity.
• STAT_END_DT — Statement end date for the report period.
• PROCESS_DT — Date the summary was processed.
• DISB_SMR_TYPE — Disbursement summary type classification.
• BKD_GROSS — Gross amount booked.
• BKD_FEE — Fee applied to the gross amount booked.
• BKD_INT_REBATE — Disbursement interest rebate for the booked amount.
• BKD_NET — Net amount booked, the value most commonly retrieved when users search on "bkd_net".
• UNBKD_GROSS / UNBKD_FEE / UNBKD_INT_REBATE / UNBKD_NET — Corresponding gross, fee, interest rebate, and net amounts for disbursements not yet booked.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Who audit columns.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID — Concurrent program context columns.

Common Use Cases and Queries

Typical consumers reconcile booked and unbooked disbursement totals by statement period, reproduce Direct Loan summary reporting, and verify batch processing outcomes. The following examples illustrate practical access patterns.

• Retrieve booked net amounts for a statement period: SELECT batch_id, school_code, stat_end_dt, bkd_gross, bkd_fee, bkd_net FROM apps.igf_db_ytd_smr WHERE stat_end_dt = :p_stat_end_dt AND record_type = 'Y';
• Compare booked versus unbooked net amounts: SELECT ytds_id, bkd_net, unbkd_net, (bkd_net + unbkd_net) total_net FROM apps.igf_db_ytd_smr WHERE batch_id = :p_batch_id;
• Identify rows created by a specific concurrent request: SELECT ytds_id, request_id, program_id, creation_date FROM apps.igf_db_ytd_smr WHERE request_id = :p_request_id ORDER BY creation_date;
• Aggregate monthly and year-to-date summaries per school: SELECT school_code, record_type, SUM(bkd_net) FROM apps.igf_db_ytd_smr GROUP BY school_code, record_type;

Because operating unit filtering is implicit, no additional organization predicate is required; results reflect the session's current operating unit only.