Maintained for Historical Purposes

This resource is being maintained for historical purposes only and is not currently applicable.

(NSLDS Guaranty Agency (GA) Technical Updates) GA-2002-02 Fiscal Year 2000 and 2001 Reasonability

Publication Date: April 29, 2002

Section: GA-2002-02


United States Department of Education
Federal Student Aid
National Student Loan Data System

Fiscal Year 2000 and 2001 Reasonability
Technical Update GA-2002-02
April 29, 2002

This information is intended for the person in your organization who is responsible for working with NSLDS. If that is not you, please forward this update to the appropriate person.

Comparing NSLDS Data to the Guaranty Agency Quarterly/Annual Report
(ED Form 1130) and the Guaranty Agency Financial Report (ED Form 2000)

This technical update is a comprehensive distribution of reasonability on selected annual items between the Guaranty Agency Financial Report (GAFR) for FY 2001, the Guaranty Agency Quarterly/Annual Report (ED Form 1130) for FY 2000, and data resident on NSLDS at the time of calculation for each respective period. You will find attached to this technical update:

A. Guaranty Agency Financial Report (ED Form 2000) Comparison to NSLDS Data for Fiscal Year 2001 (10/1/00 to 9/30/01). For easy reference, the GAFR line items are listed in the comparison. The Department of Education's (ED) Financial Management Division, Financial Partners, provided NSLDS with the GAFR fiscal year reports by agency.*

B. ED Form 2000 Comparison to NSLDS Data All GA Summary. This is a compilation of GAFR and NSLDS totals for active guaranty agencies. This worksheet also lists the guaranty agency-wide differences and percent differences for FY 2001.*

C. Guaranty Agency Quarterly/Annual Report (ED Form 1130) Comparison to NSLDS Data for Fiscal Year 2000 (10/1/99 to 9/30/00). For easy reference, the ED Form 1130 line items are listed in the comparison. The Department of Education's (ED) Financial Management Division, Financial Partners, provided ED with the 1130 fiscal year reports by agency. (Note that the report title is ED Form 2000 Comparison to NSLDS Data with an FY end date of 09/30/2000.)*

D. ED Form 1130 Comparison to NSLDS Data All GA Summary. This is a compilation of ED Form 1130 and NSLDS totals for active guaranty agencies. This worksheet also lists the guaranty agency-wide differences and percent differences for FY 2000. (Note that the report title is ED Form 2000 Comparison to NSLDS Data All GA Summary with an FY end date of 09/30/2000.)*

*Each reasonability report provides the following information:

  • The Amount from GAFR As Per ED column represents the ED reported value for the line item. (For FY 2000 this would be from the ED Form 1130 in light of column heading.)
  • The Amount from NSLDS column represents the NSLDS-calculated value for the line item.
  • The Amount Difference column presents the line item difference between the NSLDS-calculated value and the ED-calculated value based on GA reporting.
  • ยท The Percent Difference column gives a percentage value to the line item difference between ED values and NSLDS data.
  • The Percent Difference All GA column represents the average line item difference for all active guaranty agencies, so that each agency will have a perspective on these differences.

Note: If your agency is currently working with ED to modify or correct your financial reports, those changes may not be reflected in this comparison.

E. NSLDS Annual Reasonability Computation Worksheet. This worksheet details NSLDS methods for calculating each line item. The first column provides the ED GAFR line item for the comparison. The second column provides the ED Form 1130 line item for the comparison. The third and fourth columns provide NSLDS source attributes from the DPI (Data Provider Instructions) used in the calculation and a description of the computation logic for that line item.

F. Backup Data for Quarterly Reasonability File Layout. NSLDS items (AR-1, AR-2, AR-3, AR-4, AR-6, AR-7, AR-8, AR-10, AR-11, and prior year equivalents) included in the reasonability comparison are calculated on a quarterly basis. The aggregates of the four quarters within the fiscal year for each item type are included on the comparison spreadsheet. You may request backup detail for each quarter that comprises the annual figure for FY 2001, 2000, and/or FY 1999.* This file layout provides details for the quarterly backup detail.

G. Reasonability Yearly Backup File Record Layout. NSLDS items, AR-12 and AR-13 (Part E of Form 1130), that are included in the reasonability comparison are calculated on an annual basis. You may request backup detail for FY 2001, 2000, and/or FY 1999.* This file layout provides details for the annual backup detail.

*Detail for FY 1999 may no longer match the NSLDS figures provided on the FY 1999 1130 Comparison Worksheet. A new worksheet can be provided if you request complete backup detail for FY 1999.

FY 2000/2001 Reasonability Schedule

The schedule listed below provides the dates when quarterly and annual components of the reasonability calculation took place for FY 2000 and FY 2001. FY 2002 items AR-1 through AR-11 will be calculated 60 days after the end of each quarter. Items AR-12 and AR-13 are calculated once annually, 60 days after the end of the fourth quarter. Data received prior to these dates will be included in the reasonability calculations according to the logic provided in the computation worksheet (Attachment E).

Period
Frequency
NSLDS Run Date
10-01-1999 to 12-31-1999
Quarterly (Part A)
10-23-2001
01-01-2001 to 03-31-2001
Quarterly (Part A)
10-27-2001
04-01-2001 to 06-30-2001
Quarterly (Part A)
10-31-2001
07-01-2001 to 09-30-2001
Quarterly (Part A)
11-02-2001
10-01-2000 to 09-30-2001
Annual (Part E)
01-19-2002
10-01-2000 to 12-31-2000
Quarterly (Part A)
11-06-2001
01-01-2001 to 03-31-2001
Quarterly (Part A)
11-08-2001
04-01-2001 to 06-30-2001
Quarterly (Part A)
11-13-2001
07-01-2001 to 09-30-2001
Quarterly (Part A)
12-02-2001
10-01-2000 to 09-30-2001
Annual (Part E)
01-06-2002


Researching Loan Level Details

NSLDS can now provide loan level detail for selected line items on the reasonability comparisons. ED continues to work with the guaranty agency community to determine those line items from the Guaranty Agency Financial Report (GAFR) to compare with NSLDS data. Preparations are underway to provide reasonability comparisons and loan level detail to the GAFR for FY 2002 and future years. In preparation for FY 2001 reasonability, it was necessary to convert ED Form 1130 Consolidation loan guarantees and cancellations to the GAFR (Form 2000) format, thus items AR-1D and AR-2D have been converted to AR-3 and AR-4.


If you have any questions, please contact the NSLDS Customer Service Center at
(800) 999-8219 or e-mail them at nsldscoe@raytheon.com.