A pr>A Unrtwt$W» Pro#GCt»on earth sfljtft EPA Region 2 EQuIS 6.6 EDD format version 4 Edits-Release notes -A list of changes that are made to the new EPA Region 2 EQuIS 6.6 EDD format version 4. For all information about the Electronic Data Deliverable (EDD), please check the EPA Region 2 Superfund EDD web page hllps: www.epa.goY superfund region-2-superl'und- electronic-data-subm is si on EPA Region 2 EQuIS 6.6 EDD format version 4 edits Contents 1. Global changes throughout the format 2 2. Location_v4 2 3. DrillActivity_v4 3 4. Well_v4 3 5. Wellconstruction_v4 3 6. SoilGas_v4 3 7. Sample_v4 4 8. TestResultQC_v4 5 l ------- A pr>A Unrtwt$W» Pro#GCt»on earth sfljtft 1. Global changes throughout the format Section Changes Benefit/ Reason to change All section names Changed all format section names from "_v3" to "_v4". For example, the section "Location_v3" is now changed to "Location_v4". New version name All fields that have the DATETIME datatype All the fields in the format that have the DATETIME datatype are changed to SMALLDATETIME datatype, so the seconds (-SS) is removed. SQL system checks for "Smalldatetime" for the fields that have the date/time datatype. Sign and Submit Tool In the Sign & Submit Tool, 'Programcode' is changed to "EPA ID". Easy to be used by data providers. Any section that has the "sys_loc_code" field All the sys loc code in the format will throw an error when special characters are used, such as: &#%!= + *<>"' | / \ ? [ ]$. The "$" is added to the list to prevent users to put "$" as the sys loc code. Any section that has the "data_provider" field All the data_provider in the format will throw an error "A valid Data Provider must be entered" when data_provider = 'UNK', 'UNKNOWN', 'UNKNOWNX', '12543', '12013'. A data provider should not be unknown. 2. Location v4 Field New Change Benefit/ Reason to change Totaldepth This field is required when loc type = 'MW', "EXWELL', 'RW', 'SVE', 'BORING/WELL', 'IW', 'OB', 'SVM', 'DIRPUSH', 'PZ' Make sure the total depth is reported when the location type of the location is one of the following: MW= Monitoring Well, EXWELL = Extraction Well, "SVE" = Soil Vapor Extraction Well, "BORING/WELL" = Soil Boring/Monitoring Well, "IW" = Injection Well, "OB" = Observation Well, RW = Recovery Well., "SVM" = Soil Vapor Monitoring Well, "DIRPUSH" = Direct Push", and "PZ" = Piezometer. 2 ------- A pr>A Unrtwt$W» Pro#GCt»on earth sfljtft 3. DrillActivity_v4 Field New Change Benefit/ Reason to change Diameterunit The unit 'm' is removed from the Diameter unit field, leaving 'in', 'ft', 'cm', 'mm' in the enumeration list. Unit is necessary if a value is provided. It also reduces errors and makes it easier for data providers. 4. Well_v4 Field New Change Benefit/ Reason to change Well_status We added the value "INACTIVE" to the enumeration list Make field required and modify to an enumerated list for well_status consisting of "DECOMMISSIONED", "DESTROYED", and "ACTIVE". Definitions for each "status" to be added to the EDD Manual with instructions on how to address wells which have been damaged and are planned for repair. Provides data providers standard values and terms to use in this field. 5. Wellconstruction_v4 Field New Change Benefit/ Reason to change Depthunit The description of depth unit removed "unit must be in feet" and change the enumeration list to "ft" and "m" Not restrict the unit must be in feet since we allow to select "ft" and "m". Diameterunit, Thicknessunit, Slotsizeunit Removed the unit'm' from the enumeration list. Reduces errors and make it easier for the data providers. 6. SoilGas_v4 Field New Change Benefit/ Reason to change Depthunit Changed from enumeration list to a list consists of "in", "ft", "cm", "m". Reduces errors and make it easier for the data providers. 3 ------- A pr>A Unrtwt$W» Pro#GCt»on earth sfljtft 7. Sample_v4 (Some changes are applied to VI_Samples_v4 section as well) Field New Change Benefit/ Reason to change S ampl ingtechni que This field is required if Sample source = Field (Not used in the VI_Samples_v4 section) Add the sampling technique to the sample method as sample method codes. Samplematrixcode If Sample matrix code = AO or AI, then throw an error "SVI data should be entered in the VI_Sample_v4 section" (Not used in the VI_Samples_v4 section) Restrict the AO or AI to be entered in the VI section. S ampl etypecode If Sample_type_code = N, then sample matrix code cannot have the rt matrix.matrix class equal to NULL or LAB Normal sample should not have the matrix class of Null or lab Samplesource If sample source = FIELD, then sampletypecode should have the rt sample type.type class should equal FQ or NF). Prevents sample source form improperly assigning FIELD to a lab sample and LAB to a field sample. Samplesource If sample source = LAB, then the Sampletype code should have the rt sample type.type class should equal LQ. Prevents sample source form improperly assigning FIELD to a lab sample and LAB to a field sample. sampledate sample date field changed from DATETIME to SMALLDATETIME in format and field description. (Not used in the VI_Samples_v4 section) SQL system checks for "Smalldatetime" for the fields that have the date/time datatype. SAMPLETYPECODE If SAMPLE TYPE CODE = TB, EB, RB then sys loc code cannot be populated. Field blanks, trip blanks, Rinse Blanks do not require location codes. Senttolabdate The field Sent to lab date changed from DATETIME to SMALLDATETIME in format and field description. SQL system checks for "Smalldatetime" for the fields that have the date/time datatype. 4 ------- A pr>A Unrtwt$W» Pro#GCt»on earth sfljtft 8. TestResultQC_v4 (Some changes are applied to VI_TestResultsQC_v4 section as well) Field New Change Benefit/ Reason to change Labmatrixcode If lab matrix code = AO or AI, then throw an error "SVI data should be entered in the VI_TestResultsQC_v4 section." (this rule only applies to the TestResultQC_v4) Create an error if one of the SVI matricies is selected in this field. SVI matricies should be reported in the VI TestResults QC section. Validated_yn If validated_yn = N and validatorqualifier (s) are populated, throw an error on validatedyn with the error message: "Review validated data. For data that has been validated, validated yn should equal Y. For data that has not been validated, the validator qualifier should not be populated." Create error flag if validated_yn is "N" and validatorqualifiers is populated. Validator qualifier shouldn't contain a qualifier if the data are not validated. This error keeps the validated yn and validator qualifiers column in sync. Detectflag, interpretedqualifier If detect flag = Y, interpreted qualifier = TJ', then one of the radiological fields must be populated (minimumdetectableconc, countingerror, uncertainty, critical value). Else throw an error on interpreted qualifier that "Detectable results should not contain a "U" interpreted qualifier, unless reporting Radiation data. For Radiation data, one of the following fields must be populated minimum detectable conc, counting error, uncertainty, critical_value.") Radiation data needs to be able to be reported as a numeric result with a detect = Y and a U or UJ qualifier. 5 ------- |