00900045-01_ID_OIS_SIS_14.0_R16-2_DE_EN - 第31页

ASM OIS/SIS Databases 14.0 ( R16 - 2) / Interface De scription 12/2016 Edition 31 Definition of ucRecipeSta tus 0 : Undefined 1 : Recipe is active : tr iggered by recipe d ownload ( SIS Server) 2 : Recipe is active : tr …

ASM OIS/SIS Databases 14.0 (R16-2) / Interface Description 12/2016 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

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

ASM OIS/SIS Databases 14.0 (R16-2) / Interface Description 12/2016 Edition

Definition of ucRecipeStatus

0: Undefined

1: Recipe is active: triggered by recipe download (SIS Server)

2: Recipe is active: triggered by detection of alternative components

3: Recipe is closed: triggered by subsequent recipe download

4: Recipe is closed: triggered by detection of alternative components

5: Recipe is closed: triggered by the reception of a board produced based on a subsequent recipe

Definition of ucConveyorMode

1: Single lane conveyor

2: Asynchronous dual lane conveyor

3: Synchronous dual lane conveyor

4: Quad Lane in single lane conveyor

5: Quad Lane in asynchronous conveyor mode

6: Quad Lane in synchronous conveyor mode

Obsolete Columns in RECIPE Table

To meet the requirements of new features like Quad Lane support, a recipe may contain assembly

information for more than one board. Until now there was a 1:1 relation between recipe and board.

The board attributes were contained in the RECIPE table. With a 1: n relation between recipe and

boards this is no longer possible.

Starting with SIS data model version 106, the board related information is stored in the SIS BOARD

table. For compatibility reasons, the attributes of the first board entries are stored in the RECIPE

table (using the obsolete marked columns) as well.

ASM OIS/SIS Databases 14.0 (R16-2) / Interface Description 12/2016 Edition

4.5.2.2 TRACK Table

TRACK SIS name Data type Byte I P

Reference number of the setup.

The reference number is equal for all

elements of a station´s setup.

lIdTrack int 4 

Feeder type sFeederType smallint 2

Table/location ucTable tinyint 1

Track number sTrack smallint 2

Tower (MTC only, otherwise dummy) ucTower tinyint 1

Level (WPC or MTC only, otherwise dummy) sLevel smallint 2

Division sReceptacle smallint 2

Name of the component strPartNumber nvarchar(128) 256

Name of the component shape strComponentShape nvarchar(128) 256

SIPLACE Pro number for feeder type lFeederType long 4

SIPLACE Pro name for feeder type strFeederTypeName nvarchar(128) 256

SIPLACE Pro number for table type lTableType long 4

SIPLACE Pro name for table type strTableTypeName nvarchar(128) 256

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

SIPLACE Pro used flag ucUsed tinyint 1

This ID uniquely identifies the track entry

within the TRACK table

lIdTrackEntry int 4

Full path of the component (part number)

name

strComponentFullPath nvarchar(1024) 2048

Full path of the component shape name strComponentShapeFullPath nvarchar(1024) 2048

Definition of ucUsed

The ucUsed values indicate whether a track is used by the referred recipe.

Possible values of ucUsed:

0: Undefined

1: True

2: False