EQuIS Data Audit

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports > Database Tables Tools >

EQuIS Data Audit

Report Name: EQuIS Data Audit (example)

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

Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Report Grid1

 

Description: The report reports the questionable (location, sample, test, result and reference etc.) data information under the facilities and/or the locations that are involved in checking items.

 

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

 

Overview:

Non-admin users will not be able to run the report without at least Viewer-authorized permissions.

 

The following checked items are available:

Unused Reference Values

Locations with no coordinate information

Locations with coordinates but no elevation

Locations with elevation but no coordinates

Locations with no location type assigned

Locations with no associated samples

Locations with suspect coordinate information

Locations with no water levels

Locations with multiple sample matrices

Sample with future sampling dates

Samples with no assigned location

Samples with no test records

Samples with no sample date

Analytical tests with future analysis dates

Analytical tests with obviously incorrect past analysis dates

Analytical tests with suspect analysis dates (analysis date is before the sample date)

Analytical tests with no analysis location assigned

Analytical tests with no associated results

Results indicated as detected but no result value

Results indicated as non-detected but with measured values

Results indicated as non-detected but without any detection limit values

Results with no result unit assigned

Results indicated as detected but without any detection limit values

Results having limit values but no limit units

Records that the MEASUREMENT_DATE in DT_LOCATION_PARAMETER or DT_WATER_LEVEL or the START_DATE/END_DATE in DT_PRECIPITATION are after today

 

Source Tables DT_COORDINATE, DT_FACILITY, DT_LOCATION, DT_RESULT, DT_SAMPLE, DT_TEST, DT_WATER_LEVEL, RT_PK, RT_TABLE, RT_TABLE , RT_TABLE_NAME FROM, RT_TABLES, ST_REPORT_USE, ST_USER, ST_USER_REPORT

 

Report Parameters

Audit Contents

Select the contents of the Audit: Location_Summary, Location_Detail, Sample_Summary, Sample_Detail, Test_Summary, Test_Detail, Others_Summary, Others_Detail, Reference_Summary, or Reference_Detail

Facility(s)

Select one or more Facility(s)

 

 

Report Output

FACILITY_CODE

FACILITY_NAME

LOCATION_NO_COORDINATES

LOCATION_NO_ELEVATION

NO_LOC_TYPE

NO_SAMPLES

NO_WATER_LEVELS

MULTIPLE_SAMPLE_MATRICES

COORD_TYPE_CODE

IDENTIFIER

REVIEW_DATE

 

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