Field types in SamplingXL

Top  Previous  Next

 

This section describes how fields work in SamplingXL.

 

SamplingXL supports the following Field Types:

 

Field Type

Description

Width

Width field. For Sections and Sheets it is summed up from Samples or Sections

RockType

A special lookup field for the Rock Type. The Density field of the lookup table is used as the density of the sample. The pattern field of the lookup table if any is used as the pattern when drawing the section view. If the lookup table has an IsReef column this is used to determine that a sample is on reef or not

Density

A density field that is auto populated from the density in the rock types table if it is specified and has a density column.

TicketID

A ticket ID. This field is auto incremented and must be unique.

Check

Is this a check sample. (A duplicate sample as a test to verify that the lab is doing its analysis correctly)

CreatedBy

Name of user creating this sheet, section or sample

CreatedDate

Date item was created

ModifiedBy

Name of user who did the last modification of this item

ModifiedDate

Date this item was last changed

AuthorizedBy

User who authorized this item

AuthorizedDate

Date item was authorized

AssayedDate

Date item was assayed

IsReef

Is this a Reef sample. This field is automatically populated from the RockTypes table if it has a column ISREEF.

ReefInHanging

Calculated field, determines if sample is a reef sample in the hanging wall.

ReefInFoot

Calculated field, determines if a sample is a reef sample in the footwall

Numeric

Custom numeric field

String

Custom string field

Boolean

Custom yes/no field

Date

Custom date field

Lookup

General lookup field

X

X Coordinate in 3D Space

Y

Y Coordinate in 3D Space

Z

Z Coordinate in 3D Space

DX

X Offset

DY

Y Offset

DZ

Z Offset

ODX

Orientation X Offset

ODY

Orientation Y Offset

ODZ

Orientation Z Offset

Average

Average of fields in sub objects

Sum

Sum of fields in sub objects

WeightedAverage

Width weighted average of fields in sub objects

DensityWeightedAverage

Density and Width weighted average of fields in sub objects

Exclusion

Is the item (sheet or section) excluded from certain calculations. Note sections with Reef in hanging or foot are excluded anyway.

SampleValuesPresent

Are all sample values present in sub objects

Expression

Custom expression calculated field

 

A field in SamplingXL has one of the above types. The type specifies how the field is used, calculated and generally managed in the system.

You can create totally custom fields, and even custom calculated fields