Search Results current_ssn_txt




Overview
Explore in AI Chat

Overview

IGF_GR_YTD_DISB is a reporting view owned by the APPS schema within the IGF (Financial Aid) product family of Oracle E-Business Suite, available in both 12.1.1 and 12.2.2. The view presents year-to-date disbursement activity associated with financial aid origination records, consolidating disbursement reference data, acceptance amounts, payment period dates, and student identifiers into a single queryable structure. Its primary role is to support reporting and integration requirements where disbursement history must be retrieved in a flattened, business-friendly form rather than through direct joins against the underlying transaction tables. The view is defined as a secured query, applying an organization-level filter derived from the session's CLIENT_INFO context, which restricts returned rows to the operating unit currently in scope. This makes it suitable for use within Oracle Forms-based inquiries, concurrent program extracts, and external integrations that expect operating-unit-aware results without having to implement multi-org security logic themselves. The inclusion of columns such as CURRENT_SSN_TXT, STUDENT_NAME, and STUDENT_BIRTH_DATE reflects the view's orientation toward student-level compliance and reconciliation reporting.

Underlying Base Objects

The view is defined over a single documented base object: IGF_GR_YTD_DISB_ALL, aliased as GRYTDDB in the view text. IGF_GR_YTD_DISB_ALL is the multi-org (partitioned by ORG_ID) table that stores year-to-date disbursement records for financial aid grant and loan processing. Because the _ALL table carries the ORG_ID column, the view applies a predicate that evaluates the first ten characters of USERENV('CLIENT_INFO') and compares it against GRYTDDB.ORG_ID, with NVL handling to default unresolved context to -99. Queries against IGF_GR_YTD_DISB therefore return only records belonging to the current operating unit established by the client session. The view does not appear to join to additional tables, so all attributes are sourced directly from IGF_GR_YTD_DISB_ALL. The ROW_ID column is populated from the base table's ROWID, providing a stable identifier for row-level operations or drill-down navigation.

Key Columns

Common Use Cases and Queries

Typical uses include year-to-date disbursement reconciliation, SSN-based student matching, and multi-org disbursement extracts. A representative query retrieving disbursements for a given origination follows:

SELECT ytdds_id, origination_id, disb_ref_num, disb_acpt_amt, disb_dt, current_ssn_txt, student_name
FROM apps.igf_gr_ytd_disb
WHERE origination_id = :p_origination_id
ORDER BY disb_seq_num;

To list all year-to-date activity for a student identified by SSN within the current operating unit:

SELECT student_name, disb_ref_num, disb_acpt_amt, disb_dt, db_cr_flag
FROM apps.igf_gr_ytd_disb
WHERE current_ssn_txt = :p_ssn
AND fin_award_year_num = :p_award_year;

Because the view enforces operating unit context via CLIENT_INFO, integrations executing outside an EBS Forms session must set the client info context, or alternatively query IGF_GR_YTD_DISB_ALL directly with an explicit ORG_ID predicate. For batch extracts, callers should also filter on DISB_PROCESS_DATE or DISB_DT ranges to bound result sets.