---
title: Resource States with Non Working Times
alias: business-intelligence-cubes-resource-states-non-working-times
docsync: true
description: "This documentation describes a ClickHouse cube containing dimensions for resource states, tracking operational times and non-working periods across various facility"
---

# Resource States with Non Working Times Cube

## ClickHouse Cube

* cube_resourcestates_non_working_times

## Dimensions

The **Resource States with Non Working Times** Cube has the following dimensions:

| Field | Description | Primary Key | Public |
| --- | ----- | - | - |
| **Operation** | The specific operation or process being tracked. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Enterprise Name** | The name of the enterprise or company. |:material-check:{ style="color: #4DB6AC" } |:material-check:{ style="color: #4DB6AC" } |
| **Site Name** | The name of the specific site or location. |:material-check:{ style="color: #4DB6AC" } |:material-check:{ style="color: #4DB6AC" } |
| **Facility Name** | The name of the facility within the site. |:material-check:{ style="color: #4DB6AC" } |:material-check:{ style="color: #4DB6AC" } |
| **Facility DisplayOrder** | The Display Order of the facility |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Area Name** | The name of the area within the facility. |:material-check:{ style="color: #4DB6AC" } |:material-check:{ style="color: #4DB6AC" } |
| **Area DisplayOrder** | The Display Order of the area |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Resource Name** | The name of the resource (e.g., machine or equipment) being monitored. |:material-check:{ style="color: #4DB6AC" } |:material-check:{ style="color: #4DB6AC" } |
| **Resource ResourceType** | The resource user type for the resource. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Resource DisplayOrder** | The Display Order of the resource (e.g., machine or equipment) being monitored. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Model** | The model number or identifier of the resource. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Manufacturer** | The manufacturer of the resource. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Class** | The classification or category of the resource. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Shift Name** | The name of the work shift during which the resource is operating. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **SEMI E10 State** | The SEMI E10 state of the resource, indicating its operational status. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **SEMI E58 State** | The SEMI E58 state of the resource, indicating its current condition. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Basic State** | The basic state of the resource, such as 'up' or 'down'. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Start Time** | The start time of the resource state. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **End Time** | The end time of the resource state. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Calendar Name** | The specific calendar name associated with the resource state. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Calendar Day FY** | The calendar fiscal year associated with the resource state. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Calendar Day FQ** | The calendar fiscal quarter associated with the resource state. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Calendar Day FM** | The calendar fiscal month associated with the resource state. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Calendar Day FW** | The calendar fiscal week associated with the resource state. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |
| **Calendar Day** | The specific calendar day associated with the resource state. |:material-close:{ style="color: #EF5350" } |:material-check:{ style="color: #4DB6AC" } |

Table: Resource States with Non Working Times Dimensions

## Measures

The **Resource States with Non Working Times** Cube has the following measures:

