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

ASM OIS/SIS Datab ases 16.0 (R18 -2) / Interf ace Description 11/2018 Edition 32 Definition of ucRecip eStatus v alues 0 : Undefined 1 : Recipe is active: triggered by recipe download (SIS Server) 2 : Recipe is active: t…

100%1 / 150
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.
ASM OIS/SIS Databases 16.0 (R18-2) / Interface Description 11/2018 Edition
33
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
bigint
8
✓
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. Local server
Time
dtCreated
datetime
8
SIPLACE Pro used flag
ucUsed
tinyint
1
This ID uniquely identifies the track entry
within the TRACK table
lIdTrackEntry
bigint
8
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