Material

The Material hierarchy is defined as three views:

  1. V_MaterialGroup
  2. V_MaterialCategory
  3. V_Material

V_Material_Group

Each Material type must belong to a category and each category must belong to a group, for example Ore, Waste, etc. Those groups are defined in the V_MaterialGroup view. There are no attributes other than those defined in the Mandatory Column Set.

V_Material_Category

You can think of a Material Category as a subset of a Material Group. Material categories might be HighGradeOre, LowGradeOre, Overburden, etc.

Column Description
Mandatory column set
Material_Category_Group Select a Material Category Group defined in V_MaterialGroup.
Material_Category_Group_Code The value in this column is generated automatically by the system. It is the Material Category Group Code of the selected Material Category Group.

V_Material

The V_Material view defines the material types found on site, for example VeinOre, RoadFill, etc.These material types are defined in the Groups | Configuration Items | Locations | Material reference data group.

Column Description
Mandatory column set
Material_Density Enter the Material Density Factor. This value is used to compute weight.
Material_Category Select a Material Category defined in V_MaterialCategory.
Material_Category_Code The value in this column is generated automatically by the system. It is the Material Category Code of the selected Material Category.