00900223-01_ID_OIS_SIS_17.0_R19-2_EN_DE.pdf - 第18页
ASM OIS/SIS Datab ases 17.0 (R19 -2) / Interf ace 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 …
ASM OIS/SIS Databases 17.0 (R19-2) / Interface Description 11/2019 Edition
17
4.5.1.5 EVENT Table
EVENT
OIS name
Data type
Byte
CI
I
P
Identification number of the station
(Reference to Table STATION)
lId
int
4
Date/time at which this event occurred. Local station
time
dtTime
datetime
8
Serial number of manufactured PCB
lBoardNumber
int
4
Conveyor belt 1 / 2
ucConveyor
tinyint
1
Processing area 1 / 2
ucProcessingArea
tinyint
1
Event number
sEvent
smallint
2
Time when the data is written. Local server time.
dtCreated
datetime
8
Processing mode
ucProcessingMode
tinyint
1
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
Conveyor sub-lane
ucSubConveyor
byte
1
4.5.1.6 PICKUPERROR Table
PICKUPERROR
OIS name
Data type
Byte
CI
I
P
Identification number of the station
(Reference to Table STATION)
lId
int
4
Date/time at which this error occurred.
Local station time
dtTime
datetime
8
Serial number of manufactured PCB
lBoardNumber
int
4
Error number
lError
int
4
Name of the component
strPartNumber
nvarchar(128)
256
Name of the component shape
strComponentShape
nvarchar(128)
256
Table/location from which the component was
retrieved
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
Head identification
ucHead
tinyint
1
Segment of head
ucSegment
tinyint
1
Designation of nozzle
sNozzle
smallint
2
Time when the data is written. Local server time
dtCreated
datetime
8
Error type
lType
int
4
Gantry number
lGantry
int
4
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