Search Results igf_ap_nslds_data_all_pk

Overview

The IGF_AP_NSLDS_DATA_ALL table is a core data repository within the Oracle E-Business Suite (EBS) Financial Aid module (IGF). It serves as the primary storage location for National Student Loan Data System (NSLDS) information received for financial aid applicants. The NSLDS is a central U.S. Department of Education database containing federal student aid history. This table's role is to persist critical NSLDS data, such as aggregate loan amounts and Pell Grant usage, which is essential for calculating a student's eligibility for federal financial aid, ensuring compliance with loan limits, and performing regulatory overaward checks. Its "ALL" suffix indicates it is a multi-org table capable of storing data for multiple operating units, a standard design pattern in EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to hold the parsed NSLDS response data for a student. While the full column list is not detailed in the provided metadata, the primary key is documented as NSLDS_ID, a unique system-generated identifier for each NSLDS record. A critical foreign key column is ISIR_ID, which links the NSLDS data to a specific Institutional Student Information Record (ISIR) in the IGF_AP_ISIR_MATCHED_ALL table. This linkage is fundamental, as it ties the NSLDS history to the specific aid application and student. Typical data stored in this table, based on its purpose, includes aggregate outstanding principal on federal loans, Pell Grant Lifetime Eligibility Used (LEU), defaults or overpayments status, and other history elements used in need analysis and packaging.

Common Use Cases and Queries

The primary use case is the automated import and processing of an NSLDS Financial Aid History (FAH) response for a student who has applied for federal aid. System processes parse the NSLDS response and populate this table. Aid administrators and batch processes then query this data to determine eligibility. Common reporting and query scenarios include identifying students approaching or exceeding aggregate loan limits, verifying Pell Grant eligibility, and resolving Common Origination and Disbursement (COD) edit conflicts. A fundamental query pattern joins this table to the ISIR and student base tables:

• SELECT s.person_id, n.* FROM igf_ap_nslds_data_all n, igf_ap_isir_matched_all i, igf_ap_fa_base_rec_all s WHERE n.isir_id = i.isir_id AND i.base_id = s.base_id AND s.person_id = :stu_id;

This retrieves all NSLDS data for a specific student, which is crucial for packaging and audit reviews.

Related Objects

The table has documented relationships with other core Financial Aid tables, primarily through foreign key constraints. The key relationship is with the ISIR data, forming the backbone of the applicant's financial aid profile.

• IGF_AP_ISIR_MATCHED_ALL: This is the primary related table. The foreign key constraint from IGF_AP_NSLDS_DATA_ALL.ISIR_ID references the IGF_AP_ISIR_MATCHED_ALL table. This enforces that every NSLDS record must be associated with a valid ISIR application record.
• Primary Key Constraint: The table is governed by the IGF_AP_NSLDS_DATA_ALL_PK constraint on the NSLDS_ID column, ensuring the uniqueness of each record.

While not listed in the provided metadata, this table is also commonly referenced by financial aid packaging engine logic, overaward calculation routines, and regulatory reporting extracts within the IGF module.