Table Row Counts

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports > Database Metrics >

Table Row Counts

Report Name: Table Row Counts (example)

File Name: EarthSoft.Reports.Library.18095.dll

Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Report Grid1

 

Description: The Table Row Counts Report generates the total number of rows per table in the database (TOTAL_ROWS), the number of these rows in the current FACILITY_ID or facility group (IN_FACILITY), the number of reference values per reference table with STATUS_FLAG="A" and "R" (STATUS_FLAG_A and STATUS_FLAG_R, respectively).

 

Installation Instructions: This report assembly is part of the EQuIS Professional installation. No additional installation steps are necessary.

 

Overview:

 

Report Parameters

Tables

Select one or more tables. No selection will return all tables.

 

Report Output

TABLE_NAME

TOTAL_ROWS

IN_FACILITY

STATUS_FLAG_A

STATUS_FLAG_R

 

1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML, or a printer.