<< 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
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
Note: This report only works with EQuIS Professional. |
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 |
||||
---|---|---|---|---|
|
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.
Copyright © 2023 EarthSoft, Inc • Modified: 25 Nov 2021