| Field | Description | Primary Key | Public | Type | Formula |
| ---- | ------------ | - | - | - | ---- |
| **Record Count** | Total number of records in the dataset. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | count |  |
| **Working Time** | Total working time of the resource. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `WorkingTime` |
| **SEMI E10 Engineering Working Time** | Total time under SEMI E10 engineering state. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `SEMIE10State_EngineeringDuration` |
| **SEMI E10 Engineering Working Time** | Total working time under SEMI E10 engineering state. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `SEMIE10State_EngineeringWorkingTime` |
| **SEMI E10 Non-Scheduled Working Time** | Total working time under SEMI E10 non-scheduled state. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `SEMIE10State_NonscheduledWorkingTime` |
| **SEMI E10 Productive Working Time** | Total time under SEMI E10 productive state. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `SEMIE10State_ProductiveDuration` |
| **SEMI E10 Productive Working Time** | Total working time under SEMI E10 productive state. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `SEMIE10State_ProductiveWorkingTime` |
| **SEMI E10 Scheduled Down Working Time** | Total working time during scheduled downtime under SEMI E10 state. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `SEMIE10State_ScheduledDownWorkingTime` |
| **SEMI E10 Standby Time** | Total time during standby under SEMI E10 state. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `SEMIE10State_StandbyDuration` |
| **SEMI E10 Standby Working Time** | Total working time during standby under SEMI E10 state. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `SEMIE10State_StandbyWorkingTime` |
| **SEMI E10 Unscheduled Down Working Time** | Total working time during unscheduled downtime under SEMI E10 state. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `SEMIE10State_UnscheduledDownWorkingTime` |
| **Basic State Down Working Time** | Total working time during the down state. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `BasicState_DownWorkingTime` |
| **Basic State Non-Scheduled Working Time** | Total working time during non-scheduled periods under the basic state. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `BasicState_NonscheduledWorkingTime` |
| **Basic State Up Working Time** | Total working time during the up state. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `BasicState_UpWorkingTime` |
| **Non-Working Time** | Total non-working time of the resource. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `NonWorkingTime` |
| **SEMI E10 Engineering Non-Working Time** | Total non-working time under SEMI E10 engineering state. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `SEMIE10State_EngineeringNonWorkingTime` |
| **SEMI E10 Non-Scheduled Non-Working Time** | Total non-working time under SEMI E10 non-scheduled state. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `SEMIE10State_NonscheduledNonWorkingTime` |
| **SEMI E10 Productive Non-Working Time** | Total non-working time under SEMI E10 productive state. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `SEMIE10State_ProductiveNonWorkingTime` |
| **SEMI E10 Scheduled Down Non-Working Time** | Total non-working time during scheduled downtime under SEMI E10 state. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `SEMIE10State_ScheduledDownNonWorkingTime` |
| **SEMI E10 Standby Non-Working Time** | Total non-working time during standby under SEMI E10 state. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `SEMIE10State_StandbyNonWorkingTime` |
| **SEMI E10 Unscheduled Down Non-Working Time** | Total non-working time during unscheduled downtime under SEMI E10 state. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `SEMIE10State_UnscheduledDownNonWorkingTime` |
| **Basic State Down Non-Working Time** | Total non-working time during the down state. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `BasicState_DownNonWorkingTime` |
| **Basic State Non-Scheduled Non-Working Time** | Total non-working time during non-scheduled periods under the basic state. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `BasicState_NonscheduledNonWorkingTime` |
| **Basic State Up Non-Working Time** | Total non-working time during the up state. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `BasicState_UpNonWorkingTime` |
| **Duration** | The Duration |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `Duration` |
| **SEMI E10 Scheduled Down Duration** | Total Duration during scheduled downtime under SEMI E10 state. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `SEMIE10State_ScheduledDownDuration` |
| **SEMI E10 Uncheduled Down Duration** | Total Duration of unscheduled downtime under SEMI E10 state. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `SEMIE10State_UnscheduledDownDuration` |
| **Basic State duration Non-Working Time** | Total duration of non-scheduled periods under the basic state. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | sum | `BasicState_NonscheduledDuration` |
| **Potential Production Time** | The Potential Production Time for a Resource in the period, which excludes the Calendar Non Working Times and SEMI E10 Non Scheduled Times and Scheduled Down Times from the Total Time. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | number | `{duration} - {non_working_time} - {basic_state_nonscheduled_duration} + {basic_state_nonscheduled_non_working_time} - {semi_e10_state_scheduled_down_duration} + {semi_e10_state_scheduled_down_non_working_time}` |
| **Up Time** | The uptime for the Resource in the period |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | number | `{semi_e10_state_standby_duration} + {semi_e10_state_productive_duration} + {semi_e10_state_engineering_duration}` |
| **Up Time in Working Time** | The uptime in working time for the Resource in the period |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | number | `{semi_e10_state_standby_working_time} + {semi_e10_state_productive_working_time} + {semi_e10_state_engineering_working_time}` |
| **Up Time in Non-Working Time** | The uptime in non-working time for the Resource in the period |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | number | `{semi_e10_state_standby_non_working_time} + {semi_e10_state_productive_non_working_time} + {semi_e10_state_engineering_non_working_time}` |
| **Down Time** | The downtime for the Resource in the period |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | number | `{semi_e10_state_unscheduled_down_duration} + {semi_e10_state_scheduled_down_duration}` |
| **Down Time in Working Time** | The downtime in working time for the Resource in the period |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | number | `{semi_e10_state_unscheduled_down_working_time} + {semi_e10_state_scheduled_down_working_time}` |
| **Down Time in Non-Working Time** | The downtime in non-working time for the Resource in the period |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | number | `{semi_e10_state_unscheduled_down_non_working_time} + {semi_e10_state_scheduled_down_non_working_time}` |
| **Availability Up Time component** | Total uptime considered for Availability calculations. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | number | `{potential_production_time} - ( {semi_e10_state_unscheduled_down_duration} - {semi_e10_state_unscheduled_down_non_working_time} )` |
| **Availability (OEE)** | The Availability for the Resource in the period - following the definition of the Overall Equipment Effectiveness: OEE considers the Potential Production Time for the availability, which does not include Calendar Non Working Time, SEMI E10 Non Scheduled Time or Scheduled Down Time. |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | number | `{_availability} * 100` |
| **_Availability (OEE)** | Internal Use - The Availability for the Resource in the period - following the definition of the Overall Equipment Effectiveness: OEE considers the Potential Production Time for the availability, which does not include Calendar Non Working Time, SEMI E10 Non Scheduled Time or Scheduled Down Time. |:material-close:{ style="color: #EF5350" } | :material-close:{ style="color: #EF5350" } | number | `CASE   WHEN {potential_production_time} != 0   THEN (({operating_time}) / ({potential_production_time}))   ELSE 0 END` |
| **Operational Efficiency Up Time component** | Total uptime considered for Operational Efficiency calculations. |:material-close:{ style="color: #EF5350" } | :material-close:{ style="color: #EF5350" } | number | `{semi_e10_state_productive_working_time} + {semi_e10_state_engineering_working_time}` |
| **Operational Efficiency (OEE)** | The Operational Efficiency for the Resource in the period  - following the definition of the Overall Equipment Effectiveness: OEE considers the Potential Production Time for the availability, which does not include Calendar Non Working Time, SEMI E10 Non Scheduled Time or Scheduled Down Time |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | number | `{_operational_efficiency} * 100` |
| **_Operational Efficiency (OEE)** | Internal Use - The Operational Efficiency for the Resource in the period  - following the definition of the Overall Equipment Effectiveness: OEE considers the Potential Production Time for the availability, which does not include Calendar Non Working Time, SEMI E10 Non Scheduled Time or Scheduled Down Time |:material-close:{ style="color: #EF5350" } | :material-close:{ style="color: #EF5350" } | number | `CASE  WHEN {operating_time} != 0   THEN (({net_operating_time}) / ({operating_time}))   ELSE 0 END` |
| **Rate Efficiency** | The Rate Efficiency for the Resource in the period - one of the subcomponents of Performance Efficiency, which in turn is one the components of OEE |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | number | `{_rate_efficiency} * 100` |
| **_Rate Efficiency** | Internal Use - The Rate Efficiency for the Resource in the period - one of the subcomponents of Performance Efficiency, which in turn is one the components of OEE |:material-close:{ style="color: #EF5350" } | :material-close:{ style="color: #EF5350" } | number | `CASE   WHEN {net_operating_time} != 0   THEN {material_movement.ideal_cycle_time}/{net_operating_time}   ELSE 0 END` |
| **Performance Efficiency (OEE)** | The Performance Efficiency for the Resource in the period - following the definition of the Overall Equipment Effectiveness: OEE considers the Potential Production Time for the availability, which does not include Calendar Non Working Time, SEMI E10 Non Scheduled Time or Scheduled Down Time |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | number | `{_performance_efficiency} * 100` |
| **_Performance Efficiency (OEE)** | Internal Use - The Performance Efficiency for the Resource in the period - following the definition of the Overall Equipment Effectiveness: OEE considers the Potential Production Time for the availability, which does not include Calendar Non Working Time, SEMI E10 Non Scheduled Time or Scheduled Down Time |:material-close:{ style="color: #EF5350" } | :material-close:{ style="color: #EF5350" } | number | `CASE   WHEN {operating_time} != 0   THEN {material_movement.ideal_cycle_time}/{operating_time}   ELSE 0 END` |
| **OEE** | Overall Equipment Effectiveness - given by Availability (OEE) x Performance x Quality. Availability (OEE) considers the Actual Production Time (Total Time minus Non Working Times, NonScheduled Times and Scheduled Down Times) as Available Time |:material-close:{ style="color: #EF5350" } | :material-check:{ style="color: #4DB6AC" } | number | `{_availability} * {_performance_efficiency} * {material_movement._rate_of_quality} * 100` |

Table: Resource States with Non Working Times Measures

!!! warning "Public Keys"
    All dimensions or measures with the "Public" column marked with a :material-close:{ style="color: #EF5350" } icon must not be used. These are private dimensions/measures, used for intermediate calculations before the aggregations are performed. Using them will result in a query failure.