Results for “igf_ap_nslds_data_all”

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

Overview

The IGF.IGF_AP_NSLDS_DATA_ALL table is a core financial aid data object within the Oracle E-Business Suite IGF – Financial Aid product module. It stores the National Student Loan Data System (NSLDS) response data associated with a financial aid student, capturing loan aggregates, Pell payment history, default and overpayment indicators, and related federal aid status information returned by the NSLDS processing cycle. In Oracle EBS 12.1.1 and 12.2.2, this table is owned by the IGF schema and is documented as VALID, with 207 physical columns.

The table is a dependent child of the ISIR matching process. Its primary key is defined by the constraint IGF_AP_NSLDS_DATA_ALL_PK on the NSLDS_ID column, and it carries a foreign key on ISIR_ID referencing IGF_AP_ISIR_MATCHED_ALL. Based on the heuristic Data Vault classification mined from the foreign key structure, the table is satellite-leaning: it is best modeled as a descriptive satellite hanging off the ISIR-link hub, holding the wide, attribute-rich NSLDS payload for each matched student record.

Key Information Stored

The table is intentionally wide because NSLDS responses contain both aggregate totals and repeating per-loan and per-Pell segments. The most significant columns include:

• NSLDS_ID – surrogate primary key (constraint IGF_AP_NSLDS_DATA_ALL_PK) and the unique business-key candidate IGF_AP_NSLDS_DATA_ALL_U1.
• ISIR_ID – foreign key to IGF_AP_ISIR_MATCHED_ALL; also a unique candidate via IGF_AP_NSLDS_DATA_ALL_U2, establishing the one-to-one relationship between a matched ISIR and its NSLDS record.
• BASE_ID – base/grouping identifier used for record lineage.
• NSLDS_TRANSACTION_NUM / TRANSACTION_NUM_TXT – NSLDS transaction identifiers for the returned response.
• NSLDS_DATABASE_RESULTS_F and NSLDS_F – flags indicating the presence and status of database results.
• NSLDS_PELL_OVERPAY_F / NSLDS_PELL_OVERPAY_CONTACT – Pell overpayment indicator and contact information.
• NSLDS_DEFAULTED_LOAN_F and NSLDS_DISCHARGED_LOAN_F – flags for defaulted and discharged loans.
• NSLDS_AGG_SUBSZ_OUT_PRIN_BAL, NSLDS_AGG_UNSBZ_OUT_PRIN_BAL, NSLDS_AGG_COMB_OUT_PRIN_BAL, NSLDS_AGG_CONS_OUT_PRIN_BAL – aggregate outstanding principal balances by loan category.
• NSLDS_AGG_SUBSZ_TOTAL, NSLDS_AGG_UNSBZ_TOTAL, NSLDS_AGG_COMB_TOTAL, NSLDS_AGG_CONSD_TOTAL – aggregate loan totals used in needs-analysis calculations.
• NSLDS_PERKINS_OUT_BAL / NSLDS_PERKINS_CUR_YR_DISMNT – Perkins loan balance and current-year disbursement.
• NSLDS_ADDTNL_PELL_F, NSLDS_ADDTNL_LOAN_F and DIRECT_LOAN_MAS_PROM_NT_F / DLP_MASTER_PROM_NOTE_FLAG – additional-aid and master promissory note indicators.
• ORG_ID – operating unit partitioning column for multi-org reporting.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID – standard EBS WHO/audit and concurrent-program columns.

Recurring Pell segments are captured through NSLDS_PELL_*_1..3 (scheduled amount, amount paid to date, remaining amount, award amount, school code, EFC), while loan detail is captured through NSLDS_LOAN_*_1..6 segments covering loan type, program code, net amount, current status, aggregate principal balance, contact type, grade level, and capital interest flags.

Common Use Cases and Queries

Typical usage centers on financial aid packaging, compliance reporting, and monitoring default or overpayment status. Example patterns include:

• Retrieving all NSLDS records for a student via join to the ISIR table: SELECT n.NSLDS_ID, n.ISIR_ID, n.NSLDS_AGG_SUBSZ_TOTAL, n.NSLDS_DEFAULTED_LOAN_F FROM IGF.IGF_AP_NSLDS_DATA_ALL n WHERE n.ISIR_ID = :isir_id;
• Flagging students with defaulted or discharged loans for exclusion from packaging: SELECT ISIR_ID FROM IGF.IGF_AP_NSLDS_DATA_ALL WHERE NSLDS_DEFAULTED_LOAN_F = 'Y' OR NSLDS_DISCHARGED_LOAN_F = 'Y';
• Aggregate-limit monitoring using NSLDS_AGG_SUBSZ_TOTAL and NSLDS_AGG_COMB_TOTAL.
• Pell overpayment reconciliation queries using the NSLDS_PELL_* segments and overpayment flags.
• Audit and lineage queries using REQUEST_ID, PROGRAM_ID, and LAST_UPDATE_DATE to trace how NSLDS data arrived.

Related Objects

The most significant related objects, based on documented foreign-key and PK relationships, are:

• IGF_AP_ISIR_MATCHED_ALL – parent record; joined via IGF_AP_NSLDS_DATA_ALL.ISIR_ID = IGF_AP_ISIR_MATCHED_ALL.ISIR_ID. This is the primary relationship of the table.
• IGF_AP_NSLDS_DATA_ALL_PK – primary key constraint on NSLDS_ID.
• IGF_AP_NSLDS_DATA_ALL_U1 – unique index supporting the NSLDS_ID key.
• IGF_AP_NSLDS_DATA_ALL_U2 – unique index on ISIR_ID, enforcing the one-to-one cardinality between matched ISIR and NSLDS data.
• Related ISIR and student aid dependent views/tables within the IGF schema that reference NSLDS results for packaging and disbursement logic, joined on ISIR_ID or NSLDS_ID.