EDD Format Dictionary – Automate Updates [d48072]
The EDD Format Dictionary Dashboard on the EarthSoft Community Center is no longer beta and is now included in the automated release process.
EDP – Display Format Build Instead of Format Version [d48021]
Updated EDP so that it will display the Format Build instead of the Format Version when available. The Format Build will also be displayed in the EDD Description file.
EDP – Fixed Save On Create Data Issue [d48308]
Fixed a bug in EDP when the Save On Create feature was set to "Ask" that caused the saved EDD to be missing data.
EDP – Records Not Inheriting Object Type Permissions [d48927]
Fixed a bug in EDP where object type permissions were not inherited when objects were inserted using Professional EDP if the initial commit failed and was successfully retried.
EDP Format Export – Fixed User Reports Not Updating to Republished Format [d48287]
Fixed a bug that caused the file ID for a published user report to not be updated in the ST_USER_REPORT_PARAMETER table after a format export was republished as a report.
EQEDD and EQEDD_v2 Formats – Always Export DT_COORDINATE.X_COORD, Y_COORD, and COORD_TYPE_CODE Data [d47829]
Updated EQEDD export by removing the restrictions placed on Location_v1 section regarding DT_COORDINATE.X_COORD, Y_COORD, and COORD_TYPE_CODE needing to match the DT_FACILITY.COORD_TYPE_CODE and IDENTIFIER.
Updated EQEDD_v2 export by removing the restrictions placed on Location_v2 section regarding DT_COORDINATE.X_COORD, Y_COORD, and COORD_TYPE_CODE needing to match the DT_FACILITY.COORD_TYPE_CODE and IDENTIFIER.
EQEDD and EQEDD_v2 Formats – Change Logic for Conditionally Requiring Location_v#.depth_unit [d47848]
Updated the EQEDD and EQEDD_v2 formats so that Location_v#.depth_unit is required whenever Location_v#.total_depth, Location_v#.depth_to_bedrock, Location_v#.depth_to_top_of_screen, Location_v#.depth_to_bottom_of_screen, and Location_v#.top_casing_elev are populated. Also added a new custom error to make Location_v#.total_depth required when Location_v#.depth_unit is populated.
EQEDD and EQEDD_v2 Formats – Create DT_WELL Record Whenever Creating a DT_WELL_SEGMENT Record [d47813]
Updated EQEDD format so when the Location_v1 section creates a DT_WELL_SEGMENT record, it will also create a corresponding DT_WELL record.
Updated EQEDD_v2 format so when the Location_v2 section creates a DT_WELL_SEGMENT record, it will also create a corresponding DT_WELL record.
EQEDD and EQEDD_v2 Formats – Updated Mapping for Location_v#.depth_unit [d48868]
Updated the mapping of Location_v#.depth_unit to pass the depth unit value to DT_WELL.DEPTH_UNIT and/or DT_WELL_SEGMENT.DEPTH_UNIT when the location creates DT_WELL and/or DT_WELL_SEGMENT records. The value of "ft" will no longer be the default value.
EQEDD_v2 Format – Modify to Support Photo Files in Collect [d45962]
Updated the EQEDD_v2 format to include an object_euid column in the Files_v2 section and euid columns in most sections. This allows files to be linked to specific rows in these sections.
ERPIMS Format – Update Group 3 Prime and Lab Export [d47678]
Fixed an issue in the Group 3 Prime and Lab export for the ERPIMS format where a dataset would not export by task code when the task code was longer than 20 characters.
ERPIMS Format – Add SAMPLE_SOURCE Field and Change FLDSAMPID Field [d47775]
Updated the SAMPID field in the Test_Prime, Result_Prime, Test_Lab and Result_Lab sections of the ERPIMS Format. Added a SAMPLE_SOURCE field to specify whether the SYS_SAMPLE_CODE is coming from a field or a lab sample.
ERPIMS Format – Add SAMPLE_SOURCE Method Mappings [d48136]
Added conditionally mapping to DT_SAMPLE.SAMPLE_SOURCE based on the SACODE field for the Sample_Prime and Sample_Lab sections of the ERPIMS Format.
ERPIMS Format – Added LABSAMPID Field to Sample_Prime Section [d47583]
Added LABSAMPID field to the Sample_Prime section of the ERPIMS Format.
ERPIMS Format – Added Remap Parameter and Functionality to Group 3 Prime Export [d47807]
Added remap parameters to the ERPIMS Group 3 Prime export in
the ERPIMS format so users can apply a remap set to the values being
exported.
ERPIMS Format – Changed Sample_Prime PK, Requirements, and sys_sample_code Mappings [d47603]
Updated the mappings in the Sample_Prime section.
When Sample_Prime.SACODE's associated SAMPLE_TYPE's SAMPLE_TYPE_CLASS is LQ, LABSAMPID is mapped to DT_SAMPLE.SYS_SAMPLE_CODE. If Sample_Prime.SACODE's associated SAMPLE_TYPE's SAMPLE_TYPE_CLASS is NF, FQ, or NULL, FIELDSAMPID is mapped to DT_SAMPLE.SYS_SAMPLE_CODE. Both will also create a record in DT_FIELD_SAMPLE linked by the SAMPLE_ID from the corresponding record in DT_SAMPLE.
ERPIMS Format – Error on PARENTFLDID Field when Loading from Flat Text File [d47758]
Resolved an issue where the ERPIMS Format produced an error when loading from a flat text file.
ERPIMS Format – FIELDSAMPID Conditionally Required [d47615]
Updated ERPIMS Format to have Sample_Lab.FLDSAMPLE be a conditionally required field.
ERPIMS Format – Map SYS_SAMPLE_CODE Based on SAMPLE_TYPE_CLASS [d47608]
Updated the ERPIMS format to use the value in the Sample_Lab.SACODE field to find
the associated RT_SAMPLE_TYPE record and get the SAMPLE_TYPE_CLASS
value. Based on the value retrieved, either FIELDSAMPID or LABSAMPLEID
is mapped to DT_SAMPLE.SYS_SAMPLE_CODE.
ERPIMS Format – Updated Exports to Populate Correct SYS_SAMPLE_CODE, SAMPID, and SAMPLE_SOURCE Values [d47638]
Updated ERPIMS Group 3 Lab export (Sample_Lab, Test_Lab, Result_Lab sections) to conditionally map exports to LABSAMPLEID, FIELDSAMPID, SAMPLE_SOURCE fields based on DT_SAMPLE.SAMPLE_SOURCE values.
Updated ERPIMS Group 3 Prime export (Sample_Prime, Test_Prime, Result_Prime sections) to conditionally map exports to LABSAMPID, SAMPID, SAMPLE_SOURCE fields based on DT_SAMPLE.SAMPLE_SOURCE values.
ERPIMS Group 3 Prime Report – Update SYS_SAMPLE_CODE Mapping [d47628]
Updated the ERPIMS Group 3 Prime report to have DT_SAMPLE.SYS_SAMPLE_CODE be mapped differently, depending on the value of DT_SAMPLE.SAMPLE_SOURCE.
EZEDD Format – Create Export [d47655]
Added an export option to the EZEDD format that exports sample, test, and results data. The export option is called EZEDD EDD (listed in the EDD Export drop-down in the Professional ribbon of Professional EDP or as the report name in the published EDD Export).
EZEDD_Location Format – Create Export [d50873]
Added an export option to the EZEDD_Location format that exports sample, test, and results data. The export option is called EZEDD Location EDD (listed in the EDD Export drop-down in the Professional ribbon of Professional EDP or as the report name in the published EDD Export).
Format Exports – Populate Formats' File Version in Database when Published [d48118]
Whenever an Export Format is published from the Report Publisher, a new record will be added to the ST_MODULE table containing the format version.
NEDDCommon Format – Added New Format Package [d41730]
The NEDDCommon format is now part of a format package (NEDDCommon_FormatPackage.zip). The format package is available in the All Items > Formats folder on the Downloads dashboard on the EarthSoft Community Center and includes the following files:
- NEDDCommon.zip – The NEDDCommon format.
- NEDDCommon refvals.xlsx – An example reference value EDD to be used with the standard EQuIS refvals format.
- NEDDCommon remap.xlsx – An example reference value EDD that will create a NEDD remap set in the database.
- Project Example EDD.xlsx – An example EDD with contact, contract, and environmental project data to use with the NEDDCommon format.
- Well Example EDD.xlsx – An example EDD with location, borehole, and well data to use with the NEDDCommon format.
- Sample Example EDD.xlsx – An example EDD with sample and analytical result data to use with the NEDDCommon format.
- ReadMe.txt – Readme text file to explain the purpose of each file.
NEDDCommon Format – Updated Fields, Data Types, Mappings and EDD Descriptions [d41818]
Updated fields, data types, data mappings, and data exports for the EQuIS NEDDCommon format to match the NIRIS data submission requirements. The format EDD description file has been updated with these changes. Also strongly named and digitally signed the format.
Oil_Gas_Baseline_EQEDD Format – Add Fields to GeoSample_v1 Section [d47300]
Added sample_matrix_code, sampler, sampling_company_code, and composite_yn fields to the GeoSample_v1 section for the Oil_Gas_Baseline_EQEDD format.
Oil_Gas_Baseline_EQEDD Format – Updated EDD Description [d47306]
Updated the content field description in the Files_v1 section for the Oil_Gas_Baseline_EQEDD format.
Professional EDP – Browser Mode – Error Occurs When Loading Format (.zip) File a Second Time [d48068]
Fixed a bug where an error occurred when loading a format (.zip) file a second time in Professional EDP browser mode.
Vapor Intrusion Format – New VI Format Package [d50559]
The EQuIS Vapor Intrusion files are now part of a Vapor Intrusion format package file (EQuIS_Vapor_Intrusion_FormatPackage.zip) available from the All Items > Formats folder on the Downloads Dashboard on the EarthSoft Community Center. The Vapor Intrusion files will no longer be stored in the Products\Vapor Intrusion folder.