cone penetrometer test data, direct push electrical conductivity logs, membrane interface probe readings and borehole geophysical logs such as natural gamma, fluid conductivity and fluid temperature. Logs that consist of multiple readings per depth, such as acoustic and optical televiewer logs, should not be stored in the Downhole Point EDD. Associate the files to the EDD use the Files tab of the EDD. When attaching documents, please use the following naming convention: site acronym, abbreviated document description, and date of document (YYYYMMDD). Examples include: ABCsite_SAP_20170601; and Lithology_v1 Contains lithologic data collected from soil samples, rock core, or drill cuttings generated during drilling of borings or collection of rock cores. For soil classification, please use the Unified Soil Classification System (USCS). Rock should be described using standard geologic terms for the rock type encountered in the borehole. Data Providers Personnel Once per location The sys_loc_code and start_depth fields are needed for the EDD to load in this section. Well_ v1 Contains basic information for each well and is required if the location EDD contains wells. Important information captured in this EDD include the well owner, measuring point elevation, depth of the well, whether or not the well includes a pump, pump information, stickup height, driller, and installation date. Data Providers Field Personnel Once per location This EDD will include all wells installed at the site and should be submitted when well installation is complete and when the datum value of the well is changed. For example, if a well is converted from stickup to flush-mount and the inside casing is cut down, then the datum value (top of casing elevation in this case) has been changed and the Well EDD would be submitted to document this change. Following is a description of the fields in this section: WellConstruction_v1 Contains well construction information, such as casing length, screened interval, backfill information, and other Data Providers Personnel Once per location or when the surface For each well on the Well_v1 EDD section multiple records describing the components of a well, such as the collar, casing,
construction details. Note: If attaching the well log, please use the Initial EDD subsection, File_v1 to document that the well log was included with the submission. Include the well log file as part of the final EDD package. completion or top of casing elevation or datum value is changed screen and materials used can be placed in the WellConstruction_v1 EDD section at respective depths for each well. The following fields are needed for documenting well construction details in the WellConstruction_v1 EDD section so that the EDD will load: sys_loc_code – Sample location id for a well that must be unique within a facility segment_type – A code from the rt_well_segment_type valid value table describing the individual section of the well, such as “FILTER PACK”. material_type_code – A code from rt_well_segment_type valid value table describing the material used in an individual section of a well, such as “SAND PACK”. start_depth – The depth, in feet below ground surface (bgs) for the top of the well segment. end_depth – The depth, in feet bgs for the bottom of the well segment. depth_unit – The unit of depth measurement for start and end depth in feet. inner_diameter – A representing the inner diameter of the segment_type. outer_diameter – A value representing the outer diameter of the segment_type. diameter_unit – The unit of measure for the and outer diameter measurements. slot_type – The type of well screen slots in the well screen such as bridge, shutter, and continuous. slot_size – The width of the slots in the well screen.
WaterTable_v1 Contains information to document the first encounter with the water table and subsequent stabilization during drilling of a boring. Data Providers Field Personnel Once per location The fields listed below need to be populated for the EDD to load: sys_loc_code – Sample location ID for a well that must be unique within a facility type – The type of aquifer encountered such as “upper,” “lower,” “unconfined” etc. sequence – Enter either “Stabilized” or “Unstabilized” depending on the water level conditions at the time of measurement. depth – The depth, in feet, of the water table below the reference point flowing_yn – Enter “Y” for yes, water is flowing (artesian), or “N” for no, water is not flowing. measurement_method – The method of measuring the water table depth (e.g. water level indicator) reference point - Description of the reference point from which the water table depth was taken. (e.g. “ground surface elevation”) reference elevation – The elevation of the reference point from which depth measurements were taken. Note: feet msl is the preferred elevation unit for elevation data provided to DEQ. Depth measurements should be taken to the nearest 100th (e.g., 15.10 feet). ExtractionInjection Wells_v1 Contains data specific to extraction and injection wells, such as pumping rates, period of pumping, and volume pumped. These data relate to any extraction wells operating as part of an interim or remedial action, and the information is used to track the operations and maintenance (O&M) of treatment systems. Data Providers Personnel Whenever well extraction or injection data are collected and provided to MTDEQ. The fields listed below need to be populated for the EDD to load: sys_loc_code – Sample location ID for a well that must be unique within a facility. start_measure_date – Date and time that the extraction/injection measurements began. end_measure_date – Date and time that the
VI_TaskParameters_v1 VI_Samples_v1 3.3: General Information on the Vapor Intrusion Group EDD Sections Table Name Description Completed By Submission Frequency Data Requirements VI_BuildingInspection_v1 Contains data that inventories buildings and structures, and cataloging factors that impact air quality within structures. Data Providers Intrusion Team Once per building inspection The fields listed need to be populated for the EDD to load: building_code– For each building, this building code must be unique building_name– This can be a more descriptive name for the building. inspection_date – The date the building inspection was conducted. task_code – This field should identify the sampling plan that was followed to collect the samples. VI_TaskParameters_v1 Contains data specific to the VI task, for example weather, start/end atmospheric pressure, etc. Data Providers Vapor Intrusion Team Anytime structure sampling data are collected and provided to MTDEQ The fields listed below need to be populated for the EDD to load: task_code – This should identify the sampling plan that was followed to collect the samples. parameter_code – The task parameter. VI_Samples_v1 Contains sample information collected from ambient air, indoor air, and subslab soil sampling forms Data Providers Vapor Intrusion Team Anytime structure sampling data are collected and provided to The fields listed below need to be populated for the EDD to load: data_provider - The unique identifier of the company or agency submitting the data. sys_sample_code - The unique identifier of the sample. Each sample at a facility must have a unique value, including spikes and duplicates. You have considerable flexibility in the methods used to derive and assign unique sample identifiers, but uniqueness throughout the database is the only restriction enforced by EQuIS®. sample_name - Additional sample identification information as necessary.
result_type_code - Must be either "TRG" for a target or regular result, "TIC" for tentatively identified compounds, "SUR" for surrogates, "IS" for internal standards, or "SC" for spiked compounds. reportable_result - Must be either "Yes" for results which are considered to be reportable, or "No" for other results. This field has many purposes. For example, it can be used to distinguish between multiple results where a sample is retested after dilution. It can also be used to indicate which of the first or second column result should be considered primary. The proper value of this field in both of these two examples should be provided by the laboratory (only one result should be flagged as reportable). detect_flag - May be either "Y" for detected analytes or "N" for non_detects or "TR" for trace. Use "Y" for estimated values (above detection limit but below the quantitation limit). validated_yn - Y" if the result has been validated, "N" if not. lab_sdg - The unique identifier of the sample delivery (SDG) or work order. A single sample may be assigned to multiple SDGs based on different analysis. Batch_v1 Contains data that relate the individual samples to laboratory sample batch identifiers and laboratory sample delivery groups. The fields in this section need to match the data entered in corresponding fields in the TestResultQC_v1 section. Data Provider’s Analytical Laboratory Whenever analytical data are collected and provided to MTDEQ The fields listed need to be populated for the EDD to load: sys_sample_code - The unique identifier of the sample. lab_anl_method_name - The laboratory analytical method name or description, for example "SW8260B", "E130.1", etc.
installed, used, or with which it is associated, if applicable. model_number Text(50) dt_equipment.model_number The model number of the equipment. catalog_number Text(50) dt_equipment.catalog_number The catalog number of the equipment. manufacturer Text(50) dt_equipment.manufacturer The manufacturer of the equipment. Text(50) dt_equipment.owner The owner of the equipment. operation_status Text(20) dt_equipment.operation_status The operational status of the equipment. install_date DateTime dt_equipment.install_date The date and time of equipment installation. last_service_date DateTime dt_equipment.last_service_date The date and time the equipment was last serviced. next_service_date DateTime dt_equipment.next_service_date The date and time the equipment is scheduled to be serviced next. purchase_date DateTime dt_equipment.purchase_date The date and time of equipment purchase. purchase_price Text(20) dt_equipment.purchase_price The cost of the equipment. material Text(50) dt_equipment.material The main material of the equipment.
drilling activity. end_depth Numeric dt_drill_activity.end_depth The end depth below ground surface of the drilling activity. drill_start_date DateTime dt_drill_activity.start_date The date and time the drilling activity began. drill_end_date DateTime dt_drill_activity.end_date The date and time the drilling activity ended. diameter Numeric dt_drill_activity.diameter The diameter of the boring. diameter_unit Text(15) rt_unit.unit_code dt_drill_activity.diameter_unit The unit of measure of the diameter. drill_method Text(50) dt_drill_activity.drill_method The drilling method used. fluid Text(50) dt_drill_activity.fluid The description of fluid used during the drilling activity. viscosity Text(50) dt_drill_activity.viscosity The viscosity of the drilling fluid. hammer_wt Text(50) dt_drill_activity.hammer_wt The weight of hammer used during the drilling activity. hammer_fall Text(50) dt_drill_activity.hammer_fall The distance of hammer fall during the drilling activity. hammer_desc Text(50) dt_drill_activity.hammer_desc The description of the hammer used during the drilling activity.
lift_mechanism Text(50) dt_drill_activity.lift_mechanism The type of mechanism used to lift the hammer. new_yn Text(1) (Enumeration: yes_no_values) dt_drill_activity.new_yn Y" if this is a new drilling activity at the location or boring, "N" if not. repair_yn Text(1) (Enumeration: yes_no_values) dt_drill_activity.repair_yn Y" if the purpose of the drilling activity is to repair an existing boring, "N" if not. deepen_yn Text(1) (Enumeration: yes_no_values) dt_drill_activity.deepen_yn Y" if the purpose of the drilling activity is to deepen an existing boring, "N" if not. abandon_yn Text(1) (Enumeration: yes_no_values) dt_drill_activity.abandon_yn Y" if the boring has been abandoned, "N" if not. replace_yn Text(1) (Enumeration: yes_no_values) dt_drill_activity.replace_yn Y" if the purpose of the drilling activity is to replace an existing boring, "N" if not. public_yn Text(1) (Enumeration: yes_no_values) dt_drill_activity.public_yn Y" if the drilled location is for public use, "N" if not. purpose Text(70) dt_drill_activity.purpose The descriptive purpose of the drilling activity. rig_desc Text(50) dt_drill_activity.rig_desc The description of the drilling rig.
installation_date DateTime dt_well.installation_date The date and time of well installation. construct_start_date DateTime dt_well.construct_start_date The date and time the well construction began. construct_complete_date DateTime dt_well.construct_complete_date The date and time the well construction finished. construct_contractor Text(40) rt_company.company_code rt_company.company_name dt_well.construct_contractor The name of the contractor that installed well. pump_type Text(20) dt_well.pump_type The type of pump used at the well, such as centrifugal, propeller, jet, helical, rotary, etc. pump_capacity Text(6) dt_well.pump_capacity The capacity of the pump. pump_unit Text(15) rt_unit.unit_code dt_well.pump_unit The unit of measure of the pump capacity and yield. pump_yield Text(6) dt_well.pump_yield The of the pump. pump_yield_method Text(20) dt_well.pump_yield_method The method used for the pump yield. weep_hole Text(1) (Enumeration: yes_no_values) dt_well.weep_hole Y" if the well has a weep hole, "N" if not. head_configuration Text(50) dt_well.head_configuration The well head configuration. access_port_yn Text(1) (Enumeration: yes_no_values) dt_well.access_port_yn Y" if the well has an access port, "N" if not. casing_joint_type Text(50) dt_well.casing_joint_type The type of casing such as threaded, flush, or solvent welded. perforator_used Text(50) dt_well.perforator_used The description of well perforation, such as slotted, drilled, or wound.
start_depth Numeric PK Y dt_well_segment.start_depth The depth of the top of the well segment below ground surface. end_depth Numeric Y dt_well_segment.end_depth The depth of the bottom of the well segment below ground surface. depth_unit Text(15) Y ft rt_unit.unit_code dt_well_segment.depth_unit The unit of measurement of the depth. inner_diameter Numeric dt_well_segment.inner_diameter The diameter of the well segment. outer_diameter Numeric dt_well_segment.outer_diameter The outer diameter of the well segment. diameter_unit Text(15) rt_unit.unit_code dt_well_segment.diameter_unit The unit of measurement of the diameter. thickness Numeric dt_well_segment.thickness The thickness of the well segment. thickness_unit Text(15) rt_unit.unit_code dt_well_segment.thickness_unit The unit of measurement of the thickness. slot_type Text(20) dt_well_segment.slot_type The type of slots in the well segment, such as bridge, shutter, and continuous. slot_size Numeric dt_well_segment.slot_size The of the slots. slot_size_unit Text(15) rt_unit.unit_code dt_well_segment.slot_size_unit The unit of measurement of the slot size. perf_length Numeric dt_well_segment.perf_length The length of the perforated portion of the screen.
past reference points. water_level_depth Numeric dt_water_level.water_level_depth The depth of the water level. water_level_elev Numeric dt_water_level.water_level_elev The elevation of the water level. corrected_depth Numeric dt_water_level.corrected_depth The depth of the water level after any necessary corrections. For example, corrections may be necessary if free product was encountered. corrected_elev Numeric dt_water_level.corrected_elevation The elevation of the water level after any necessary corrections. For example, corrections may be necessary if free product was encountered. measured_depth_of_well Numeric dt_water_level.measured_depth_of_well The depth below ground surface to the bottom of the well. depth_unit Text(15) rt_unit.unit_code dt_water_level.depth_unit The unit of measure of the depths. technician Text(50) dt_water_level.technician The name of the technician measuring the level. dry_indicator_yn Text(1) (Enumeration: yes_no_values) dt_water_level.dry_indicator_yn Y" if the well is dry, "N" if not. measurement_method Text(20) dt_water_level.measurement_method The method used to measure the water level. batch_number Text(10) dt_water_level.batch_number The batch of the water
level measurement. dip_or_elevation Text(9) Y dip (Enumeration: dip_or_elevation) dt_water_level.dip_or_elevation dip" if the water level is below the measurement datum, "elevation" if the water level is above the measurement datum (i.e. an artesian well). remark Text(2000) dt_water_level.remark Any additional information about the water level measurement. lnapl_cas_rn Text(15) rt_analyte.cas_rn dt_water_level.lnapl_cas_rn The identifier of the LNAPL analyte. lnapl_depth Numeric dt_water_level.lnapl_depth The to LNAPL. dnapl_cas_rn Text(15) rt_analyte.cas_rn dt_water_level.dnapl_cas_rn The identifier of the DNAPL analyte. dnapl_depth Numeric dt_water_level.dnapl_depth The depth to DNAPL. task_code Text(40) dt_task.task_code dt_water_level.task_code The unique identifier of the task associated with the water level measurement. approval_code Text(10) rt_valid_code.accept_code dt_water_level.approval_code The approval code for the water level measurement. custom_field_1 Text(255) dt_water_level.custom_field_1 A custom field. custom_field_2 Text(255) dt_water_level.custom_field_2 A custom field. custom_field_3 Text(255) dt_water_level.custom_field_3 A custom field. custom_field_4 Text(255) dt_water_level.custom_field_4 A custom field. custom_field_5 Text(255) dt_water_level.custom_field_5 A custom field.
sampler Text(50) dt_field_sample.sampler The name or initials of the sampler. sampling_company_code Text(40) rt_company.company_code rt_company.company_name dt_field_sample.sampling_company_code The unique identifier of the sampling company. sampling_reason Text(30) dt_field_sample.sampling_reason The reason for the sampling event. sampling_method Text(40) rt_sample_method.method_code dt_sample.sample_method The method of sample collection. task_code Text(40) dt_task.task_code dt_sample.task_code The unique identifier of the SAP/work plan under which the field sample was collected. collection_quarter Text(5) dt_field_sample.collection_quarter Enter the quarter of the year for samples collected (i.e. Q1, Q2, Q3, or Q4). composite_yn Text(1) Y (Enumeration: yes_no_values) dt_field_sample.composite_yn Y" if the sample is a composite sample, "N" if not. composite_desc Text(255) dt_field_sample.composite_desc The description of composite sample (if composite_yn is "Yes"). Example: "Composite sample from soil pile." or "Composite sample from individual samples SB-001, SB-005, and SB-009." sample_class Text(10) dt_sample.sample_class The class code for the sample type: NF - Normal Field Sample, FQ - Field Quality Control Sample, or LQ - Lab Quality Control Sample. medium Text(20) rt_medium.medium_code dt_sample.medium_code The medium of the sample. This is typically more general than matrix, for example "soil" or "water". sample_desc Text(255) dt_sample.sample_desc Additional sample description information as necessary. Is not
reported as the detection limit. detection_limit_unit is required. If detect_flag='N' and result_type_code='SC', 'TRG' or 'TIC' then reporting_detection_limit is required. quantitation_limit Text(20) dt_result.quantitation_limit The quantitation limit refers to a minimum concentration of an analyte that can be measured within specified limits of precision and accuracy. It is generally 5-10 times the detection limit. Thus, when quantitation limits are used as reporting limits, the laboratory is saying that the analyte is not present in a sufficient amount to be reliably quantified (i.e. at a concentration above the quantitation limit). It may be present and even positively identified or "seen" at a lower concentration. If method_detection_limit, reporting_detection_limit, or quantitation_limit is populated then detection_limit_unit is required. result_unit Text(15) rt_unit.unit_code dt_result.result_unit The unit of measurement of the result value. If result_value is populated then result_unit is required. detection_limit_unit Text(15) rt_unit.unit_code dt_result.detection_limit_unit The unit of measurement of the the detection limit(s). This field is required if a reporting_detection_limit is reported. If method_detection_limit, reporting_detection_limit, or quantitation_limit is populated then detection_limit_unit is required. tic_retention_time Text(8) dt_result.tic_retention_time The retention time, in seconds, for tentatively identified compounds. If result_type_code='TIC' then tic_retention_time is required. minimum_detectable_conc Numeric dt_result.minimum_detectable_conc For radiological results: Minimum detectable concentration or activity. This value must be in the same units as the result_value. Reporting_detection_limit cannot be negative unless one of the radiological fields (minimum_detectable_conc, counting_error, uncertainty, critical_value) are populated. counting_error Numeric dt_result.counting_error For radiological results: Counting as reported by the Reporting_detection_limit cannot be negative unless one of the radiological fields