Fields of the alarm table |
Manual -> Industrial Performance Analyzer (IPA) -> Connection to the database -> Fields of the alarm table |
Show all Hide all |
The table, to which the alarm data are written, is created on the first start of the Runtime. The following fields (columns) are generated in the table.
Table fields:
Field name |
Data type |
Size |
Allow zero |
Info |
---|---|---|---|---|
TIMERECEIVED |
Datetime |
8 |
Yes |
|
TIMECLEARED |
Datetime |
8 |
Yes |
|
VARIABLENAME |
varchar |
1024 |
Yes |
|
ALARMTEXT |
varchar |
1024 |
Yes |
|
ALARMGROUP |
int |
4 |
Yes |
|
ALARMCLASS |
int |
4 |
Yes |
|
IDENTIFICATION |
varchar |
1024 |
Yes |
|
PROJECT |
varchar |
1024 |
Yes |
|
ALARMVALUE |
Varchar |
1024 |
Yes |
|
SHIFTALARMRECEIVED |
int |
4 |
Yes |
|
SHIFTALARMCLEARED |
int |
4 |
Yes |
|
ERRORSECONDS |
int |
4 |
Yes |
|
ALARMSTATUS |
int |
4 |
Yes |
|