13/10/2016 2 TE-MPE-MI ASSET MANAGEMENT DATABASE DEPLOYMENT FOR WIC - PowerPoint Presentation

Slide1

Slide2

13/10/2016

2

TE-MPE-MI

ASSET MANAGEMENT DATABASE DEPLOYMENT FOR WIC

Geza Csendes

TE-MPE-MI

Slide3

13/10/2016

TE-MPE-MI

3

WIC (Warm magnet Interlock Controller) layout

Standardized

interlock

system for normal conducting magnets

based

on

PLC

Slide4

13/10/2016

TE-MPE-MI

4

WIC INSTALLATION FACTS:

MASTER

REMOTE

REMOTE

REMOTE

36

WIC (PLC) SYSTEMS

110

RACKS

>270

CRATES

≈

1700

SIEMENS PLC MODULES

Slide5

13/10/2016

TE-MPE-MI

5

MACHINE

NUMBER OF

WIC

SYSTEMS

NUMBER OF

RACKS

SAFETY PLC

LHC

8

8

SPS

7

12

BOOSTER

4

23

HIE_ISOLDE

2

4

LINAC

4

2

2

ELENA

1

3

LEIR

1

4

LINAC

3

12NON-SAFETY(STANDARD) PLC TT66_HIRADMAT22 TT 4012 TI 812+18 TI 212+17 TT 4111+6 TT 6011

WIC INSTALLATION FACTS:

Slide6

13/10/2016

TE-MPE-MI

6

ASSET MANAGEMENT DATABASEIMPROVEMENT, TRANSFER

MS Access local

database

Installation data

updated

/

corrected

Creation

of a new structure

before

the

transfer

Creation

of

codes for Module/Crate

equipment (ID convention)Data transfer

using the «CERN Upload Utility»

toolTransfer of the assets (modules, crates, …)Set up in Infor relationships b/w assets and systemsStill

quite some manual tweaksLabelling (barcodes)

With support fromEDMS team

Slide7

13/10/2016

TE-MPE-MI

7

It is based on an Oracle database and the web-based user interfaced can be accessed from both inside and outside CERN.

Infor

EAM

presentation

:

https://edms.cern.ch/document/1384731/3

+ MPE

Slide8

13/10/2016

TE-MPE-MI

8

Tracking

changes

Infor

EAM

presentation

:

https://edms.cern.ch/document/1384731/3

Slide9

13/10/2016

TE-MPE-MI

9

www.cern.ch/cmms-service

Infor

EAM

presentation

:

https://edms.cern.ch/document/1384731/3

Slide10

13/10/2016

TE-MPE-MI

10

- The physical equipment, handled in MTF/Infor EAM, and visible/editable in all interlinked applications (EAM Light, EDMS, TREC)- Information related to a specific (physical) piece of equipment

- Create

asset structures to track assembly configurations

.

- Asset

can be mobile,

replaceable

- Equipment code (ID)

InforEAM

objects

:

ASSETS

MODULE

CRATE

RACK

Slide11

13/10/2016

TE-MPE-MI

11

POWER SUPPLY CRATE ID:

HC

CIW

SA

001

-CR000043

SERIAL NR.

VERSION

EQUIPMENT CODE

INITIAL

Equipment

naming

convention:

LHC-PM-QA-202.00 (

EDMS: 103547)

Slide12

13/10/2016

TE-MPE-MI

12

 

MTF DB information

 

WIC Equipment code

Description

1

HCCIWTA001

TEST EQUIPMENT

2

HCCIWMA001

Master Crate (CPU-F/SIMATIC_NET/24DI/24DI/24DI/8DI_8DO)

3

HCCIWML001

Master Crate (CPU-F+SIMATIC_NET/24DI/24DI/24DI/8DI_8DO)

4

HCCIWMB001

Master Crate (CPU-F/SIMATIC_NET/24DI/24DI/32DO/32DO/8DI_8DO)

5

HCCIWMC001

Master Crate (CPU-F/SIMATIC_NET/24DI/24DI/32DO/8DI_8DO)

6

HCCIWMD001

Master Crate (CPU-F/SIMATIC_NET/24DI/24DI/8DI_8DO)

7

HCCIWMN001

Master Crate (CPU-F+SIMATIC_NET/24DI/24DI/8DI_8DO)

8

HCCIWME001

