/
Swapping Cause and Equipment for Downtime

Swapping Cause and Equipment for Downtime

Owned by Michael Addison
Last updated: Sept 17, 2024
1 min read

How to change the data within these tables.

tblAreaShutdownEquipment

tblAreaShutdownReason

tblAreaShutdown

Step 1 - Duplicate Data

Datagrip, create insert into statements for Equipment and Reason tables for all the data.

For inserts for tblAreaShutdownReason, do a REPLACE

image-20240917-175525.png
image-20240917-175533.png

For inserts for tblAreaShutdownEquipment, do a REPLACE

 

Related content

Cause and Equipment Administration
Cause and Equipment Administration
Plant Focus Knowledge Base
More like this
Downtime Cause Equipment Logic Map
Downtime Cause Equipment Logic Map
Plant Focus Knowledge Base
More like this