CiAnalogAlarm
- Last UpdatedJul 18, 2023
- 3 minute read
|
ColumnName |
DataType |
Primary |
NotNull |
Flags |
Default |
Comment |
AutoInc |
|---|---|---|---|---|---|---|---|
|
Abstract |
BIT |
NN |
|||||
|
AccessControlList |
INTEGER |
NN |
|||||
|
AckTime |
TIMESTAMP |
NN |
|||||
|
ACLAsText |
VARCHAR(253) |
NN |
|||||
|
AcqError |
SMALLINT |
NN |
|||||
|
AlarmArea |
INTEGER |
NN |
|||||
|
AlarmCanDisable |
BIT |
NN |
|||||
|
AlarmCanLocate |
BIT |
NN |
|||||
|
AlarmCanRespond |
BIT |
NN |
|||||
|
AlarmCanUnaccept |
BIT |
NN |
|||||
|
AlarmCategory |
SMALLINT |
NN |
|||||
|
AlarmDesc |
VARCHAR(31) |
NN |
|||||
|
AlarmDisabled |
BIT |
NN |
|||||
|
AlarmEnableConfirm |
TINYINT |
NN |
|||||
|
AlarmHandlerMethod |
INTEGER |
NN |
|||||
|
AlarmHandlerObjectId |
INTEGER |
NN |
|||||
|
AlarmLastUpdateTime |
TIMESTAMP |
NN |
|||||
|
AlarmPrivilege |
SMALLINT |
NN |
|||||
|
AlarmRedirection |
BIT |
NN |
|||||
|
AlarmRemovable |
BIT |
NN |
|||||
|
AlarmSeverity |
SMALLINT |
NN |
|||||
|
AlarmSeverityDesc |
VARCHAR(31) |
NN |
|||||
|
AlarmSource |
INTEGER |
NN |
|||||
|
AlarmSourceValid |
BIT |
NN |
|||||
|
AlarmState |
INTEGER |
NN |
|||||
|
AlarmType |
VARCHAR(23) |
NN |
|||||
|
AlarmViewClass |
VARCHAR(23) |
NN |
|||||
|
AlarmViewId |
INTEGER |
NN |
|||||
|
AlarmViewLink |
INTEGER |
NN |
|||||
|
AlarmViewName |
VARCHAR(254) |
NN |
|||||
|
AlmUnspSeverity |
SMALLINT |
NN |
|||||
|
AlmUnspSeverityDesc |
VARCHAR(31) |
NN |
|||||
|
AlmUnspState |
INTEGER |
NN |
|||||
|
AlmUnspStateDesc |
VARCHAR(31) |
NN |
|||||
|
Background |
INTEGER |
NN |
|||||
|
Blink |
BIT |
NN |
|||||
|
CiAnalogAlarmState |
VARCHAR(253) |
NN |
|||||
|
CiAnalogAlarmState |
BIT |
NN |
|||||
|
CiAnalogAlarmState |
TIMESTAMP |
NN |
|||||
|
CiAnalogAlarmState |
VARCHAR(63) |
NN |
|||||
|
CiAnalogAlarmState |
VARCHAR(31) |
NN |
|||||
|
CiAnalogAlarmState |
VARCHAR(253) |
NN |
|||||
|
CiAnalogAlarmState |
INTEGER |
NN |
|||||
|
CiAnalogAlarmState |
BIT |
NN |
|||||
|
CiAnalogAlarmState |
BIT |
NN |
|||||
|
CiAnalogAlarmState |
BIT |
NN |
|||||
|
CiAnalogAlarmState |
BIT |
NN |
|||||
|
CiAnalogAlarmState |
BIT |
NN |
|||||
|
CiAnalogAlarmState |
TIMESTAMP |
NN |
|||||
|
CiAnalogAlarmState |
VARCHAR(23) |
NN |
|||||
|
CiAnalogAlarmState |
INTEGER |
NN |
|||||
|
CiAnalogAlarmState |
INTEGER |
NN |
|||||
|
CiAnalogAlarmState |
VARCHAR(127) |
NN |
|||||
|
CiAnalogAlarmState_ |
VARCHAR(63) |
NN |
|||||
|
CiAnalogAlarmState |
TINYINT |
NN |
|||||
|
CiAnalogAlarmState |
BIT |
NN |
|||||
|
CiAnalogAlarmState |
VARCHAR(253) |
NN |
|||||
|
CiAnalogAlarmState |
TIMESTAMP |
NN |
|||||
|
CiAnalogAlarmState |
TIMESTAMP |
NN |
|||||
|
CiAnalogAlarmState |
INTEGER |
NN |
|||||
|
CiAnalogAlarmState |
INTEGER |
NN |
|||||
|
CiAnalogAlarmState_Id |
INTEGER |
NN |
|||||
|
CiAnalogAlarmState |
TIMESTAMP |
NN |
|||||
|
CiAnalogAlarmState |
TIMESTAMP |
NN |
|||||
|
CiAnalogAlarmState |
VARCHAR(253) |
NN |
|||||
|
CiAnalogAlarmState |
INTEGER |
NN |
|||||
|
CiAnalogAlarmState_OrigSuppressingCond |
VARCHAR(127) |
NN |
|||||
|
CiAnalogAlarmState_ |
VARCHAR(63) |
NN |
|||||
|
CiAnalogAlarmState |
TINYINT |
NN |
|||||
|
CiAnalogAlarmState |
TIMESTAMP |
NN |
|||||
|
CiAnalogAlarmState |
VARCHAR(253) |
NN |
|||||
|
CiAnalogAlarmState |
TIMESTAMP |
NN |
|||||
|
CiAnalogAlarmState |
VARCHAR(63) |
NN |
|||||
|
CiAnalogAlarmState |
VARCHAR(127) |
NN |
|||||
|
CiAnalogAlarmState |
TINYINT |
NN |
|||||
|
CiAnalogAlarmState |
INTEGER |
NN |
|||||
|
CiAnalogAlarmState |
VARCHAR(31) |
NN |
|||||
|
CiAnalogAlarmState |
INTEGER |
NN |
|||||
|
CiAnalogAlarmState |
VARCHAR(31) |
NN |
|||||
|
CiAnalogAlarmState |
TIMESTAMP |
NN |
|||||
|
CiAnalogAlarmState_ |
INTEGER |
NN |
|||||
|
CiAnalogAlarmState |
TIMESTAMP |
NN |
|||||
|
ColourPalette |
INTEGER |
NN |
|||||
|
Comment |
VARCHAR(254) |
NN |
|||||
|
ConditionActiveTime |
TIMESTAMP |
NN |
|||||
|
ConfigTime |
TIMESTAMP |
NN |
|||||
|
ConfigUser |
VARCHAR(63) |
NN |
|||||
|
ConfigValid |
BIT |
NN |
|||||
|
ConfigVersion |
INTEGER |
NN |
|||||
|
ConsAlarmsType |
TINYINT |
NN |
|||||
|
ConsAlarmsTypeDesc |
VARCHAR(63) |
NN |
|||||
|
ConsParentAlarmCond |
INTEGER |
NN |
|||||
|
ConsParentAlarmObjId |
INTEGER |
NN |
|||||
|
CustomFilters |
VARCHAR(253) |
NN |
|||||
|
DataTimestamp |
TIMESTAMP |
NN |
|||||
|
Deadband |
REAL |
NN |
|||||
|
Delay |
INTEGER |
NN |
|||||
|
DeltaTime |
INTEGER |
NN |
|||||
|
Description |
VARCHAR(254) |
NN |
|||||
|
Deviation |
REAL |
NN |
|||||
|
DeviationDelay |
INTEGER |
NN |
|||||
|
DisableTime |
TIMESTAMP |
NN |
|||||
|
DisplayName |
VARCHAR(79) |
NN |
|||||
|
DisplayTime |
TIMESTAMP |
NN |
|||||
|
DocumentContent |
INTEGER |
NN |
|||||
|
Equipment |
VARCHAR(254) |
NN |
|||||
|
ExcludeFromExclCtrl |
BIT |
NN |
|||||
|
ExclusiveCtrlActive |
BIT |
NN |
|||||
|
ExclusiveCtrlUser |
VARCHAR(254) |
NN |
|||||
|
Foreground |
INTEGER |
NN |
|||||
|
Format |
INTEGER |
NN |
|||||
|
FullName |
VARCHAR(254) |
NN |
|||||
|
HelpPage |
VARCHAR(64) |
NN |
|||||
|
HelpViewClass |
VARCHAR(23) |
NN |
|||||
|
HelpViewId |
INTEGER |
NN |
|||||
|
HelpViewLink |
INTEGER |
NN |
|||||
|
HelpViewName |
VARCHAR(254) |
NN |
|||||
|
High |
REAL |
NN |
|||||
|
HighDelay |
INTEGER |
NN |
|||||
|
HighHigh |
REAL |
NN |
|||||
|
HighHighDelay |
INTEGER |
NN |
|||||
|
Historian |
TINYINT |
NN |
|||||
|
Id |
INTEGER |
NN |
|||||
|
InvariantRecordId |
VARCHAR(40) |
NN |
|||||
|
Latched |
BIT |
NN |
|||||
|
Low |
REAL |
NN |
|||||
|
LowDelay |
INTEGER |
NN |
|||||
|
LowLow |
REAL |
NN |
|||||
|
LowLowDelay |
INTEGER |
NN |
|||||
|
ManuallyNotified |
BIT |
NN |
|||||
|
MarkerColourBad |
INTEGER |
NN |
|||||
|
MarkerColourGood |
INTEGER |
NN |
|||||
|
MemoryUsage |
INTEGER |
NN |
|||||
|
MobileHelpViewId |
INTEGER |
NN |
|||||
|
Name |
VARCHAR(63) |
NN |
|||||
|
NoteText |
VARCHAR(253) |
NN |
|||||
|
NoteTextLong |
INTEGER |
NN |
|||||
|
NoteTime |
TIMESTAMP |
NN |
|||||
|
NoteUser |
VARCHAR(63) |
NN |
|||||
|
ObjectLink |
INTEGER |
NN |
|||||
|
OffTime |
TIMESTAMP |
NN |
|||||
|
OnTime |
TIMESTAMP |
NN |
|||||
|
PagingEnabled |
BIT |
NN |
|||||
|
PagingGroup |
VARCHAR(80) |
NN |
|||||
|
ParentGroupId |
INTEGER |
NN |
|||||
|
ParentGroupName |
VARCHAR(254) |
NN |
|||||
|
Priority |
SMALLINT |
NN |
|||||
|
Quality |
INTEGER |
NN |
|||||
|
Rate |
REAL |
NN |
|||||
|
Rights |
INTEGER |
NN |
|||||
|
Setpoint |
REAL |
NN |
|||||
|
SetpointConfigured |
BIT |
NN |
|||||
|
StateNumeric |
SMALLINT |
NN |
|||||
|
StoredDynMetadataFields |
INTEGER |
NN |
|||||
|
SummaryRecordId |
INTEGER |
NN |
|||||
|
SuppressingAlarmId |
INTEGER |
NN |
|||||
|
SuppressingCondition |
VARCHAR(127) |
NN |
|||||
|
SuppressingConsType |
TINYINT |
NN |
|||||
|
SuppressingConsTypeDesc |
VARCHAR(63) |
NN |
|||||
|
TypeDesc |
VARCHAR(63) |
NN |
|||||
|
TypeName |
VARCHAR(63) |
NN |
|||||
|
TypeNum |
SMALLINT |
NN |
|||||
|
UserLocation |
VARCHAR(20) |
NN |
|||||
|
UserMethods |
BIT |
NN |
|||||
|
UsrAlmSeverity |
SMALLINT |
NN |
|||||
|
UsrAlmSeverityDesc |
VARCHAR(31) |
NN |
|||||
|
UsrAlmState |
INTEGER |
NN |
|||||
|
UsrAlmStateDesc |
VARCHAR(31) |
NN |
|||||
|
UsrAlmUnspSeverity |
SMALLINT |
NN |
|||||
|
UsrAlmUnspSeverityDesc |
VARCHAR(31) |
NN |
|||||
|
UsrAlmUnspState |
INTEGER |
NN |
|||||
|
UsrAlmUnspStateDesc |
VARCHAR(31) |
NN |
|||||
|
Value |
REAL |
NN |
|||||
|
WSAlmSeverity |
SMALLINT |
NN |
|||||
|
WSAlmSeverityDesc |
VARCHAR(31) |
NN |
|||||
|
WSAlmState |
INTEGER |
NN |
|||||
|
WSAlmStateDesc |
VARCHAR(31) |
NN |
|||||
|
WSAlmUnspSeverity |
SMALLINT |
NN |
|||||
|
WSAlmUnspSeverityDesc |
VARCHAR(31) |
NN |
|||||
|
WSAlmUnspState |
INTEGER |
NN |
|||||
|
WSAlmUnspStateDesc |
VARCHAR(31) |
NN |
|
IndexName |
IndexType |
Columns |
|---|---|---|
|
pkCiAnalogAlarm |
Index |
Id |
|
idxId |
Index |
Id |
|
idxParentGroupId |
Index |
ParentGroupId |
|
idxFullName |
Index |
FullName |
|
idxConsParentAlarmObjId |
Index |
ConsParentAlarmObjId |
|
idxCiAnalogAlarmState_Id |
Index |
CiAnalogAlarmState_Id |