00900135-02_ID_OIS_SIS_15.1_R18-1_DE_EN - 第78页

4 5 OIS Views 37 5.1 Views der Version 15.1 ...................................................................................... 37 5.1.1 View V_FEEDERTYPE151 ...........................................................…

100%1 / 148
ASM OIS/SIS Datenbanken 15.1 (R18-1) / Schnittstellenbeschreibung Ausgabe 05/2018
3
Inhalt
1 Allgemeines 7
2 Datenschnittstelle 8
3 Einschränkungen 9
4 Datenbank 10
4.1 Name der Datenbank ......................................................................................... 10
4.2 Version des Datenbank-Schemas ..................................................................... 10
4.3 Benutzer ............................................................................................................ 10
4.4 Datenbank-Wartung ........................................................................................... 11
4.4.1 "DB lösche alte Daten" ....................................................................................... 11
4.4.2 Automatische Reorganisation von Indexes und Statistik ................................... 12
4.4.3 Periodische manuelle Wartung der OIS-Datenbank in OIS V10.x / V11.x ......... 12
4.5 Tabellen ............................................................................................................. 13
4.5.1 OIS-Tabellen ...................................................................................................... 14
4.5.1.1 Tabelle STATETEXT ......................................................................................... 14
4.5.1.2 Tabelle FEEDERTYPE ...................................................................................... 14
4.5.1.3 Tabelle BOARD ................................................................................................. 14
4.5.1.4 Tabelle EVENT .................................................................................................. 16
4.5.1.5 Tabelle USEREVENT ........................................................................................ 16
4.5.1.6 Tabelle PICKUPERROR .................................................................................... 17
4.5.1.7 Tabelle USEDCOMPONENTS .......................................................................... 19
4.5.1.8 Tabelle PARTNUMBER ..................................................................................... 19
4.5.1.9 Tabelle COMPONENTSHAPE........................................................................... 20
4.5.1.10 Tabelle STATION .............................................................................................. 20
4.5.1.11 Tabelle STATE .................................................................................................. 21
4.5.1.12 Tabelle STATESHARE ...................................................................................... 21
4.5.1.13 Tabelle DATAMODEL ........................................................................................ 21
4.5.1.14 Tabelle SHIFTWORK......................................................................................... 21
4.5.1.15 Tabelle EVENTTEXT ......................................................................................... 21
4.5.1.16 Tabelle STATETRANSITION ............................................................................. 22
4.5.1.17 Tabelle RECIPECHANGE ................................................................................. 24
4.5.1.18 Tabelle SESSION .............................................................................................. 24
4.5.1.19 Tabelle GantryState ........................................................................................... 25
4.5.1.20 Tabelle PlocState ............................................................................................... 25
4.5.1.21 Tabelle CompBlock ............................................................................................ 26
4.5.1.22 Tabelle CompDetail ........................................................................................... 26
4.5.1.23 Tabelle CompPosition ........................................................................................ 28
4.5.1.24 Tabelle Panel ..................................................................................................... 28
4.5.1.25 Tabelle SpliceEvent ........................................................................................... 29
4.5.2 SIS-Tabellen ...................................................................................................... 30
4.5.2.1 Tabelle RECIPE ................................................................................................. 30
4.5.2.2 Tabelle TRACK .................................................................................................. 33
4.5.2.3 Tabelle DATAMODEL ........................................................................................ 34
4.5.2.4 Tabelle BOARD ................................................................................................. 34
4.5.2.5 Tabelle HEAD .................................................................................................... 35
4.5.2.6 Tabelle RECIPEADDON .................................................................................... 35
4
5 OIS Views 37
5.1 Views der Version 15.1 ...................................................................................... 37
5.1.1 View V_FEEDERTYPE151 ................................................................................ 37
5.1.2 View V_STATION151 ........................................................................................ 37
5.2 Views der Version 14.1 ...................................................................................... 37
5.2.1 View V_BOARD141 ........................................................................................... 37
5.2.2 View V_EVENT141 ............................................................................................ 37
5.2.3 View V_EVENTANDTEXT14 ............................................................................. 37
5.2.4 View V_STATETRANSITION141 ...................................................................... 38
5.2.5 View V_STATETRANSITIONANDTEXT141 ...................................................... 38
5.2.6 View V_SPLICEEVENT141 ............................................................................... 38
5.3 Views der Version 14.0 ...................................................................................... 38
5.3.1 View V_STATION14 .......................................................................................... 38
5.4 Views der Version 12 ......................................................................................... 38
5.4.1 View V_USEDCOMPONENTS12 ...................................................................... 38
5.5 Views der Version 11 ......................................................................................... 39
5.5.1 View V_PANEL11 .............................................................................................. 39
5.5.2 View V_BOARD11 ............................................................................................. 39
5.6 Views der Version 10 ......................................................................................... 39
5.6.1 View V_USEDCOMPONENTS10 ...................................................................... 39
5.6.2 View V_PlocState10 .......................................................................................... 39
5.6.3 View V_GantryState10 ...................................................................................... 39
5.7 Views der Version 9 ........................................................................................... 40
5.7.1 View V_BOARD9 ............................................................................................... 40
5.7.2 View V_EVENT9 ................................................................................................ 40
5.7.3 View V_STATION9 ............................................................................................ 40
5.8 Views der Version 8 ........................................................................................... 40
5.8.1 View V_BOARD8 ............................................................................................... 40
5.8.2 View V_Event8 .................................................................................................. 40
5.9 Views der Version 7 ........................................................................................... 40
5.9.1 View V_BOARD7 ............................................................................................... 40
5.9.2 View V_ PICKUPERROR7 ................................................................................ 41
5.9.3 View V_RECIPECHANGE7 ............................................................................... 41
5.10 Views der Version 6 ........................................................................................... 41
5.10.1 View V_USEDCOMPONENTS6 ........................................................................ 41
5.10.2 View V_PARTNUMBER6 ................................................................................... 41
5.10.3 View V_COMPONENTSHAPE6 ........................................................................ 42
5.10.4 View V_PICKUPERROR6 ................................................................................. 42
5.10.5 View V_EVENT6 ................................................................................................ 42
5.10.6 View V_EVENTANDTEXT6 ............................................................................... 42
5.10.7 View V_USEREVENT6 ...................................................................................... 42
5.10.8 View V_USEREVENTANDTEXT6 ..................................................................... 42
5.10.9 View V_STATETRANSITION6 .......................................................................... 42
5.11 Views der Version 5 ........................................................................................... 43
5.11.1 View V_BOARD5 ............................................................................................... 43
5.11.2 View V_EVENT5 ................................................................................................ 43
5.11.3 View V_EVENTANDTEXT5 ............................................................................... 43
5.11.4 View V_USEREVENT5 ...................................................................................... 43
5.11.5 View V_USEREVENTANDTEXT5 ..................................................................... 43
5.11.6 View V_PICKUPERROR5 ................................................................................. 43
5.11.7 View V_USEDCOMPONENTS5 ........................................................................ 44
5.11.8 View V_STATION5 ............................................................................................ 44
5.11.9 View V_STATE5 ................................................................................................ 44
5.11.10 View V_STATESHARE5 .................................................................................... 44
5.11.11 View V_DATAMODEL5 ..................................................................................... 44
5.12 Views der Version 4 ........................................................................................... 44
5.12.1 View V_STATION4 ............................................................................................ 44
5.13 Views der Version 3 ........................................................................................... 45
5.13.1 View V_BOARD3 ............................................................................................... 45
5.13.2 View V_EVENT3 ................................................................................................ 45
5.13.3 View V_EVENTANDTEXT3 ............................................................................... 45
5
5.13.4 View V_USEREVENT3 ...................................................................................... 45
5.13.5 View V_USEREVENTANDTEXT3 ..................................................................... 45
5.13.6 View V_PICKUPERROR3 ................................................................................. 45
5.13.7 View V_USEDCOMPONENTS3 ........................................................................ 45
5.13.8 View V_STATION3 ............................................................................................ 46
5.13.9 View V_STATE3 ................................................................................................ 46
5.13.10 View V_STATESHARE3 .................................................................................... 46
5.13.11 View V_DATAMODEL3 ..................................................................................... 46
5.14 Views der Version 2 ........................................................................................... 46
5.14.1 View V_BOARD2 ............................................................................................... 46
5.14.2 View V_EVENT2 ................................................................................................ 46
5.14.3 View V_EVENTANDTEXT2 ............................................................................... 46
5.14.4 View V_USEREVENT2 ...................................................................................... 47
5.14.5 View V_USEREVENTANDTEXT2 ..................................................................... 47
5.14.6 View V_PICKUPERROR2 ................................................................................. 47
5.14.7 View V_USEDCOMPONENTS2 ........................................................................ 47
5.14.8 View V_STATION2 ............................................................................................ 47
5.14.9 View V_STATE2 ................................................................................................ 47
5.14.10 View V_STATESHARE2 .................................................................................... 47
5.14.11 View V_DATAMODEL2 ..................................................................................... 48
5.15 Views der Version 1 ........................................................................................... 48
6 SIS Views 49
6.1 Views der Version 14.1 ...................................................................................... 49
6.1.1 View V_RECIPE141 .......................................................................................... 49
6.2 Views der Version 13.0 ...................................................................................... 49
6.2.1 View V_RECIPE13 ............................................................................................ 49
6.2.2 View V_RECIPEADDON13 ............................................................................... 49
6.3 Views der Version 11 ......................................................................................... 49
6.3.1 View V_BOARD11 ............................................................................................. 49
6.4 Views der Version 7 ........................................................................................... 50
6.4.1 View V_BOARD7 ............................................................................................... 50
6.4.2 View V_RECIPE7 .............................................................................................. 50
6.5 Views der Version 6 ........................................................................................... 50
6.5.1 View V_RECIPE6 .............................................................................................. 50
6.5.2 View V_BOARD6 ............................................................................................... 50
6.5.3 View V_TRACK6 ............................................................................................... 50
6.5.4 View V_RECIPEADDON6 ................................................................................. 50
6.6 Views der Version 5 ........................................................................................... 51
6.6.1 View V_RECIPE5 .............................................................................................. 51
6.6.2 View V_HEAD5 .................................................................................................. 51
6.6.3 View V_BOARD5 ............................................................................................... 51
6.6.4 View V_TRACK4 ............................................................................................... 51
6.7 Views der Version 4 ........................................................................................... 51
6.7.1 View V_RECIPE4 .............................................................................................. 51
6.8 Views der Version 3 ........................................................................................... 52
6.8.1 View V_RECIPE3 .............................................................................................. 52
6.8.2 View V_TRACK3 ............................................................................................... 52
6.8.3 View V_DATAMODEL3 ..................................................................................... 52
6.9 Views der Version 2 ........................................................................................... 52
6.10 Views der Version 1 ........................................................................................... 52
6.10.1 View V_RECIPE ................................................................................................ 52
6.10.2 View V_TRACK ................................................................................................. 52
6.10.3 View V_DATAMODEL ....................................................................................... 52
7 OIS Zustandsautomaten 53
7.1 Maschinen mit einem Bearbeitungsbereich ....................................................... 53
7.2 Maschinen mit zwei Bearbeitungsbereichen ...................................................... 55
7.3 I-Placement ........................................................................................................ 55