VI_TaskParameters_v1 VI_Samples_v1 3.3: General Information on the Vapor Intrusion Group EDD Sections Completed Submission Table Name Description Data Requirements By Frequency The fields listed need to be populated for the EDD to load: Contains building_code– For each data that building, this building code inventories must be unique buildings building_name– This can and Data be a more descriptive structures, Providers Once per name for the building. VI_BuildingInspection_v1 and building inspection_date The – cataloging Intrusion inspection date the building inspection factors that Team was conducted. impact air task_code This field – quality should identify the within sampling plan structures. that was followed to collect the samples. Contains data The fields listed below need to be Anytime specific to populated for the EDD to load: structure the VI task, Data task_code This – sampling for example Providers should identify the data are VI_TaskParameters_v1 Vapor sampling plan collected weather, Intrusion that was followed to collect and start/end Team the samples. provided to atmospheric parameter_code The – MTDEQ pressure, task parameter. etc. 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. Contains sys_sample_code - The sample Anytime unique identifier of the information structure sample. Each sample at a collected Data sampling facility must have a unique from Providers data are value, including spikes and VI_Samples_v1 ambient air, Vapor collected duplicates. You have indoor air, Intrusion and considerable flexibility in and subslab Team provided to the methods used to derive soil and assign unique sample sampling identifiers, but uniqueness forms throughout the database is the only restriction enforced by EQuIS®. sample_name - Additional sample identification information as necessary.
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.
e-TREADS_EDD_Manual_08082017.docx