00194923-01_OIS_DB.pdf - 第14页
Schnittstellenbeschreibung OIS Datenbank Version 4.1 Interface Description OIS Database Version 4.1 14 von 47 4.7.8 V_STATION2 view Supplies all the columns of the STATION table in the following sequence: lVersion, strLi…
OIS Datenbank Version 4.1 Schnittstellenbeschreibung
OIS Database Version 4.1 Interface Description
13 von 47
4.7 Views of Version 2
4.7.1 V_BOARD2 view
Supplies all the columns of the BOARD table in the following sequence:
sVersion, lIp, dtTime, strRecipe, strSetup, strBoard, lBoardNumber, ucConveyor, sDuration, dtRecipeStart,
dtSetupStart, strBarcode, bAbort
4.7.2 V_EVENT2 view
Supplies all the columns of the EVENT table in the following sequence:
lIp, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent
4.7.3 V_EVENTANDTEXT2 view
Supplies all the columns of the EVENT table as well as the appropriate event name for the corresponding
event number from the EVENTTEXT table in the following sequence:
lIp, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent, strName
4.7.4 V_USEREVENT2 view
Supplies all the columns of the USEREVENT table in the following sequence:
lIp, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent
4.7.5 V_USEREVENTANDTEXT2 view
Supplies all the columns of the USEREVENT table as well as the appropriate event name for the
corresponding event number from the EVENTTEXT table in the following sequence:
lIp, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent, strName
4.7.6 V_PICKUPERROR2 view
Supplies all the columns of the PICKUPERROR table in the following sequence:
lIp, dtTime, lBoardNumber, lError, strPartNumber, strComponentShape, ucTable, sTrack, ucTower, sLevel,
sReceptacle, ucHead, ucSegment, sNozzle
4.7.7 V_USEDCOMPONENTS2 view
Supplies all the columns of the USEDCOMPONENTS table in the following sequence:
lIp, dtTime, lBoardNumber, sAccessTotal, sAccessError, ucTable, sTrack, ucTower, sLevel, sReceptacle

Schnittstellenbeschreibung OIS Datenbank Version 4.1
Interface Description OIS Database Version 4.1
14 von 47
4.7.8 V_STATION2 view
Supplies all the columns of the STATION table in the following sequence:
lVersion, strLine, strStation, ucProcessingArea, strText, strIP, lOrder
Note
The strIP column returns the OIS-internal IP address. This may differ from the actual IP address of the
machine.
4.7.9 V_STATE2 view
Supplies all the columns of the STATE table in the following sequence:
strTimeShare, strName, lColor, bDefined
4.7.10 V_STATESHARE2 view
Supplies all the columns of the STATESHARE table in the following sequence:
strTimeShare, lState, lPercent
4.7.11 V_DATAMODEL2 view
Supplies all the columns of the DATAMODEL table in the following sequence:
strName, lLong, strString, dtTime, dDouble
4.8 Views of Version 1
The views of version 1.0 will no longer be supported.

OIS Datenbank Version 4.1 Schnittstellenbeschreibung
OIS Database Version 4.1 Interface Description
15 von 47
5 State machines
5.1 Machines with one processing area
OIS shows the operator how long the placement machine was in a certain state. In fact, OIS actually collects
and records the events of the placement machine. The manner in which the states are calculated from these
events is shown at the end of this section. Each event is assigned a timestamp from the station.
Explanation of terms:
An action can set and/or clear one or more storage variables. An event has a unique name by which it is
identified. An event can be assigned an action which is always executed when this event occurs. A state has
a unique name. An action can be assigned to a state. This action is then always executed when this state is
entered. A storage variable exists for each state. Each storage variable can be set or cleared. A state
transition describes how the machine behaves when it receives an event. A state transition can contain two
different entries:
• The new state is specified directly.
• The new state is determined by reading the storage variable. If several storage variables are set, the
state with the highest priority is determined.
The following table describes a state machine with storage variables. The time a machine spends in a
particular state is assigned to that state.
Example: The machine is in state 10 OIS_WAIT_PCB_INSIDE (waiting for a PCB in the center conveyor).
Event 15 FIDUCIAL_ERROR now occurs. First, the action for the FIDUCIAL_ERROR event is executed,
"c14, c16, c17, c18“. Secondly, the state transition is performed, i.e. the machine switches to state 14
OIS_FIDUCIAL_ERROR. Thirdly, the action for the OIS_FIDUCIAL_ERROR state is executed, "m 14“.
Note
Events 125, 140 and 141 in the downstream state automaton are artificially generated events for conveyor
track 2. This means, for example, that if the machine sends event 25 from conveyor track 2, it must be input
to the state automaton as event 125. There is no change for events on conveyor track 1.