Search Results disb_process_date

Overview

IGF_GR_YTD_DISB is a multi-org view owned by the APPS schema in Oracle E-Business Suite, registered under FND Design Data as IGF.IGF_GR_YTD_DISB and holding a VALID status. It exposes year-to-date disbursement records associated with the Oracle Student System (formerly Oracle Financial Aid / IGF) grant and Title IV disbursement processing. Because it is implemented as a multi-org view, it automatically restricts results to the operating unit of the current session, ignoring rows belonging to other operating units. A typical query therefore returns only the disbursement data relevant to the user's active organization.

The view serves as a reporting and integration surface for disbursement activity exchanged with the Common Origination and Disbursement (COD) System. Its columns align closely with the federal reporting fields used in Pell Grant and Direct Loan submissions, making it a convenient read-only source for reconciliation reports, audit extracts, and downstream interfaces that must respect operating unit security.

Underlying Base Objects

The documented ETRM metadata for this view lists no explicitly referenced base objects; the object definition is identified by its FND Design Data entry and by the column list embedded in the view source. In practice, IGF_GR_YTD_DISB is a multi-org secured projection over the IGF disbursement tables that carry the year-to-date disbursement identifiers (YTDDS_ID) and origination records. It wraps these transactional tables in an operating-unit filter keyed on ORG_ID, so callers do not need to add an organization predicate manually. Because the underlying tables are not enumerated in the supplied metadata, implementers should inspect the view DDL in the target instance (for example, via ALL_VIEWS and DBA_DEPENDENCIES) to confirm the exact base table list before building custom extensions.

Standard WHO audit columns are inherited from the base records, including CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE.

Key Columns

• YTDDS_ID — primary identifier for the year-to-date disbursement summary record.
• ORIGINATION_ID / INST_CROSS_REF_CODE — links the disbursement to the originating award or loan record and the institution cross-reference code.
• DISB_REF_NUM / DISB_SEQ_NUM / PREV_DISB_SEQ_NUM — disbursement reference and the sequence counters used to track adjustments and the order in which records were processed.
• DISB_ACCPT_AMT / DB_CR_FLAG — accepted disbursement amount and its debit/credit indicator.
• DISB_DT / DISB_PROCESS_DATE / PYMT_PRD_START_DT — the disbursement date, the date the record was processed by the COD System, and the payment period start date.
• DISB_REL_IND / ACTION_CODE — indicates whether the disbursement is anticipated or actual, and the action applied to the record.
• CI_CAL_TYPE / CI_SEQUENCE_NUMBER / FIN_AWARD_YEAR_NUM — calendar instance and award year context for the disbursement.
• STUDENT_NAME / CURRENT_SSN_TXT / STUDENT_BIRTH_DATE — student identity attributes carried on the record.
• ROUTING_ID_TXT / ATTEND_ENTITY_ID_TXT — unique entity identifier and the Pell-ID of the attended campus.
• ORG_ID — operating unit used by the multi-org filter.

Common Use Cases and Queries

The most frequent requirement, and the one corresponding to the search term disb_process_date, is to retrieve disbursements processed within a given COD processing window for reconciliation or federal reporting. A representative query is:

• SELECT YTDDS_ID, DISB_REF_NUM, DISB_ACCPT_AMT, DISB_DT, DISB_PROCESS_DATE, STUDENT_NAME FROM APPS.IGF_GR_YTD_DISB WHERE DISB_PROCESS_DATE BETWEEN :p_start AND :p_end ORDER BY DISB_PROCESS_DATE;
• Anticipated versus actual disbursement analysis: filter on DISB_REL_IND and aggregate by FIN_AWARD_YEAR_NUM.
• Adjustment tracking: select rows where DISB_SEQ_NUM > 1 or PREV_DISB_SEQ_NUM IS NOT NULL to identify re-processed disbursements.
• Student-level extracts by joining CURRENT_SSN_TXT or ROUTING_ID_TXT to student and award tables.

Since operating unit security is enforced within the view, no additional ORG_ID predicate is required for standard reporting users.