Equipment Model Tables
In the Equipment model, there is no measurable data; most of the facts are relations.
The following table describes the reporting database tables and their descriptions.
| Table | Description |
|---|---|
| Dim_Equipment | Equipment definitions. |
| Dim_EquipmentClass | Equipment class definitions. |
| Fact_EquipmentActual | Equipment actuals. |
| Fact_PropertiesOfEquipment | Equipment property configuration, including both class properties and instance properties. |
| Fact_ClassesOfEquipment | Equipment class and Equipment definition association. |
| Bridge_EquipmentHierarchy | Equipment hierarchy table. |
Equipment Hierarchy Table
The Bridge_EquipmentHierarchy table is designed to simplify reports that query multiple depths of the hierarchy information. For example, you can sum the total parts used in one organization.The bridge table contains a pathway from each parent equipment to each subsidiary below it, including itself (zero length). For example, for the following equipment hierarchy:
- ABC Medical Supply (1)
- Chicago Branch (2)
- Building 2 Production (4)
- Detroit Branch (3)
- Chicago Branch (2)
The bridge table will look like:
| Equipment | Subsidiary | Level | IsParentTop | IsSubBottom |
|---|---|---|---|---|
| 1 | 1 | 0 | Y | N |
| 1 | 2 | 1 | Y | N |
| 1 | 4 | 2 | Y | Y |
| 2 | 4 | 1 | N | Y |
| 1 | 3 | 1 | Y | Y |
| 2 | 2 | 0 | N | N |
| 3 | 3 | 0 | N | Y |
| 4 | 4 | 0 | N | Y |
The following diagram illustrates the relationship between the Equipment model tables:
