00900170-01_ID_OIS_SIS_16.0_R18-2_EN_DE.pdf - 第31页

ASM OIS/SIS Datab ases 16.0 (R18 -2) / Interf ace Description 11/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 …

100%1 / 150
ASM OIS/SIS Databases 16.0 (R18-2) / Interface Description 11/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
bigint
8
✓
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 16.0 (R18-2) / Interface Description 11/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
bigint
8
Board ID, reference to BOARD table
lIdBoard
bigint
8
Bypassed flag
bBypassed
bit
1
Time when the data is written. Local server
time
dtCreated
DATETIME
8
Unique ID for this recipe
lIdRecipe
bigint
8
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 16.0 (R18-2) / Interface Description 11/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.