Maintained for Historical Purposes

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

Loan Record Detail Report (LRDR) Import Tool

Posted Date: March 11, 2015

Author: Pamela Eliadis, Service Director, System Operations & Aid Delivery Management, Federal Student Aid

Subject: Loan Record Detail Report (LRDR) Import Tool

We are pleased to announce the availability of the National Student Loan Data System (NSLDS) Loan Record Detail Report (LRDR) Import Tool. The LRDR Import Tool can be used to easily load data generated from the LRDR into the Microsoft Excel spreadsheet application, and is designed to assist schools with reviewing and analyzing their LRDR extract files.

An LRDR contains information on the loans that were used to calculate a school’s draft or
official cohort default rate (CDR) and is distributed as part of the eCDR notification package. Each eCDR package contains an extract-type LRDR (message class SHCDREOP). When the LRDR extract is loaded into the LRDR Import Tool, the file is converted into a spreadsheet with assigned column headings, creating a view of the data that is manageable and easy to review.

Note: As a reminder, schools can request an LRDR on an ad-hoc basis on the NSLDS Professional Access Web site. An LRDR that has been requested online may also be loaded into the LRDR Import Tool.

To download the LRDR Import Tool, go to the Default Management Web site and choose “CDR Guide” from the left-hand navigation bar. The LRDR Import Tool can be found in the “Templates/Spreadsheets” section. Instructions for using the tool are provided on the first tab of the workbook.

Contact Information

If you have questions about using the LRDR Import Tool or NSLDS, contact the NSLDS Customer Support Center at 800/999-8219. You can also contact Customer Support by e-mail at

Last Modified: 03/10/2015