COLLECT_INSPECTION_AQS Format – Updated Field Lengths and Digitally Signed Format [d41324]
Updated the field lengths for EQUIPMENT_PARAMETER.PARAM_VALUE from 20 to 255 characters and EQUIPMENT_PARAMETER.REMARK from 255 to 2000 characters for the COLLECT_INSPECTION_AQS format, and digitally signed the format.
EDP – Added Field Mapping Support for "smallint" Data Types to Generate Format File Tool [d41604]
Fixed a bug in the Generate Format File tool that resulted in an error when mapping to a "smallint" datatype field in the database.
EDP – Fixed "NaN" Error When Creating EDD Package [d40968]
Fixed a bug where NaN (Not a Number) was considered a valid value in numeric fields, which resulted in an Invalid Data Type error when creating an EDD.
EDP – Fixed Default File Use When Custom ALIVE_EDGE Format Name Includes "Survey" [d41636]
Fixed a bug where EDP defaulted to use the SURVEY.xse file, rather than the ALIVE_EDGE.xse
file, in custom ALIVE_EDGE formats that contained the word "Survey" in
their name (e.g., Wildlife_Survey).
EDP – Fixed Incorrect Reading of Encoded Text Files [d41475]
Fixed a bug in EDP where encoded text (.TXT) files within a zipped EDD were read incorrectly in some cases.
EDP – Fixed Lookup Mapping Error [d41099]
Fixed an issue that resulted in "Target field not found in mapping..." errors being listed in the debug log when attempting to conduct complex lookup mappings.
EFWEDD Format – Added Requirement That SYS_LOC_CODE Values are Present in Database [d41043]
Updated the EFWEDD format to require that SYS_LOC_CODE values exist in DT_LOCATION. If a SYS_LOC_CODE value is missing, an error is displayed stating "SYS_LOC_CODE must exist in the database".
Enterprise EDP – Updated Permission Requirements to Download and View EDDs [d41270]
Updated the permission requirements to download and/or view EDDs for users who are not administrators and who did not submit the EDD(s). The Viewer permission on the Facility and EDD object types is required to download and/or view EDDs for the EDP EDD Status widget and the "Enterprise EDP: EDD List" form.
EQEDD and EQEDD_v2 Formats – Fixed Error Check Refresh When RESULT_TYPE_CODE Changed [d41192]
Fixed an error in the EQEDD and EQEDD_v2 formats that was caused by edits made to the REPORTING_DETECTION_LIMIT field, which resulted in the format(s) not being refreshed.
EQEDD and EQEDD_v2 Formats – Fixed Error in Published EQEDD Lab EDD and EQEDD_v2 Lab EDD Exports [d41003]
Fixed a bug that caused an error with published EQEDD Lab EDD and EQEDD_v2 Lab EDD exports when an ' (apostrophe) was included in the SYS_SAMPLE_CODE data and the export file type was Excel.
EQEDD and EQEDD_v2 Formats – Improved "Out of range" Error Message [d41294]
Improved the "Out of range" error message to include the minimum and maximum values that make up the acceptable range.
EQEDD Format – Updated "water_level_elev" to Match EQEDD_v2 Format Behavior [d41685]
Updated the EQEDD format to match how the EQEDD_v2 format handles the "water_level_elev" field.
ERPIMS Format – Added Latitude and Longitude Fields to LDI Section [d41590]
Added LATITUDE and LONGITUDE fields to the LDI section of the ERPIMS format. LATITUDE maps to DT_COORDINATE.Y_COORD and LONGITUDE maps to DT_COORDINATE.X_COORD. When either field is populated, 'LAT_LONG' will be added to DT_COORDINATE.COORD_TYPE_CODE.
ERPIMS Format – Changed LTD.LOGCODE Mapping [d41560]
Changed the mapping of LTD.LOGCODE in the ERPIMS format from DT_LOCATION.DRILLING_SUBCONTRACTOR to DT_LITHOLOGY.CUSTOM_FIELD_1.
ERPIMS Format – Fixed Data Export into RESULT_LAB.LAB_DQT and RESULT_LAB.LAB_QC_FLAG [d41549]
Fixed data exports for the ERPIMS format. Now, DT_RESULT.LAB_QUALIFIERS correctly maps to LAB_QC_FLAG and, when PARAM_CODE equals "LAB_DQT", DT_RESULT_PARAMETER.PARAM_VALUE correctly maps to LAB_DQT.
ERPIMS Format – Fixed Group 3 Prime and Group 3 Lab Exports [d41504]
Fixed a bug that caused Group 3 Prime and Group 3 Lab exports to fail unless a sample also included associated test and result data.
ERPIMS Format – Fixed LTD.ENDDEPTH Values Not Truncating on Export [d41648]
Fixed a bug in the ERPIMS format export where the LTD.ENDDEPTH field had trailing zeros appended after the decimal point. The export now truncates this field to comply with the ERPIMS Schema.
ERPIMS Format – Fixed WINT.IBDEPTH and WINT.IEDEPTH Values Not Truncating on Export [d41594]
Fixed a bug in the ERPIMS format export where the WINT.IBDEPTH and WINT.IEDEPTH fields had trailing zeros appended after the decimal point. The export now truncates these fields to comply with the ERPIMS Schema.
ERPIMS Format – Improved Custom Error Handling [d41387]
Updated the error handling for the ERPIMS Sample_Lab section when populating SACODE, PARENTFLDID, and PARENTLABID to inform the user about misconfigured data.
ERPIMS Format – Remapped PARVAL Field for Format Export [d41431]
Updated the Result_Prime and Result_Lab sections of the ERPIMS Format export to use DT_RESULT.RESULT_TEXT instead of DT_RESULT.RESULT_NUMERIC for the PARVAL field.
ERPIMS Format – Updated All Date Field Formats [d41583]
Updated all date fields to use the dd-MMM-yyyy format (e.g., 02-Sep-2024).
ERPIMS Format – Updated Decimal Lengths for Numeric Fields [d41524]
Updated the "fractionDigits" parameter so the decimal lengths are consistent between the ERPIMS format and ERPIMS Schema.
ERPIMS Format – Updated Format Field Lengths [d40872]
Updated the field lengths in the ERPIMS format to match the field lengths in the ERPIMS Schema.
Facility Format – Added Date Checks [d42114]
The at_facility, dt_task, and dt_location sections of the Facility format now check that the start_date must be before the end_date.
GeologyEDD Format – Implements water_level_elev Calculation Used by EQEDD_v2 Format [d42026]
The WaterLevel section of the GeologyEDD format will automatically calculate water_level_elev based on water_level_depth and historical_reference_elev, but will not overwrite a provided value.
GeotrackerEDF Format – Updated Drop-down Options [d42492]
Updated drop-down selections to match options listed on the official GeoTracker site.
HZST Format – HZST Export Report Allows Selection of Coordinate Type [d42147]
Updated the Hazardous Site (HZST) Format Export, HZST EDD section, to allow users to select the coordinate type (DT_COORDINATE.COORD_TYPE_CODE) to populate X and Y coordinate data. The HZST EDD export can be published like other reports in EQuIS.
Person_and_Company Format – Fixed Persistent Error After Clearing Company_Code [d42573]
Fixed an issue in the Person_and_Company Format where a persistent error was occurring after clearing an invalid company_code.
Refvals and Facility Formats – Fixed Failure When Loading Data to RT_GROUP_MEMBER [d41072]
Added custom errors to the RT_GROUP_MEMBER section of the Refvals format and the Facility format to notify users when:
- a record with the RT_GROUP_MEMBER.MEMBER_TYPE is "group_code" and the RT_GROUP_MEMBER.MEMBER_CODE does not exist in the RT_GROUP section of the EDD or in the RT_GROUP table in the database.
- a record's RT_GROUP_MEMBER.MEMBER_TYPE does not match the parent RT_GROUP.GROUP_CODE's RT_GROUP.MEMBER_TYPE and the RT_GROUP.MEMBER_TYPE does not equal "*" (asterisk).
refvals Format – Fixed Error When Adding Data Submitter to DT_PERSON [d41160]
Fixed a duplicate key error that caused a data submitter to not be added to DT_PERSON.USER_ID if the USER_ID already existed in the DT_PERSON table.
v54_analytical_results Format – No Longer a Standard Format [d42579]
The v54_analytical_results format has been removed as a Standard EQuIS Format
from the Professional and Enterprise installers. Please use the
Analytical_Results_II format instead.