A/L Benchmarks

Removing secure data from the REG-Loans or ALERT file before uploading

As we've mentioned in previous posts we understand that the detail loan file format #1 contains sensitive customer data.  If you upload a file to us with customer sensitive data we delete this information right away, we don't want this information either.  Part of our agreement with you is to keep information confidential.

For those of you that are still concerned about about sending the data file we can offer you a new program utility that deletes the sensitive data from the RegLoans (or ALERT) file before you upload it to us.  We call it the "ALERT File Scrubber".  It's a simple program that you download and run on your computer.  It reads in your original data file, deletes (or scrubs) the sensitive data fields, and saves a new clean version of the file that you can upload to us.

Here is the URL:  (you should probably right-click and choose "Save Target as...")

http://www.olsonresearch.com/blogresources/ALERTFileScrubber.exe

The program will save a "scrubbed" version of your original loan file back into the same folder with the same name and a new extension ".ScrubbedForORA".  This is the file you'll want to upload.

If you have any questions about using this program please leave a comment here, email, or call us.  Contact information is in the margin.

Data File Specifications

Here are links to our suggested data file formats:

• Call report data files
• Investment data files
• Loan data files

Once you have created a data file, you may upload it to us using our Secure file upload (sign-in required) area.