Table Row Counts (18095)

<< Click to Display Table of Contents >>

EQuIS 7  >>  EQuIS Library > Reports > EarthSoft Standard Reports > Database Tables Tools >

Table Row Counts (18095)

Report Name: Table Row Counts (18095)

 

Report Type: Standard

 

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).

 

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

 

Contact support@earthsoft.com for a direct file link.

 

Language: English

 

Input Parameters: A selection made to customize the output of a report.

 

Input Parameters

Input Parameter Screenshot

Output Columns

Tables


                                               

30100-input.params.scrnsht

TABLE_NAME

TOTAL_ROWS

IN_FACILITY

STATUS_FLAG_A

STATUS_FLAG_R

 

Tables: All tables for the selected facility_id or a facility group

 

Database Type: SQL

 

Database Schema: Standard (no custom or add-on schemas required)

 

Database Version: EQuIS 5.4.3+

 

Data Requirements: N/A

 

Report Requirements: N/A

 

Output Type: Pro Igrid

 

Example Output: View the following example.

 

30100-ex.output

 

EarthSoft.Reports.Library._18095.TableRowCounts