Advanced Action Levels – Add Multiple Analyte Calculations [d43539]
Added two new lookup_methods for Advanced Action Levels: CALC_EXP_LOG_2 and CALC_EXP_LOG_3. The _2 or _3 indicates the number of analytes present in the calculation.
Forms – Action Levels – Filter Options Not Re-Selected After Clearing Lookup Records Filter in Action Levels [d47151]
Improved the consistency and usability of the Advanced Action Levels Lookup column filter:
- Column filters are now cleared by default
- Applying a filter updates the available filter options of all other columns
- Only DT_ACTION_LEVEL_LOOKUP records with associated DT_ACTION_LEVEL_PARAMETER records will be accessible from this view
- On Refresh the "Action Level Code Details" tab is selected and the currently selected ACTION_LEVEL details are cleared
Forms – Docs & Photos Form – Non-Admin User Cannot View Certain Folders and Groups [d45169]
Fixed an issue where users with non-administrator permissions were not able to see certain folders and subfolders in the Docs & Photos form for which they had permissions to view.
Forms – EQuIS Alert Form – Removed [d43558]
The EQuIS Alert Form has been deprecated and will no longer be available on the EarthSoft Community Center.
Professional – Handle Overrun of Varchar(max) Fields in Grid View [d45138]
Fixed a bug where large text (i.e., over 32,000 characters) in varchar fields caused tables and grid output to error when viewed.
Professional – Installer – Removed DMR EDDs From "Examples" Folder [d43722]
Removed the *\Examples\EDD Tutorial\DMR folder, which included the DMR EDD examples, from Professional installations.
Professional – Installer – Removed Legacy Geotechnical Module Files [d43639]
Removed legacy Geotechnical Module (AGS 4 Link Mapping.link) files from the EQuIS Professional installer.
Professional – SQL User Login – Update ST_USER.LAST_USE_DATE [d44776]
Added functionality when logging into Professional as a SQL User or Windows User that will update the date and time in the ST_USER.LAST_USE_DATE record.
Professional – Updated Third-Party Tool/Interface Icons [d43654]
Updated the third-party icons on the Data and Graphics ribbons in Professional.
Professional – User Login – Transmit Username Between Professional and Enterprise [d45288]
Improved user login functionality so that the username automatically transfers from the desktop login screen (Professional, SPM, and EnviroInsite) and the browser popups that appear for logins. The username is also included again when saving *.equis files for Enterprise, Microsoft, and OpenID logins.
Published Reports – Not Signed with Strong Name Error Message [d42633]
When opening a published report and the report DLL file is not present in the local install, corrected the error message to state that the file is not present rather than erroneously stating that the file was not signed with a strong name.
Reports – Action Level Exceedance II Reports – Additional Action Level Fields via Column Configuration [d46748]
Additional columns from the DT_ACTION_LEVEL and DT_ACTION_LEVEL_PARAMETER tables may be configured for use via the Column Configuration parameter.
Reports – Action Level Exceedance II Reports – Column Configuration Error when Report Contains Missing Unit Conversion Flagging [d46936]
Fixed a bug that was crashing the Action Level Exceedance II Reports when all of the following was true:
- ACTION_LEVEL = 'NaN' records were present
- Action Level Unit Conversion Errors = Flag Errors
- Column Configuration option was in use
Reports – Action Level Exceedance II Reports – Incorrect Unit Conversion [d43569]
Fixed a bug where the Action Level Exceedance II reports incorrectly converted units when two Method Analyte Groups were used together.
Reports – Action Level Exceedance II Reports – New Report Parameter for Straddle Samples [d46357]
A new report parameter has been added to the Action Level Exceedance II with Parameters report to now match straddle samples to both action levels, the upper action level, or lower action level.
Reports – Action Level Exceedance II Reports – Published Crosstab Report Runs when No Data for Action Level in Data Range [d46900]
Fixed issue where Crosstab reports based on the Action Level Exceedance II Reports would not run when there was no data for one of the Action Levels in the selected date range.
Reports – Action Level Exceedance II Reports – Returns Consistent Output for Multi-TEQ Action Level [d46570]
Fixed an issue where Multi-TEQ (Toxic Equivalency Quotient) Action Levels were generating inconsistent sum data when used with other Action Levels in the Action Level Exceedance II reports.
Reports – Analytical Results II – Statistics – Columns and Small Sample Size Calculations Updated [d45073]
Updated the Analytical Results II - Statistics report to include columns for intermediate calculation results of the Mann-Kendall trend analysis (Variance, S Value, Z Value, Small Sample Probability) and reports the final trend analysis as "Positive Trend," "Negative Trend," or "No Trend."
Also updated the calculation for small sample sizes (<10) to use the EPA-specified method.
Reports – Analytical Results II – Statistics – New Additional Fields Parameter Functionality [d46165]
Updated the Analytical Results II - Statistics report to display data generated using the Additional Fields parameter.
Reports – Analytical Results II – Statistics – Variance of S value is not calculated based on the EPA [d42953]
Added a new column named Variance_S to Analytical Results II - Statistics, which is calculated based on an equation in EPA QA/G9.
Reports – Analytical Results II Report – Fixed Incorrect Significant Figure Application [d42845]
Fixed a bug where MAG_SUM and TEQ_SUM were not applying significant figures correctly when "calc_result" was selected for the Significant Figures report parameter.
Reports – Crosstabs – Fixed Display of Formatting [d42531]
Fixed an issue with the Crosstab report where formatting would not be visible when display (non-detect) was used.
Reports – Location Parameters (Extra Fields) – Fixed Extra Selects Parameter [d46022]
Resolved a bug where the extra_select parameter in the Location Parameters (Extra Fields) Report would not generate output.
Reports – New – Agent - Coordinate Updates Report [d38238]
Created a new Report Agent that enables users to automatically convert a location's COORD_TYPE_CODE to another COORD_TYPE_CODE.
Reports – New – Agents - Configuration Settings Report [d43436]
Created a new Report Agent (Agent - Configuration Settings) that enables administrators to modify a collection of ST_CONFIG table settings using report parameters.
Reports – New EQuIS SEDD Report [d42060]
The Staged Electronic Data Deliverable (SEDD) format has been deprecated and replaced with the EQuIS SEDD Report, which can be opened in the SEDD data interface in Professional to export data from an EQuIS database into an XML file that complies with the organizational structure required of SEDD.
Reports – New Reference Value Summary Report [d44261]
Created new Reference Value Summary Report that generates an Excel file with reference values pertinent to analytical results data for a given facility or facilities.
Reports – RDL – Removed Display Error from RDL Viewer and Exports [d43655]
RDL Reports can be displayed and exported without data being replaced by errors in the document output.
Reports – Statistics: Analytical Statistics (by Location) Report – Fixed Calculation of Mann-Kendall S Value [d42898]
Fixed the known issue regarding the miscalculated Mann-Kendall S Value in the Statistics: Analytical Statistics (by Location) report.
Reports – Water Level - Action Level Exceedance Report – Multiple Locations on One Chart Error [d45599]
Fixed an error that occurred in the Water Level - Action Level Exceedance Report when the Plot Group Type parameter was set to 'All Locations in One Chart' and multiple locations were selected.
Reports – Water Levels II – Updated Decimal Separator for WATER_LEVEL Column [d43271]
Updated the WATER_LEVEL column of the Water Levels II report to use the appropriate decimal separator based on the cultural setting of the computer.
Schema – Professional – Added Coordinate Metadata Fields to VW_LOCATION [d43468]
Added coordinate metadata fields from DT_COORDINATE to be included in VW_LOCATION.
Schema – Professional – Added DT_LOCATION.ALT_LOC_CODE [d43427]
Added the ALT_LOC_CODE column to the DT_LOCATION table. This field can be used to maintain old SYS_LOC_CODEs that have been updated.
Schema – Professional – Enhanced ST_USER_TAU_SEND_USER_CERTIFICATE Trigger [d46359]
Updated an ST_USER trigger to only create new user certificate notices if password values differ.
Schema – Professional – Fixed Computed Columns [EUID] and [SYSID] [d43471]
Resolved database naming inconsistencies with columns handling SQ_EUID and SQ_SYSID sequences. Unpopulated EUID columns will be removed.
Schema – Professional – Improved Permissions Performance [d39538]
Made a minor performance improvement when permissions are applied.
Schema – Professional – Incorrect EUID Column Definitions in EUID-Based _ID Tables Causing Mismatches [d46223]
Adjusted the following tables to have a (computed/calculated) EUID column ID:
- ST_LICENSED_DATABASE (Standard/Professional)
- XT_TOKEN (Standard/Professional)
Schema – Professional – Move EUID Creation to Beginning to Avoid EUID Assignments of -1 [d47528]
Updated sequence EUID creation process to run at the beginning of the Schema file to ensure valid EUID values are being created.
Schema – Professional – Removed DT_BIOLOGICAL_RESULT Table [d45431]
Removed DT_BIOLOGICAL_RESULT from the Professional Schema. Please see the ECC Forum post linked here for more information.
Schema – Professional – Specifying LAT/LONG Coordinate Type in VW_LOCATION [d43466]
Added two new columns, COORD_TYPE_CODE_LATLONG and IDENTIFIER_LATLONG to DT_FACILITY to be referenced in VW_LOCATION when returning the LATITUDE and LONGITUDE fields. Previously, the view would return LATITUDE and LONGITUDE value from records matching the pattern of IDENTIFIER='PRIMARY' and COORD_TYPE_CODE like '%LAT%LONG%' from DT_COORDINATE.
Schema – Professional – Updated DT_LITHOLOGY.END_DEPTH Update Error Message [d46593]
Improved clarity of error message received when updating DT_LITHOLOGY.END_DEPTH requirements. This change improves the Upgrade process but does not change anything within the database.
Schema – Revoked Previously Granted Public Permissions in External License Database Script [d40806]
Updated the external license database script (License_Database.sql) so that external license database objects use the ES_PUBLIC role to comply with security policies. This script will need to be re-run in external license databases.
Schema – StandardReports – Deprecated v54 Reports with Class Report Replacements and No Dependents [d46376]
In databases where deprecated v54 reports have been published (i.e., databases created prior to the 7.25.1 Build), these reports will have ST_REPORT.STATUS_FLAG set to 'R'. The list of deprecated and inactive reports is as follows:
- Action Level Exceedance – Database Object: v54.action_level_exceedance
- Action Level Exceedance (by EDD) – Database Object: v54.action_level_exceedance_ebatch
- Anaylte Exceedance – Database Object: v54.analyte_exceedance
- Analytical Results (Aggregate) – Database Object: v54.analytical_result_aggregate
- Analytical Results (QC) – Database Object: v54.analytical_results_qc
- Basic Results – Database Object: v54.basic_results
- Facility Results – Database Object: v54.facility_results
- Location Information – Database Object: v54.location_info
- Location Parameter Exceedance – Database Object: v54.location_parameter_exceedance
- Location Parameters (Most Recent) – Database Object: v54.location_parameter_recent
- Sample Holding Time – Database Object: v54.sample_holding_time
- Sample Parameters – Database Object: v54.sample_parameters
- Sample Parameters (Exceedance) – Database Object: v54.sample_parameter_exceedance
- Sample Parameters (Most Recent) – Database Object: v54.sample_parameter_recent
A new folder will be created in the RT_GROUP table named 'Deprecated', and the following v54 reports will be moved into the folder. These deprecated reports remain active (STATUS_FLAG = 'A') due to dependencies or lack of replacements and include:
- Analytical Results – Database Object: v54.analytical_results
- Analytical Results (Aggregate) – Database Object: v54.analytical_result_aggregate
- Location Parameters – Database Object: v54.location_parameters
- Location Parameters (Action Level Exceedance) – Database Object: v54.location_parameter_exceedance_al
- Water Levels – Database Object: v54.water_level
Changes to the v54 reports occur with updates to the schema.StandardReports.xme file.
Schema – StandardReports – Stopped Publishing v54 Reports in New Databases [d46214]
The following v54 reports are no longer being published in new databases:
- Action Level Exceedance – Database Object: v54.action_level_exceedance
- Action Level Exceedance (by EDD) – Database Object: v54.action_level_exceedance_ebatch
- Anaylte Exceedance – Database Object: v54.analyte_exceedance
- Analytical Results (Aggregate) – Database Object: v54.analytical_result_aggregate
- Analytical Results (QC) – Database Object: v54.analytical_results_qc
- Basic Results – Database Object: v54.basic_results
- Facility Results – Database Object: v54.facility_results
- Location Information – Database Object: v54.location_info
- Location Parameter Exceedance – Database Object: v54.location_parameter_exceedance
- Location Parameters (Most Recent) – Database Object: v54.location_parameter_recent
- Sample Holding Time – Database Object: v54.sample_holding_time
- Sample Parameters – Database Object: v54.sample_parameters
- Sample Parameters (Exceedance) – Database Object: v54.sample_parameter_exceedance
- Sample Parameters (Most Recent) – Database Object: v54.sample_parameter_recent
The functions and procedures generated by these v54 reports will still be available. Changes to the v54 reports occur with updates to the schema.StandardReports.xme file.