00900170-01_ID_OIS_SIS_16.0_R18-2_EN_DE - 第15页

ASM OIS/SIS Datab ases 16.0 (R18 -2) / Interf ace Description 11/2018 Edition 15 Unique ID for Line Job strLineJobGuid nvarchar(36) 72 Sequence ID (internal use) lIdSequence bigint 8 Internal ID to mark entries referring…

100%1 / 150
ASM OIS/SIS Databases 16.0 (R18-2) / Interface Description 11/2018 Edition
14
4.5.1 OIS Tables
4.5.1.1 STATETEXT Table
STATETEXT
OIS name
Data type
Byte
CI
I
P
Identification number of the State
sState
smallint
2
Name of the State
strName
nvarchar(32)
64
4.5.1.2 FEEDERTYPE Table
FEEDERTYPE
OIS name
Data type
Byte
CI
I
P
SIPLACE Pro number for feeder type
(available with station software version 701
and higher)
lFeederType
int
4
SIPLACE Pro name for feeder type
strFeederTypeName
nvarchar(128)
256
SIPLACE Pro feeder code
IFeederCode
int
4
4.5.1.3 BOARD Table
BOARD
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
✓
Manufactured production lot
strRecipe
nvarchar(128)
256
Name of the setup
strSetup
nvarchar(128)
256
Name of the PCB
strBoard
nvarchar(128)
256
Station internal local number of manufactured
PCB
lBoardNumber
int
4
Conveyor belt 1 / 2
ucConveyor
tinyint
1
Cycle time of PCB
sDuration
smallint
2
Time when production of lot started
dtRecipeStart
datetime
8
Time when setup used for manufacture started
dtSetupStart
datetime
8
PCB barcode
strBarcode
nvarchar(256)
512
PCB status (see definition below)
ucStatus
tinyint
1
Time when the data is written. Local server
time
dtCreated
datetime
8
✓
Number of panels within the board
lPanel
int
4
Conveyor sub-lane
lSubConveyor
int
4
Board side
ucBoardSide
tinyint
1
ASM OIS/SIS Databases 16.0 (R18-2) / Interface Description 11/2018 Edition
15
Unique ID for Line Job
strLineJobGuid
nvarchar(36)
72
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
Internal GUID containing a unique GUID of the
board (for internal use only)
strPCBGuid
nvarchar(256)
512
Build time of the board for the first processing
area in milliseconds
Only available for stations with station software
>= 704
lBuildTimePA1
int
4
Build time of the board for the second
processing area in milliseconds
Only available for stations with station software
>= 704
lBuildTimePA2
int
4
Reference to Panel tables entries
lIdPanel
bigint
8
Definition of ucStatus
The status of each PCB has been enhanced as of station software versions 605 and 701. As of
these versions, the status is interpreted as a bit array. The enhancement allows backward
compatibility.
1st bit:
True = PCB was aborted.
False = PCB was produced.
2nd bit:
True = PCB was produced with auto recovery.
False = PCB was produced normally without auto recovery.
3rd bit:
-
4th bit:
True = PCB is in transport through mode.
False = PCB was produced.
Definition of lSubConveyor
The lSubconveyor entry has been added to distinguish between the right and the left sub-lane if the
placement machine runs in quad lane mode. If the placement machine is not in quad lane mode
this value is always "0".
Possible values of lSubConveyor:
0:
No sub-lane
1:
Right sub-lane
2:
Left sub-lane
Definition of ucBoardSide
The ucBoardSide indicates 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
16
4.5.1.4 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.5 USEREVENT Table
USEREVENT
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
User 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
tinyint
1