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

ASM OIS/SIS Databases 15.1 ( R18 - 1) / Interface De scription 05/2018 Edition 31 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 / 148
ASM OIS/SIS Databases 15.1 (R18-1) / Interface Description 05/2018 Edition
30
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
31
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
ASM OIS/SIS Databases 15.1 (R18-1) / Interface Description 05/2018 Edition
32
Definition of ucRecipeStatus values
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 values
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
Definition of DownloadMode values
0: Unknown
1: LineWiseDownload
2: StationWiseDownload
3: BarcodeDrivenAutoDownload
Definition of ucProductionMode values
0: Unknown
1: Normal production
2: New production introduction
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.