Sample Holding Time II

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports >

Sample Holding Time II

Report Name: Sample Holding Time II (example)

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

Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Report Grid1

 

Note: The Sample Holding Time Report would not publish because a report with the same name exists in the SQL function reports in the EQuIS database. Renaming it to the Sample Holding Time II Report has solved this issue.

 

Description: The Sample Holding Time II Report displays time spent from sampling to analyzing the samples plus other items, which can also be obtained in the Analytical Results II** Report.

 

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

 

Overview:

Report features include:

 

If no location groups are selected, loc_group_code (old name is log_group) and loc_group_order are not listed in the results.

NULL/BLANK is added to the drop-down list of some of the user interface items.

 

Tables: DT_SAMPLE, DT_FIELD_SAMPLE,DT_STATIC_PROPS, DT_TEST, VW_LOCATION, DT_TASK, RT_GROUP

 

Report Parameters

Location


Individual(s)

Parameter for selecting individual locations.

Group(s)

Parameter for selecting location groups.

Sample


Type(s)

Select one or more sample types.

Date Range

Section to select the start date, end date, most recent sampling, and the option to use date range to select the most recent sampling events.

Matrix(es)

Select one or more sample matrix.

Task(s)

Select one or more tasks.

Delivery Group

Parameter for selecting the sample delivery group.

Geologic Unit(s)

Parameter for selecting geologic unit(s).

Depth

Section for selecting the minimum and maximum start and end depths as well as depth unit

Minimum Start Depth

If a value is entered, only samples that start (DT_SAMPLE.START_DEPTH) above that value will be included. Sample with null START_DEPTH will be excluded.

Maximum End Depth

If a value is entered, only samples that end (DT_SAMPLE.END_DEPTH) below that value will be included. Sample with null END_DEPTH will be excluded.

Unit

Select the desired unit for sample depth min/max.

Test


Method(s)

Select one or more test method

Fraction(s)

Select one or more fraction

Column Number(s)

Select one or more column number

Type(s)

Select one or more test type

Lab Matrix(es)

Select one or more lab matrixes

Prep Method(s)

Select one or more prep methods

 

Report Output

FACILITY_ID

FACILITY_CODE

SYS_LOC_CODE

LOC_NAME

LOC_GROUP

LOC_REPORT_ORDER

SYS_SAMPLE_CODE

SAMPLE_NAME

SAMPLE_DATE

SENT_TO_LAB_DATE

PREP_DATE

ANALYSIS_DATE

SAMPLE_TO_PREP_HRS

PREP_TO_ANALYSIS_HRS

SAMPLE_TO_ANALYSIS_HRS

RECEIPT_TO_ANALYSIS_HRS

LEACHATE_DATE

SAMPLE_TYPE_CODE

START_DEPTH

END_DEPTH

DEPTH_UNIT

MATRIX_CODE

GEOLOGIC_UNIT_CODE

TASK_CODE

TASK_DESC

FIELD_SDG

ANALYSIS_LOCATION

LAB_SAMPLE_ID

LAB_MATRIX_CODE

LAB_NAME_CODE

ANALYTIC_METHOD

COLUMN_NUMBER

FRACTION

TEST_TYPE

PREP_METHOD

LEACHATE_METHOD

LAB_SDG

PERCENT_MOISTURE

TEST_ID

TURNAROUND_DAYS

PERSERVATIVE

LAB_REPORT_DUE_DATE

LAB_REPORT_RECEIPT_DATE

X_COORD

Y_COORD

Z_COORD_AVG

ZFROM

ZTO

LONGITUDE

LATITUDE

 

1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML, or a printer.