Action Level Exceedance Format III

<< Click to Display Table of Contents >>

EQuIS 7  >>  EQuIS Library > Reports > EarthSoft Standard Reports > Action Level Reports >

Action Level Exceedance Format III

Report Name: Action Level Exceedance Format III (111561)

*previously called Action Level Exceedance Format 3

 

Report Type: Standard

 

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. 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.

 

In previous versions, this report was called Action Level Exceedance Format 3.

 

Note: When including action levels, there are a variety of format options for flagging. This requires storing the formats as ActionLevelFormats.xlsx in DT_FILE (upload via Docs & Photos Form). When this reference file is missing, the action level list will be empty.

 

This report features an option to select an Excel template with customized titles and notes (example: ALEF3_template.xlsx). Note the template file must be placed at ...\My EQuIS Work\ folder or uploaded to DT_FILE. 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.

 

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

 

Report Dependencies:

 

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

 

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

 

Language: English

 

Input Parameters: A selection made to customize the output of a report. The Action Level Exceedance Format III Report includes all the input parameters from the Analytical Results II Report, in addition to the input parameters shown in the table below. Note that the Additional Fields parameter may be customized as explained here.

 

Input Parameters

Input Parameter Screenshot

Output Columns

Sample




Samples




Sample ID
(sys_sample_code)

Test




Lab Name
(lab_name_code)



Leachate Method


Header




Header Line 1:



Header Line 2:



Header Line 3:



Individual(s)


Footer




Footer Line 1:



Footer Line 2:



Task(s)


Note




Note Line 1:



Note Line 2:



Note Line 3:



Note Line 4:



Note Line 5:


Output File Type



Add a Watermark



Columns per
page for pdf



Rows per page
for pdf



*Matrix code
for groundwater



Action Level

Action Level(s)



Enter a multiplier
for all action level limits



Display
exceedances only



Use action level
units



Comparison
Operator



List summed
action levels


Use non-detects



*Enter max
decimal place for results of report



Additional Fields






                                               

30177.input.params

Contact

support@earthsoft.com

for more information

 

Tables: 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

 

Database Type: SQL

 

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

 

Database Version: EQuIS 6.3+

 

Data Requirements: If including action levels, an ActionLevelFormats.xlsx must be stored in DT_FILE (uploaded via Docs & Photos Form). When this is missing, the action

level list will be empty.

 

Report Requirements: N/A

 

Output Type: Excel

 

Example Output: View the following example or download the following attachment, Action Level Exceedance Format 3_Springfield_20150409091540.xlsx.

 

Excel Output Example:

 

30177-ex.output_zoom61