00900045-01_ID_OIS_SIS_14.0_R16-2_DE_EN - 第21页

ASM OIS/SIS Databases 14.0 ( R16 - 2) / Interface De scription 12/2016 Edition 21 4.5.1.12 STA TESHARE Table STATESHARE OIS name Data type Byte I P 8 user - defin ed states (T 1 – T 8 ), availability (T b ) and the defin…

100%1 / 144
ASM OIS/SIS Databases 14.0 (R16-2) / Interface Description 12/2016 Edition
20
4.5.1.9 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) 256
Time when the data is written. Server Time dtCreated datetime 8
4.5.1.10 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
Full path of the line strLineFullPath nvarchar(1024) 2048
Full path of the station 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
4.5.1.11 STATE Table
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
ASM OIS/SIS Databases 14.0 (R16-2) / Interface Description 12/2016 Edition
21
4.5.1.12 STATESHARE Table
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.13 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
Value 3 of data type datetime dtTime datetime 8
Value 4 of data type double e dDouble float 8
4.5.1.14 SHIFTWORK Table
SHIFTWORK OIS name Data type Byte I P
Name of shift strName nvarchar(32) 64
Starting time of shift dtStart datetime 8
4.5.1.15 EVENTTEXT Table
EVENTTEXT OIS name Data type Byte I P
Event number sEvent smallint 2
Event name strName nvarchar(32) 64
ASM OIS/SIS Databases 14.0 (R16-2) / Interface Description 12/2016 Edition
22
4.5.1.16 STATETRANSITION Table
STATETRANSITION 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
State based on events sState smallint 2
Date/time at which this event occurred.
Station time
dtTime datetime 8
Time when the data is written. Server time dtCreated datetime 8
Event number sEvent smallint 2
Processing mode usProcessingMode tinyint 1
Sequence ID (internal use) lIdSequence int 4
State history (internal use) IHistory int 4
Definition of ucProcessingMode
The ucProcessingMode indicates whether the "Alternating" or "I-Placement" mode was used to
process the board.
Possible values of ucProcessingMode:
0: Undefined
1: Alternating mode
2: I-Placement mode
Definition of ucConveyor
The current implementation is processing area specific, i.e. one state machine is available for each
processing area. Future improvements may use a state machine for each processing area and
each conveyor. As long as this improvement is not implemented, the ucConveyor is always set to
"0".