00900223-01_ID_OIS_SIS_17.0_R19-2_EN_DE.pdf - 第19页
ASM OIS/SIS Datab ases 17.0 (R19 -2) / Interf ace Description 11/2019 Edition 19 4.5.1.8 COMPONENT SHAPE Table COMPONENTSHAPE OIS name Data type Byte CI I P Identification number of the component shape name lComponentSha…
ASM OIS/SIS Databases 17.0 (R19-2) / Interface Description 11/2019 Edition
18
Sequence ID (internal use)
lIdSequence
bigint
8
Internal ID to mark entries referring to a "Board
Station Composite" object (for internal use only)
lBoardCompositeId
bigint
8
Unique feeder ID (available with station software
as of version 70x)
strFeederId
nvarchar(128)
256
Definition of lType (Error Types) values
0:
not defined
2:
conveyor error
3:
track error
4:
machine error
5:
general error
11:
placement error
12:
pickup error
13:
feeder error
14:
component measurement error
15:
processing component error
16:
fiducial measurement. error
NOTICE
Error types 2-5 are sent from stations with station software as of version 605.
Error types 11-16 are sent from stations with station software as of version 701.
The track number may contain the value -1. This indicates that the track is unknown and
it typically occurs if a MTC is used as feeder.
Definition of lGantry and ucHead
With introduction of the lGantry column, the semantic of the ucHead column has changed. The
content of ucHead column has moved into the lGantry column.
The ucHead now relates to the head position where the head is mounted on the gantry.
I.e., a gantry may carry one or two heads. For gantries with only one head, the head value is
always "1". For gantries, which are able to carry two heads, the following definition of ucHead is
used:
Definition of ucHead values
1:
head is located on the right position of the gantry
2:
head is located on the left position of the gantry
4.5.1.7 PARTNUMBER Table
PARTNUMBER
OIS name
Data type
Byte
CI
I
P
Identification number of the component name
lPartNumber
int
4
Name of the component, including path
strPartNumber
nvarchar(128)
512
Time when the data is written. Local server time
dtCreated
datetime
8
ASM OIS/SIS Databases 17.0 (R19-2) / Interface Description 11/2019 Edition
19
4.5.1.8 COMPONENTSHAPE Table
COMPONENTSHAPE
OIS name
Data type
Byte
CI
I
P
Identification number of the component shape
name
lComponentShape
int
4
Name of the component shape, including path
strComponentShape
nvarchar(128)
512
Time when the data is written. Local server time
dtCreated
datetime
8
4.5.1.9 STATION Table
STATION
OIS name
Data type
Byte
I
P
Name of the line
strLine
nvarchar(1024)
2048
Name of the station
strStation
nvarchar(128)
256
Number of placement areas
ucProcessingArea
tinyint
1
Text for the user
strText
nvarchar(32)
64
TCP/IP address or computer name of station
strComputer
nvarchar(255)
510
Identification number of the station
lId
int
4
Position of the stations within the line
lOrder
int
4
Machine identification MID
strMid
nvarchar(50)
100
Is a machine identification available?
bMid
bit
1
Complete line name (path included)
strLineFullPath
nvarchar(1024)
2048
Complete station name (path included)
strStationFullPath
nvarchar(1024)
2046
Station software version as a string
strSWVersion
nvarchar(128)
256
Station type name as a string. The available
station types are maintained and displayed in
SIPLACE Pro.
strTypeName
nvarchar(128)
256
Type of the station (printer or station)
Species
int
4
Host name of the station
strComputerName
nvarchar(255)
510
Time when the data is written. Local server time
dtCreated
datetime
8
Position of a device (station, printer, inspection
system, etc) in the line
DeviceInLinePosition
tinyint
1
Identification number of the lane assignment
(reference to LaneAssignment table)
IdLaneAssignment
bigint
8
Insert or update time of row
dtCreated
datetime
8
SIPLACE Pro number for station type
IStationType
long
4
Are monitoring events accepted for station
StationSelectionState
tinyint
2
Definition of Species values
0:
Placement machine
1:
Print
ASM OIS/SIS Databases 17.0 (R19-2) / Interface Description 11/2019 Edition
20
Definition of IOrder values
0:
Sequence of the placement machines. Other machines are not arranged.
Definition of StationSelectionState values
0:
Not selected for monitoring
1:
selected for monitoring
2:
selected for monitoring and SiplacePro data are available
4.5.1.10 STATE Table
Only relevant for OIS Client. Determines the display of the states there.
STATE
OIS name
Data type
Byte
I
P
8 user-defined states (T
1
– T
8
), availability (T
b
) and
the definition "show table states" (T
9
)
strTimeShare
nvarchar(32)
64
Name of share of time
strName
nvarchar(32)
64
Color of share of time
lColor
int
4
Show share of time
bDefined
bit
1
4.5.1.11 STATESHARE Table
Only relevant for OIS Client. Determines the display of the states there.
STATESHARE
OIS name
Data type
Byte
I
P
8 user-defined states (T
1
– T
8
), availability (T
b
) and
the definition "show table states" (T
9
)
strTimeShare
nvarchar(32)
64
Machine state, individual states of the state
machine
lState
int
4
Share of time
lPercent
int
4
4.5.1.12 DATAMODEL Table
DATAMODEL
OIS 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
Date/time at which this event occurred. Local
station time
dtTime
datetime
8
Value 4 of data type double e
dDouble
float
8