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

ASM OIS/SIS Databases 14.0 ( R16 - 2) / Interface De scription 12/2016 Edition 30 Value 2 if this s tation works i n I - Placement mode Value n if this s tation is in a clus ter of n parallel machi nes Value 2*n if this …

100%1 / 144
ASM OIS/SIS Databases 14.0 (R16-2) / Interface Description 12/2016 Edition
29
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 14.0 (R16-2) / Interface Description 12/2016 Edition
30
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
31
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.