BEASV_INTERRUPTIONS

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"