ResourceStates DataSet#
Source: DWH
Fields#
The ResourceStates Data Set has the following fields:
| Field | Description | DataType | Field Type | Order |
|---|---|---|---|---|
| Header_DateTime | The start time of the resource state. | DateTime | Timestamp | 1 |
| NextHeader_DateTime | The end time of the resource state. | DateTime | Timestamp | 2 |
| NextHeader_DateTimeCorrected | The end time of the resource state corrected with current UTC date when no next state exists. | DateTime | Timestamp | 3 |
| Duration | Total duration of the resource state. | Integer | Metric | 4 |
| Operation | The specific operation or process being tracked. | String | Dimension | 5 |
| Enterprise_Name | The name of the enterprise or company. | String | Dimension | 6 |
| Site_Name | The name of the specific site or location. | String | Dimension | 7 |
| Facility_Name | The name of the facility within the site. | String | Dimension | 8 |
| Area_Name | The name of the area within the facility. | String | Dimension | 9 |
| Resource_Name | The name of the resource (e.g., machine or equipment) being monitored. | String | Dimension | 10 |
| Resource_Type | The type of the resource. | String | Dimension | 11 |
| Resource_ResourceType | The resource user type for the resource. | String | Dimension | 12 |
| Model | The model number or identifier of the resource. | String | Dimension | 13 |
| Manufacturer | The manufacturer of the resource. | String | Dimension | 14 |
| Class | The classification or category of the resource. | String | Dimension | 15 |
| Shift_Name | The name of the work shift during which the resource is operating. | String | Dimension | 16 |
| CalendarDay | The specific calendar day associated with the resource state. | DateTime | Timestamp | 17 |
| Calendar_Name | The specific calendar name associated with the resource state. | String | Dimension | 18 |
| CalendarDay_FY | The calendar fiscal year associated with the resource state. | Integer | Metric | 19 |
| CalendarDay_FQ | The calendar fiscal quarter associated with the resource state. | Integer | Metric | 20 |
| CalendarDay_FM | The calendar fiscal month associated with the resource state. | Integer | Metric | 21 |
| CalendarDay_FW | The calendar fiscal week associated with the resource state. | Integer | Metric | 22 |
| Calendar_Timezone | The timezone associated with the calendar. | String | Dimension | 23 |
| Calendar_TZToUTCInMin | Difference in minutes between the Time zone of the calendar and UTC. | Integer | Metric | 24 |
| SEMIE10State | The SEMI E10 state of the resource, indicating its operational status. | String | Dimension | 25 |
| SEMIE10State_EngineeringDuration | Total duration of the resource in SEMI E10 engineering state. | Integer | Metric | 26 |
| SEMIE10State_NonscheduledDuration | Total duration of non-scheduled time under SEMI E10 state. | Integer | Metric | 27 |
| SEMIE10State_ProductiveDuration | Total duration of productive time under SEMI E10 state. | Integer | Metric | 28 |
| SEMIE10State_ScheduledDownDuration | Total duration of scheduled downtime under SEMI E10 state. | Integer | Metric | 29 |
| SEMIE10State_StandbyDuration | Total duration of standby time under SEMI E10 state. | Integer | Metric | 30 |
| SEMIE10State_UnscheduledDownDuration | Total duration of unscheduled downtime under SEMI E10 state. | Integer | Metric | 31 |
| SEMIE58State | The SEMI E58 state of the resource, indicating its current condition. | String | Dimension | 32 |
| BasicState | The basic state of the resource, such as 'up' or 'down'. | String | Dimension | 33 |
| BasicState_DownDuration | Total duration of the resource being down. | Integer | Metric | 34 |
| BasicState_NonscheduledDuration | Total duration of non-scheduled time under the basic state. | Integer | Metric | 35 |
| BasicState_UpDuration | Total duration of the resource being up and running. | Integer | Metric | 36 |
| prevBasicState | The previous basic state of the resource, such as 'up' or 'down'. | String | Dimension | 37 |
| DownToUp | True if the state was switched from Down to Up. | Integer | Metric | 38 |
| UpToDown | True if the state was switched from Up to Down. | Integer | Metric | 39 |
| Shift_WorkingTimeSecs | Total amount in seconds in a day of Working Time. | Integer | Metric | 40 |
| Shift_NonWorkingTimeSecs | Total amount in seconds in a day of Non Working Time. | Integer | Metric | 41 |
Table: ResourceStates fields