EQuIS Data Audit (57243)

<< Click to Display Table of Contents >>

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

EQuIS Data Audit (57243)

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

Audit Contents


                                               

30034-input.params.srnsht

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

 

30034-map_zoom80

 
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.

 

30034-ex.output

 

EarthSoft.Reports.Library._57243.EQuISDataAudit