Action Level Exceedance Format III

Report Name: Action Level Exceedance Format III (example)

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

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Excel1

Description: The Action Level Exceedance Format III Report generates cross-tabbed analytic results with or without action level exceedances. The row headers are chemical_name (Analyte), report_result_unit (Units), report_result_limit (Limits), and action levels if selected. Its column headers are SYS_LOC_CODE (Station ID), SYS_SAMPLE_CODE (Sample ID), MATRIX_CODE (Matrix), SAMPLE_DATE (Sample Date). This allows you to add lab_qualifiers after results and export RT_QUALIFIER.REMARK as a footnote.

Installation Instructions: This report assembly is part of the EQuIS Professional installation. No additional installation steps are necessary.

Overview:

Two types of action level comparisons are possible.

1.The first is to compare each of the action level values of selected action level codes to a result where the Action Level\Select action level comparison method\All parameter is selected.

2.The second is when the Action Level \ Select action level comparison method\First and/or min of the rest parameter is selected, the report compares the action level value of the first action level code to a result, and continues to compare the minimum of the action level values of the rest of the action level codes to the result if the result is not flagged to the first action level. It is a class report and obtains source data using the Analytical Results II Report.

The Action Level Exceedance Format III Report uses the same tables as the Analytical Results II Report, in addition to the following tables:

•DT_ACTION_LEVEL

•DT_ACTION_LEVEL_PARAMETER

This report features an option to select an Excel template with customized titles and notes (example: ALEF3_template.xlsx).

Notes:

•The template file must be placed at ...\My EQuIS Work\ folder or uploaded to the DT_FILE table. The insert_from_here must be populated in a cell of Column A of the template file so that the report will insert cross-tabbed results from the row the insert_from_here is at.

•If including action levels with this report, in order for the Action Levels to appear, the ActionLevelFormats.xl must be added to DT_FILE (uploaded via Docs & Photos Form) before publishing the DLL. If the DLL is published before the .xlsx is added to dt_file, the Action levels will never populate. Or, if the ActionLevelFormat is added to dt_file and the DLL is never published, the Action Levels selection remains NULL.

Warning: Do not enter a file name into the Template/File Name parameter if no template file is used.

Report Parameters *

Location	Parameter section for selecting individual locations, location groups and whether to use DT_GEOGRAPHY for coordinates.
Sample	Section for selecting sample related parameters.
Result	Section for selecting result related parameters.
Qualifier
Action Level
Action Level 1	Select one action level to use for comparison.
Format 1	Select one format.
Action Level 2	Select one action level to use for comparison.
Format 2	Select one format.
Action Level 3	Select one action level to use for comparison.
Format 3	Select one format.
Action Level 4	Select one action level to use for comparison.
Format 4	Select one format.
Action Level 5	Select one action level to use for comparison.
Format 5	Select one format.
Action Level 6	Select one action level to use for comparison.
Format 6	Select one format.
Select action level comparison method	Select one item. Defualt: First and/or min of the rest.
Use Action Level Units	Check the box to use action level units. Default; false
Template

* This report contains hidden parameters that could affect the output of the report.

Consult an EQuIS administrator if these parameters should be visible or use different default values in a published report (a report
that allows saving of user reports). These parameters cannot be viewed or changed in unpublished reports outside of a report

parameter file.

1Excel report output requires a valid license of Microsoft Excel to view the output.