00900170-01_ID_OIS_SIS_16.0_R18-2_EN_DE.pdf - 第4页
4 4.5.2.6 RECIPEAD DON Table .................................................................................... 35 5 OIS Vie ws 37 5.1 Views o f Version 16.0 ............................................................…
ASM OIS/SIS Databases 16.0 (R18-2) / Interface Description 11/2018 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 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 PARTNUMBER Table ..................................................................................... 18
4.5.1.8 COMPONENTSHAPE Table ........................................................................... 18
4.5.1.9 STATION Table ............................................................................................... 18
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 ......................................................................................... 20
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 ........................................................................................ 26
4.5.1.21 Panel Table ..................................................................................................... 26
4.5.1.22 SpliceEvent Table ........................................................................................... 27
4.5.1.23 ProcessingLocation Table ............................................................................... 27
4.5.1.24 PlocAvailability Table....................................................................................... 28
4.5.1.25 LaneAssignment Table .................................................................................... 29
4.5.1.26 AssistCollection Table ..................................................................................... 29
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.0 ...................................................................................... 37
5.1.1 V_PLOCSTATE_160 View .............................................................................. 37
5.1.2 V_GANTRYSTATE_160 View ......................................................................... 37
5.1.3 V_PANEL_160 View ....................................................................................... 37
5.1.4 V_PICKUPERROR_160 View ......................................................................... 37
5.1.5 V_USEDCOMPONENTS_160 View ................................................................ 37
5.1.6 V_EVENT_160 View ....................................................................................... 38
5.1.7 V_BOARD_160 View....................................................................................... 38
5.2 Views of Version 15.1 ...................................................................................... 38
5.2.1 V_FEEDERTYPE151 View.............................................................................. 38
5.2.2 V_STATION151 View ...................................................................................... 38
5.3 Views of Version 14.1 ...................................................................................... 38
5.3.1 V_BOARD141 View ........................................................................................ 38
5.3.2 V_EVENT141 View ......................................................................................... 38
5.3.3 V_EVENTANDTEXT14 View ........................................................................... 39
5.3.4 V_STATETRANSITION141 View .................................................................... 39
5.3.5 V_STATETRANSITIONANDTEXT141 View .................................................... 39
5.3.6 V_SPLICEEVENT141 View ............................................................................. 39
5.4 Views of Version 14.0 ...................................................................................... 39
5.4.1 V_STATION14 View ........................................................................................ 39
5.5 Views of Version 12 ......................................................................................... 39
5.5.1 V_USEDCOMPONENTS12 View .................................................................... 39
5.6 Views of Version 11 ......................................................................................... 40
5.6.1 V_PANEL11 View ........................................................................................... 40
5.6.2 V_BOARD11 View .......................................................................................... 40
5.7 Views of Version 10 ......................................................................................... 40
5.7.1 V_USEDCOMPONENTS10 View .................................................................... 40
5.7.2 V_PlocState10 View ........................................................................................ 40
5.7.3 V_GantryState10 View .................................................................................... 40
5.8 Views of Version 9 ........................................................................................... 41
5.8.1 V_BOARD9 View ............................................................................................ 41
5.8.2 V_EVENT9 View ............................................................................................. 41
5.8.3 V_STATION9 View .......................................................................................... 41
5.9 Views of Version 8 ........................................................................................... 41
5.9.1 V_BOARD8 View ............................................................................................ 41
5.9.2 V_Event8 View ................................................................................................ 41
5.10 Views of Version 7 ........................................................................................... 41
5.10.1 V_BOARD7 View ............................................................................................ 41
5.10.2 V_ PICKUPERROR7 View .............................................................................. 42
5.10.3 V_RECIPECHANGE7 View ............................................................................. 42
5.11 Views of Version 6 ........................................................................................... 42
5.11.1 V_USEDCOMPONENTS6 View ...................................................................... 42
5.11.2 V_PARTNUMBER6 View ................................................................................ 42
5.11.3 V_COMPONENTSHAPE6 View ...................................................................... 43
5.11.4 V_PICKUPERROR6 View ............................................................................... 43
5.11.5 V_EVENT6 View ............................................................................................. 43
5.11.6 V_EVENTANDTEXT6 View ............................................................................. 43
5.11.7 V_USEREVENT6 View ................................................................................... 43
5.11.8 V_USEREVENTANDTEXT6 View ................................................................... 43
5.11.9 V_STATETRANSITION6 View ........................................................................ 43
5.12 Views of Version 5 ........................................................................................... 44
5.12.1 V_BOARD5 View ............................................................................................ 44
5.12.2 V_EVENT5 View ............................................................................................. 44
5.12.3 V_EVENTANDTEXT5 View ............................................................................. 44
5.12.4 V_USEREVENT5 View ................................................................................... 44
5.12.5 V_USEREVENTANDTEXT5 View ................................................................... 44
5.12.6 V_PICKUPERROR5 View ............................................................................... 44
5.12.7 V_USEDCOMPONENTS5 View ...................................................................... 45
5
5.12.8 V_STATION5 View .......................................................................................... 45
5.12.9 V_STATE5 View .............................................................................................. 45
5.12.10 V_STATESHARE5 View ................................................................................. 45
5.12.11 V_DATAMODEL5 View ................................................................................... 45
5.13 Views of Version 4 ........................................................................................... 45
5.13.1 V_STATION4 View .......................................................................................... 45
5.14 Views of Version 3 ........................................................................................... 46
5.14.1 V_BOARD3 View ............................................................................................ 46
5.14.2 V_EVENT3 View ............................................................................................. 46
5.14.3 V_EVENTANDTEXT3 View ............................................................................. 46
5.14.4 V_USEREVENT3 View ................................................................................... 46
5.14.5 V_USEREVENTANDTEXT3 View ................................................................... 46
5.14.6 V_PICKUPERROR3 View ............................................................................... 46
5.14.7 V_USEDCOMPONENTS3 View ...................................................................... 46
5.14.8 V_STATION3 View .......................................................................................... 47
5.14.9 V_STATE3 View .............................................................................................. 47
5.14.10 V_STATESHARE3 View ................................................................................. 47
5.14.11 V_DATAMODEL3 View ................................................................................... 47
5.15 Views of Version 2 ........................................................................................... 47
5.15.1 V_BOARD2 View ............................................................................................ 47
5.15.2 V_EVENT2 View ............................................................................................. 47
5.15.3 V_EVENTANDTEXT2 View ............................................................................. 47
5.15.4 V_USEREVENT2 View ................................................................................... 48
5.15.5 V_USEREVENTANDTEXT2 View ................................................................... 48
5.15.6 V_PICKUPERROR2 View ............................................................................... 48
5.15.7 V_USEDCOMPONENTS2 View ...................................................................... 48
5.15.8 V_STATION2 View .......................................................................................... 48
5.15.9 V_STATE2 View .............................................................................................. 48
5.15.10 V_STATESHARE2 View ................................................................................. 48
5.15.11 V_DATAMODEL2 View ................................................................................... 49
5.16 Views of Version 1 ........................................................................................... 49
6 SIS Views 50
6.1 Views of Version 16.0 ...................................................................................... 50
6.1.1 V_RECIPE_160 View ...................................................................................... 50
6.1.2 V_RECIPEADDON_160 View ......................................................................... 50
6.1.3 V_BOARD_160 View....................................................................................... 50
6.1.4 V_TRACK_160 View ....................................................................................... 50
6.1.5 V_HEAD_160 View ......................................................................................... 50
6.2 Views of Version 14.1 ...................................................................................... 51
6.2.1 V_RECIPE141 View ........................................................................................ 51
6.3 Views of Version 13.0 ...................................................................................... 51
6.3.1 V_RECIPE13 View .......................................................................................... 51
6.3.2 V_RECIPEADDON13 View ............................................................................. 51
6.4 Views of Version 11 ......................................................................................... 51
6.4.1 V_BOARD11 View .......................................................................................... 51
6.5 Views of Version 7 ........................................................................................... 51
6.5.1 V_BOARD7 View ............................................................................................ 51
6.5.2 V_RECIPE7 View ............................................................................................ 52
6.6 Views of Version 6 ........................................................................................... 52
6.6.1 V_RECIPE6 View ............................................................................................ 52
6.6.2 V_BOARD6 View ............................................................................................ 52
6.6.3 V_TRACK6 View ............................................................................................. 52
6.6.4 V_RECIPEADDON6 View ............................................................................... 52
6.7 Views of Version 5 ........................................................................................... 53
6.7.1 V_RECIPE5 View ............................................................................................ 53
6.7.2 V_HEAD5 View ............................................................................................... 53
6.7.3 V_BOARD5 View ............................................................................................ 53
6.7.4 V_TRACK4 View ............................................................................................. 53
6.8 Views of Version 4 ........................................................................................... 53
6.8.1 V_RECIPE4 View ............................................................................................ 53