Loan Audit File Extract

Overview of IL682

The Loan Auditors File report allows you to generate a report containing loan information as of a specified date. You can opt to generate a report only, or you can elect to generate a data file in fixed or comma separated value. The report can be transferred via FTP if your organization is set up to do so. You can also extract to a data file, or transfer via email. The data file contains information such as loan number, balance, last payment date, last payment amount, and other information. To run the report:

Report Criteria Example

Report Criteria Fields

Field

Description

Base date

Set the "as of" date for the report. You can type it in a mm/dd/yyyy format or click the calendar icon to select the date

Loan types

If you wish to report only on certain loan types, you can set that here. Type in one or more loan type codes, separated by commas, or click the list icon to select from a list of active loan types in the system. Leave the field blank to report against all loan types

Loan categories

If you wish to report only on certain loan categories, you can set that here. Type in one or more loan category codes, separated by commas, or click the list icon to select from a list of loan categories in the system. Leave the field blank to report against all loan categories

Transfer mode

This determines the type of report output. Click the drop down arrow to view your options. They are:

Option	Description
FTP	Selecting this option enables several additional fields. The first is the option to select your data format (fixed width or comma separated value). The next fields require the FTP information for the site that you wish to ftp the file to
Email	Selecting this option will enable additional fields. The first is the option to select your data format (fixed width or comma separated value) and the second is the email address that you wish to transfer the report output to
System file	Selecting this option will enable additional fields. The first is the option to select your data format (fixed width or comma separated value). Next, you'll indicate whether the file destination is local or a unix file (this should always be set to local, unless otherwise indicated by a DDI staff member). The final option is to provide a name and file destination for the output. You can type the path and file name, or click the folder icon to navigate to the directory where you wish to save the output
Report only	If this option is selected, the system will generate only the pdf output

Data format

This determines the data format of filename output. Click the drop down arrow to view your options. They are:

Option	Description
Fixed format	Fixed column length format
Comma separated	Comma separated format that can easily be loaded into Microsoft Access
XML format	Special XML format that can easily be loaded into Microsoft Access or Microsoft Excel

Filename

Relevant when transfer mode equals Email, FTP, or System file

Email address

Relevant when transfer mode equals Email

FTP file