The BEASV_INTERRUPTIONS dashboard view contains all the previous, current and planned interruptions for all resources and tools with their respective start and end date. The view also includes a calculated field called InterruptionDuration, which is the amount of time between the interruption start and end date in hours. This field shows interruption hours in the future, if the end date is later than the current date. Therefore, the InterruptionUntilToday column is created in the view, so that it is possible to easily get the interruption hours up until the current date. Other interruption details are included, such as the interruption reason, description, status and operator.
Column |
Description |
Table Info |
---|---|---|
ResourceOrToolId |
Id of Resource/Tool |
beas_aplatz_stillstand.aplatz_id |
Name |
Name of Resource/Tool |
|
ResourceGroup |
Group of Resource |
|
Active |
Resource/Tool active? |
|
Type |
"Resource" or "Tool" |
|
ServiceResource |
This is a service resource |
|
CapacityPlanning |
Capacity planing supported |
|
DateFrom |
Interruption from |
beas_aplatz_stillstand |
DateTo |
Interruption to |
beas_aplatz_stillstand |
InterruptionDuration |
Duration of Interruption |
|
InterruptionUntilToday |
real duration until today in hours |
|
Operator |
Personnel Id of Operator |
beas_aplatz_stillstand |
InterruptionReasonId |
Id of Interruptuption |
beas_aplatz_stillstand.grundid |
InterruptionDescription |
Description of Interruption |
beas_stillstandgrund.grundinfo |
InterruptionStatus |
Status of Interruption "Planned" or "Complete" |