System Model > Alarms > Alarm Server Database Specification > CiAnalogAlarm

CiAnalogAlarm

ColumnName

DataType

PrimaryKey

NotNull

Flags

Default
Value

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_AcceptComment VARCHAR(253) NN        
CiAnalogAlarmState_Accepted BIT NN        
CiAnalogAlarmState_AcceptTime TIMESTAMP NN        
CiAnalogAlarmState_AcceptUser VARCHAR(63) NN        
CiAnalogAlarmState_ActiveSubCondition VARCHAR(31) NN        
CiAnalogAlarmState_AreaOfInterest VARCHAR(253) NN        
CiAnalogAlarmState_AreaOfInterestId INTEGER NN        
CiAnalogAlarmState_CanAccept BIT NN        
CiAnalogAlarmState_CanDisable BIT NN        
CiAnalogAlarmState_CanRemove BIT NN        
CiAnalogAlarmState_CanRespond BIT NN        
CiAnalogAlarmState_CanUnaccept BIT NN        
CiAnalogAlarmState_ConditionActiveTime TIMESTAMP NN        
CiAnalogAlarmState_CondName VARCHAR(23) NN        
CiAnalogAlarmState_Cookie INTEGER NN        
CiAnalogAlarmState_CurrSuppressingAlarmId INTEGER NN        
CiAnalogAlarmState_CurrSuppressingCond VARCHAR(127) NN        
CiAnalogAlarmState_CurrSuppressingConsDesc VARCHAR(63) NN        
CiAnalogAlarmState_CurrSuppressingConsType TINYINT NN        
CiAnalogAlarmState_Disabled BIT NN        
CiAnalogAlarmState_DisabledBy VARCHAR(253) NN        
CiAnalogAlarmState_DisabledEndTime TIMESTAMP NN        
CiAnalogAlarmState_DisableTime TIMESTAMP NN        
CiAnalogAlarmState_EvtSeqNumberClear INTEGER NN        
CiAnalogAlarmState_EvtSeqNumberSet INTEGER NN        
CiAnalogAlarmState_Id INTEGER NN        
CiAnalogAlarmState_InactiveTime TIMESTAMP NN        
CiAnalogAlarmState_LastUpdateTime TIMESTAMP NN        
CiAnalogAlarmState_Message VARCHAR(253) NN        
CiAnalogAlarmState_OrigSuppressingAlarmId INTEGER NN        
CiAnalogAlarmState_OrigSuppressingCond VARCHAR(127) NN        
CiAnalogAlarmState_OrigSuppressingConsDesc VARCHAR(63) NN        
CiAnalogAlarmState_OrigSuppressingConsType TINYINT NN        
CiAnalogAlarmState_ReceiptTime TIMESTAMP NN        
CiAnalogAlarmState_Response VARCHAR(253) NN        
CiAnalogAlarmState_ResponseTime TIMESTAMP NN        
CiAnalogAlarmState_ResponseUser VARCHAR(63) NN        
CiAnalogAlarmState_ResponsibleEntity VARCHAR(127) NN        
CiAnalogAlarmState_ResponsibleEntityType TINYINT NN        
CiAnalogAlarmState_Severity INTEGER NN        
CiAnalogAlarmState_SeverityDesc VARCHAR(31) NN        
CiAnalogAlarmState_State INTEGER NN        
CiAnalogAlarmState_StateDesc VARCHAR(31) NN        
CiAnalogAlarmState_SubConditionActiveTime TIMESTAMP NN        
CiAnalogAlarmState_SuppressedAlarmCount INTEGER NN        
CiAnalogAlarmState_VisibleTime 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
Id
idxId Index Id
idxParentGroupId Index ParentGroupId
idxFullName Index FullName
idxConsParentAlarmObjId Index ConsParentAlarmObjId
idxCiAnalogAlarmState_Id Index CiAnalogAlarmState_Id

See Also

Alarm Server Side Synchronization

Published June 2018