The View consistency checks definitions tab

The View consistency checks definitions tab on the Server Tools Consistency Checks Info screen provides information on the consistency checks available for each database table. In this tab, you can undertake the following actions.

Action	Description
Download consistency check information	Click Download to download a ZIP file that contains a set of linked HTML files that describe the consistency checks that Guidewire provides in the PolicyCenter base configuration.
Search by table name	Search by table name to find the consistency checks related to a specified table. Most consistency checks operate on the specified table, but some checks, such as typelist table checks, operate on other tables as well. To search, enter a complete or partial table name in the Table name fragment field and click Search. The results of the search show in a table that lists the table name, the consistency check name, and a description of the consistency check. To clear the results of the search, click Reset.
Filter by check type	Filter the list of consistency check types to see a list of all tables for which that consistency check is available.
View SQL query	Review the SQL query used to generate a given database consistency check. First, select a consistency check, then: Select the Command tab at the bottom of the screen to view the SQL command of the consistency check. The SQL command retrieves a count of rows that violate the consistency check. Select the Query to identify rows tab at the bottom of the screen (if available) to view the SQL query used to identify rows that violate the consistency check. SQL queries to identify rows that violate consistency checks are not available for all check types.