Sourced measures and KPIs
This table shows the measures that are sourced directly in Data Warehouse:
| Measure | Description |
|---|---|
| Actual Usage – Hrs | The actual usage in hours of an equipment for the report date |
| Actual Usage – Meter 1 | The actual usage in meter 1 of an equipment for the report date |
| Actual Usage – Meter 2 | The actual usage in meter 2 of an equipment for the report date |
| Actual Usage – Meter 3 | The actual usage in meter 3 of an equipment for the report date |
| Actual Usage – Meter 4 | The actual usage in meter 4 of an equipment for the report date |
| Downtime | The downtime hours of each work order |
| Lifecycle Usage – Hrs | The average daily usage in hours of an equipment between its manufacturing date and the report date |
| Lifecycle Usage – Meter 1 | The average daily usage in meter 1 of an equipment between its manufacturing date and the report date |
| Lifecycle Usage – Meter 2 | The average daily usage in meter 2 of an equipment between its manufacturing date and the report date |
| Lifecycle Usage – Meter 3 | The average daily usage in meter 3 of an equipment between its manufacturing date and the report date |
| Lifecycle Usage – Meter 4 | The average daily usage in meter 4 of an equipment between its manufacturing date and the report date |
| No. of Failures | The number of work orders with downtime hours greater than zero |
| No. of Non-PM Work Orders | The number of non-preventive maintenance work orders, which are defined as those with service classification not equal to 3 |
| No. of Operations | The number of operations of a completed work order |
| No. of PM Work Orders | The number of preventive maintenance work orders, which are defined as those with service classification equal to 3 |
| No. of Shutdowns | The number of work orders that required a shutdown of the equipment |
| No. of WO w/ Plnd Downtime | The number of work orders with service classification equal to 3 and downtime hours greater than 0 |
| No. of WO w/ Unplnd Downtime | The number of work orders with service classification not equal to 3 and downtime hours greater than 0 |
| No. of Work Orders | The number of completed work orders |
| Planned Downtime | The downtime hours of work orders with service classification equal to 3 |
| Plnd Usage – Hrs | The equipment's planned usage in the meter representing hours as specified in the corresponding DWD variable |
| Plnd Usage – Meter 1 | The equipment's planned usage in meter 1, as specified in the corresponding DWD variable |
| Plnd Usage – Meter 2 | The equipment's planned usage in meter 2, as specified in the corresponding DWD variable |
| Plnd Usage – Meter 3 | The equipment's planned usage in meter 3, as specified in the corresponding DWD variable |
| Plnd Usage – Meter 4 | The equipment's planned usage in meter 4, as specified in the corresponding DWD variable |
| Target Avl – Hrs | The target availability of an equipment multiplied by the planned usage in hours |
| Target Avl – Meter 1 | The target availability of an equipment multiplied by the planned usage in meter 1 |
| Target Avl – Meter 2 | The target availability of an equipment multiplied by the planned usage in meter 2 |
| Target Avl – Meter 3 | The target availability of an equipment multiplied by the planned usage in meter 3 |
| Target Avl – Meter 4 | The target availability of an equipment multiplied by the planned usage in meter 4 |
| Unplanned Downtime | The downtime hours of work orders with service classification not equal to 3 |