Standard Project Status

<< Click to Display Table of Contents >>

Standard Project Status

Report Name: Standard Project Status (128305)

 

Report Type: Standard Report

 

Description: The report examines four (4) kinds of project statuses (below) in the selected date range:
 

1.Calculates the number of samples per task_code, sample_date, sys_loc_code and analysis_location where DT_SAMPLE.SAMPLE_TYPE_CODE='N';

2.Reviews some major data of DT_WATER_LEVEL, DT_MEASURE_DATUM and DT_WELL;

3.Reports the locations having ground water samples with missing screen intervals from DT_SAMPLE where matrix_code='WG', DT_WELL_SEGMENT.SEGMENT_TYPE=null or 'screen' and DT_WELL_SEGMENT.START_DEPTH=null or '-999%';

4.Reports the soil samples with missing start_depths from DT_SAMPLE where matrix_code='SO' and DT_SAMPLE.START_DEPTH=null or '-999%'.

 

For the details, please reference the output examples and data mapping of the results at the end of the article.

 

Report Dependencies: N/A

 

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

 

Language: English

 

Input Parameters: A selection made to customize the output of a report.

 

Input Parameters

Input Parameter Screenshot

Output Columns

Sample




Date Range




Start Date



End Date

30214-input

Contact support@earthsoft.com
for more information.

 

Tables: DT_SAMPLE, DT_WATER_LEVEL, DT_WELL, DT_WELL_SEGMENT, DT_MEASURE_DATUM, RT_COMPANY

 

Database Type: SQL

 

Database Schema: Standard (no Custom or add-on Schemas required)

 

Database Version: EQuIS 6.6+

 

Data Requirements: N/A

 

Report Requirements: Excel

 

Output Type: Excel

 

Example Output: View the following examples.

 

1. SampleCounts:

 

30214-output1_zoom95

 

2. WaterLevels:

 

30214-output2_zoom53

 

3. MissingSoilDepthsBySample:

 

30214-output3_zoom59

 

4. GWSampleLocationsMissing_ScrnIn:

 

30214-output4_zoom52