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

ASM OIS/SIS Datab ases 16.0 (R18 -2) / Interf ace Description 11/2018 Edition 34 4.5.2.3 DATAMODEL T able DATAMODEL SIS name Data type Byte I P Name of the entry strName nvarchar(32) 64 Value 1 of data type int lLong int…

100%1 / 150
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
ASM OIS/SIS Databases 16.0 (R18-2) / Interface Description 11/2018 Edition
34
4.5.2.3 DATAMODEL Table
DATAMODEL
SIS name
Data type
Byte
I
P
Name of the entry
strName
nvarchar(32)
64
Value 1 of data type int
lLong
int
4
Value 2 of data type string
strString
nvarchar(255)
510
Value 3 of data type datetime
dtTime
datetime
8
Value 4 of data type double
dDouble
float
8
4.5.2.4 BOARD Table
The BOARD table contains all board related entries. The link between the RECIPE table entry and
the BOARD table entries is the lIdBoard attribute. I.e. if a recipe gets downloaded the board
information is extracted and stored separately in the BOARD table. All new board entries are
getting stored with the same lIdBoard identifier. This identifier is also contained in the RECIPE
table entry to establish the link between the RECIPE table entry and BOARD table entries.
BOARD
SIS name
Data type
Byte
CI
I
P
Board ID
lIdBoard
bigint
8
✓
Size of the lot
lLotSize
int
4
Board name as string
strBoardName
nvarchar(128)
256
Order ID
strOrderId
nvarchar(256)
512
Board side
ucBoardSide
tinyint
1
Subconveyor ID
lSubConveyor
int
4
Time when the data is written. Local server
time
dtCreated
datetime
8
Full path of the board name
strBoardFullPath
nvarchar(1024)
2048
Count of components
lComponentCount
int
4
Total count of panels. I.e. the number of
panels of this type that have to be produced.
lPanelLotSize
int
4
Definition of ucBoardSide
The ucBoardSide describes whether the top or bottom side of the board has been processed.
Possible values of ucBoardSide:
0:
Undefined
1:
Top side
2:
Bottom side
ASM OIS/SIS Databases 16.0 (R18-2) / Interface Description 11/2018 Edition
35
4.5.2.5 HEAD Table
The HEAD table is new in the SIS data model version 106 and contains head and gantry related
information. There is a 1:n relation between RECIPE table entry and HEAD table entries. The link
between the RECIPE table entry and HEAD table entries is realized via the lIdHead identifier. The
link mechanism between the RECIPE table entry and HEAD table entries is the same mechanism
as between the RECIPE table entry and BOARD table entries.
HEAD
SIS name
Data type
Byte
CI
I
P
Head ID
lIdHead
bigint
8
✓
Gantry number
lGantry
int
4
Head number
ucHead
tinyint
1
Head type as string
strHeadType
nvarchar(128)
256
Bypassed flag
bBypassed
bit
1
Time when the data is written. Local erver
time
dtCreated
datetime
8
4.5.2.6 RECIPEADDON Table
This table contains additional recipe information and has been introduced with SIS 8.0.
RECIPEADDON
SIS name
Data type
Byte
CI
I
P
ID for this recipe related entry
lIdRecipe
bigint
8
✓
Processing Area: either 1 or 2
ucProcessingArea
tinyint
1
See below
ucPlacementMode
tinyint
1
Time from first measurement to last
placement activity
lBuildTime
int
4
StationTactTime = Build Time + Transport
Time
lStationTactTime
int
4
See below
lParallelProcessingFactor
int
4
Value 1 if the head steps are using more
than one stopper position
SteppingActive
bit
1
Definition of ucPlacementMode values
0:
Undefined
1:
Alternating mode (both gantries place on both lanes)
2:
I-Placement mode (right gantry places on the right lane, left gantry places on the left lane)
3:
Right (both gantries are placing on the right lane only)
4:
Left (both gantries are placing on the left lane only)