Report Transformations in Analytical Results II

<< Click to Display Table of Contents >>

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

Report Transformations in Analytical Results II

The Analytical Results II Report features an API for applying standard or custom logic (transformations) to report results. The Transformation(s) input parameter, hidden by default, provides for selection of one or more transformations.

 

Standard Transformations

 

Standard transformations for Mag Sum and TEQ Sum, detailed below, are included with the Analytical Results II Report.

 

Notes:

 

The sum transformations match analytic results with the analytic method, matrix, and fraction specified in RT_MTH_ANL_GROUP_MEMBER; results that do not match are excluded from the sum.

Some samples may have more than one result for a given analyte due to different analytic methods being run on the same sample or due to different fractions being tested for the same sample. If the ANALYTIC_METHOD and FRACTION columns in RT_MTH_ANL_GROUP_MEMBER are both NULL for that analyte, then the first result listed in the report output table will be used in the sum.

Whichever results are used in the sum for a given analyte can be controlled by setting one or more of the following values in the RT_MTH_ANL_GROUP_MEMBER table:

oANALYTIC METHOD:

If the ANALYTIC_METHOD column is not NULL,

then only results with a matching DT_TEST.ANALYTIC_METHOD are included in the sum.

oFRACTION:

If the TOTAL_OR_DISSOLVED column is not NULL,

then only results with a matching DT_TEST.FRACTION are included in the sum.

(Note that the RT_MTH_ANL_GROUP_MEMBER.TOTAL_OR_DISSOLVED column is displayed under the FRACTION column header in the Analyte Group form.)

oMATRIX:

If the MATRIX column is not NULL,

then only results with a matching DT_SAMPLE.MATRIX_CODE are included in the sum.

 

Mag Sum Transformation

 

For each sample in the analytical results, adds a row to the Analytical Results II output. Basic values are copied to the new row, with new data populated as follows.

1.REPORT RESULT_TEXT and REPORT_RESULT_VALUE = the sum of the results of the members of the Method Analyte Group (MAG). REPORT RESULT_TEXT includes comparison operator where applicable.

2.CAS_RN and CHEMICAL NAME = method analyte group for the sum calculation, as defined at DT_ACTION_LEVEL_LOOKUP.PARAM_CODE.

3.DETECT_FLAG = Y if sample results include any detect; N if all results are non-detects.

 

Populate DT_ACTION_LEVEL_LOOKUP. The columns below are required unless otherwise noted.

 

lookup_source (25 char): EQuIS_AR_II

lookup_code (40 char): Optional column used to create different categories for each source.

lookup_method (255 char): MAG_SUM

param_code (20 char): the method analyte group code for the sum calculation

comparison_operator (10 char): This must be ND_X for the Non-Detect Multiplier to be activated.

oIf not using the Non-Detect Multiplier, enter NONE or NA or any other value since this column may not be NULL.

comparison_value (19 char): Optional value to multiply by the Non-Detect analytical result detection limits, before adding to the MAG_SUM.

oDefaults to 1 if no value entered.  

oIf the value entered is < 0, then 0 is used.  

oIf the value entered is > 1, then 1 is used.

oRequires comparison_operator = ND_X.

action_level_unit (15 char): The output unit for the sum calculation.

 

TEQ Sum Transformation

 

For each sample in the analytical results, while performing the MAG Sum, each member result is multiplied by a Toxic Equivalency Factor (TEF) before adding the result to the sum. The original member result is replaced with the Toxic Equivalency Quotient (TEQ) Sum.

 

1.REPORT RESULT_TEXT is replaced with “TEQ” for those results where multiplier applied and product summed.

2.REPORT_RESULT_VALUE is replaced with result value after multiplied by TEF.  

 

Basic values are copied to the new row, with new data populated as follows.

 

1.REPORT RESULT_TEXT and REPORT_RESULT_VALUE = the sum of the results of the members of the Method Analyte Group (MAG). REPORT RESULT_TEXT includes comparison operator where applicable.

2.CAS_RN and CHEMICAL NAME = method analyte group for the sum calculation as defined at DT_ACTION_LEVEL_LOOKUP.PARAM_CODE.

3.DETECT_FLAG = Y if sample results include any detect; N if all results are non-detects.

 

Populate DT_ACTION_LEVEL_LOOKUP. The columns below are required unless otherwise noted.

 

lookup_source (25 char): EQuIS_AR_II

lookup_code (40 char): Optional column used to create different categories for each source.

lookup_method (255 char): TEQ_SUM

param_code (20 char): The method analyte group code for the sum calculation.

comparison_id (20 char): The CAS_RN of the analyte to multiply by the TEF.

comparison_operator (10 char): TEF

comparison_value (19 char): The TEF value to multiply by the result value for the CAS_RN (designated in comparison_id), before adding to the TEQ_SUM.

action_level_unit (15 char): The output unit for the sum calculation.

 

Custom Transformations

 

Custom transformations may be configured as follows.  

 

Populate ST_MODULE with a new record:

 

module_type: ARII Transformation

Object_name: [Name of the assembly],[Namespace].[Class] for a valid ARII Transformation that Inherits EarthSoft.Common.Reports.IGridReportTransform.

name: transformation name; must equal lookup_method to associate DT_ACTION_LEVEL_LOOKUP rows with the transformation.

 

Optionally (if transformation queries this table), populate DT_ACTION_LEVEL_LOOKUP as appropriate. The columns below are required, unless otherwise noted.

 

lookup_source (25 char): EQuIS_AR_II

lookup_code (40 char): Optional column used to create different categories for each source.

lookup_method (255 char): transformation description; must equal ST_MODULE.NAME

param_code (20 char): Optional column used for the method analyte group code for the standard sum calculations. If you are not using this column, enter NONE or NA or any value since this column may not be NULL.

comparison_operator (10 char): Optional column used with comparison_value for the standard sum calculations. If you are not using this column, enter NONE or NA or any value since this column may not be NULL.

comparison_value (19 char): Optional value that can be used with comparison_operator.