Material
The Material hierarchy is defined as three views:
- V_MaterialGroup
- V_MaterialCategory
- 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. |