00900223-01_ID_OIS_SIS_17.0_R19-2_EN_DE - 第20页

ASM OIS/SIS Datab ases 17.0 (R19 -2) / Interf ace Description 11/2019 Edition 20 Definition of IOrder v alues 0: Sequence of the placement m achines. Other m achines are not arranged . Definition of Station SelectionStat…

100%1 / 150
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
ASM OIS/SIS Databases 17.0 (R19-2) / Interface Description 11/2019 Edition
20
Definition of IOrder values
0:
Sequence of the placement machines. Other machines are not arranged.
Definition of StationSelectionState values
0:
Not selected for monitoring
1:
selected for monitoring
2:
selected for monitoring and SiplacePro data are available
4.5.1.10 STATE Table
Only relevant for OIS Client. Determines the display of the states there.
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
4.5.1.11 STATESHARE Table
Only relevant for OIS Client. Determines the display of the states there.
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.12 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
Date/time at which this event occurred. Local
station time
dtTime
datetime
8
Value 4 of data type double e
dDouble
float
8
ASM OIS/SIS Databases 17.0 (R19-2) / Interface Description 11/2019 Edition
21
4.5.1.13 SHIFTWORK Table
Only relevant for OIS Client. For evaluations with OIB, shifts must be managed via the Factory
Calendar.
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.14 EVENTTEXT Table
EVENTTEXT
OIS name
Data type
Byte
I
P
Event number
sEvent
smallint
2
Event name
strName
nvarchar(32)
64
4.5.1.15 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. Local
station time
dtTime
datetime
8
Time when the data is written. Local server time
dtCreated
datetime
8
Event number
sEvent
smallint
2
Processing mode
usProcessingMode
tinyint
1
Sequence ID (internal use)
lIdSequence
bigint
8
State history (internal use)
IHistory
int
4
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".
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