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

ASM OIS/SIS Datab ases 16.0 (R18 -2) / Interf ace Description 11/2018 Edition 26 4.5.1.20 CompPosition Table CompPosition OIS name Data type Byte CI I P Identification number of the station (reference to STATION table) l…

100%1 / 150
ASM OIS/SIS Databases 16.0 (R18-2) / Interface Description 11/2018 Edition
25
Number of consecutive pickup attempts that
does not cause an track-empty error.
sPickupRetries
int
4
Version of the information source for the reject
data
sAttritionInfoVersion
int
4
Definition of sRejectVacuum
sRejectVacuum = SUM(sAbsenceAfterPick, sComponentAbsenceBeforePlacement,
sTreatmentError, sDroppedError, sComponentAbsenceAfterPlacement,
sPickupRetries)
Definition of sRejectIdent
sRejectIdent = SUM(sComponentMaterialDefect, sIdentError)
Definition of sPlacedComponents values
-1:
Undefined for all data records issued by a station with a station software version < 708
0:
No successful placement (i. e. pass-through mode, canceled board etc.)
n:
n successful placements
Definition of sAttritionInfoVersion values
0:
Reject data comes from a station software version < 708
1:
Reject data comes from astation software version >= 708
ASM OIS/SIS Databases 16.0 (R18-2) / Interface Description 11/2018 Edition
26
4.5.1.20 CompPosition Table
CompPosition
OIS name
Data type
Byte
CI
I
P
Identification number of the station
(reference to STATION table)
lId
int
4
Reference number of the entry
lIdPosition
bigint
8
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
Identification number of the component name
(available with station software version 701 and
higher)
lPartNumber
int
4
Identification number of the component shape
name (available with station software version
701 and higher)
lComponentShape
int
4
SIPLACE Pro number for feeder type (available
with station software version 701 and higher)
lFeederType
long
4
Time when the data is written. Local server time
dtCreated
datetime
8
Unique feeder ID
strFeederId
nvarchar(128)
256
4.5.1.21 Panel Table
Panel
OIS name
Data type
Byte
CI
I
P
Reference (from BOARD table).
Note: This reference may occur several times
since a board may have several panel groups.
lIdPanel
bigint
8
Count of produced panels
lCountProduced
int
4
Count of omitted panels
lCountOmitted
int
1
Encoding whether the panel entry is intended to
be counted as assembled PCB (based on
SIPLACE Pro setting)
CountAsAssembledPCB
tinyint
2
Name of the concerned placement list
strPlacementListName
nvarchar(256)
512
Definition of CountAsAssembledPCB values
0:
Undefined
1:
True
2:
False
ASM OIS/SIS Databases 16.0 (R18-2) / Interface Description 11/2018 Edition
27
4.5.1.22 SpliceEvent Table
SpliceEvent
OIS name
Data type
Byte
CI
I
P
Identification number of the station
(reference to STATION table)
lId
int
4
Table/location from which the component was
retrieved
ucTable
tinyint
1
Track number
sTrack
smallint
2
Division
sDivision
smallint
2
Identification number of the component name
lPartNumber
int
4
Date/time at which the data record was created.
Station time
dtTime
datetime
8
Time when the splice occurred at the station
dtSpliceTime
datetime
8
Time when the data is written. Local server Time
dtCreated
datetime
8
Sequence ID (internal use)
lIdSequence
bigint
8
4.5.1.23 ProcessingLocation Table
The table is filled after configuring the station. If the station is no longer registered after cleaning up
the database (task approximately every 40 days), the entries are deleted.
ProcessingLocation
OIS name
Data type
Byte
CI
I
P
Entry Identifier
ld
bigint
8
✓
Identification number of the station
(reference to STATION table)
lId
int
4
Processing area 1 / 2 (Printer machines always
have only 1)
ProceesingArea
tinyint
1
Physical number of conveyor
1 → right / 2 → left. Single conveyor = 1
Conveyor
tinyint
1
Logical assignment of conveyor (i.e. printer
back-to-back solution)
VirtualLine
tinyint
1
Time when the data is written. Server Time
dtCreated
datetime
8