Analytical Result II Format – INTERPRETED_QUALIFIER Checked Against RT_QUALIFIER Values [d28850]
Updated INTERPRETED_QUALIFIER field to check against existing qualifiers in the RT_QUALIFIER table. Previously, the Analytical Result II format would add qualifiers to, rather than check against, the RT_QUALIFIER table.
EDP – Browser Mode Does Not Allow EDD or Package Downloads [d28363]
Updated EDP in Browser mode so that EDDs and packages will download when they are saved.
EDP – Clean Up Electronic Data Deliverable Files from Temp Folder [d28888]
Temporary EQuIS Data Processor (EDP) files are deleted once they are no longer needed (e.g., after commit, when loading a format, and on close of EDP).
EDP – Improve RecallLastUsedFormat Setting for Error Handling with EDP Security Requirements [d27171]
Fixed a bug where EDP would fail to open if RecallLastFormat was set to "True" or "Standalone" and the last format used did not meet EDP's security requirements introduced in the 7.22.1 Build.
EDP – Value in Geography Table Changes to "null" on Create Instead of Mapping to DT_GEOGRAPHY.GEOGRAPHY [d28116]
Fixed a bug in Professional EDP that would map NULL values to DT_GEOGRAPHY.GEOGRAPHY instead of valid data.
EDP – Window Resize Area Too Small [d27746]
Updated the bottom right grip area to resize the EDP window more easily.
EQEDD and EQEDD_v2 Format – Error When Same CHAIN_OF_CUSTODY Data Exists in FieldSample and COC [d29406]
Fixed a bug when creating a package from an EDD that contained the same CHAIN_OF_CUSTODY information in the COC table and the FieldSample table. If the CHAIN_OF_CUSTODY is the same, the package now creates the row from the COC table information.
EQEDD_v2 Format – Add a Lookup to RT_SAMPLE_METHOD [d28398]
FieldSample_v2.sample_method and LabSample_v2.sample_method are now lookups to RT_SAMPLE_METHOD.METHOD_CODE.
EQEDD_v2 Format – Default Value of 'Step' in STEP_OR_LINEAR Should Only Occur if DATUM_VALUE Is Populated [d28351]
Updated
the LOCATION_V2.STEP_OR_LINEAR field so that it will be populated with the default
value only if it is blank and LOCATION_V2.DATUM_VALUE has been populated.
EQEDD_v2 Format – Incorrect Error Highlighting in TestBatch_v2 [d28540]
Fixed a bug in the TestBatch_v2 section of the EQEDD_v2 format where rows were falsely highlighted as having an error.
EQEDD_v2 Format – Missing Required Parent Checks (RT_ANALYTE_DETAIL) [d28402]
Changed the lookup for LNAPL_CAS_RN and DNAPL_CAS_RN from RT_ANALYTE to RT_ANALYTE_DETAIL.
EQEDD_v2 Format – Update WATERLEVEL_V2.WATER_LEVEL_ELEV Checks Information in Description [d28396]
Updated the WATERLEVEL_V2.WATER_LEVEL_ELEV field with information that clarifies this field is populated by subtracting the WATER_LEVEL_DEPTH value from the HISTORICAL_REFERENCE_ELEV value.
EZEDD_Location Format – Displaying Error When SYS_LOC_CODE Value Missing from Database [d27337]
Added an error check to the EZEDD_Location Format when a SYS_LOC_CODE value is not present in the DT_LOCATION database table.
Facility Format – Error Inserting Data into DT_FACILITY [d30407]
Updated the Facility format to appropriately commit data to DT_FACILITY when certain triggers have been applied to a database.
Facility Format – Fixed Error When Character Limit Exceeded Incorrect Value [d27578]
Fixed an error in EDP when the character count for DT_LOCATION.LOC_PURPOSE exceeded 20 characters. The character limit has been increased to 50 characters, matching the character limit of the Schema. An error will still be displayed if more than 50 characters are used in the DT_LOCATION.LOC_PURPOSE field.
GeoTracker EDF format – Updates to EDF Sections [d29245]
Updated the EDFSAMP,
EDFTEST, EDFRES, EDFCL, and EDFFlat sections of the GeotrackerEDF format to improve data
loading into EQuIS.
GeotrackerEDF Format – Auto-populate SAMPID on Load for Lab Samples if Null [d28231]
Updated the GeotrackerEDF format to populate field SAMPID if empty for lab samples after an EDD is loaded in the EDFFlat section. Removed the CLFlat section and moved the EDFCL section to the Flat File group.
GeotrackerEDF Format – EDFFlat Section Not Mapping Based on QCCODE [d28070]
Updated
the EDFFlat section of the GeotrackerEDF format so that QC information is saved
correctly.
GeoTrackerEDF Format – Export EDFFlat SRM mapping incorrect [d30405]
Fixed a bug where the SRM field in the EDFFlat section was being exported incorrectly.
GeoTrackerEDF Format – GEO_FIELD Section Updates and Fixes [d29549]
Updated the GEO_FIELD section of the GeotrackerEDF format to load data more easily into EQuIS.
GeotrackerEDF Format – Surrogates Should Also Map to DT_RESULT.NUMERIC and _TEXT [d28364]
Updated the GeotrackerEDF format to map to DT_RESULT.RESULT_TEXT and RESULT_NUMERIC for surrogate results.
GeoTrackerEDF Format – Update ANMCODE from RT_LOOKUP.LOOKUP_CODE to RT_ANALYTIC_METHOD.ANALYTIC_METHOD [d29382]
ANMCODE lookups in the EDFTEST, EDFRES, and EDFFlat sections were changed to RT_ANALYTIC_METHOD.ANALYTIC_METHOD.
GeotrackerEDF Format – Update Required Fields and Primary Keys in the EDFFlat and CLFlat Sections [d28033]
Updated
the GeotrackerEDF format to include a primary key for the EDFFlat and CLFlat
sections. Also, the following fields have been changed to be required in
EDFFlat: LOGDATE, LOGTIME, LOGCODE, SAMPID, PROJNAME, GLOBAL_ID, EXTDATE, and
RECDATE.
GeoTrackerEDF Format – WellConstruction Section Added Default Depth Unit Default Mapping [d29385]
Added a default mapping of "FT" to DT_WELL_SEGMENT.DEPTH_UNIT in the WELL_CONSTRUCTION section.
Professional EDP – Disable Save Package Button after Commit [d27838]
Updated Professional EDP to disable the Save Package button after a package has been committed unless the package contains uncommitted rows.
Professional EDP – Pro.RegisterFile Does Not Fully Work with Standard ALS Read/Write Role [d28721]
Fixed a bug that prevented EDDs from being saved in the ST_FILE_REGISTRATION table when uploaded by Application Level Security (ALS) users through Professional EDP.
Professional EDP – RECEIVED_DATE in ST_FILE_REGISTRATION and ST_TASK Not in UTC [d27783]
Fixed an issue for EDDs loaded via Professional EDP where the user's local time was added to the ST_FILE_REGISTRATION and ST_TASK tables instead of UTC.
Refvals Format – Change to Not Default STATUS_FLAG to A [d27454]
Added a STATUS_FLAG column to each section of the Refvals format and export. Added a STATUS_FLAG parameter to the export.
Refvals Format – Make Format Self-referential [d28455]
The
refvals Format is now self-referential and will no longer flag a value as
"Reference value not found" if the value can be found in the
corresponding section of the EDD.
Scribe Format – Strongly Name and Ensure Mapping to DT_LITHOLOGY.END_DEPTH [d27258]
Updated the Scribe Format to comply with EDP 7.22.1 and higher security requirements. In the Scribe format, added mapping from "SamplesSoil.Samp_Depth_to" to DT_LITHOLOGY.END_DEPTH.