00900135-02_ID_OIS_SIS_15.1_R18-1_DE_EN - 第37页

ASM OIS/SIS Databases 15.1 ( R18 - 1) / Interface De scription 05/2018 Edition 37 5 OIS Views 5.1 Views of Versi on 15.1 5.1.1 V_FEEDERTYPE 151 View Supplies all column s of the FEEDERTYP E table in the foll owing sequen…

ASM OIS/SIS Databases 15.1 (R18-1) / Interface Description 05/2018 Edition

Definition of IParallelProcessingFactor values

2: if the station runs in I-Placement mode

n: if the station runs in a cluster of n parallel stations

2*n: if the station runs in I-Placement mode and in a cluster of n parallel stations

1: in all other cases

ASM OIS/SIS Databases 15.1 (R18-1) / Interface Description 05/2018 Edition

5 OIS Views

5.1 Views of Version 15.1

5.1.1 V_FEEDERTYPE151 View

Supplies all columns of the FEEDERTYPE table in the following sequence:

IFeederType, strFeederTypeName, IFeederCode

5.1.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.2 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.2.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.2.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

5.2.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

ASM OIS/SIS Databases 15.1 (R18-1) / Interface Description 05/2018 Edition

5.2.4 V_STATETRANSITION141 View

Supplies all columns of the STATETRANSITION table in the following sequence:

lId, ucConveyor, ucProcessingArea, sState, dtTime, dtCreated, sEvent, ucProcessingMode

5.2.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.2.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.3 Views of Version 14.0

5.3.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.4 Views of Version 12

5.4.1 V_USEDCOMPONENTS12 View

Supplies all joined columns of the CompBlock, CompDetail und 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