Sample Holding Time II

<< Click to Display Table of Contents >>

Sample Holding Time II

Report Name: Sample Holding Time II*

*previously called Sample Holding Time

 

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.

 

Report Type: Standard Report

 

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. It is the class version of the custom function report of the same name. The differences in the class version are:

 

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.

 

**previously called (Beta) Analytical Results

 

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

 

Language: English

 

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

 

Input Parameters

Input Parameter Screenshot

Output Columns

Location




Individual(s)



Group(s)


Sample




Type(s)



Date Range




Start Date



End Date


Matrix(es)



Task(s)



Delivery Group(s)


Test




Method(s)



Fraction(s)



Column Number(s)



Type(s)



Lab Matrix(es)



Prep Method(s)


                                               

30080-input.param.scrnsht3

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

Note: *refers to hidden parameters.

 

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

 

Database Type: SQL

 

Database Schema: Standard (no custom or add-on schemas required)

 

Database Version: EQuIS 6.1+

 

Data Requirements: N/A

 

Report Requirements: N/A

 

Output Type: IGrid

 

Example Output: View the following example.

 

30080-ex.output_zoom50

 

 

EarthSoft.Reports.Library.95547