00900223-01_ID_OIS_SIS_17.0_R19-2_EN_DE.pdf - 第3页

ASM OIS/SIS Datab ases 17.0 (R19 -2) / Interf ace Description 11/2019 Editi on 3 Contents 1 General 7 2 Data Interface 8 3 Restrictions 9 4 Database 10 4.1 Predefined name o f the Database ...............................…

100%1 / 150
All names identified by ® are registered trademarks of the ASM Assembly Systems GmbH & Co. KG. The
remaining trademarks in this publication may be trademarks whose use by third parties for their own purposes
could violate the rights of the owner.
We have reviewed the contents of this publication to ensure consistency with the hardware and software
described. Since variance cannot be precluded entirely, we cannot guarantee full consistency. However, the
information given in this publication is reviewed regularly and any necessary corrections are included in
subsequent editions.
Copyright © ASM Assembly Systems Technical data subject to change
ASM Assembly Systems GmbH & Co. KG Item-no.: 00900223-01
Rupert-Mayer-Strasse 44
81379 München
Germany
www.asm-smt.com
Alle mit dem Schutzrechtsvermerk ® gekennzeichneten Bezeichnungen sind eingetragene Marken der ASM
Assembly Systems GmbH & Co. KG. Die übrigen Bezeichnungen in dieser Schrift können Marken sein, deren
Benutzung durch Dritte für deren Zwecke die Rechte der Inhaber verletzen kann.
Wir haben den Inhalt der Druckschrift auf Übereinstimmung mit der beschriebenen Hard- und Software geprüft.
Dennoch können Abweichungen nicht ausgeschlossen werden, sodass wir für die vollständige Übereinstimmung
keine Gewähr übernehmen. Die Angaben in dieser Druckschrift werden regelmäßig überprüft und notwendige
Korrekturen sind in den nachfolgenden Auflagen enthalten.
Copyright © ASM Assembly Systems Änderungen vorbehalten
ASM Assembly Systems GmbH & Co. KG Artikel-Nr.: 00900223-01
Rupert-Mayer-Straße 44
81379 München
Deutschland
www.asm-smt.com
ASM OIS/SIS Databases 17.0 (R19-2) / Interface Description 11/2019 Edition
3
Contents
1 General 7
2 Data Interface 8
3 Restrictions 9
4 Database 10
4.1 Predefined name of the Database ................................................................... 10
4.2 Version of the Database Schema .................................................................... 10
4.3 Users ............................................................................................................... 10
4.4 Database Maintenance .................................................................................... 11
4.4.1 "DB remove old data" ...................................................................................... 11
4.4.2 Automatic Reorganization of Indexes and Statistics ........................................ 12
4.4.3 Periodic Manual Maintenance of the OIS Database in OIS V10.x / V11.x ........ 12
4.5 Tables ............................................................................................................. 13
4.5.1 OIS Tables ...................................................................................................... 14
4.5.1.1 Performance tips for querying OIS................................................................... 14
4.5.1.2 STATETEXT Table .......................................................................................... 15
4.5.1.3 FEEDERTYPE Table....................................................................................... 15
4.5.1.4 BOARD Table ................................................................................................. 15
4.5.1.5 EVENT Table .................................................................................................. 17
4.5.1.6 PICKUPERROR Table .................................................................................... 17
4.5.1.7 PARTNUMBER Table ..................................................................................... 18
4.5.1.8 COMPONENTSHAPE Table ........................................................................... 19
4.5.1.9 STATION Table ............................................................................................... 19
4.5.1.10 STATE Table ................................................................................................... 20
4.5.1.11 STATESHARE Table....................................................................................... 20
4.5.1.12 DATAMODEL Table ........................................................................................ 20
4.5.1.13 SHIFTWORK Table ......................................................................................... 21
4.5.1.14 EVENTTEXT Table ......................................................................................... 21
4.5.1.15 STATETRANSITION Table ............................................................................. 21
4.5.1.16 GantryState Table ........................................................................................... 23
4.5.1.17 PlocState Table ............................................................................................... 23
4.5.1.18 CompBlock Table ............................................................................................ 24
4.5.1.19 CompDetail Table ............................................................................................ 24
4.5.1.20 CompPosition Table ........................................................................................ 25
4.5.1.21 Panel Table ..................................................................................................... 26
4.5.1.22 SpliceEvent Table ........................................................................................... 26
4.5.1.23 ProcessingLocation Table ............................................................................... 27
4.5.1.24 PlocAvailability Table....................................................................................... 27
4.5.1.25 LaneAssignment Table .................................................................................... 28
4.5.1.26 AssistCollection Table ..................................................................................... 28
4.5.1.27 ErrorMessage Table ........................................................................................ 29
4.5.2 SIS Tables ....................................................................................................... 30
4.5.2.1 RECIPE Table ................................................................................................. 30
4.5.2.2 TRACK Table .................................................................................................. 33
4.5.2.3 DATAMODEL Table ........................................................................................ 34
4.5.2.4 BOARD Table ................................................................................................. 34
4.5.2.5 HEAD Table .................................................................................................... 35
4
4.5.2.6 RECIPEADDON Table .................................................................................... 35
5 OIS Views 37
5.1 Views of Version 16.1 ...................................................................................... 37
5.2 Views of Version 16.0 ...................................................................................... 37
5.2.1 V_PLOCSTATE_160 View .............................................................................. 37
5.2.2 V_GANTRYSTATE_160 View ......................................................................... 37
5.2.3 V_PANEL_160 View ....................................................................................... 37
5.2.4 V_PICKUPERROR_160 View ......................................................................... 37
5.2.5 V_USEDCOMPONENTS_160 View ................................................................ 37
5.2.6 V_EVENT_160 View ....................................................................................... 38
5.2.7 V_BOARD_160 View....................................................................................... 38
5.3 Views of Version 15.1 ...................................................................................... 38
5.3.1 V_FEEDERTYPE151 View.............................................................................. 38
5.3.2 V_STATION151 View ...................................................................................... 38
5.4 Views of Version 14.1 ...................................................................................... 38
5.4.1 V_BOARD141 View ........................................................................................ 38
5.4.2 V_EVENT141 View ......................................................................................... 38
5.4.3 V_EVENTANDTEXT14 View ........................................................................... 39
5.4.4 V_STATETRANSITION141 View .................................................................... 39
5.4.5 V_STATETRANSITIONANDTEXT141 View .................................................... 39
5.4.6 V_SPLICEEVENT141 View ............................................................................. 39
5.5 Views of Version 14.0 ...................................................................................... 39
5.5.1 V_STATION14 View ........................................................................................ 39
5.6 Views of Version 12 ......................................................................................... 39
5.6.1 V_USEDCOMPONENTS12 View .................................................................... 39
5.7 Views of Version 11 ......................................................................................... 40
5.7.1 V_PANEL11 View ........................................................................................... 40
5.7.2 V_BOARD11 View .......................................................................................... 40
5.8 Views of Version 10 ......................................................................................... 40
5.8.1 V_USEDCOMPONENTS10 View .................................................................... 40
5.8.2 V_PlocState10 View ........................................................................................ 40
5.8.3 V_GantryState10 View .................................................................................... 40
5.9 Views of Version 9 ........................................................................................... 41
5.9.1 V_BOARD9 View ............................................................................................ 41
5.9.2 V_EVENT9 View ............................................................................................. 41
5.9.3 V_STATION9 View .......................................................................................... 41
5.10 Views of Version 8 ........................................................................................... 41
5.10.1 V_BOARD8 View ............................................................................................ 41
5.10.2 V_Event8 View ................................................................................................ 41
5.11 Views of Version 7 ........................................................................................... 41
5.11.1 V_BOARD7 View ............................................................................................ 41
5.11.2 V_ PICKUPERROR7 View .............................................................................. 42
5.11.3 V_RECIPECHANGE7 View ............................................................................. 42
5.12 Views of Version 6 ........................................................................................... 42
5.12.1 V_USEDCOMPONENTS6 View ...................................................................... 42
5.12.2 V_PARTNUMBER6 View ................................................................................ 42
5.12.3 V_COMPONENTSHAPE6 View ...................................................................... 43
5.12.4 V_PICKUPERROR6 View ............................................................................... 43
5.12.5 V_EVENT6 View ............................................................................................. 43
5.12.6 V_EVENTANDTEXT6 View ............................................................................. 43
5.12.7 V_USEREVENT6 View ................................................................................... 43
5.12.8 V_USEREVENTANDTEXT6 View ................................................................... 43
5.12.9 V_STATETRANSITION6 View ........................................................................ 43
5.13 Views of Version 5 ........................................................................................... 44
5.13.1 V_BOARD5 View ............................................................................................ 44
5.13.2 V_EVENT5 View ............................................................................................. 44
5.13.3 V_EVENTANDTEXT5 View ............................................................................. 44
5.13.4 V_USEREVENT5 View ................................................................................... 44
5.13.5 V_USEREVENTANDTEXT5 View ................................................................... 44
5.13.6 V_PICKUPERROR5 View ............................................................................... 44