EDP Format Export – Format Export Reports No Longer Cause Memory Leaks [d53005]
Fixed an issue where memory use increased each time a Format Export Report was executed.
EFWEDD Format – Added Additional Export Parameters [d53259]
Added additional export parameters and remapping to the EFWEDD format.
ERPIMS Format – Added Mappings to SCC Section [d51306]
Updated the ERPIMS format to include import mappings for the SCC section.
EZEDD_Location Format – Improved Error Handling in the EZEDD_Location Format [d53085]
Fixed an issue where an error was thrown for SYS_LOC_CODE even if a value was not present.
NEDDCommon Format – Added Custom Check to LOCATION.PROXIMITY [d53081]
Added custom check to LOCATION.PROXIMITY indicating that if SITE_NAME starts with "offsite", PROXIMITY must be "O".
NEDDCommon Format – Error Displays if LOCATION.ESTABLISHING_CONTRACT_ID Does Not Exist [d52947]
Improved the NEDDCommon Format by displaying an error if LOCATION.ESTABLISHING_CONTRACT_ID does not exist in the database or in the PROGRAM_CONTRACT section.
NEDDCommon Format – Error Displays if NEDDCommon Well_LocationName Does Not Exist [d52998]
Improved the NEDDCommon Format by displaying an error if WELL.LOCATION_NAME does not exist in the database or in the LOCATION section.
NEDDCommon Format – Error Displays if Sample.Location_Name Does Not Exist [d53059]
Improved the NEDDCommon Format by displaying an error if SAMPLE.LOCATION_NAME does not exist in the database or in the LOCATION section.
NEDDCommon Format – Improved refvals [d52992]
Improved NEDDCommon format reference values (refvals) file and example EDDs functionality.
NEDDCommon Format – Updated RT_COMPANY Mapping in the PROGRAM_CONTRACT.CONTRACTOR_NAME Section [d52979]
Fixed an issue where the PROGRAM_CONTRACT.CONTRACTOR_NAME field was not correctly mapping to RT_COMPANY.
Oil_Gas_Baseline_EQEDD Format – Added Lookup for Location_v1.verification_code [d53240]
Improved handling of LOCATION_V1.VERIFICATION_CODE, adding the ability to pull and map data from RT_COORD_VERIFICATION.VERIFICATION_CODE.
Oil_Gas_Baseline_EQEDD Format – Added Lookup to LabSample_v1.sampling_company_code [d53092]
Added a drop down in the LabSample_v1 table for sampling_company_code.
Oil_Gas_Baseline_EQEDD Format – Increased Purge_v1.purge_purpose and WaterLevel_Purge.purge_purpose Lengths to Match Database [d53227]
Increased PURGE_V1.PURGE_PURPOSE and WATERLEVEL_PURGE.PURGE_PURPOSE length from 2 characters to 20 characters to match database length.
Oil_Gas_Baseline_EQEDD Format – Modify EDD Description Comment for WaterLevel_Purge.measurement_time [d53400]
Updated the WaterLevel_Purge.measurement_time field description to be clearer in the Oil_Gas_Baseline_EQEDD format.
Oil_Gas_Baseline_EQEDD Format – Modify Lookup for lnapl_cas_rn Field in WaterLevel_v1 Section to Use RT_ANALYTE_DETAIL.CAS_RN [d53422]
Fixed an issue in the Oil_Gas_Baseline_EQEDD format where an error would occur during the commit stage in EDP if WaterLevel_v1.lnapl_cas_rn is not in the RT_ANALYTE_DETAIL table.
Oil_Gas_Baseline_EQEDD Format – Remove Empty Enumerations from Various Sections [d53427]
Updated the Oil_Gas_Baseline_EQEDD format to not have empty enumerations in the following format section fields:
- WaterLevel_Purge.purge_method
- WaterLevel_Purge.toc_or_surf
- WaterLevel_Purge.dip_or_elevation
- WaterLevel_v1.dip_or_elevation
Oil_Gas_Baseline_EQEDD Format – Remove unit_type Filters for Unit Fields in WaterLevel_Purge Section [d53436]
Updated the Oil_Gas_Baseline_EQEDD format to not apply filters to the unit fields in the WaterLevel_Purge section.
Oil_Gas_Baseline_EQEDD Format – Removed Enumeration and Added Lookup for Location_v1.horz_datum_code [d53238]
Improved handing of LOCATION_V1.HORZ_DATUM_CODE so that it references RT_COORD_HORZ_DATUM when pulling data.
Oil_Gas_Baseline_EQEDD Format – Updated Licensing [d53256]
Updated the licensing so that it can be used with an Enterprise license or any Professional license above and including PlusData.
Vapor Intrusion Format – Added New Fields to the VI_Building_Parameter Section [d52851]
Added two new fields to the VI_Building_Parameter section of the Vapor Intrusion format that maps as follows:
- dt_subfacility_parameter.person
- dt_subfacility_parameter.measurement_method
Vapor Intrusion Format – Changed VI_Locations.horz_accuracy_unit from Lookup to Enumeration [d53052]
The HORZ_ACCURACY_UNIT in the Vapor Intrusion Format's VI_Location section will no longer pull all available RT_UNIT.UNIT_CODEs rather they will pull values from the EQuIS_Vapor_Intrusion-enum.xml file for the HORZ_ACCURACY_UNIT.
Vapor Intrusion Format Package – Added Enumeration/Default Mapping Refvals EDD [d52942]
Added the "Enumeration and Default mapping refvals.xlsx" EDD file to the Vapor Intrusion Format package.
VI Analytical Results II with Building Parameters Report – Error Selecting DT_SUBFACILITY Additional Fields [d52990]
Fixed an issue where the Vapor Intrusion Analytical Results II with Building Parameters report would fail to run when adding DT_SUBFACILITY values in the Extra Fields parameter.
WQX Schema – Add New Fields to DT_BIOLOGICAL_SAMPLE and DT_BIOLOGICAL_RESULT [d42021]
Added new fields to the WQX Schema for the DT_BIOLOGICAL_SAMPLE and DT_BIOLOGICAL_RESULT tables to work with the USEPA's WQX Biological Template. The WQX Biological Template is the USEPA's format to import data into the WQX online data warehouse and is the structure of WQX Biological Report that can be exported from Professional.
WQX Schema – Increased Character Limit for WQX.PROJECT_ Function @task_code Parameter for Consistency [d45425]
Updated the character limit of the @task_code parameter from varchar(20) to varchar(40) to be consistent with other WQX functions and database TASK_CODE fields.
WQX Schema – Length and Type Updates for WQX 3.0 [d43280]
The following fields in the WQX Schema has been updated to support future WQX format changes:
- individual_id – from varchar(10) to varchar(60)
pollution_tolerance – from varchar(4) to varchar(30)
trophic_level – from varchar(4) to varchar(30)
feeding_group_1 to _3 – from varchar(10) to varchar(30)
- component_name – from varchar(15) to varchar(120)
- component_sequence – from integer to varchar(60)
WQX Schema – Resolve Database Creation Error [d51209]
Resolved an issue where an error occurred while creating a new database with the WQX Schema.
WQX Schema – Updated WQX.Result View [d44862]
Updated WQX.Result view to only display units for results that contain non-null data.
WQX-refvals Format – Added rt_timezone Section [d47974]
Added rt_timezone as a new section in the WQX-refvals Format.