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

ASM OIS/SIS Databases 15.1 ( R18 - 1) / Interface De scription 05/2018 Edition 30 4.5.2 SIS Tables 4.5.2.1 RECIPE Table RECIPE SIS name Data type B yt e I P Name of the reci pe strRecipe nvarchar(128) 256 Name of the lin…

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

4.5.1.25 SpliceEvent Table

SpliceEvent OIS name Data type Byte CI I P

Identification number of the station

(reference to STATION table)

lId int 4

Table/location from which the component was

retrieved

ucTable tinyint 1

Track number sTrack smallint 2

Division sDivision smallint 2

Identification number of the component name lPartNumber int 4

Date/time at which the data record was created.

Station time

dtTime datetime 8

Time when the splice occurred at the station dtSpliceTime datetime 8

Time when the data is written. Server Time dtCreated datetime 8

Sequence ID (internal use) lIdSequence int 4

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

4.5.2 SIS Tables

4.5.2.1 RECIPE Table

RECIPE SIS name Data type Byte I P

Name of the recipe strRecipe nvarchar(128) 256

Name of the line strLine nvarchar(1024) 2048

Name of the station strStation nvarchar(128) 256

Conveyor belt 1 / 2 ucConveyor tinyint 1

Name of the PCB

Obsolete due to new BOARD table!

strBoard nvarchar(128) 256

Name of the setup strSetup nvarchar(128) 256

Start time of the recipe. Server time. dtStart datetime 8 

End time of the recipe. Server time. dtEnd datetime 8

Reference number to the corresponding

setup in the TRACK table

lIdTrack int 4 

Number of boards to produce

Obsolete due to new BOARD table!

lLotSize long 4

Machine identification MID strMid nvarchar(50) 100

Is a machine identification available? bMid bit 1

Extra ID for production schedule

Obsolete due to new BOARD table!

strOrderId string 512

Cycle time in [ms] calculated from the

optimizer

lCycleTime long 4

Position of the stations within a line lOrder long 4

Top or bottom side of the board [Top,

Bottom]

Obsolete due to new BOARD table

strBoardSide nvarchar(128) 256

SIPLACE Pro name for station type strStationTypeName nvarchar(128) 256

SIPLACE Pro number for station type lStationType long 4

Is the recipe produced with component

barcode?

bComponentBarcode boolean 1

Indicates whether SIPLACE Pro has set the

StationCycleTime value

bStationCycleTime boolean 1

Station Cycle time in [ms] for the PCB

processing calculated from the optimizer

lStationCycleTime long 4

Indicates whether SIPLACE Pro has set the

ParallelProcessingFactor value

bParallelProcessingFactor boolean 1

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

Value 2 if this station works in I-Placement

mode

Value n if this station is in a cluster of n

parallel machines

Value 2*n if this station works in I-Placement

mode and is in a cluster of n parallel

machines

Otherwise value 1

lParallelProcessingFactor long 4

Unique ID for line job strLineJobGuid nvarchar(36) 72

Head ID, reference to HEAD table lIdHead int 4

Board ID, reference to BOARD table lIdBoard int 4

Bypassed flag bBypassed

bit 1

Time when the data is written. Server time dtCreated DATETIME 8

Unique ID for this recipe lIdRecipe int 4

Full path of the setup name strSetupFullPath nvarchar(1024) 2048

Full path of the recipe name strRecipeFullPath nvarchar(1024) 2048

Full path of the line name strLineFullPath nvarchar(1024) 2048

Full path of the station name strStationFullPath nvarchar(1024) 2048

Internal ID regarding the whispering ability of

the line

ucPosInBIDCluster tinyint 1

Counts up updates for this recipe triggered

by detection of alternative components

lACUpdateCount int 4

Status of the recipe entry ucRecipeStatus tinyint 1

Conveyor mode of the recipe ucConveyorMode tinyint 1

Value 1 if long board is active LBOActive bit 1

Value 1 if long board is active for a station LBOActiveStationInLine bit 1

Mode of the download DownloadMode tinyint 1

Mode of the production ucProductionMode tinyint 1

Definition of ucPosInBIDCluster

The ucPosInBIDCluster values describe the position of a station in a BID cluster.

Possible values of ucPosInBIDCluster:

0: Unknown

1: Station not in BID Cluster

2: First position

3: Middle position (neither first not last position)

4: Last position