<< Click to Display Table of Contents >> Navigation: EQuIS Library > Reports > EarthSoft Standard Reports > Analytical Results > Analytical Results with Sample Parameter (Table) |
Report Name: Analytical Results with Sample Parameter (Table) (example)
File Name: EarthSoft.Reports.Library.23967.dll
Dependencies: v54.sample_parameter report
Software: EQuIS Professional and EQuIS Enterprise
Source: EQuIS Professional install
Language: English
Output Type: Report Grid1
Description: The Analytical Results with Sample Parameter (Table) Report combines the Analytical Results Report and the Sample Parameter Report using the mapping outlined below.
Installation Instructions: This report assembly is part of the EQuIS Professional installation. No additional installation steps are necessary, however, this report requires the v54.samples_parameter report to have a STATUS_FLAG value of A.
Overview:
The following data mapping is used for this report to combine the Analytical Results report and Sample Parameters report.
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"
Source Tables DT_SAMPLE, DT_SAMPLE_PARAMETER, RT_GROUP, RT_GROUP_MEMBER, RT_MTH_ANL_GROUP, RT_SAMPLE_PARAM_TYPE
Report Parameters |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Report Output |
||
---|---|---|
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 |
1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML, or a printer.
Copyright © 2022 EarthSoft, Inc • Modified: 25 Nov 2021