EQuIS Data Audit (57243)
Copyright © 2020 EarthSoft, Inc • Modified: 24 Feb 2020
Report Name: EQuIS Data Audit (57243)
Report Type: Standard
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.
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
Report Dependencies: There are no dependencies for this report.
File Name: EarthSoft.Reports.Library.57243.dll
Contact firstname.lastname@example.org for a direct file link.
Input Parameters: A selection made to customize the output of a report.
Input Parameter Screenshot
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
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
Database Type: SQL
Database Schema: Standard (no custom or add-on Schemas required)
Database Version: EQuIS 5.5+
Data Requirements: N/A
Report Requirements: Non-admin users will not be able to run the report without at least Viewer-authorized permissions.
Output Type: IGrid
Example Output: View the following example.