How to Obtain Information on the Equitrac Database Structure to Create Custom Reports

Question:

With Equitrac Office and Equitrac Express, is there information available about the Eqcas database schema or are there any views to assist in the creation of custom reports with third-party software?

Answer:

During the Equitrac installation process, there are Database view creation SQL scrpts and readme files for SQL or Oracle (dependent on the chosen database at installation time) are copied to the installation drive in the following location:

\Program Files\Equitrac\[Office or Express]\Database\

Where [Office or Express] is the actual product installed.

SQL views filenames are CAS_SQLServer_Views.sql and Oracle views filename = CAS_Oracle_Views.sql and associated readme.txt

NOTE: These Views are not guaranteed to remain unchanged in subsequent releases of Equitrac