Standard Project Status Report

Report Name: Standard Project Status (example)

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

Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Excel1

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 the DT_WATER_LEVEL, DT_MEASURE_DATUM and DT_WELL tables.

3.Reports the locations having ground water samples with missing screen intervals from the DT_SAMPLE table 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 the DT_SAMPLE table where MATRIX_CODE = 'SO' and DT_SAMPLE.START_DEPTH = null or '-999%'.

Installation Instructions: This report assembly is part of the EQuIS Professional installation. No additional installation steps are necessary.

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

Report Parameters

Sample
Date Range
Start	Section to select the start date.
End	Section to select the end date.

1Excel report output requires a valid license of Microsoft Excel to view the output.