<< 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, but this report requires the Sample Parameters report (v54.sample_parameter) to have a STATUS_FLAG of A in ST_REPORT. For more information, see Change Report Status.
Overview:
This report uses the following data mapping 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"
To appear in the report, sample parameter group records (as listed in the Parameter > Group(s) report parameter) must meet the following conditions:
1.RT_GROUP.GROUP_TYPE = "param_code" for the group
2.RT_GROUP_MEMBER.MEMBER_TYPE = "param_code" for the group members
3.RT_GROUP_MEMBER.MEMBER_CODE entries for the group members exist in RT_SAMPLE_PARAM_TYPE.PARAM CODE.
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 © 2023 EarthSoft, Inc • Modified: 28 Oct 2022