00900170-01_ID_OIS_SIS_16.0_R18-2_EN_DE.pdf - 第38页

ASM OIS/SIS Datab ases 16.0 (R18 -2) / Interf ace Description 11/2018 Edition 38 5.1.6 V_EVENT_160 View Supplies all colum ns of the EVENT table in th e following sequence: lId , dtTime , lBoardN umber , ucConveyor , uc …

100%1 / 150
ASM OIS/SIS Databases 16.0 (R18-2) / Interface Description 11/2018 Edition
37
5 OIS Views
5.1 Views of Version 16.0
**
The so marked attributes were extended from smallint to int.
***
The so marked attributes were extended from int to bigint.
5.1.1 V_PLOCSTATE_160 View
Supplies all columns of the PlocState table in the following sequence:
lId, ucConveyor, ucProcessingArea, sState, ***lIdSequence, dtTime
5.1.2 V_GANTRYSTATE_160 View
Supplies all columns of the GantryState table in the following sequence:
lId, ucNumber, ucProcessingArea, sState, sErrorReason, lBoardNumber, ***lIdSequence, dtTime
5.1.3 V_PANEL_160 View
Supplies all columns of the Panel table in the following sequence:
***lIdPanel, lCountProduced, lCountOmitted, CountAsAssembledPCB, strPlacementListName
5.1.4 V_PICKUPERROR_160 View
Supplies all columns of the PickupError table in the following sequence:
lId, dtTime, lBoardNumber, lError, strPartNumber, strComponentShape, ucTable, sTrack, ucTower,
sLevel, sReceptacle, ucHead, ucSegment, sNozzle, dtCreated, lType, lGantry, ***lIdSequence,
strFeederId
5.1.5 V_USEDCOMPONENTS_160 View
Supplies all joined columns of the CompBlock, CompDetail and CompPosition tables in the
following sequence:
lId, dtTime, dtCreated, lBoardNumber, sAccessTotal, **sRejectIdent,** sRejectVacuum,
**sTrackEmpty, **sPlacedComponents, **sAbsenceAfterPick, **sAbsenceBeforePlacement,
**sMaterialDefect, **sTreatmentError, **sDroppedError, **sIdentError, **sPresenceAfterPlacement,
**sPickupRetries, **sAttritionInfoVersion, ucTable, sTrack, ucTower, sLevel, sReceptacle,
lPartNumber, lComponentShape, lFeederType, strFeederId
ASM OIS/SIS Databases 16.0 (R18-2) / Interface Description 11/2018 Edition
38
5.1.6 V_EVENT_160 View
Supplies all columns of the EVENT table in the following sequence:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent, dtCreated,
ucProcessingMode, ***lIdSequence, ucSubConveyor
5.1.7 V_BOARD_160 View
Supplies all columns of the BOARD table in the following sequence:
lId, dtTime, strRecipe, strSetup, strBoard, lBoardNumber, ucConveyor, sDuration, dtRecipeStart,
dtSetupStart, strBarcode, ucStatus, dtCreated, lPanel, lSubConveyor, ucBoardSide, strLineJobId,
lBuildTimePA1, lBuildTimePA2, ***lIdPanel, strPCBGuid
5.2 Views of Version 15.1
5.2.1 V_FEEDERTYPE151 View
Supplies all columns of the FEEDERTYPE table in the following sequence:
IFeederType, strFeederTypeName, IFeederCode
5.2.2 V_STATION151 View
Supplies all columns of the STATION table in the following sequence:
strLine, strStation, ucProcessingArea, strText, strComputer, lId, lOrder, strMid, bMid,
strLineFullPath, strStationFullPath, strSWVersion, strTypeName, Species, strComputerName,
dtCreated
5.3 Views of Version 14.1
For the old event views the new printer states are filtered. The new views do not filter these events.
5.3.1 V_BOARD141 View
Supplies all columns of the BOARD table in the following sequence:
lId, dtTime, strRecipe, strSetup, strBoard, lBoardNumber, ucConveyor, sDuration, dtRecipeStart,
dtSetupStart, strBarcode, ucStatus, dtCreated, lPanel, lSubConveyor, ucBoardSide, strLineJobId,
lBuildTimePA1, lBuildTimePA2, lIdPanel, strPCBGuid
5.3.2 V_EVENT141 View
Supplies all columns of the EVENT table in the following sequence:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent, dtCreated,
ucProcessingMode, lIdSequence, ucSubConveyor
ASM OIS/SIS Databases 16.0 (R18-2) / Interface Description 11/2018 Edition
39
5.3.3 V_EVENTANDTEXT14 View
Supplies all 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, dtCreated,
ucProcessingMode, strName
5.3.4 V_STATETRANSITION141 View
Supplies all columns of the STATETRANSITION table in the following sequence:
lId, ucConveyor, ucProcessingArea, sState, dtTime, dtCreated, sEvent, ucProcessingMode
5.3.5 V_STATETRANSITIONANDTEXT141 View
Supplies all columns of the STATETRANSITION table with the appropriate event name and state
name from the EVENTTEXT and STATETEXT table in the following sequence:
lId, ucConveyor, sucProcessingArea, dtTime, sEvent, sState, EventName, StateName
5.3.6 V_SPLICEEVENT141 View
Supplies all columns of the SpliceEvent table with the appropriate component name from the
PARTNUMBER table in the following sequence:
lId, ucTable, sTrack, sDivision, dtSpliceTime, dtTime, dtCreated, , strPartNumber
5.4 Views of Version 14.0
5.4.1 V_STATION14 View
Supplies all columns of the STATION table in the following sequence:
strLine, strStation, ucProcessingArea, strText, strComputer, lId, lOrder, strMid, bMid,
strLineFullPath, strStationFullPath, strSWVersion, strTypeName, Species
5.5 Views of Version 12
5.5.1 V_USEDCOMPONENTS12 View
Supplies all joined columns of the CompBlock, CompDetail and CompPosition tables in the
following sequence:
lId, dtTime, dtCreated, lBoardNumber, sAccessTotal, sRejectIdent, sRejectVacuum, sTrackEmpty,
sPlacedComponents, sAbsenceAfterPick, sAbsenceBeforePlacement, sMaterialDefect,
sTreatmentError, sDroppedError, sIdentError, sPresenceAfterPlacement, sPickupRetries,
sAttritionInfoVersion, ucTable, sTrack, ucTower, sLevel, sReceptacle, lPartNumber,
lComponentShape, lFeederType, strFeederId