Comps Database

The Comps Database is your central location for getting the most out of one of your most precious resources.  When adequately stocked with an ample supply of comp data, your TOTAL Comps Database can virtually replace your MLS as a source of reliable comp information.  Moreover, if you add comps from your old reports into your database, you can place comps in the grid with data using your own shorthand and even choose the data source to be used!

After seeing TOTAL's Comps Database in action, you'll feel like other Comps Databases are in the Stone Age.  TOTAL's new UAD-aware Comps Database uses our Spectrum Digital Workfile Architecture to integrate all the various data sources (prior reports, imported MLS data, public records, photos, notes, docs, and so on) into one comprehensive visual Map and Grid based view of your market.

It properly understands sales, rentals, and listings, and also captures "snapshots" of the past history events of every address that passes through it.  Click on a property on the map or grid, and you'll see all of the historical events, by date and data source, for that address.  Choose any one of the sources to use as the data to push to the form, and even view the database info side-by-side with the current grid (a huge boost when pushing non-UAD data into a UAD grid).

Searching is world-class.  Simply "draw" on the map — you can even define odd-shaped neighborhood or market areas and save them for future use — and combine that visual boundary with IQ Search (Intelligent Query Search) to immediately find the most likely comps by default every time.

Accessing the Comps Database

There are three ways to access TOTAL's Comps Database:

From the Side-by-Side PowerView
While in a report, click Side-by-Side at the top to access the Side-by-Side PowerView, then click Comps Database in the top toolbar.

Comps Database

From the Tools menu while in a report
Click Tools on the upper left and select Comps Database from the drop‑down menu.
From TOTAL Dashboard
Click the Dashboard icon ( Dashboard Icon )  from the Appraisal Desktop or while you're in a report, locate Comps Database in the list, and click Launch.
Outside of TOTAL
From your start menu, go to (all) Programs, expand the TOTAL folder, and launch Comps Database.

Customize Search

The Customize Search button allows you to configure the fields and search parameters used for IQ Search, as well as adjust the available fields for your Search Filters.  For more information on customizing searches click here.

Delete Comps

The Delete button allows you to remove a comparable from your database. Simply select a blue push‑pin in the Map view, or select an entry from the Grid view and click Delete.

Keep in mind that if you sign the report again or run the Comps Database Importer, previously deleted comparables are added to the database if they don't exist, or they differ from existing comparables in your database.

Place Comps

The Place button allows you to take the comps you currently have selected in the Comps Database, and place them into your report.  Follow the instructions below to place a comparable:

  1. Begin by marking your comparables:
    From the Map View
    Click the blue push-pin for the comparable you want to mark to view the comp details pop-up.  In the Details pop-up, select the data source to use (if there is more than one), then continue to mark additional comps as necessary.
    From the Grid View
    Simply check the box beside each comparable you want to place.
  2. To view a list of all comparables you currently have marked, click the Comps Marked button.  This opens a separate window that lists each comp currently marked in your Comps Database.  To remove a comp from the list, simply uncheck the box.
  3. When you're ready to transfer your marked comps to your report, simply click Place in the Marked Comps window, or in the top toolbar of the Comps Database.

That's it!  The comparables marked in the Comps Database are now transferred to the next open slot in your report.  If necessary, TOTAL adds an additional comps page to your report if you placed more comps that what was available in the report.

Import comps

The Import Button allows you to import comparables from existing reports in TOTAL's Appraisal Desktop, as well as from Aurora's Appraisal Desktop, and Aurora's Comps Database (if available).  Future updates will allow additional import sources.  Click here for more information and step-by-step instructions on importing comparables, or click here for instructions on how to export comps automatically when signing a report.

Selected Report dropdown

The Selected Report drop‑down menu appears when you have more than one report open, or when you start a new search from the file menu of the Comps Database.  The drop‑down menu allows you to select the subject data to use when searching, or to choose where you want to place your selected comparables.

New Search And Edit Subject

The New Search function is primarily used when the Comps Database is launched by itself outside of a report, but can also be used when the Comps Database is launched from a report.  The purpose of the New Search is to provide a way for you to enter a few pieces of information about a subject property that can be used when applying the IQ Search parameters, and can be saved as a new report.  To start a new search:

  1. From the Comps Database, click File and select New Search from the drop‑down menu.

  2. In the window that appears, fill out the information about the subject property.

  3. Click Configure to add or remove fields that appear for the subject data, then click OK to return to New Search screen.
  4. Click Search to start your new search.

The Information entered for the subject is used for the IQ search parameters, and the comparables matching your criteria are displayed.  If you have started more than one search, or if you have more than one report open, toggle between the reports and searches using the Selected Reports drop‑down menu.

When you start a new search, or any time you launch the Comps Database outside of TOTAL, an additional Edit Subject button appears in your toolbar.  This button allows you to edit the subject information you used for your new search.

Save as report

When you start a new search, and/or Edit Subject Data, the option to save the subject information and start a new report using comps from your Comps Database appears.  To save your new search as a report:

  1. Click File, and select Save as report from the drop‑down menu.

  2. In the window that appears, select the folder in which you would like to place the report, and enter a report description.

  3. Click Save.

Export

New to TOTAL is the option to export comparables from your Comps Database.  To export your comps:

  1. Click File in the menu bar, hover over Export, and choose from the following options:
    All records
    Exports every property in your comparables database.
    Visible records
    Exports only the properties that match your current search criteria.
    Marked Records
    Exports only the records you have marked in your Comps Database.
  2. In the window that appears, choose the Delimeter type to be used when exporting from the drop‑down menu.
  3. Click Browse, and in the window that appears, browse to the location in which you want to save your file, enter a filename, and click Save.

Print

To print your comps:

  1. Click File in the menu bar, hover over Print, and choose from the following options:
    All records
    Exports every property in your comparables database.
    Visible records
    Exports only the properties that match your current search criteria.
    Marked Records
    Exports only the records you have marked in your Comps Database.
  2. Select your print options and click Print.