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

4 5 OIS Views 36 5.1 Views of Version 12 ........................................................................................... 36 5.1.1 V_USEDCOMP ONENTS12 Vie w ....................................................…

100%1 / 144
ASM OIS/SIS Databases 14.0 (R16-2) / Interface Description 12/2016 Edition
3
Contents
1 General 7
2 Data Interface 8
3 Restrictions 9
4 Database 10
4.1 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 STATETEXT Table ............................................................................................ 14
4.5.1.2 FEEDERTYPE Table ......................................................................................... 14
4.5.1.3 BOARD Table .................................................................................................... 14
4.5.1.4 EVENT Table ..................................................................................................... 16
4.5.1.5 USEREVENT Table ........................................................................................... 16
4.5.1.6 PICKUPERROR Table....................................................................................... 17
4.5.1.7 USEDCOMPONENTS Table ............................................................................. 19
4.5.1.8 PARTNUMBER Table ........................................................................................ 19
4.5.1.9 COMPONENTSHAPE Table ............................................................................. 20
4.5.1.10 STATION Table ................................................................................................. 20
4.5.1.11 STATE Table ..................................................................................................... 20
4.5.1.12 STATESHARE Table ......................................................................................... 21
4.5.1.13 DATAMODEL Table .......................................................................................... 21
4.5.1.14 SHIFTWORK Table ........................................................................................... 21
4.5.1.15 EVENTTEXT Table ............................................................................................ 21
4.5.1.16 STATETRANSITION Table ................................................................................ 22
4.5.1.17 RECIPECHANGE Table .................................................................................... 24
4.5.1.18 SESSION Table ................................................................................................. 24
4.5.1.19 GantryState Table .............................................................................................. 25
4.5.1.20 PlocState Table ................................................................................................. 25
4.5.1.21 CompBlock Table .............................................................................................. 26
4.5.1.22 CompDetail Table .............................................................................................. 26
4.5.1.23 CompPosition Table........................................................................................... 28
4.5.1.24 Panel Table ........................................................................................................ 28
4.5.2 SIS Tables ......................................................................................................... 29
4.5.2.1 RECIPE Table ................................................................................................... 29
4.5.2.2 TRACK Table ..................................................................................................... 32
4.5.2.3 DATAMODEL Table .......................................................................................... 33
4.5.2.4 BOARD Table .................................................................................................... 33
4.5.2.5 HEAD Table ....................................................................................................... 34
4.5.2.6 RECIPEADDON Table....................................................................................... 34
4
5 OIS Views 36
5.1 Views of Version 12 ........................................................................................... 36
5.1.1 V_USEDCOMPONENTS12 View ...................................................................... 36
5.2 Views of Version 11 ........................................................................................... 36
5.2.1 V_PANEL11 View .............................................................................................. 36
5.2.2 V_BOARD11 View ............................................................................................. 36
5.3 Views of Version 10 ........................................................................................... 37
5.3.1 V_USEDCOMPONENTS10 View ...................................................................... 37
5.3.2 V_PlocState10 View .......................................................................................... 37
5.3.3 V_GantryState10 View ...................................................................................... 37
5.4 Views of Version 9 ............................................................................................. 37
5.4.1 V_BOARD9 View ............................................................................................... 37
5.4.2 V_EVENT9 View ................................................................................................ 37
5.4.3 V_STATION9 View ............................................................................................ 38
5.5 Views of Version 8 ............................................................................................. 38
5.5.1 V_BOARD8 View ............................................................................................... 38
5.5.2 V_Event8 View .................................................................................................. 38
5.6 Views of Version 7 ............................................................................................. 38
5.6.1 V_BOARD7 View ............................................................................................... 38
5.6.2 V_ PICKUPERROR7 View ................................................................................ 39
5.6.3 V_RECIPECHANGE7 View ............................................................................... 39
5.7 Views of Version 6 ............................................................................................. 39
5.7.1 V_USEDCOMPONENTS6 View ........................................................................ 39
5.7.2 V_PARTNUMBER6 View................................................................................... 39
5.7.3 V_COMPONENTSHAPE6 View ........................................................................ 40
5.7.4 V_PICKUPERROR6 View ................................................................................. 40
5.7.5 V_EVENT6 View ................................................................................................ 40
5.7.6 V_EVENTANDTEXT6 View ............................................................................... 40
5.7.7 V_USEREVENT6 View ...................................................................................... 40
5.7.8 V_USEREVENTANDTEXT6 View ..................................................................... 40
5.7.9 V_STATETRANSITION6 View .......................................................................... 40
5.8 Views of Version 5 ............................................................................................. 41
5.8.1 V_BOARD5 View ............................................................................................... 41
5.8.2 V_EVENT5 View ................................................................................................ 41
5.8.3 V_EVENTANDTEXT5 View ............................................................................... 41
5.8.4 V_USEREVENT5 View ...................................................................................... 41
5.8.5 V_USEREVENTANDTEXT5 View ..................................................................... 41
5.8.6 V_PICKUPERROR5 View ................................................................................. 41
5.8.7 V_USEDCOMPONENTS5 View ........................................................................ 42
5.8.8 V_STATION5 View ............................................................................................ 42
5.8.9 V_STATE5 View ................................................................................................ 42
5.8.10 V_STATESHARE5 View .................................................................................... 42
5.8.11 V_DATAMODEL5 View ..................................................................................... 42
5.9 Views of Version 4 ............................................................................................. 42
5.9.1 V_STATION4 View ............................................................................................ 42
5.10 Views of Version 3 ............................................................................................. 43
5.10.1 V_BOARD3 View ............................................................................................... 43
5.10.2 V_EVENT3 View ................................................................................................ 43
5.10.3 V_EVENTANDTEXT3 View ............................................................................... 43
5.10.4 V_USEREVENT3 View ...................................................................................... 43
5.10.5 V_USEREVENTANDTEXT3 View ..................................................................... 43
5.10.6 V_PICKUPERROR3 View ................................................................................. 43
5.10.7 V_USEDCOMPONENTS3 View ........................................................................ 43
5.10.8 V_STATION3 View ............................................................................................ 44
5.10.9 V_STATE3 View ................................................................................................ 44
5.10.10 V_STATESHARE3 View .................................................................................... 44
5.10.11 V_DATAMODEL3 View ..................................................................................... 44
5.11 Views of Version 2 ............................................................................................. 44
5.11.1 V_BOARD2 View ............................................................................................... 44
5.11.2 V_EVENT2 View ................................................................................................ 44
5.11.3 V_EVENTANDTEXT2 View ............................................................................... 44
5
5.11.4 V_USEREVENT2 View ...................................................................................... 45
5.11.5 V_USEREVENTANDTEXT2 View ..................................................................... 45
5.11.6 V_PICKUPERROR2 View ................................................................................. 45
5.11.7 V_USEDCOMPONENTS2 View ........................................................................ 45
5.11.8 V_STATION2 View ............................................................................................ 45
5.11.9 V_STATE2 View ................................................................................................ 45
5.11.10 V_STATESHARE2 View .................................................................................... 45
5.11.11 V_DATAMODEL2 View ..................................................................................... 46
5.12 Views of Version 1 ............................................................................................. 46
6 SIS Views 47
6.1 Views of Version 11 ........................................................................................... 47
6.1.1 V_BOARD11 View ............................................................................................. 47
6.2 Views of Version 7 ............................................................................................. 47
6.2.1 V_BOARD7 View ............................................................................................... 47
6.2.2 V_RECIPE7 View .............................................................................................. 47
6.3 Views of Version 6 ............................................................................................. 47
6.3.1 V_RECIPE6 View .............................................................................................. 47
6.3.2 V_BOARD6 View ............................................................................................... 48
6.3.3 V_TRACK6 View................................................................................................ 48
6.3.4 V_RECIPEADDON6 View ................................................................................. 48
6.4 Views of Version 5 ............................................................................................. 48
6.4.1 V_RECIPE5 View .............................................................................................. 48
6.4.2 V_HEAD5 View .................................................................................................. 48
6.4.3 V_BOARD5 View ............................................................................................... 48
6.4.4 V_TRACK4 View................................................................................................ 49
6.5 Views of Version 4 ............................................................................................. 49
6.5.1 V_RECIPE4 View .............................................................................................. 49
6.6 Views of Version 3 ............................................................................................. 49
6.6.1 V_RECIPE3 View .............................................................................................. 49
6.6.2 V_TRACK3 View................................................................................................ 49
6.6.3 V_DATAMODEL3 View ..................................................................................... 49
6.7 Views of Version 2 ............................................................................................. 49
6.8 Views of Version 1 ............................................................................................. 50
6.8.1 V_RECIPE View ................................................................................................ 50
6.8.2 V_TRACK View ................................................................................................. 50
6.8.3 V_DATAMODEL View ....................................................................................... 50
7 OIS State Machines 51
7.1 Machines with One Processing Area ................................................................. 51
7.2 Machines with Two Processing Areas ............................................................... 53
7.3 I-Placement ........................................................................................................ 53
7.4 Synchronous Dual Conveyor ............................................................................. 54
7.4.1 Station Software 605.xx ..................................................................................... 54
7.4.2 Station Software 7xx .......................................................................................... 55
7.5 MTC / WPC Track .............................................................................................. 56
7.6 Quad Lane Support ........................................................................................... 56
8 Appendix 58
8.1 Time Slices ........................................................................................................ 58
8.2 OIS Relevant Machine Error Messages ............................................................. 60