Publication Date: July 6, 2007
Author: William Leith, Acting General Manager, Application, Operations and Delivery Services, Federal Student Aid
Summary: Availability of Direct Loan (DL) Tools for Windows, Release 7.0
Posted on 07-06-2007
Federal Student Aid is pleased to announce the availability of Direct Loan (DL) Tools for Windows, Release 7.0, a supplemental software product for Direct Loan participants. DL Tools is available for download from ED’s Federal Student Aid Download Web site, located at fsadownload.ed.gov.
In addition to the software, the following DL Tools, Release 7.0 user documentation is now available on the FSAdownload Web site:
These documents contain important information regarding DL Tools functionality, enhancements, and installation that you should review.
Volume IV (DL Tools) of the 2007-2008 COD Technical Reference, which includes external import record layouts and other information for system administrators, will be available later in July 2007.
What is DL Tools?
DL Tools is a multi-year, Windows-based application designed to provide the following functionality related to all Direct Loan schools’ software:
DL Tools processes data for multiple program years. Release 7.0 contains SAS Compare and formatting, Cash Management, and Rebuild functionality for the 2005-2006, 2006-2007, and 2007-2008 cycles.
All Direct Loan schools can use the Compare and Cash Management functions. The Rebuild function is used by schools to rebuild accepted Direct Loan records in EDExpress for Windows databases. However, non-EDExpress users can export data from a rebuilt EDExpress database to recreate non-EDExpress loans or databases. For information on creating file formats and exporting data from EDExpress to an external system and creating file formats, see Volume III of the 2007-2008 COD Technical Reference.
One way to meet the Quality Assurance requirement in the Direct Loan program is to run the Disbursement Measurement Tool Report (available in DL Tools if connected to EDExpress), as well as certain Direct Loan lists (available in EDExpress). Tolerances can be applied when running these reports. Tolerances are guidelines you set for evaluating the effectiveness of your school’s Direct Loan processes and procedures.
The Disbursement Measurement Tool Report and certain Direct Loan lists with tolerances assist schools with monitoring current operations, procedures, and program status. Your school decides which reports to use, when to run them, and what action to take as a result. You can use them to review progress as part of a continuous improvement plan.
If you do not use EDExpress, you can still use DL Tools to assist in reconciling Direct Loans. You can import cash, loan, or disbursement data from your external Direct Loan system into DL Tools and compare your data to the SAS.
Important DL Tools Comparison Reports Note: DL Tools Loan and Disbursement Comparison Reports are designed to be run using the SAS with YTD (Year-to-Date) detail, not monthly detail. See Direct Loan Bulletin (DLB) 02-36 for information about default settings and SAS option selections. You may change your SAS options (YTD detail, for example) by contacting your COD School Relations customer service representative at 800/848-0978; TDD/TTY 800/461-7010 or by e-mail at CODSupport@acs-inc.com or by accessing the COD Web site at cod.ed.gov.
Before You Install Release 7.0
You cannot access 2004-2005 data in your DL Tools database after you upgrade from Release 6.0 to Release 7.0. We strongly recommend you create a back-up copy of your Release 6.0 database (DLT.mdb) before upgrading to Release 7.0, in the event that you need to access your 2004-2005 data using an earlier version of DL Tools on another PC.
You must also make sure there are no record locks on the database and that no user IDs are logged in by following the steps listed below:
1) To check for record locks, select Tools, Clear Locks from the menu bar. If you receive the message “No records selected,” there are no record locks. If the Clear Locks dialog box appears, click Select All, then OK to clear any record locks.
2) To check for logged-in user IDs, select Tools, Setup, Security Users from the menu bar, and then click Retrieve. The user ID you are currently using should be the only ID with a “Y” displayed in the Logged In column (you can disregard the Locked column). Select any user ID displayed as logged in and click OK. Clear the Logged In? checkbox and click OK. Repeat the process for each logged-in user ID except the one you are using.
Release 7.0 Download/Installation Process
DL Tools Release 7.0 is available for download from the FSAdownload Web site located at fsadownload.ed.gov in two formats. You can download the entire software in one file, called DLTool70.exe, or you can download the software in separate “disk” installment files, which can be copied to a network drive (LAN), CD, or other portable storage format. Review the download instructions in the “Downloading DL Tools from the FSAdownload Web Site” section of the Installation Guide for further information.
You are required to have Windows 2000 or Windows XP as your PC workstation operating system to run DL Tools Release 7.0.
Note: At this time, Federal Student Aid has not certified the Microsoft Corporation’s recently released Windows Vista as a supported operating system for DL Tools or its other PC software products. This guidance also applies to the Local Area Network (LAN) or “server” version of Windows, known as Windows Server 2008, which is due for release in 2008. We will provide additional information as it becomes available.
Important Installation Alert: Y ou must be an Administrator on your workstation to install DL Tools for Windows, Release 7.0 in the Windows 2000 or Windows XP operating systems. If you are not an Administrator, you will receive a warning when you try to install DL Tools. After an Administrator has installed DL Tools, you can run DL Tools as a member of the Power Users group. If your database is on a network server, you must be a Power User or higher on the network (or “domain”) as well as on your workstation. No workarounds exist for these Windows rights issues. Consult with your school’s technical department if you receive a warning that an Administrator must install the DL Tools software.
DL Tools for Windows Release 7.0 can be installed as an upgrade to DL Tools Release 6.0 in order to carry existing 2005-2006 and 2006-2007 DL Tools data forward. To upgrade DL Tools from Release 6.0 to Release 7.0, run the Stand Alone Custom installation option (for standalone PC environments) or Workstation installation option (for network environments). The Workstation installation option should be run on all PCs in your office that currently access the DL Tools Release 6.0 database on your network.
The DL Tools database is updated with the DL Tools Release 7.0 changes the first time you access the DL Tools Release 7.0 software following completion of your Stand Alone Custom or Workstation installation(s). You will no longer be able to DL Tools Release 6.0 after this update is completed.
Users installing DL Tools for the first time should perform either the Stand Alone Full installation option (for standalone PC environments) or the Network Server and Workstation installations (for network environments) of Release 7.0. New DL Tools users are not required to have Release 6.0 installed prior to installing Release 7.0.
If you receive any prompt while installing DL Tools indicating an existing file was found and asking if you want to overwrite it, click “Yes.”
If You Have Questions
If you need assistance connecting to the FSAdownload site, downloading DL Tools in single or multiple file format, or with the installation or use of DL Tools, contact CPS/SAIG Technical Support at 800/330-5947 (TDD/TTY 800/511-5806)or by e-mail at CPSSAIG@ed.gov.
If you have technical questions about Federal Student Aid’s systems and software, you may want to subscribe to our e-mail listserv, FSATECH. For more information about FSATECH, including how to subscribe, go to http://FSA4Schools.ed.gov, click “Listservs/Mailing Lists” on the left menu, and click the “FSATech listserv” link.