00900170-01_ID_OIS_SIS_16.0_R18-2_EN_DE - 第78页

4 4.5.2.6 Tabelle RECIPEA DDON ................................................................................. 36 5 OIS Vie ws 38 5.1 Views der Versi on 16.0 ............................................................…

100%1 / 150
ASM OIS/SIS Datenbanken 16.0 (R18-2) / Schnittstellenbeschreibung Ausgabe 11/2018
3
Inhalt
1 Allgemeines 7
2 Datenschnittstelle 8
3 Einschränkungen 9
4 Datenbank 10
4.1 Vorbelegter 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 PARTNUMBER ................................................................................... 18
4.5.1.8 Tabelle COMPONENTSHAPE ........................................................................ 18
4.5.1.9 Tabelle STATION ............................................................................................ 19
4.5.1.10 Tabelle STATE ................................................................................................ 20
4.5.1.11 Tabelle STATESHARE .................................................................................... 20
4.5.1.12 Tabelle DATAMODEL ..................................................................................... 20
4.5.1.13 Tabelle SHIFTWORK ...................................................................................... 20
4.5.1.14 Tabelle EVENTTEXT....................................................................................... 21
4.5.1.15 Tabelle STATETRANSITION ........................................................................... 21
4.5.1.16 Tabelle GantryState ........................................................................................ 23
4.5.1.17 Tabelle PlocState ............................................................................................ 24
4.5.1.18 Tabelle CompBlock ......................................................................................... 24
4.5.1.19 Tabelle CompDetail ......................................................................................... 24
4.5.1.20 Tabelle CompPosition ..................................................................................... 26
4.5.1.21 Tabelle Panel .................................................................................................. 26
4.5.1.22 Tabelle SpliceEvent ......................................................................................... 27
4.5.1.23 Tabelle ProcessingLocation............................................................................. 27
4.5.1.24 Tabelle PlocAvailability .................................................................................... 28
4.5.1.25 Tabelle LaneAssignment ................................................................................. 29
4.5.1.26 Tabelle AssistCollection .................................................................................. 29
4.5.1.27 Tabelle ErrorMessage ..................................................................................... 30
4.5.2 SIS-Tabellen ................................................................................................... 31
4.5.2.1 Tabelle RECIPE .............................................................................................. 31
4.5.2.2 Tabelle TRACK ............................................................................................... 34
4.5.2.3 Tabelle DATAMODEL ..................................................................................... 35
4.5.2.4 Tabelle BOARD ............................................................................................... 35
4.5.2.5 Tabelle HEAD ................................................................................................. 36
4
4.5.2.6 Tabelle RECIPEADDON ................................................................................. 36
5 OIS Views 38
5.1 Views der Version 16.0 .................................................................................... 38
5.1.1 View V_PLOCSTATE_160 .............................................................................. 38
5.1.2 View V_GANTRYSTATE_160 ......................................................................... 38
5.1.3 View V_PANEL_160 ....................................................................................... 38
5.1.4 View V_PICKUPERROR_160 ......................................................................... 38
5.1.5 View V_USEDCOMPONENTS_160 ................................................................ 38
5.1.6 View V_EVENT_160 ....................................................................................... 39
5.1.7 View V_BOARD_160....................................................................................... 39
5.2 Views der Version 15.1 .................................................................................... 39
5.2.1 View V_FEEDERTYPE151 ............................................................................. 39
5.2.2 View V_STATION151 ...................................................................................... 39
5.3 Views der Version 14.1 .................................................................................... 39
5.3.1 View V_BOARD141 ........................................................................................ 39
5.3.2 View V_EVENT141 ......................................................................................... 39
5.3.3 View V_EVENTANDTEXT14 ........................................................................... 40
5.3.4 View V_STATETRANSITION141 .................................................................... 40
5.3.5 View V_STATETRANSITIONANDTEXT141 .................................................... 40
5.3.6 View V_SPLICEEVENT141 ............................................................................. 40
5.4 Views der Version 14.0 .................................................................................... 40
5.4.1 View V_STATION14 ........................................................................................ 40
5.5 Views der Version 12....................................................................................... 40
5.5.1 View V_USEDCOMPONENTS12 .................................................................... 40
5.6 Views der Version 11....................................................................................... 41
5.6.1 View V_PANEL11 ........................................................................................... 41
5.6.2 View V_BOARD11 .......................................................................................... 41
5.7 Views der Version 10....................................................................................... 41
5.7.1 View V_USEDCOMPONENTS10 .................................................................... 41
5.7.2 View V_PlocState10 ........................................................................................ 41
5.7.3 View V_GantryState10 .................................................................................... 41
5.8 Views der Version 9 ........................................................................................ 42
5.8.1 View V_BOARD9 ............................................................................................ 42
5.8.2 View V_EVENT9 ............................................................................................. 42
5.8.3 View V_STATION9 .......................................................................................... 42
5.9 Views der Version 8 ........................................................................................ 42
5.9.1 View V_BOARD8 ............................................................................................ 42
5.9.2 View V_Event8 ................................................................................................ 42
5.10 Views der Version 7 ........................................................................................ 42
5.10.1 View V_BOARD7 ............................................................................................ 42
5.10.2 View V_ PICKUPERROR7 .............................................................................. 43
5.10.3 View V_RECIPECHANGE7 ............................................................................. 43
5.11 Views der Version 6 ........................................................................................ 43
5.11.1 View V_USEDCOMPONENTS6 ...................................................................... 43
5.11.2 View V_PARTNUMBER6 ................................................................................ 43
5.11.3 View V_COMPONENTSHAPE6 ...................................................................... 44
5.11.4 View V_PICKUPERROR6 ............................................................................... 44
5.11.5 View V_EVENT6 ............................................................................................. 44
5.11.6 View V_EVENTANDTEXT6 ............................................................................. 44
5.11.7 View V_USEREVENT6 ................................................................................... 44
5.11.8 View V_USEREVENTANDTEXT6 ................................................................... 44
5.11.9 View V_STATETRANSITION6 ........................................................................ 44
5.12 Views der Version 5 ........................................................................................ 45
5.12.1 View V_BOARD5 ............................................................................................ 45
5.12.2 View V_EVENT5 ............................................................................................. 45
5.12.3 View V_EVENTANDTEXT5 ............................................................................. 45
5.12.4 View V_USEREVENT5 ................................................................................... 45
5.12.5 View V_USEREVENTANDTEXT5 ................................................................... 45
5.12.6 View V_PICKUPERROR5 ............................................................................... 45
5.12.7 View V_USEDCOMPONENTS5 ...................................................................... 46
5
5.12.8 View V_STATION5 .......................................................................................... 46
5.12.9 View V_STATE5 .............................................................................................. 46
5.12.10 View V_STATESHARE5 ................................................................................. 46
5.12.11 View V_DATAMODEL5 ................................................................................... 46
5.13 Views der Version 4 ........................................................................................ 46
5.13.1 View V_STATION4 .......................................................................................... 46
5.14 Views der Version 3 ........................................................................................ 47
5.14.1 View V_BOARD3 ............................................................................................ 47
5.14.2 View V_EVENT3 ............................................................................................. 47
5.14.3 View V_EVENTANDTEXT3 ............................................................................. 47
5.14.4 View V_USEREVENT3 ................................................................................... 47
5.14.5 View V_USEREVENTANDTEXT3 ................................................................... 47
5.14.6 View V_PICKUPERROR3 ............................................................................... 47
5.14.7 View V_USEDCOMPONENTS3 ...................................................................... 47
5.14.8 View V_STATION3 .......................................................................................... 48
5.14.9 View V_STATE3 .............................................................................................. 48
5.14.10 View V_STATESHARE3 ................................................................................. 48
5.14.11 View V_DATAMODEL3 ................................................................................... 48
5.15 Views der Version 2 ........................................................................................ 48
5.15.1 View V_BOARD2 ............................................................................................ 48
5.15.2 View V_EVENT2 ............................................................................................. 48
5.15.3 View V_EVENTANDTEXT2 ............................................................................. 48
5.15.4 View V_USEREVENT2 ................................................................................... 49
5.15.5 View V_USEREVENTANDTEXT2 ................................................................... 49
5.15.6 View V_PICKUPERROR2 ............................................................................... 49
5.15.7 View V_USEDCOMPONENTS2 ...................................................................... 49
5.15.8 View V_STATION2 .......................................................................................... 49
5.15.9 View V_STATE2 .............................................................................................. 49
5.15.10 View V_STATESHARE2 ................................................................................. 49
5.15.11 View V_DATAMODEL2 ................................................................................... 50
5.16 Views der Version 1 ........................................................................................ 50
6 SIS Views 51
6.1 Views der Version 16.0 .................................................................................... 51
6.1.1 View V_RECIPE_160 ...................................................................................... 51
6.1.2 View V_RECIPEADDON_160 ......................................................................... 51
6.1.3 View V_BOARD_160....................................................................................... 51
6.1.4 View V_TRACK_160 ....................................................................................... 51
6.1.5 View V_HEAD_160 ......................................................................................... 51
6.2 Views der Version 14.1 .................................................................................... 52
6.2.1 View V_RECIPE141 ........................................................................................ 52
6.3 Views der Version 13.0 .................................................................................... 52
6.3.1 View V_RECIPE13 .......................................................................................... 52
6.3.2 View V_RECIPEADDON13 ............................................................................. 52
6.4 Views der Version 11....................................................................................... 52
6.4.1 View V_BOARD11 .......................................................................................... 52
6.5 Views der Version 7 ........................................................................................ 52
6.5.1 View V_BOARD7 ............................................................................................ 52
6.5.2 View V_RECIPE7 ............................................................................................ 53
6.6 Views der Version 6 ........................................................................................ 53
6.6.1 View V_RECIPE6 ............................................................................................ 53
6.6.2 View V_BOARD6 ............................................................................................ 53
6.6.3 View V_TRACK6 ............................................................................................. 53
6.6.4 View V_RECIPEADDON6 ............................................................................... 53
6.7 Views der Version 5 ........................................................................................ 54
6.7.1 View V_RECIPE5 ............................................................................................ 54
6.7.2 View V_HEAD5 ............................................................................................... 54
6.7.3 View V_BOARD5 ............................................................................................ 54
6.7.4 View V_TRACK4 ............................................................................................. 54
6.8 Views der Version 4 ........................................................................................ 54
6.8.1 View V_RECIPE4 ............................................................................................ 54