Reporting Database

Use the Reporting Database tool to create a database of the loan fields used most often in your reports. When you use the reporting database, the time required to perform a search and return results is greatly reduced.

In Encompass Banker Edition, the reporting database is also used to designate fields for which you want to create an audit trail. Whenever a change is made to one of these fields in a loan file, Encompass creates a record of the change which includes the date, the ID and name of the user who made the change, and the value the field was changed to.

ClosedOpen the Reporting Database

  1. On your Windows task bar, click the Start menu or Start icon, navigate to the Ellie Mae Encompass program folder, and then click Admin Tools.

  2. Double-click Reporting Database.

ClosedEdit the Reporting Database

  1. To add fields to the reporting database, use one of the following methods:

ClosedManually select fields from the Fields section

  1. Select one or more fields from the tabs in the Fields section, and then click Add.

Note: Most of the fields on the Team Members, Milestones, Documents, Conditions, and Post-Conditions tabs will have more than one instance associated with each loan file. For example, if you select the Document Title field, a window will open from which you will select the name of a specific document.

ClosedImport a text file that contains field information

Create a text file (*.txt) that contains the required field information and then import the file into the Reporting Database. Or, you can export the fields currently listed in the Selected Fields section to a .txt file, edit the file as needed, and then import the file to the Reporting Database.

  1. Click the Export icon.
  2. In the Export to field, enter the file path/location where the file will be exported.
  3. In the File Name field, type a file name. By default, the file name will be automatically set to Fields-[today’s date].txt.
  4. Click OK, then click OK again in the confirmation window.
  5. Next, open the text file.

The text file is comma-delimited, with the first line listing each header field in the Selected Fields pane of the Reporting Database (Field ID, Pair, Description, etc.) followed by each field entry that was listed.

  1. Edit the file. You can change existing field information, add new field information, or deleted fields.
  2. When finished, save the file.
  3. Back in the Reporting Database, click the New icon.
  4. In the Add Required Fields window, click Import.
  1. To remove a field, select a field in the Selected Fields section, and then click Remove.
  2. To edit a field, select a field in the Selected Fields section, and then click the Edit icon.

Note: For fields that you commonly use to filter reports, creating indexes for those fields can reduce report generation time. However, indexes also increase the size of the database and can increase the time required to save a loan file.

Note: This option is available with Encompass Banker Edition only.

  1. When all selections and changes have been made, click Update to update your database.
  2. Click Yes to confirm the update.
  3. Click Yes or No when asked if the newly added fields should be made accessible to all personas.
  4. When the database has been updated, click Yes to populate the database.
  5. Click OK in response to the completion message.

Note: If fields in the Reporting Database exceed the recommended number (1500), a warning message displays each time the administrator opens the Reporting Database, explaining that performance may be affected.