Datasource Properties: Sample Tracker

Database Options

The Sample Tracker data model can be enabled or disabled on the Sample Tracker page of the Datasource Property Editor. Enabling Sample Tracker will set it to use the "Micromine Geobank Version 10 " Sample Tracker Data Model.

Sample result link table

Use the primary sample table (GB_SAMPLE) as the primary link

The default primary sample table in the Sample Tracker data model. See GB_SAMPLE_FRACTION below.

Use the size fraction table (GB_SAMPLE_FRACTION) as the primary link

The size fraction table (GB_SAMPLE_FRACTION) is optional in most environments, although it is required in the case of coal washability data. This table records the yield (mass percentage) for a given size fraction.

Use the exclude flag in the primary sample table

The EXCLUDE column in the GB_SAMPLE table can be used to exclude records from data views.

Often in RAB, aircore or RC drilling, large (typically 2 metre or 4 metre) composites are taken by default. This is usually done to save money or to save time at the lab. If the results from these composites arouse further interest they may be resampled, for example, as 1 metre "split" samples.

As a result, in the sample table there will be more than one sample for the same intervals. Since most reporting and 3D modelling processes expect only one sample to exist per interval, you can use the Exclude flag to exclude the original 2 metre or 4 metre composite samples from being exported or reported.

Note for Administrators: The data in the EXCLUDE column will only be used by Sample Tracker (to exclude samples for which it is set to true) when the Use the exclude flag in the primary sample table option is enabled. Even with this option deselected, the underlying code used by Sample Tracker still requires the existence of an EXCLUDE column. If the underlying table(s) do not contain an EXCLUDE column, you can utilise SQL code to build a database view, such as VW_SAMPLE, to map and provide the requisite column. For example:

	CAST (0 AS BIT ) AS EXCLUDE

For more information on using SQL with Micromine Geobank, see Data Manipulation Language (DML)

Use GENERIC METHOD as the primary key

The option of storing either the GENERIC METHOD code or the original LAB METHOD code in result tables and associated metadata, is provided. The standard Micromine Geobank data model uses LAB METHOD code and so this option is unchecked by default.

Sample Tracker Data Model