DQM - Add Calculation Options to Spike Recovery Check [d804]
Six new parameters have been added to
the DQM check for Spike Recovery.
DQM - Add Calculation Options to RPD Check [d808]
Nine new parameters have been added to
the DQM check for Relative Percent Difference (RPD):
- compare_to_calculated_lcsd and compare_to_calculated_msd and compare_to_calculated_lab_dup
- acceptable_variance_lcsd and acceptable_variance_msd and acceptable_variance_lab_dup
- calculated_before_reported_lcsd and calculated_before_reported_msd and reported_before_calculated_lab_dup
ALEII - Skip Missing Unit Conversions for Action Level Comparisons [d906]
A new report parameter has been added to the ALEII reports, "Action Level Unit Conversion Errors", with the following three options:
- "Stop Report"
- A unit conversion error message is displayed in the report grid with no other report output.
- This is the current functionality and the default value for this new report parameter.
- "Flag Errors"
- The unit conversion error message is displayed in the FLAG column of each result with a unit conversion error.
- This allows the report to run for all of the other results that do not have the error.
- This allows the user to see exactly which results have the error.
- This prevents an accidental "No Exceedances" Report due to a data entry issue.
- "Skip Errors"
- Results with a unit conversion error between the result unit and the action level unit are treated as if there was no match between the result and the action level.
- The report output will contain no values in any of the action level columns for the results with a unit conversion error (just like results that do not have a matching action level).
- This could result in accidental "No Exceedances" report output that are not accurate. Therefore, this option is hidden in the standard release DLL.
- This option can be added, at the user's own risk, by changing the DATA_SOURCE column in ST_REPORT_PARAMETER. (ask support@earthsoft.com for instructions)
Republishing the ALEII report assembly (EarthSoft.Reports.Library.51729.dll) is recommended following these instructions: https://help.earthsoft.com/pro_report-publisher.htm?zoom_highlightsub=republish.
DQM - Add Calculation Options to RPD - Field Check [d949]
Three new parameters have been added to
the DQM check for Relative Percent Difference (RPD) for Field Duplicate Samples.
DQM - Holding Time Check Improvements - Preservation Intervals [d1099]
The Holding Times Check is updated with three new Holding Time Type intervals and related logic.
Replace Foreign Key Constraint "FK__st_user_report_p__[...]" Error with Message to Republish Report [d1252]
Saving a user report for an outdated base report resulted in the 'The INSERT statement conflicted with the FOREIGN KEY constraint "FK__st_user_report_p__[...]"' error appearing in Professional. This error message has been replaced.
New Standard Report: "VI Analytical Results II with Building Parameters" [d1427]
As part of the Vapor Intrusion Module, the new VI Analytical Results II with Building Parameters Report combines standard Analytical Results II report output with vapor intrusion building data.
Schema - Add Return Date Field to DT_EQUIPMENT [d1448]
Added column END_OF_SERVICE_DATE to table DT_EQUIPMENT.
Stored Procedure Fixes to ADD_EUID and BUILD_TABLE_TYPE [d1473]
Made fixes to stored procedures EQUIS.ADD_EUID and EQUIS.BUILD_TABLE_TYPE.
SampleTestResult III Form [d1636]
A new form, SampleTestResult III, has been added to the EQuIS Professional Installer.
STR III When Opened as STR II from ARII [d1685]
The SampleTestResult II has been updated to show all the parameters selected for the ARII report in a new Parameters tab.
DQM - Add SDG_STATUS Tab to In Process and History Forms [d1707]
When Opening an In Process Event or a Historical Event in DQM, a status, date, and reviewer may be recorded for the event to aid in communicating the SDG status without having to open the DQM event.
DQM - Add Preserved/Unpreserved Option to Holding Times Check [d1835]
Added functionality to look to DT_TEST.PRESERVATIVE to determine if populated.
Added schema change to RT_HOLDING_TIME.
EQuIS for gINT - Create Project - "/*^INSERT*/ INSERT INTO" "Invalid SQL statement" Errors [d2003]
Fixed SQL error that occurred when creating .gpj files using the EQuIS for gINT interface.
Schema - Add DQM_PRESERVED_YN to RT_HOLDING_TIME [d2017]
In the standard Professional Schema (i.e. schema.xml/e), added the DQM_PRESERVED_YN column to the RT_HOLDING_TIME table.
DQM: Add Upper Cutoff Fields to RT_DQM_CONTROL_LIMITS [d2059]
Added columns LCS_REC_UPPER_CUTOFF, MS_REC_UPPER_CUTOFF, and SURR_REC_UPPER_CUTOFF to the RT_DQM_CONTROL_LIMITS table.
DQM: Add PREP_METHOD to RT_DQM_CONTROL_LIMITS [d2100]
Added DDL column PREP_METHOD to RT_DQM_CONTROL_LIMITS with a Foreign Key to RT_PREP_METHOD; also included PREP_METHOD in the Unique Key of RT_DQM_CONTROL_LIMITS.
Report Parameter Selector Filter Improvements [d2107]
An issue was causing filter performance to be slow using the Report Parameter Selector grid for List Parameters with thousands of records. This has been fixed.
New Standard Report: "VI Building Parameter" [d2187]
As part of the Vapor Intrusion Module, the new VI Building Parameter report generates output of the building parameters and building inspection information for the selected building codes while also including the locations associated with the selected buildings.
Schema - Add SPM COC Fields/Tables to Standard Schema [d2246]
Added DT_CHAIN_OF_CUSTODY_MAG and DT_CHAIN_OF_CUSTODY_MAG_MEMBER tables to the standard Schema previously added by SPM to the DT_CHAIN_OF_CUSTODY table.
MAG_SUM - Detect Exceedances Not Flagged if "Flag Non-Detects" = No [d2309]
A bug in the MAG sum calculation for Action Level Exceedance II was causing the FLAG column to not be populated for detected concentrations if "Flag Non-Detect" = 'No'. This has been fixed. We recommend this report (EarthSoft.Reports.Library.51729.dll), if already published to your project database(s), be republished following these instructions: https://help.earthsoft.com/pro_report-publisher.htm?zoom_highlightsub=republish.
Advanced Action Levels (AALs) - Multiple and/or Mixed AALs Bug in Lookup Function [d2312]
The MULTIPLE(OR)_LOOKUP and MULTIPLE(OR)_MIXED advanced action level had a bug that failed to use the first analyte (comparison_id) in a comparison group. This has been fixed.
Professional - Reports - Detect Flag Applied Incorrectly to the Analytical Results with Sample Calculations Report [d2319]
The detect_flag value of a sample summary row was taken from the first row of the sample results even if the sample results had various detect_flag values. It is now updated to reflect all the detect_flag values that occurred in the sample results. We recommend this report (EarthSoft.Reports.Library.11472.dll), if already published to your project
database(s), be republished following these instructions: https://help.earthsoft.com/pro_report-publisher.htm?zoom_highlightsub=republish.
EnviroInsite Analyte Concentration Map Report Does Not Honor Extents Set in Report for Image Generated in Page [d2397]
Fixed an issue in the EnviroInsite Analyte Concentration Map Report where Easting and Northing inputs were not being correctly applied due to outlier location coordinates.
We recommend this report (EarthSoft.Reports.Library.EnviroInsite.dll), if already published to your project
database(s), be republished following these instructions: https://help.earthsoft.com/pro_report-publisher.htm?zoom_highlightsub=republish.
Update DQM Event - Update DQM Status and Update DQM Status Remark Buttons Do Not Work [d2411]
The intended functionality of the "Update DQM Status" and "Update DQM Status Remark" buttons on the Process "DQM EVENT" window has been restored.
Statistics: Analytical Statistics (by location) Parameter 'Differ Statistics By Start_depth' to 'False' Causes Error [d2444]
Fixed the bug that occurred on running the "Statistics: Analytical Statistics (by location)" Report when the "Differ Statistics By Start_Depth" parameter is unchecked. We recommend this report (EarthSoft.Reports.Library.14425.dll), if already published to your project database(s), be republished following these instructions: https://help.earthsoft.com/pro_report-publisher.htm?zoom_highlightsub=republish.
Reports - Analytical Results II - Add @workflow_status [d2482]
Reports - Analytical Results II - ND REPORT_RESULT_UNIT using DETECTION_LIMIT_UNIT over RESULT_UNIT [d2538]
Fixed the bug that ARII takes detection_limit_unit rather than result_unit as the original unit.
Installer Checks for TLS 1.2 [d2541]
Standardize Login Screen [d2629]
The Connection screen in EQuIS Professional has been updated to be more consistent with other EarthSoft Products. Support for signing in with OpenID has been added.
Action Level Exceedance II Will Not Open When Report is Published to Database and Full Library Not Installed [d2646]
The Analytical Results II (EarthSoft.Reports.Library.50943.dll) and Action Level Exceedance II reports (EarthSoft.Reports.Library.51729.dll) are now included as part of EQuIS Professional without having to install the full library.
If the full library is not installed, the EarthSoft.ActionLevels.Library.105851.dll is still needed in the EQuIS folder in order to use Advanced Action Levels in an Action Level Exceedance II report.
German Translations [d2671]
EQuIS Professional has been updated to contain corrected German Translations throughout the User Interface.
Updates to the DQM-refvals Format and DQM Starter QAPP EDD [d2758]
There are significant updates to the DQM-refvals format and DQM Starter QAPP.xlsx EDD installed at ./EQuIS/Formats/DQM. The updates support new DQM functionality in Version 7.20.4 and include:
- A new RT_HOLDING_TIME_V2 section replaces the old. The new tab includes a reordering of all fields, a new column, DQM_PRESERVED_YN, a removed column, CALCULATION_UNIT, and three new holding time intervals:
- collect_preserve
- preserve_prep
- preserve_analysis
- A new Batch Completeness check, with three rules, three reason codes, and five check parameters.
- Parameters additions: Nine new parameters for RPD check, Six new parameters for Spike Recovery 2 check, three new parameters for Field RPD check, two new parameters for the Required Detection Limit check, and one new parameter for the Holding Time check.
Note that since the DQM-refvals format is restructured, EDDs of the previous version must be updated to load successfully.
EQuIS for ArcGIS - Missing Rows when Values Exceed Hard-Coded Field Lengths [d2874]
EQuIS for AutoCAD "Connect" Fails to Launch [d3234]
EQuIS for AutoCAD failed to load the EQuIS connection form. This has been resolved.
Add DQM Update QAPP EDD to Formats/DQM folder [d3265]
A link to the new DQM Update Existing QAPPs help page has been added to the EQuIS/Formats/DQM folder. This help page contains links to Update Existing QAPP EDD with all of the new checks, rules, and parameters pertaining to new functionality added in various EQuIS builds and instructions for how to use the linked DQM Update QAPP EDDs: https://help.earthsoft.com/PRO_DQM_Update_Existing_QAPPs.htm