00900135-02_ID_OIS_SIS_15.1_R18-1_DE_EN - 第25页

ASM OIS/SIS Databases 15.1 ( R18 - 1) / Interface De scription 05/2018 Edition 25 4.5.1.19 GantryState Table The GantryState table reflects gantry state changes. The gantry states have been added to ext end the state tra…

100%1 / 148
ASM OIS/SIS Databases 15.1 (R18-1) / Interface Description 05/2018 Edition
24
4.5.1.17 RECIPECHANGE Table
The RECIPECHANGE table is an internal table that is used to recognize recipe changes.
RECIPECHANGE OIS name Data type Byte CI I P
Identification number of the station
(reference to STATION table)
lId int 4
Conveyor belt 1 / 2 ucConveyor tinyint 1
Processing area 1 / 2 ucProcessingArea tinyint 1
Subconveyor lSubconveyor int 4
Line Job Guid as string strLineJobGuid nvarchar(36) 72
The lIdSequence value of the referring event
entry
lIdSequence int 8
Date/time at which this event occurred.
Station time
dtTime datetime 8
Time when the data is written. Server time t dtCreated datetime 8
4.5.1.18 SESSION Table
The SESSION table is used by the Monitoring Service to store session related data. This table is
private, i.e. it will not be exposed via public view.
SESSION OIS name Data type Byte CI I P
Type of session: e.g. "PickupObservationSession" strType nvarchar(64) 128
GUID that uniquely identifies the session strGuid nvarchar(36) 72
Start time when the session started dtStart datetime 8
End time when the session was stopped
dtEnd datetime 8
State of the session lState int 4
Period in seconds in case the session provides
periodical events.
lPeriod int 4
Session internal information. strInternal nvarchar(2048) 4096
Definition of lState values
0: Unknown
1: Open
2: Closed
ASM OIS/SIS Databases 15.1 (R18-1) / Interface Description 05/2018 Edition
25
4.5.1.19 GantryState Table
The GantryState table reflects gantry state changes. The gantry states have been added to extend
the state transitions stored in STATETRANSITION table.
GantryState OIS name Data type Byte CI I P
Identification number of the station
(reference to STATION table))
lId int 4
Number of gantry within the processing area ucNumber tinyint 1
Processing area 1 / 2 ucProcessingArea tinyint 1
Gantry state value sState smallint 2
Error reason (is sState in Error state) sErrorReason smallint 2
BoardNumber of the board that has been
processed when the state change occurred.
lBoardNumber int 4
Unique sequence id of the entry lIdSequence int 4
Date/time at which this event occurred.
Station time
dtTime datetime 8
Definition of sState values
0: Undefined
1: Idle
2: Interrupted
3: Processing
4.5.1.20 PlocState Table
The PlocState table contains state changes related to the processing location. These states act as
extensions of the state changes related to the processing area that are stored in the
STATETRANSITION table.
PlocState OIS name Data type Byte CI I P
Identification number of the station
(reference to STATION table)
lId int 4
Conveyor belt 1 right / 2 left ucConveyor tinyint 1
Processing area 1 / 2 ucProcessingArea tinyint 1
PlocState state value sState smallint 2
Unique sequence id of the entry lIdSequence int 4
Date/time at which this event occurred.
Station time
dtTime datetime 8
The definitions of the PlocStates (sState) are the same as those described in section 4.5.1.16.
ASM OIS/SIS Databases 15.1 (R18-1) / Interface Description 05/2018 Edition
26
4.5.1.21 CompBlock Table
CompBlock OIS name Data type Byte CI I P
Identification number of the station
(reference to STATION table)
lId int 4
Date/time at which the data record was created.
Station time
dtTime datetime 8
Serial number of manufactured PCB lBoardNumber int 4
Time when the data is written. Server time dtCreated datetime 8
Reference number of the entry. lIdBlock int 4
Unique number of the BoardComposite lBoardCompositeId int 4
4.5.1.22 CompDetail Table
CompDetail OIS name Data type Byte CI I P
Number of attempts to access this track sAccessTotal smallint 2
Sum of all reject attempts on this track after
Vision error messages
sRejectIdent smallint 2
Sum of all reject attempts on this track after
other error messages
sRejectVacuum smallint 2
Number of rejected parts because of ident error sRejectIdent smallint 2
Number of rejected parts because of vacuum
error
sRejectVacuum smallint 2
Number of TrackEmpty pickup attempts sTrackEmpty smallint 2
Reference into CompBlock table lIdBlock int 2
Reference into CompPosition table lIdPosition int 2
Number of successfully placed components on
this track
sPlacedComponents smallint 2
Number of reject attempts on this track because
of missing components after pickup
sAbsenceAfterPick smallint 2
Number of pickup attempts on this track
because of missing components before
placement
sAbsenceBefore
Placement
smallint 2
Number of rejects on this track because of
Coplan or material errors reported by Vision
sMaterialDefect smallint 2
Number of rejects on this track because of
erroneous special procedures (dipping, gluing
etc.)
sTreatmentError smallint 2
Number of rejects on this track because of an
interrupted placement process (i.e. canceled
board)
sDroppedError smallint 2
Number of rejects on this track because of
pickup tolerances checked by Vision
sIdentError smallint 2
Number of (incorrect) placement attempts on
this track because of gluey components
sPresenceAfter
Placement
smallint 2