To use as an example to answer this question, a cliet asked asked: We report multiple different units and filtered analysis…e.g. the analysis is Chlorophyll, the filter is lab 0.22, the units are mg/L and then for the same station I also have a field 0.45 and units are mg/L for reporting OrthoP for the same station. How is that handled in Enviro Data. 

In this scenario , a sample taken at a site and filtered in the field with a 0.45u filter, all these analyses would have the FilteredSampleCode of F45U. When the lab reports Chlorophyll back they would use a FilteredAnalysisCode of L22U (for Lab 0.22u). The OrthoP result would have its own FilteredAnalysisCode of TOT. The units for both would be whatever the lab reports. (See Filtered table below.) However, if the OrthoP sample was not filtered, it would be a different sample even though it was filtered in the lab. They obviously would not be the same Analsysis since the Parameter is different. 

Filtered lookup table. 

Also, if these two samples did not all have the same criteria as shown in the unique index for the Samples, they would not be the same sample. 

Criteria for a Unique Sample

Enviro Data identifies unique samples based on the station, sample date, sample matrix, sample top, duplicate sample, sample bottom, filtered sample, field sample ID, QC sample code and alternate sample ID fields as seen below. This allows the data administrator to import multiple samples related to one sampling event or make multiple imports of analyses from a given sampling event.

Fields used to define the Unique Index in the Samples Table.

Criteria for a Unique Analyses

Enviro Data identifies unique analyses based on sample number, parameter number, superseded, analytic method, leach method, report units, basis, filtered analyses code, QC analysis code and lab sample id fields as seen below. This allows the data administrator to import multiple analyses related to one sample or make multiple imports of analyses from a given sampling event. Re-analyses or analyses delivered at separate times are matched to the correct sample event by the import code using the unique fields listed above.

Fields used to define the Unique Index in the Analyses table.