Results for “nslds_agg_unsbz_total”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGF_AP_NSLDS_DATA_V is a Financial Aid (IGF) seed view owned by the APPS schema and shipped in valid status within Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented description is "NSLDS Details." The view exposes data received from the National Student Loan Data System (NSLDS), the U.S. Department of Education clearinghouse that reports a student's Title IV loan and grant history to institutions participating in federal student aid programs.

Within the Oracle Student System / Financial Aid architecture, NSLDS data arrives as part of the ISIR (Institutional Student Information Record) transaction load. The view provides a denormalized, flat read interface over that payload, allowing callers to evaluate default status, aggregate outstanding loan balances, overpayment flags, and Pell payment history without navigating the normalized staging and detail tables. It is primarily consumed by financial aid inquiry pages, validation logic, and reporting extracts rather than by transactional processing.

Underlying Base Objects

The ETRM metadata documents no referenced base objects for this view in 12.2.2. The naming convention of the exposed columns — NSLDS_ID, ISIR_ID, and BASE_ID — indicates the view is defined over NSLDS detail and ISIR base tables within the IGF schema family, keyed by an NSLDS record identifier, the originating ISIR identifier, and the student base identifier. Because the view text is a straight projection of columns with no aggregation or join predicates shown, it functions as a column-level abstraction layer: downstream code selects from IGF_AP_NSLDS_DATA_V so that the physical table layout can change between releases without breaking dependent objects.

This abstraction is significant during an upgrade from 12.1.1 to 12.2.2. Views in the IGF product family are frequently re-pointed at restructured tables while retaining their public column lists. Any customer extension that hard-codes a direct reference to a base table instead of the view may require remediation.

Key Columns

• Identity keys: NSLDS_ID, ISIR_ID, BASE_ID and TRANSACTION_NUM_TXT / NSLDS_TRANSACTION_NUM identify the NSLDS record, its source ISIR, and the student.
• Status flags: NSLDS_DATABASE_RESULTS_F, NSLDS_F, NSLDS_PELL_OVERPAY_F, NSLDS_SEOG_OVERPAY_F, NSLDS_PERKINS_OVERPAY_F, NSLDS_DEFAULTED_LOAN_F, NSLDS_DISCHGED_LOAN_CHNG_F, NSLDS_SATIS_REPAY_F, and NSLDS_ACT_BANKRUPTCY_F. These drive eligibility edits and disbursement holds.
• Aggregate loan balances: NSLDS_AGG_SUBSZ_OUT_PRIN_BAL, NSLDS_AGG_UNSBZ_OUT_PRIN_BAL, NSLDS_AGG_COMB_OUT_PRIN_BAL, and NSLDS_AGG_CONS_OUT_PRIN_BAL report outstanding principal by loan type; NSLDS_AGG_SUBSZ_TOTAL, NSLDS_AGG_UNSBZ_TOTAL, NSLDS_AGG_COMB_TOTAL, and NSLDS_AGG_CONSD_TOTAL report the corresponding aggregate totals. NSLDS_AGG_CONSD_TOTAL is the consolidated aggregate total — the column most often referenced by the user search term "nslds_agg_consd_total."
• Pending disbursements: NSLDS_AGG_SUBSZ_PEND_DISMT and NSLDS_AGG_UNSBZ_PEND_DISMT carry anticipated disbursement amounts.
• Perkins data: NSLDS_PERKINS_OUT_BAL and NSLDS_PERKINS_CUR_YR_DISMNT.
• Change indicators: NSLDS_OVERPAY_CHNG_F, NSLDS_AGG_LOAN_CHNG_F, NSLDS_PERKINS_LOAN_CHNG_F, and NSLDS_PELL_PAYMNT_CHNG_F signal that NSLDS updated a data element since the prior transaction.
• Pell payment detail (1 of 3): Repeating groups NSLDS_PELL_SEQ_NUM_n through NSLDS_PELL_AWARD_AMT_n capture scheduled amount, amount paid to date, remaining amount, percentage of scheduled award used, and award amount for up to three Pell records.

Common Use Cases and Queries

Typical uses include verifying default or overpayment status before authorizing a disbursement, reconciling institutional records against NSLDS-reported aggregate totals, and extracting Pell payment history for reporting.

Retrieve aggregate and consolidated totals for a student:

• SELECT base_id, nslds_transaction_num, nslds_agg_sabsz_total, nslds_agg_unsbz_total, nslds_agg_comb_total, nslds_agg_consd_total FROM apps.igf_ap_nslds_data_v WHERE base_id = :p_base_id;

Identify records with a defaulted loan or Pell overpayment flag:

• SELECT isir_id, nslds_id, nslds_defaulted_loan_f, nslds_pell_overpay_f FROM apps.igf_ap_nslds_data_v WHERE nslds_defaulted_loan_f = 'Y' OR nslds_pell_overpay_f = 'Y';

Detect records where NSLDS reported changed aggregate loan data, useful for periodic reconciliation:

• SELECT base_id, nslds_agg_loan_chng_f FROM apps.igf_ap_nslds_data_v WHERE nslds_agg_loan_chng_f = 'Y';

Because the view carries no documented WHERE clause, callers should always filter by BASE_ID, ISIR_ID, or NSLDS_ID. Applying a transaction-number predicate ensures the most recent NSLDS response is selected when multiple transactions exist for a student.