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

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

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.