Master Crate (CPU-F/SIMATIC_NET/24DI/8DOR/8DOR/32DO/32DO/8DI_8DO)

9

HCCIWMM001

Master Crate (CPU-F+SIMATIC_NET/24DI/8DOR/8DOR/32DO/32DO/8DI_8DO)10HCCIWMF001 Master Crate (CPU-F/SIMATIC_NET/24DI/8DOR/8DOR/32DO/8DI_8DO)11HCCIWMG001 Master Crate (CPU-F/SIMATIC_NET/32DO/8DI_8DO)12HCCIWMH001Master Crate (PS_5A/CPU/SIMATIC_NET/32DI/32DO/8DOR)13HCCIWMI001Master Crate (PS_5A/CPU/SIMATIC_NET/32DI/32DO/8DOR/8DOR/8DOR)14HCCIWMJ001Master Crate (CPU/SIMATIC_NET/32DI/32DO/8DOR/8DOR/8DOR/8DI_8DO)15HCCIWMK001 Master Crate (CPU-F/SIMATIC_NET/24DI/24DI/32DO/32DO/32DO/8DI_8DO)16HCCIWRA001Remote Crate (ET200/24DI/24DI)17HCCIWRB001Remote Crate (ET200/24DI/24DI/24DI)18HCCIWRC001Remote Crate (ET200/24DI/24DI/24DI/24DI)19HCCIWRD001Remote Crate (ET200/24DI/24DI/32DO/32DO)20HCCIWRE001Remote Crate (ET200/24DI/24DI/8DOR/8DOR/8DOR/8DOR/32DO)21HCCIWRF001Remote Crate (ET200/24DI/8DOR/8DOR)22HCCIWRG001

Remote Crate (ET200/24DI/8DOR/8DOR/32DO)

23

HCCIWRH001

Remote Crate (ET200/24DI/8DOR/8DOR/8DOR/8DOR)

24

HCCIWRI001

Remote Crate (ET200/24DI/8DOR/8DOR/8DOR/8DOR/32DO)

25

HCCIWRJ001

Remote Crate (ET200/24DI/8DOR/8DOR/8DOR/8DOR/8DOR/8DOR)

26

HCCIWRK001

Remote Crate (ET200/24DI/8DOR/8DOR/8DOR/8DOR/8DOR/8DOR/32DO)

27

HCCIWRL001

Remote Crate (ET200/8DOR/8DOR/32DO/32DO)

28

HCCIWRM001

Remote Crate (ET200/8DOR/8DOR/32DO/32DO/32DO)

29

HCCIWRN001

Remote Crate (ET200/8DOR/8DOR/8DOR/8DOR/32DO/32DO)

30

HCCIWRO001

Remote Crate (ET200/8DOR/8DOR/8DOR/8DOR/32DO/32DO/32DO)

31

HCCIWRP001

Remote Crate (ET200/8DOR/8DOR/8DOR/8DOR/8DOR/8DOR)

32

HCCIWRQ001

Remote Crate (ET200/8DOR/8DOR/8DOR/8DOR/8DOR/8DOR/8DOR/8DOR)

33

HCCIWRR001

Remote Crate (EXISTA/ET200/24DI/24DI/32DO/32DO)

34

HCCIWRS001

Remote Crate (EXISTA/ET200/24DI/32DO)

35

HCCIWRT001

Remote Crate (PS_5A/ET200/32DI/8DOR/8DOR/8DOR)

36

HCCIWFA001

Fast Boolean Crate (ET200/FM352)

37

HCCIWFB001

Fast Boolean Crate (ET200/FM352/FM352)

38

HCCIWUA001

Tunel

Remote Crate (EXISTA/ET200/32DI/32DO)

39

HCCIWUB001

Tunel

Remote Crate (EXISTA/ET200/32DI/32DO/REPEATER)

40

HCCIWSA001

Power Supply Crate (

PS_10A/REDUNDANCE/PS_10A/DIAGNOSIS

)

Equipment code (

example

):

CIWSA

Description:

Power

Supply Crate (PS_10A/REDUNDANCE/PS_10A/DIAGNOSIS

)

naming-service@cern.ch

CERN NAMING PORTAL

Equipment

naming

convention:

CRATES

Slide13

The code for modules are common for all PLC users at CERN

13/10/2016

TE-MPE-MI

