Action Level Exceedance Format I

<< Click to Display Table of Contents >>

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

Action Level Exceedance Format I

Report Name: Action Level Exceedance Format I

(previously called Action Level Exceedance Format 1)

 

Report Type: Standard

 

Description: The Action Level Exceedance Format I Report generates a report with or without action level exceedances. Its row headers are Constituent, action levels and units. Its column headers are Location ID, Sample Date, Sample Time, Sampled Interval, Sample ID, Laboratory and Lab Number. It can report up to a maximum of three action level codes. The units of action levels can be used as final units of the report. Checking results against summed action levels can be done in the report. It is a class report, based on the Analytical Results II Report. In previous versions, this report was called Action Level Exceedance Format 1.

 

Example 1

 

The steps below are an example of preparing data to do summed action levels with select individual analytes.

 

1.Create a method_analyte_group_code = 'sumAnalytesIndiv' without populating group_type. Add the analytes to be summed for checking a summed action level.

2.Create a summed action level in DT_ACTION_LEVEL_PARAMETER, e.g. param_code='sumAnalytesIndiv' in the action level code to be used in the report and populate DT_ACTION_LEVEL_PARAMETER.REMARK with sum_al, and populate action level values and unit.

3.Select individual analytes and no analyte groups, and select the action level code which has the summed action level, e.g. 'sumAnalytesIndiv'.

4.Check the "Action Level\List summed action levels" box.

 

Example 2

 

The steps below are an example of preparing data to do summed action levels with select analyte groups.

 

1.Create a method_analyte_group_code, e.g. 'sumAnalytes' and populate group_type with the method_analyte_group_code (e.g. antimony_sodium) with which sumAnalytes is associated. Add the analytes to be summed for checking a summed action level; the analytes must be the members of the associated method_analyte_group_code (e.g. antimony_sodium).

2.Create a summed action level in DT_ACTION_LEVEL_PARAMETER, e.g. param_code='sumAnalytes' in the action level code (e.g. A_test) to be used in the report and populate DT_ACTION_LEVEL_PARAMETER.remark with sum_al, and populate action level values and unit.

3.Select analyte groups, and select the action level code (e.g. A_test) which has the  summed action level, e.g. 'sumAnalytes'.

4.Check the "Action Level\List summed action levels".

5.Populate RT_ANALYTIC_METHOD.CATEGORY or RT_LOOKUP.LOOKUP_DESC if duplicated results occur due to different analytic_methods (Note that the duplicates may occur because analytic_method is not in the column headers). When a duplicated result occurs, the report first checks if it belongs to a specific group that requires RT_ANALYTIC_METHOD.CATEGORY or RT_LOOKUP.LOOKUP_DESC to be populated with the group name that the results belong to. For example, if the RT_ANALYTIC_METHOD.CATEGORY (e.g. VOCS) of a result is equal to RT_MTH_ANL_GROUP.METHOD_ANALYTE_GROUP_CODE (e.g. VOCS), the result only belongs to the VOCS group. It Is obvious that the report uses RT_ANALYTIC_METHOD.CATEGORY or RT_LOOKUP.LOOKUP_DESC to prevent adding duplicated results of different analyte groups together when calculating a summed result.

 

If RT_ANALYTIC_METHOD.CATEGORY does not exist in the database, RT_LOOKUP.LOOKUP_DESC can be used to replace it where RT_LOOKUP.LOOKUP_CODE=ANALYTIC_METHOD and RT_LOOKUP.LOOKUP_TYPE='analytic_method_category'.

 

Formats and Rules for Doing Summed Action Levels

 

1.A result is formatted bold if it violates one action level, bold+italic if it violates two action levels and bold+italic+underline if it violates three action levels.

2.If all results (including exceedances) are desired, summed values should show with any non-detects being treated as zero values in the summation math.

3.If all results are non-detects, the reporting limits should be summed, and the report will display "<" & "summed reporting limits".

 

Data Mapping

 

Data Mapping

Constituent

RT_ANALYTE.CHEMICAL_NAME if RT_FRACTION.REMARK=0 or RT_ANALYTE.CHEMICAL_NAME

RT_FRACTION.FRACTION_DESC with DT_TEST.FRACTION=RT_FRACTION.FRACTION

It is ordered by RT_MTH_ANL_GROUP_MEMBER.REPORT_ORDER or RT_ANALYTE.SORT_ORDER

Location ID:

DT_SAMPLE.SYS_LOC_CODE. Note it is RT_SAMPLE_TYPE.REMARK or SAMPLE_TYPE_CODE if SYS_LOC_CODE is null.

Sample Date:

DT_SAMPLE.SAMPLE_DATE

Sample Time:


Sampled Interval:

DT_SAMPLE.START_DEPTH - DT_SAMPLE.END_DEPTH or DT_WELL_SEGMENT.START_DEPTH -

DT_WELL_SEGMENT.END_DEPTH with segement_type='SCREEN' and matrix_code='GW' + DT_SAMPLE.DEPTH_UNIT or

DT_WELL_SEGEMENT.DEPTH_UNIT

Sample ID:

DT_SAMPLE.SYS_SAMPLE_CODE

Laboratory:

RT_COMPANY.CUSTOM_FIELD_1 with company_code=DT_TEST.LAB_NAME_CODE and company_type='LAB'

Lab. Number:

DT_TEST.LAB_SAMPLE_ID


Column header is ordered by Location ID, Sample Date, Start Depth, Sample Time

Results

RT_RESULT.RESULT_NUMERIC DT_TEST.LAB_QUALIFIERS

 

Report Dependencies: Analytical Results (Extra Fields) 50943

 

File Name: EarthSoft.Reports.Library.67034.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 I Report includes all the input parameters from the Analytical Results II Report, in addition to the input parameters shown in the table below. Please note that the Additional Fields parameter may be customized as explained in the article How To - Customize Additional Fields Parameter.

 

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



*Matrix code for groundwater



Action Level

Action Level(s)



Enter a multipllier for

all action level limits



Display exceedances only



Use action level units



Comparison Operator



List summed action levels


Use non-detects



*Enter the max decimal place for the results of the report



Additional Fields



Contact

support@earthsoft.com
for more information.

Contact support@earthsoft.com for more information.

Note: * refers to hidden parameters

 

Tables: The Action Level Exceedance Format I Report uses the same tables by the Analytical Results Report in addition to the following tables: DT_WELL_SEGMENT, RT_SAMPLE_TYPE.

 

Database Type: SQL

 

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

 

Database Version: EQuIS 5.6+

 

Data Requirements: The report lists RT_SAMPLE_TYPE.SAMPLE_TYPE_CODE if Location ID SYS_LOC_CODE is not found.

 

A sample START_DEPTH/END_DEPTH can be replaced by DT_WELL_SEGMENT.START_DEPTH/END_DEPTH if the sample START_DEPTH/END_DEPTH is not available. In this case, the hidden input parameter plays a role, which is that the DT_SAMPLE.MATRIX_CODE and also DT_WELL_SEGMENT.SEGMENT_TYPE are required to be "SCREEN."

 

Report Requirements: N/A

 

Output Type: PDF or Excel

 

Revision History: The revision below was completed in EQuIS 7.

The report only worked with the date format of M/d/yyyy or MM/dd/yyyy. It is modified to work with different date formats defined by a computer operating system (Case 138634).

Example Output: View the following example or download one of the following attachments, Action Level Exceedance Format 1.xlsx or Action Level Exceedance Format 1.pdf.

 

Example Output: Contact support@earthsoft.com

 

30176-sample1

 

PDF Output Example

 

30176-sample1_pdf