Report Name: VI Analytical Results II with Building Parameters (example; file contains output from three different examples)
File Name: EarthSoft.Reports.Library.191612.dll
Dependencies: Analytical Results II Report
Software: EQuIS Professional and EQuIS Enterprise
Source: EQuIS Professional install, EQuIS Enterprise install + Vapor Intrusion Module (EarthSoft Community Center > Products > Vapor Intrusion)
Output Type: Report Grid1
Description: The VI Analytical Results II with Building Parameters report combines standard Analytical Results II report output with vapor intrusion building data. The vapor intrusion implementation assumes that buildings are a subfacility type and that individual buildings are identified with a SUBFACILITY_CODE. Building parameters are defined as subfacility parameters.
The report output combines building and analytical data based on the association at DT_LOCATION.SUBFACILITY_CODE. As such, locations may only be associated with one subfacility, while a building subfacility may be associated with multiple locations.
Note: Subfacility location associations defined in the AT_SUBFACILITY_LOCATION table are not referenced by this report. For reporting options related to this table, see Turning a Subfacility into a Location Group.
The building parameter selections are described below. If there are multiple parameter codes and/or parameter values per subfacility, analytical results rows are added to accommodate separate rows for each subfacility parameter combination. For example if subfacility BLDG 1 has multiple PARAM_CODEs, the same analytical results for the associated location are output for each PARAM_CODE. Similarly if subfacility BLDG 1 has multiple PARAM_CODEs, and multiple PARAM_VALUEs for each PARAM_CODE, the same analytical results for the associated location are output for each PARAM_CODE and param_value combination.
Building Code(s) – A multi-select lookup from DT_SUBFACILITY.SUBFACILITY_CODE. If no building input is selected or only a Building Code(s) is selected, the report returns standard Analytical Results II output plus the SUBFACILITY_CODE column.
Building Parameter Code(s) – A multi-select lookup from DT_SUBFACILITY_PARAMETER.PARAMETER_CODE. When selected, the report returns the standard Analytical Results II output plus the SUBFACILITY_CODE, PARAM_CODE, and PARAM_VALUE fields.
Building Parameter Value(s) – A multi-select lookup from DT_SUBFACILITY_PARAMETER.PARAM_VALUE. When selected, the report returns the standard Analytical Results II output plus the SUBFACILITY_CODE, PARAM_CODE, and PARAM_VALUE fields.
Installation Instructions: The VI Analytical Results II with Building Parameters report (EarthSoft.Reports.Library.191612.dll) is available for download in the Products\Vapor Intrusion folder on the Downloads Dashboard on the EarthSoft Community Center. For Enterprise use, this report should be published to the database. The report will be available for selection once it has been published.
Tables: DT_FACILITY, DT_FIELD_SAMPLE, DT_LITHOLOGY, DT_LOCATION, DT_PURGE, DT_RESULT, DT_RESULT_QC, DT_SAMPLE, DT_STATIC_PROPS, DT_SUBFACILITY, DT_SUBFACILITY_PARAMETER, DT_TASK, DT_TEST, DT_WATER_LEVEL, DT_WELL, RT_ANALYTE, RT_ANALYTE_VAR, RT_ANALYTIC_METHOD, RT_GROUP, RT_GROUP_MEMBER, RT_MATRIX, RT_MTH_ANL_GROUP, RT_MTH_ANL_GROUP_MEMBER, RT_SAMPLE_TYPE, ST_EDD_BATCH, VW_LOCATION
Report Parameters: All the standard Analytical Results II report parameters plus building parameters listed within the Location group.
1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML, or a printer.
Copyright © 2020 EarthSoft, Inc • Modified: 08 Oct 2020