00900223-01_ID_OIS_SIS_17.0_R19-2_EN_DE.pdf - 第29页

ASM OIS/SIS Datab ases 17.0 (R19 -2) / Interf ace Description 11/2019 Edition 29 4.5.1.27 ErrorMessage T able The ErrorMessage t able is used to store th e translations of the error num bers from the AssistCollection tab…

100%1 / 150
ASM OIS/SIS Databases 17.0 (R19-2) / Interface Description 11/2019 Edition
28
5000 (Unscheduled Downtime)
5000
„Unscheduled Downtime” (USD)
50e1
USD\Assist
50e2
USD\Emergency stop
50s1
USD\No product defined
50s2
USD\Skipped work instructions
50s3
USD\Setup mismatch
6000 (Non-Scheduled Time)
6000
Non Scheduled Time
65a0
Power off
60a0
Unknown
If the CurrentStateCode contains 50e1 then an assist was received. This data is stored in the
tables AssistCollection and ErrorMessage.
4.5.1.25 LaneAssignment Table
The table contains the assignment of lanes of a station to the lanes of a line.
(A station can contain 2 entries. A printer has only 1 lane but can be assigned to the right or left
side of a line.)
LaneAssignment
OIS name
Data type
Byte
CI
I
P
Identification number of the LaneAssignments
IdLaneAssignment
bigint
8
Lane of the device DeviceLaneId
DeviceLaneId
tinyint
1
Lane of the section SectionLaneId
SectionLaneId
tinyint
1
4.5.1.26 AssistCollection Table
The AssistCollection table is used to store the associated assists and the error number in the
database for error states that have led to machine down-time.
AssistCollection
OIS name
Data type
Byte
CI
I
P
Identification number of the AssistCollection
Id
bigint
8
Identification of the list of Assists that have led to
a state change
IdAssistList
bigint
8
Assist ID as reported from the device
AssistId
int
8
Identification number of the device that reports
the Assist
lId
int
4
Error number that the device has reported to the
Assists
ErrorNo
nvarchar(256)
512
Version of the device that identifies a uniform set
of error numbers, e.g.
ASM::SIPLACE::SIRIO::701.1
ScenarioSourceId
nvarchar(256)
512
Date/time when the Assist occurred
dtAssist
datetime
8
Time when the data is written. Server Time
dtCreated
datetime
8
ASM OIS/SIS Databases 17.0 (R19-2) / Interface Description 11/2019 Edition
29
4.5.1.27 ErrorMessage Table
The ErrorMessage table is used to store the translations of the error numbers from the
AssistCollection table.
ErrorMessage
OIS name
Data type
Byte
CI
I
P
Error number that the device has reported to the
Assists
ErrorNo
nvarchar(256)
256
Version of the device that identifies a uniform set
of error numbers, e.g.
ASM::SIPLACE::SIRIO::701.1
ScenarioSourceId
nvarchar(256)
256
Identifies the language by means of a code
consisting of 2 small letters for the culture
of the language and a 2 capital letters long
code made up of ISO 3166 for the country.
E.g. fr-FR for French in France
LanguageCode
nvarchar(10)
10
Text for the error message in the respective
language
Message
nvarchar(256)
256
ASM OIS/SIS Databases 17.0 (R19-2) / Interface Description 11/2019 Edition
30
4.5.2 SIS Tables
4.5.2.1 RECIPE Table
RECIPE
SIS name
Data type
Byte
I
P
Name of the recipe
strRecipe
nvarchar(128)
256
Name of the line
strLine
nvarchar(1024)
2048
Name of the station
strStation
nvarchar(128)
256
Conveyor belt 1 / 2
ucConveyor
tinyint
1
Name of the PCB
Obsolete due to new BOARD table!
strBoard
nvarchar(128)
256
Name of the setup
strSetup
nvarchar(128)
256
Start time of the recipe. Server time.
dtStart
datetime
8
End time of the recipe. Server time.
dtEnd
datetime
8
Reference number to the corresponding
setup in the TRACK table
lIdTrack
bigint
8
Number of boards to produce
Obsolete due to new BOARD table!
lLotSize
long
4
Machine identification MID
strMid
nvarchar(50)
100
Is a machine identification available?
bMid
bit
1
Extra ID for production schedule
Obsolete due to new BOARD table!
strOrderId
string
512
Cycle time in [ms] calculated from the
optimizer
lCycleTime
long
4
Position of the stations within a line
lOrder
long
4
Top or bottom side of the board [Top,
Bottom]
Obsolete due to new BOARD table
strBoardSide
nvarchar(128)
256
SIPLACE Pro name for station type
strStationTypeName
nvarchar(128)
256
SIPLACE Pro number for station type
lStationType
long
4
Is the recipe produced with component
barcode?
bComponentBarcode
boolean
1
Indicates whether SIPLACE Pro has set the
StationCycleTime value
bStationCycleTime
boolean
1
Station Cycle time in [ms] for the PCB
processing calculated from the optimizer
lStationCycleTime
long
4
Indicates whether SIPLACE Pro has set the
ParallelProcessingFactor value
bParallelProcessingFactor
boolean
1