00194923-01_OIS_DB.pdf - 第12页

Schnittstellenbeschreibung OIS Datenbank Version 4.1 Interface Description OIS Database Version 4.1 12 von 47 4.6.4 V_USEREVENT3 view Supplies all the columns of the USEREVEN T table in the following sequenc e: lId, dtTi…

100%1 / 47
OIS Datenbank Version 4.1 Schnittstellenbeschreibung
OIS Database Version 4.1 Interface Description
11 von 47
4.4.10 SHIFTWORK table
SHIFTWORK OIS name Data type Byte I P
Name of shift strName nvarchar(32) 64
9
Starting time of shift dtStart datetime 8
4.4.11 EVENTTEXT table
EVENTTEXT OIS name Data type Byte I P
Event number sEvent smallint 2
Event name strName nvarchar(32) 64
4.5 Views of Version 4
4.5.1 V_STATION4 view
Supplies all the columns of the STATION table in the following sequence:
strLine, strStation, ucProcessingArea, strText, strComputer, lId, lOrder, strMid, bMid
4.6 Views of Version 3
4.6.1 V_BOARD3 view
Supplies all the columns of the BOARD table in the following sequence:
lId, dtTime, strRecipe, strSetup, strBoard, lBoardNumber, ucConveyor, sDuration, dtRecipeStart,
dtSetupStart, strBarcode, ucStatus
4.6.2 V_EVENT3 view
Supplies all the columns of the EVENT table in the following sequence:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent
4.6.3 V_EVENTANDTEXT3 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:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent, strName
Schnittstellenbeschreibung OIS Datenbank Version 4.1
Interface Description OIS Database Version 4.1
12 von 47
4.6.4 V_USEREVENT3 view
Supplies all the columns of the USEREVENT table in the following sequence:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent
4.6.5 V_USEREVENTANDTEXT3 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:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent, strName
4.6.6 V_PICKUPERROR3 view
Supplies all the columns of the PICKUPERROR table in the following sequence:
lId, dtTime, lBoardNumber, lError, strPartNumber, strComponentShape, ucTable, sTrack, ucTower, sLevel,
sReceptacle, ucHead, ucSegment, sNozzle
4.6.7 V_USEDCOMPONENTS3 view
Supplies all the columns of the USEDCOMPONENTS table in the following sequence:
lId, dtTime, lBoardNumber, sAccessTotal, sRejectIdent, sRejectVacuum, ucTable, sTrack, ucTower, sLevel,
sReceptacle
4.6.8 V_STATION3 view
Supplies all the columns of the STATION table in the following sequence:
strLine, strStation, ucProcessingArea, strText, strComputer, lId, lOrder
4.6.9 V_STATE3 view
Supplies all the columns of the STATE table in the following sequence:
strTimeShare, strName, lColor, bDefined
4.6.10 V_STATESHARE3 view
Supplies all the columns of the STATESHARE table in the following sequence:
strTimeShare, lState, lPercent
4.6.11 V_DATAMODEL3 view
Supplies all the columns of the DATAMODEL table in the following sequence:
strName, lLong, strString, dtTime, dDouble
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