13

Modules (assets)

Nr.

Function

MTF CODE

WIC SPEC. CODE

MTF description (LHC Equipment Catalogue - by Code)

Reference

InforEAM

description

1

24DI

CPIIB

HCCPIIB001

24 Digital Input Security Card SM326

6ES7326-1BK00-0AB0

Module - SM326, F-DI 24 X DC24V, FAILSAFE

2

24DI

CPIIB

HCCPIIB002

24 Digital Input Security Card SM326

6ES7326-1BK01-0AB0

Module - SM326, F-DI 24 X DC24V, FAILSAFE

3

24DI

CPIIB

HCCPIIB003

24 Digital Input Security Card SM326

6ES7326-1BK02-0AB0

Module - SM326, F-DI 24 X DC24V, FAILSAFE

432DICPIIAHCCPIIA001Digital Input Card SM321 DI 32xDC 24v6ES7321-1BL00-0AA0Module - 32 DI module - SM321532DOCPIILHCCPIIL001CPIIL SM 322 DO 32xDC 24v 0.5A6ES7322-1BL00-0AA0Module - SM322 DO 32XDC24V/0.5A68DI/8DOCPIIPHCCPIIP001SM 323 DI 8 DO 8 DC 24v 0.5A6ES7323-1BH01-0AA0Module - SM323, 8DI/8DO, DC24V, 0.5A78DOCPIIMHCCPIIM001SM 322 DO 8xDC 24v 2A6ES7322-1BF01-0AA0Module - SM322, 8DO, 24V DC, 2A88DO RELCPIICHCCPIIC002Digital Relay Output Card SM322 DO 8XRel AC 230V 5A 6ES7322-1HF10-0AA0Module - SM322, 8DO, 24V DC/5A OR 230V AC/5A98DO RELCPIICHCCPIIC001

Digital Relay Output Card SM322 DO 8XRel AC 230V 5A

6ES7322-5HF00-0AB0

Module - SM322, 8DO RELAY, 24VDC, 120-230V AC, 5A

10

8DO REL

CPIIC

HCCPIIC003

Digital Relay Output Card SM322 DO 8XRel AC 230V 5A

6AG1322-5HF00-4AB0

Module - SM322, 8DO RELAY, 24VDC, 120-230V AC, 5A

11

ET200

CPIIF

HCCPIIF001

ET200M

ProfiBus

coupler IM153

6ES7153-1AA02-0XB0

Module - ET200M, INTERFACE MODULE IM153-1

12

ET200

CPIIF

HCCPIIF002

ET200M

ProfiBus

coupler IM153

6ES7153-1AA03-0XB0

Module - ET200M, INTERFACE MODULE IM153-1

13

ET200

CPIIF

HCCPIIF003

ET200M

ProfiBus

coupler IM153

6ES7153-2AA02-0XB0

Module - ET200M, INTERFACE MODULE IM153-2

14

ET200

CPIIF

HCCPIIF004

ET200M

ProfiBus

coupler IM153

6ES7153-2BA02-0XB0

Module - ET200M, INTERFACE IM153-2 HF

15

ET200

CPIIF

HCCPIIF005

ET200M

ProfiBus

coupler IM153

6ES7153-2BA10-0XB0

Module - ET200M, INTERFACE IM153-2 HF

16

ET200

CPIIF

HCCPIIF006

ET200M

ProfiBus

coupler IM153

6AG1153-2BA10-2XY0

Module - ET200M, INTERFACE IM153-2 HF

17

EXISTA

CPSXA

HCCPSXA001

High Radiation Level Power Supply ACT50 24V 2A

ACS50 RT - 24 Vdc

Module - P.S.- EXISTA Code 4000.1275

18

FM352

CPUIE

HCCPUIE001

FM 352-5 High Speed Boolean

Controler

6ES7352-5AH00-0AE0

Module - FM 352-5, BOOLEAN PROCESSOR 12DE/8DA

19

FM352

CPUIE

HCCPUIE002

FM 352-5 High Speed Boolean

Controler

