00900045-01_ID_OIS_SIS_14.0_R16-2_DE_EN - 第76页

4 5 OIS Views 36 5.1 Views der Version 12 ......................................................................................... 36 5.1.1 View V_USEDCOMPONENTS12 .......................................................…

100%1 / 144
ASM OIS/SIS Datenbanken 14.0 (R16-2) / Schnittstellenbeschreibung Ausgabe 12/2016
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 .................................................................................................. 20
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 ........................................................................................... 24
4.5.1.20 Tabelle PlocState ............................................................................................... 25
4.5.1.21 Tabelle CompBlock ............................................................................................ 25
4.5.1.22 Tabelle CompDetail ........................................................................................... 26
4.5.1.23 Tabelle CompPosition ........................................................................................ 28
4.5.1.24 Tabelle Panel ..................................................................................................... 28
4.5.2 SIS-Tabellen ...................................................................................................... 29
4.5.2.1 Tabelle RECIPE ................................................................................................. 29
4.5.2.2 Tabelle TRACK .................................................................................................. 32
4.5.2.3 Tabelle DATAMODEL ........................................................................................ 33
4.5.2.4 Tabelle BOARD ................................................................................................. 33
4.5.2.5 Tabelle HEAD .................................................................................................... 34
4.5.2.6 Tabelle RECIPEADDON .................................................................................... 34
4
5 OIS Views 36
5.1 Views der Version 12 ......................................................................................... 36
5.1.1 View V_USEDCOMPONENTS12 ...................................................................... 36
5.2 Views der Version 11 ......................................................................................... 36
5.2.1 View V_PANEL11 .............................................................................................. 36
5.2.2 View V_BOARD11 ............................................................................................. 36
5.3 Views der Version 10 ......................................................................................... 37
5.3.1 View V_USEDCOMPONENTS10 ...................................................................... 37
5.3.2 View V_PlocState10 .......................................................................................... 37
5.3.3 View V_GantryState10 ...................................................................................... 37
5.4 Views der Version 9 ........................................................................................... 37
5.4.1 View V_BOARD9 ............................................................................................... 37
5.4.2 View V_EVENT9 ................................................................................................ 37
5.4.3 View V_STATION9 ............................................................................................ 38
5.5 Views der Version 8 ........................................................................................... 38
5.5.1 View V_BOARD8 ............................................................................................... 38
5.5.2 View V_Event8 .................................................................................................. 38
5.6 Views der Version 7 ........................................................................................... 38
5.6.1 View V_BOARD7 ............................................................................................... 38
5.6.2 View V_ PICKUPERROR7 ................................................................................ 39
5.6.3 View V_RECIPECHANGE7 ............................................................................... 39
5.7 Views der Version 6 ........................................................................................... 39
5.7.1 View V_USEDCOMPONENTS6 ........................................................................ 39
5.7.2 View V_PARTNUMBER6 ................................................................................... 39
5.7.3 View V_COMPONENTSHAPE6 ........................................................................ 40
5.7.4 View V_PICKUPERROR6 ................................................................................. 40
5.7.5 View V_EVENT6 ................................................................................................ 40
5.7.6 View V_EVENTANDTEXT6 ............................................................................... 40
5.7.7 View V_USEREVENT6 ...................................................................................... 40
5.7.8 View V_USEREVENTANDTEXT6 ..................................................................... 40
5.7.9 View V_STATETRANSITION6 .......................................................................... 40
5.8 Views der Version 5 ........................................................................................... 41
5.8.1 View V_BOARD5 ............................................................................................... 41
5.8.2 View V_EVENT5 ................................................................................................ 41
5.8.3 View V_EVENTANDTEXT5 ............................................................................... 41
5.8.4 View V_USEREVENT5 ...................................................................................... 41
5.8.5 View V_USEREVENTANDTEXT5 ..................................................................... 41
5.8.6 View V_PICKUPERROR5 ................................................................................. 41
5.8.7 View V_USEDCOMPONENTS5 ........................................................................ 42
5.8.8 View V_STATION5 ............................................................................................ 42
5.8.9 View V_STATE5 ................................................................................................ 42
5.8.10 View V_STATESHARE5 .................................................................................... 42
5.8.11 View V_DATAMODEL5 ..................................................................................... 42
5.9 Views der Version 4 ........................................................................................... 42
5.9.1 View V_STATION4 ............................................................................................ 42
5.10 Views der Version 3 ........................................................................................... 43
5.10.1 View V_BOARD3 ............................................................................................... 43
5.10.2 View V_EVENT3 ................................................................................................ 43
5.10.3 View V_EVENTANDTEXT3 ............................................................................... 43
5.10.4 View V_USEREVENT3 ...................................................................................... 43
5.10.5 View V_USEREVENTANDTEXT3 ..................................................................... 43
5.10.6 View V_PICKUPERROR3 ................................................................................. 43
5.10.7 View V_USEDCOMPONENTS3 ........................................................................ 43
5.10.8 View V_STATION3 ............................................................................................ 44
5.10.9 View V_STATE3 ................................................................................................ 44
5.10.10 View V_STATESHARE3 .................................................................................... 44
5.10.11 View V_DATAMODEL3 ..................................................................................... 44
5.11 Views der Version 2 ........................................................................................... 44
5.11.1 View V_BOARD2 ............................................................................................... 44
5.11.2 View V_EVENT2 ................................................................................................ 44
5.11.3 View V_EVENTANDTEXT2 ............................................................................... 44
5
5.11.4 View V_USEREVENT2 ...................................................................................... 45
5.11.5 View V_USEREVENTANDTEXT2 ..................................................................... 45
5.11.6 View V_PICKUPERROR2 ................................................................................. 45
5.11.7 View V_USEDCOMPONENTS2 ........................................................................ 45
5.11.8 View V_STATION2 ............................................................................................ 45
5.11.9 View V_STATE2 ................................................................................................ 45
5.11.10 View V_STATESHARE2 .................................................................................... 45
5.11.11 View V_DATAMODEL2 ..................................................................................... 46
5.12 Views der Version 1 ........................................................................................... 46
6 SIS Views 47
6.1 Views der Version 11 ......................................................................................... 47
6.1.1 View V_BOARD11 ............................................................................................. 47
6.2 Views der Version 7 ........................................................................................... 47
6.2.1 View V_BOARD7 ............................................................................................... 47
6.2.2 View V_RECIPE7 .............................................................................................. 47
6.3 Views der Version 6 ........................................................................................... 47
6.3.1 View V_RECIPE6 .............................................................................................. 47
6.3.2 View V_BOARD6 ............................................................................................... 48
6.3.3 View V_TRACK6 ............................................................................................... 48
6.3.4 View V_RECIPEADDON6 ................................................................................. 48
6.4 Views der Version 5 ........................................................................................... 48
6.4.1 View V_RECIPE5 .............................................................................................. 48
6.4.2 View V_HEAD5 .................................................................................................. 48
6.4.3 View V_BOARD5 ............................................................................................... 48
6.4.4 View V_TRACK4 ............................................................................................... 49
6.5 Views der Version 4 ........................................................................................... 49
6.5.1 View V_RECIPE4 .............................................................................................. 49
6.6 Views der Version 3 ........................................................................................... 49
6.6.1 View V_RECIPE3 .............................................................................................. 49
6.6.2 View V_TRACK3 ............................................................................................... 49
6.6.3 View V_DATAMODEL3 ..................................................................................... 49
6.7 Views der Version 2 ........................................................................................... 49
6.8 Views der Version 1 ........................................................................................... 50
6.8.1 View V_RECIPE ................................................................................................ 50
6.8.2 View V_TRACK ................................................................................................. 50
6.8.3 View V_DATAMODEL ....................................................................................... 50
7 OIS Zustandsautomaten 51
7.1 Maschinen mit einem Bearbeitungsbereich ....................................................... 51
7.2 Maschinen mit zwei Bearbeitungsbereichen ...................................................... 53
7.3 I-Placement ........................................................................................................ 53
7.4 Synchroner Doppeltransport .............................................................................. 54
7.4.1 Stationssoftware 605.xx ..................................................................................... 54
7.4.2 Stationssoftware 7xx .......................................................................................... 55
7.5 MTC-/WPC-Spur ................................................................................................ 56
7.6 "Quad Lane"-Unterstützung ............................................................................... 56
8 Anhang 58
8.1 Zeitanteile .......................................................................................................... 58
8.2 OIS-relevante Maschinen-Fehlermeldungen ..................................................... 60