Creating and Using User Defined Edits

User Defined Edits can be an effective way to review your data for inaccuracies, erroneous data or to check the data quality of non-required HMDA fields. User defined edits are like FFIEC edits, but you build them yourself and they are not on required fields. 

Once you build the edits, they can be used on any file.

Create User Defined Edit Checks 

To create a User Defined Edit, follow these steps:

  1. Go to the Edit module.
  2. From the Tools menu at the top of the program, select Define Edit Checks:

    Get the most out of Wiz

    The software displays the Error Check Builder:
    Get the most out of Wiz

  3. Click the New button.

    The software prompts for an error code:
    Get the most out of Wiz

  4. Type in a number (do not type in the “U,” as the software will do that for you.)
  5. Click the Build button.

    The software displays the Expression Builder:
    Get the most out of Wiz

  6. Type in the expression and then click the Apply link at the top right corner.
  7. Copy the expression into the Error Description pane of the Error Check Builder.

    Note: The Error Description displays in the Edit reports, so it is important to be descriptive. 

  8. Continue this process until all edits have been built.
    Note: You can always go back and edit, delete, or add new edits later. To change edit checks, go to the Tools menu, and select Define Edit Checks. Scan the User Defined Edits by clicking on Next and Previous buttons as needed. Click Build to make changes to a particular Edit.  Remember to edit the description if it has changed.

    Below are some examples of common edits you may want to create:
100 Series (Note Rate)
U101 Action=1 and NoteRate<1
U102 Action=1 and NoteRate>25
U103 Action=1 and IsNull(NoteRate)
200 Series (APR)
U201 Action=1 and APR<1
U202 Action=1 and APR 25
U203 Action=1 and IsNull(APR)
300 Series (BERatio)
U301 BERatio<1
U302 BERatio >105
U303 IsNull(BERatio)
400 Series (LTV)
U401 LTV < 1
U402 LTV > 105
U403 IsNull(LTV)
500 Series (Cust_Credt)
U501 Cust_Credt < 450
U502 Cust_Credt >850
U503 IsNull(Cust_Credt)
600 Series (Beacon)
U601 Beacon < 450
U602 Beacon >850
U603 IsNull(Beacon)
700 Series (Fair_Issac)
U701 Fair_Issac < 450
U702 Fair_Issac >850
U703 IsNull(Fair_Issac)

Running Edit Checks on a File

To run Edit Checks on a selected file, follow these steps:

  1. Go to File Management.
  2. Right-click the selected file and from the contextual menu select Run Edit Checks -> Non-Geography Related Edit Checks.

    The software displays a confirmation dialog box.

  3. Click Yes.

Running Edit Reports to Review Loans with Edits

  1. Click on Analysis -> Reports.
  2. In the tree view, display the Exception and Edit Reports folder located under the Edit/Geocoder entry:
    Get the most out of Wiz
  3. Click on the report you want to generate:
  • Summary Exceptions

    Displays a list of all the edits and how many loans fall within the criteria for that Edit:
    Get the most out of Wiz

  • Detail Record Exceptions

Displays detail about each loan with edits.  The data shown is the standard FFIEC HMDA data (for HMDA files):Get the most out of Wiz

Filtering File for User Defined Edits

To filter a file for User Defined Edits, follow these steps:

  1. Click the Filter button.

    The software displays the Filter pane:
    Get the most out of Wiz

  2. Click the Custom Loan Information folder.
  3. Click the Create New Expression folder:
    Get the most out of Wiz

    The software displays the Expression Builder:
    Get the most out of Wiz

  4. In the expression window, type the following expression:

    InStr(1 ,EditStatus ,"U" , 1)>0

    Get the most out of Wiz

  5. Click the Apply link located in the upper right corner.
  6. In the Filter pane, click the Apply link:
    Get the most out of Wiz

    The window will now show only the records that have user defined edits.

Creating a Gap Map using Web Map

Sara Hill of Wolters Kluwer recently presented the following topic at the May 2021 Wiz User Group sessions. For those of you who missed the live presentation, we have prepared the following Job Aid:

Job Aid:  Creating a Gap Map →

Stay informed

Find links below to this month's newsletter.