6ES7352-5AH01-0AE0Module - FM 352-5, BOOLEAN PROCESSOR 12DE/8DA20IM365CPMICHCCPMIC001CPMIC IM 365 bus interface6ES7365-0BA01-0AA0Module - Interface Module IM36521CPU CPUICHCCPUIC001CPU Unit CPU315-2 DP6ES7315-1AF03-0AB0Module - SIMATIC S7-300, CPU 315, 48KB22CPU CPUICHCCPUIC002CPU Unit CPU315-2 DP6ES7315-2AF03-0AB0Module - CPU315-2DP, 48KB23CPU CPUICHCCPUIC003CPU Unit CPU315-2 DP6ES7315-2AG10-0AB0Module - CPU315-2DP, 128KB24CPU CPUICHCCPUIC004CPU Unit CPU315-2 DP6ES7315-2AH14-0AB0Module - CPU315-2DP, 256KB25PS 10ACPSICHCCPSIC001SITOP Modular Power Supply 24V 10A (DIN35) 6EP1334-3BA00Module - SITOP PSU200M 24 V/10 A26PS 10ACPSICHCCPSIC002SITOP Modular Power Supply 24V 10A (DIN35) 6EP1334-3BA10Module - SITOP PSU200M 24 V/10 A27PS 2ACPSIIHCCPSII001PS 307 2A Power Supply, DC 24v/2A 6ES7307-1BA00-0AA0Module - PS 307, 120/230 V AC, 24 V DC/2 A28PS 5ACPSIBHCCPSIB001Power Supply for PS307-5A6ES7307-1EA00-0AA0Module - PS 307 5A29PS 5ACPSIBHCCPSIB002Power Supply for PS307-5A6ES7307-1EA01-0AA0Module - PS 307 5A30DIAGNOSISCPSJCHCCPSJC001Diagnostic Module for Redundant Power Supplies6EP1961-2BA00Module - SITOP SELECT DIAGNOSIS MODULE31REDUNDANCYCPSJDHCCPSJD001Redundant Module for Redundant Power Supplies6EP1961-3BA20Module - SITOP REDUNDANCY MODULE32REDUNDANCYCPSJDHCCPSJD002Redundant Module for Redundant Power Supplies6EP1961-3BA21Module - SITOP REDUNDANCY MODULE33REPEATERCBPRAHCCBPRA001ProfiBus RS 485 Repeater6ES7972-0AA01-0XA0Module - REPEATER RS485 F. PROFIBUS/MPI34REPEATERCBPRAHCCBPRA002ProfiBus RS 485 Repeater6ES7972-0AA02-0XA0Module - REPEATER RS485 F. PROFIBUS/MPI35TOUCHPANELCPHTCHCCPHTC001SIMATIC TOUCH PANEL 6AV6545-0BC15-2AX0Module - TP170B STN-COLOR-DISPLAY36SIMATIC_NETCPEIJHCCPEIJ001CP 343-1 IT Ethernet communication processor 6GK7343-1EX11-0XE0Module - SIMATIC NET CP 343-137SIMATIC_NETCPEIJHCCPEIJ002CP 343-1 IT Ethernet communication processor 6GK7343-1GX20-0XE0Module - SIMATIC NET CP 343-138SIMATIC_NETCPEIJHCCPEIJ003CP 343-1 IT Ethernet communication processor 6GK7343-1GX21-0XE0Module - SIMATIC NET CP 343-139SIMATIC_NETCPEIJHCCPEIJ004CP 343-1 IT Ethernet communication processor 6GK7343-1GX30-0XE0Module - SIMATIC NET CP 343-140SIMATIC_NETCPEIJHCCPEIJ005CP 343-1 IT Ethernet communication processor 6GK7343-1GX31-0XE0Module - SIMATIC NET CP 343-141SIMATIC_NETCPEIJHCCPEIJ006CP 343-1 IT Ethernet communication processor 6GK7343-1CX10-0XE0Module - SIMATIC NET CP 343-1 LEAN42SIMATIC_NETCPEIJHCCPEIJ007CP 343-1 IT Ethernet communication processor 6GK7343-1EX30-0XE0Module - SIMATIC NET CP 343-1 43CPU-FCPUIPHCCPUIP001CPU Unit CPU315F (1DP OR 2DP)6ES7315-6FF01-0AB0Module - CPU315F, 192KB44CPU-FCPUIPHCCPUIP002CPU Unit CPU315F (1DP OR 2DP)6ES7315-6FF04-0AB0Module - CPU315F, 384KB45CPU-F + CPCPUISHCCPUIS001CPU315-F unit with embedded Ethernet module6ES7315-2FJ14-0AB0Module - CPU315F, 512KB with SIMATIC NET CP

