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

ASM OIS/SIS Datab ases 16.0 (R18 -2) / Interf ace Description 11/2018 Edition 28 4.5.1.24 PlocAvailabilit y Table As of station software version 712.0, th is table contains the processing location st ates explicitl y sen…

100%1 / 150
ASM OIS/SIS Databases 16.0 (R18-2) / Interface Description 11/2018 Edition
27
4.5.1.22 SpliceEvent Table
SpliceEvent
OIS name
Data type
Byte
CI
I
P
Identification number of the station
(reference to STATION table)
lId
int
4
Table/location from which the component was
retrieved
ucTable
tinyint
1
Track number
sTrack
smallint
2
Division
sDivision
smallint
2
Identification number of the component name
lPartNumber
int
4
Date/time at which the data record was created.
Station time
dtTime
datetime
8
Time when the splice occurred at the station
dtSpliceTime
datetime
8
Time when the data is written. Local server Time
dtCreated
datetime
8
Sequence ID (internal use)
lIdSequence
bigint
8
4.5.1.23 ProcessingLocation Table
The table is filled after configuring the station. If the station is no longer registered after cleaning up
the database (task approximately every 40 days), the entries are deleted.
ProcessingLocation
OIS name
Data type
Byte
CI
I
P
Entry Identifier
ld
bigint
8
✓
Identification number of the station
(reference to STATION table)
lId
int
4
Processing area 1 / 2 (Printer machines always
have only 1)
ProceesingArea
tinyint
1
Physical number of conveyor
1 → right / 2 → left. Single conveyor = 1
Conveyor
tinyint
1
Logical assignment of conveyor (i.e. printer
back-to-back solution)
VirtualLine
tinyint
1
Time when the data is written. Server Time
dtCreated
datetime
8
ASM OIS/SIS Databases 16.0 (R18-2) / Interface Description 11/2018 Edition
28
4.5.1.24 PlocAvailability Table
As of station software version 712.0, this table contains the processing location states explicitly
sent by the station.
PlocAvailability
OIS name
Data type
Byte
CI
I
P
Entry Identifier
ld
bigint
8
Reference to ProcessingLocation table ->(Id)
PlocId
bigint
8
Reference to EVENT table -> (lIdSequence)
EventSequenceId
bigint
8
Timestamp (localtime) from station when state
was entered
CurrentStateBegin
datetime
8
Current E58 State Code
CurrentStateCode
nvarchar(4)
10
Previous E58 State Code
PreviousStateCode
nvarchar(4)
10
Time when the data is written. Server Time
dtCreated
datetime
8
E58 State Codes:
E10 States
Substate E58
State description
0
No value entered
1000 (Productive)
1000
PRD\Default
1100
PRD\Regular work
11a1
PRD\Regular work: Hardware occupied
11b1
PRD\Pass-Through
1400
PRD\Engineering runs
2000 (Standby)
2000
SBY\Default
20a0
SBY\External data missing
22a0
SBY\No product: Blocked
22b0
SBY\No product: Starved
22b1
SBY\No product: No consumables
2300
SBY\No support tool
2400
SBY\Associated cluster module down
2500
SBY\No host
3000 (Engineering)
3000
ENG\Default
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.
ASM OIS/SIS Databases 16.0 (R18-2) / Interface Description 11/2018 Edition
29
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
bigint
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)
256
Version of the device that identifies a uniform set
of error numbers, e.g.
ASM::SIPLACE::SIRIO::701.1
ScenarioSourceId
nvarchar(256)
256
Date/time when the Assist occurred
dtAssist
datetime
8
Time when the data is written. Server Time
dtCreated
datetime
8
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