value, including spikes and duplicates. sample_matrix_code - Matrix code representing the sample matrix as defined in the field. sample_type_code - The including types code which distinguishes of samples, between different types of matrix that the samples. For example, sample was normal field samples must collected from, be distinguished from data and laboratory method blank location the samples, etc. sample was sample_source collected. sample_date - The date and time the sample was collected (in MM/DD/YYYY HH:MM:SS format). composite_yn if the – “Y” sample is a composite sample, "N" if not. MTDEQ requires the fields listed below be populated: data_provider Valid – value from rt_company or data provider EDD section Contains field for organization collecting parameters the field results. collected sys_loc_code The – during sample location ID where sampling field results were taken. events, such sys_sample_code The – as groundwater sample that is associated quality with the field results parameters, Whenever collected. including field_parameter The – turbidity, Data investigation CAS number code from temperature, Providers data are rt_analyte representing the FieldResults_v1 specific collected field parameter collected. conductance, Personnel and start_depth The start – pH, Eh, and provided to depth below ground dissolved MTDEQ surface or water surface of oxygen. Field the sample interval. test kit results end_depth The end – for parameters, below ground surface or such as ferrous water surface of the iron, which are sample interval. analyzed in the depth_unit The sample – field, may also start and end depth unit. be entered into result_date The date the – this EDD. field parameter measurement was taken. result_time The time the – field parameter measurement was taken.
including types of samples, matrix that the sample was collected from, data and location the sample was collected. value, including spikes and duplicates. sample_matrix_code - Matrix code representing the sample matrix as defined in the field. sample_type_code - The code which distinguishes between different types of samples. For example, normal field samples must be distinguished from laboratory method blank samples, etc. sample_source sample_date - The date and time the sample was collected (in MM/DD/YYYY HH:MM:SS format). composite_yn – “Y” if the sample is a composite sample, "N" if not. FieldResults_v1 Contains field parameters collected during sampling events, such as groundwater quality parameters, including turbidity, temperature, specific conductance, pH, Eh, and dissolved oxygen. Field test kit results for parameters, such as ferrous iron, which are analyzed in the field, may also be entered into this EDD. Data Providers Personnel Whenever investigation data are collected and provided to MTDEQ MTDEQ requires the fields listed below be populated: data_provider – Valid value from rt_company or data provider EDD section for organization collecting the field results. sys_loc_code – The sample location ID where field results were taken. sys_sample_code – The sample that is associated with the field results collected. field_parameter – The CAS number code from rt_analyte representing the field parameter collected. start_depth – The start depth below ground surface or water surface of the sample interval. end_depth – The end below ground surface or water surface of the sample interval. depth_unit – The sample start and end depth unit. result_date – The date the field parameter measurement was taken. result_time – The time the field parameter measurement was taken.
e-TREADS_EDD_Manual.docx