Equipment naming convention: MODULES

Slide14

13/10/2016

TE-MPE-MI

14

Machine

Layout name

Expert name

Layout ID

Owner

Booster

D(BCER155

RA155

5800556

TE-MPE

R(BAT17A

RA17A

5800738

TE-EPC / TE-MPE

D(BAT20A

RA20A

5827278

TE-MPE

D(BAT22F

RA22F

5827304

TE-MPE

R(BCER254

RA254

10410424

TE-EPC / TE-MPE

D(BAT26

RA26

5827298

TE-MPE

D(BAT30

RA305827300 TE-MPE D(BAT35RA355827301 TE-MPE D(BCER353RA3535800608 TE-MPE D(BCER361RA3615800610 TE-MPE D(BCER377RA3775800625 TE-MPE D(BAT45RA455827371 TE-MPE D(BAT49RA495800970 TE-MPE D(BAT52RA525827302 TE-MPE D(BAT56RA565827303 TE-MPE R(BAT59CRA595800975

TE-EPC / TE-MPE

D(BCER635

RA635

5800696

TE-MPE

D(BCER636

RA636

5800697

TE-MPE

D(BAT66

RA66

5827275

TE-MPE

D(BCER688

RA688

5800729

TE-MPE

D(BCER689

RA689

5800730

TE-MPE

D(BAT71

RA71

5800799

TE-MPE

RY02-BHP

RY02

5800979

TE-MPE

Racks:

LAYOUT DATABASE TEAM

Slide15

Barcode

labels:

Barcode label printing service

http://edms.cern.ch/nav/ST-00319913/10/2016

TE-MPE-MI

15

MODULES

CRATES

C -TYPE

A

-TYPE

RACKS

Slide16

13/10/2016

TE-MPE-MI

16

Systems are

used

to group all

assets

and

other

objects

into

logical

groups.

Systems can be structured into several

levels.

Systems are not mobile.

MASTER

REMOTE

REMOTE

REMOTE

WIC

SYSTEM

e.g

. WIC BOOSTER_AUX1

MASTER

REMOTE

REMOTE

REMOTE

MASTER

REMOTEREMOTEREMOTEAUX1AUX2…MACHINE e.g BOOSTERInforEAM objects: SYSTEMS

Slide17

13/10/2016

TE-MPE-MI

17

MACHINE

(LHC)

WIC PLC

(POINT 7)

RACK

CRATE

MODULES

POSITION

LOCATION

Equipment Graph

SYSTEM

SYSTEM

ASSET

ASSET

ASSET

Slide18

13/10/2016

TE-MPE-MI

18

Show on Map

Slide19

13/10/2016

TE-MPE-MI

19

Tree Structure

Drag and drop

functionality

Build

or

modify

the structure of the

objects

Slide20

13/10/2016

TE-MPE-MI

20

Record

View

Slide21

13/10/2016

TE-MPE-MI

21

List View: Example of a query

PERSONALISED FILTER

EXPORT TO EXCEL FUNCTION

Slide22

13/10/2016

TE-MPE-MI

22

Conclusion 1/2WIC

- CURRENT STATUS

All equipment labelled ( >2000 barcode label )

Structure populated

Spare inventory done

Start for real use in coming EYETS

Many features could be interesting to use (upload pictures ,link to EDMS docs

etc

…)

Slide23

13/10/2016

TE-MPE-MI

23

Conclusion 2/2PIC - FMCM

Equipment codes exist in

inforEAM

All equipment labelled (barcode)

Structure and relations to be implemented

BIS

MS local database

Equipment codes exist in

inforEAM

All equipment labelled (barcode)

Structure and relations to be implemented

Still discussion with experts needed…

Slide24

13/10/2016

TE-MPE-MI

24

Acknowledgements:inforEAM team:

Tsvetelin Krastev (

EN-ACE-EDM)

David

Widegren

(

EN-ACE-AMM)

Lukasz

Piotr Pater (

EN-ACE-AMM)

Layout BD:

Pascal Le Roux (BE-CO-DS)

GIS portal: Olivier Barriere (BE-CO-IN)

EDMS: Samy Chemli (EN-ACE)WIC team

Slide25

13/10/2016

TE-MPE-MI

25