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
|