Analytical Results with Sample Parameter (Table)

<< Click to Display Table of Contents >>

EQuIS 7  >>  EQuIS Library > Reports > EarthSoft Standard Reports > Analytical Results >

Analytical Results with Sample Parameter (Table)

Report Name: Analytical Results with Sample Parameter (Table) (23967)

 

Report Type: Standard

 

Description: The Analytical Results with Sample Parameter (Table) Report combines the Analytical Results Report and the Sample Parameter Report

using the following data mapping:

 

DT_SAMPLE_PARAMETER.MEASUREMENT_DATE = "ANALYSIS_DATE"

DT_SAMPLE_PARAMETER.MEASUREMENT_METHOD = "ANALYTIC_METHOD"

DT_SAMPLE_PARAMETER.PARAM_CODE = "CAS_RN"

DT_SAMPLE_PARAMETER.PARAM_VALUE = "REPORT_RESULT_VALUE" (numeric values only)

DT_SAMPLE_PARAMETER.PARAM_VALUE = "REPORT_RESULT_TEXT"

DT_SAMPLE_PARAMETER.PARAM_UNIT = "REPORT_RESULT_UNIT"

 

Note: In EQuIS 5.6.4 and earlier, the DT_SAMPLE_PARAMETER.PARAM_VALUE must be <40 characters, otherwise a 'String or binary data would be truncated...' error will result.

 

Report Dependencies:

 

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

 

Contact support@earthsoft.com for a direct file link.

 

Language: English

 

Input Parameters: A selection made to customize the output of a report. Note the Additional Fields parameter may be customized as explained here.

 

Input Parameters

Input Parameter Screenshot

Output Columns

Location




Individual



Group(s)


Sample




Type(s)



Date Range




Start



End


Matrix(es)



Task(s)



Delivery Group(s)



Depth




Minimum
Start Depth



Maximum
End Depth



Unit

Test




Method(s)



Fraction(s)



Column Number(s)



Type(s)



Lab Matrix(es)



Prep Method(s)


Result




Analyte




Individual(s)



Group(s)


Unit



Type(s)



Detect Flag(s)



Non-Detect Multiplier



Non-Detect Symbol



Reportable



Reporting Limit


Additional Fields



Parameter




Individual(s)



Group(s)


                                               

30021-input.param.scrnsht.med2

FACILITY_ID

FACILITY_CODE

SYS_LOC_CODE

LOC_NAME

SAMPLE_ID

SYS_SAMPLE_CODE

SAMPLE_NAME

SAMPLE_DATE SAMPLE_TYPE_CODE START_DEPTH

END_DEPTH

DEPTH_UNIT

MATRIX_CODE

TASK_CODE PARENT_SAMPLE_CODE ANALYSIS_LOCATION LAB_SAMPLE_ID LAB_MATRIX_CODE LAB_NAME_CODE ANALYTIC_METHOD ANALYSIS_DATE COLUMN_NUMBER

FRACTION

TEST_TYPE

PREP_METHOD LEACHATE_METHOD LEACHATE_DATE

LAB_SDG

PERCENT_MOISTURE DILUTION_FACTOR

TEST_ID

CAS_RN

CHEMICAL_NAME

ORGANIC_YN REPORT_RESULT_TEXT REPORT_RESULT_VALUE REPORT_RESULT_UNIT REPORT_RESULT_LIMIT REPORTABLE_RESULT DETECT_FLAG INTERPRETED_QUALIFIERES VALIDATOR_QUALIFIERS LAB_QUALIFIERS QUANTITATION_LIMIT METHOD_DETECTION_LIMIT REPORTING_DETECTION_LIMIT DETECTION_LIMIT_UNIT APPROVAL_CODE

RESULT_TEXT RESULT_NUMERIC RESULT_UNIT

RESULT_TYPE_CODE X_COORD Y_COORD

Z_COORD_AVG

ZFROM

ZTO

LONGITUDE

LATITUDE

Note: *refers to hidden parameters

 

Tables: DT_SAMPLE, DT_SAMPLE_PARAMETER, RT_GROUP, RT_GROUP_MEMBER, RT_MTH_ANL_GROUP, RT_SAMPLE_PARAM_TYPE

 

Database Type: SQL

 

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

 

Database Version: EQuIS 5.5.1+

 

Data Requirements: N/A

 

Output Type: PRO Grid

 

Example Output: Note the attached .xls file is exported from the PRO Grid. View the example below or download the attachment.

 

30021-ex.output_zoom80