System Model > Alarms > Alarm Server Database Specification > CiDigitalAlarm

CiDigitalAlarm

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        
CiDigitalAlarmState_AcceptComment VARCHAR(253) NN        
CiDigitalAlarmState_Accepted BIT NN        
CiDigitalAlarmState_AcceptTime TIMESTAMP NN        
CiDigitalAlarmState_AcceptUser VARCHAR(63) NN        
CiDigitalAlarmState_ActiveSubCondition VARCHAR(31) NN        
CiDigitalAlarmState_AreaOfInterest VARCHAR(253) NN        
CiDigitalAlarmState_AreaOfInterestId INTEGER NN        
CiDigitalAlarmState_CanAccept BIT NN        
CiDigitalAlarmState_CanDisable BIT NN        
CiDigitalAlarmState_CanRemove BIT NN        
CiDigitalAlarmState_CanRespond BIT NN        
CiDigitalAlarmState_CanUnaccept BIT NN        
CiDigitalAlarmState_ConditionActiveTime TIMESTAMP NN        
CiDigitalAlarmState_CondName VARCHAR(23) NN        
CiDigitalAlarmState_Cookie INTEGER NN        
CiDigitalAlarmState_CurrSuppressingAlarmId INTEGER NN        
CiDigitalAlarmState_CurrSuppressingCond VARCHAR(127) NN        
CiDigitalAlarmState_CurrSuppressingConsDesc VARCHAR(63) NN        
CiDigitalAlarmState_CurrSuppressingConsType TINYINT NN        
CiDigitalAlarmState_Disabled BIT NN        
CiDigitalAlarmState_DisabledBy VARCHAR(253) NN        
CiDigitalAlarmState_DisabledEndTime TIMESTAMP NN        
CiDigitalAlarmState_DisableTime TIMESTAMP NN        
CiDigitalAlarmState_EvtSeqNumberClear INTEGER NN        
CiDigitalAlarmState_EvtSeqNumberSet INTEGER NN        
CiDigitalAlarmState_Id INTEGER NN        
CiDigitalAlarmState_InactiveTime TIMESTAMP NN        
CiDigitalAlarmState_LastUpdateTime TIMESTAMP NN        
CiDigitalAlarmState_Message VARCHAR(253) NN        
CiDigitalAlarmState_OrigSuppressingAlarmId INTEGER NN        
CiDigitalAlarmState_OrigSuppressingCond VARCHAR(127) NN        
CiDigitalAlarmState_OrigSuppressingConsDesc VARCHAR(63) NN        
CiDigitalAlarmState_OrigSuppressingConsType TINYINT NN        
CiDigitalAlarmState_ReceiptTime TIMESTAMP NN        
CiDigitalAlarmState_Response VARCHAR(253) NN        
CiDigitalAlarmState_ResponseTime TIMESTAMP NN        
CiDigitalAlarmState_ResponseUser VARCHAR(63) NN        
CiDigitalAlarmState_ResponsibleEntity VARCHAR(127) NN        
CiDigitalAlarmState_ResponsibleEntityType TINYINT NN        
CiDigitalAlarmState_Severity INTEGER NN        
CiDigitalAlarmState_SeverityDesc VARCHAR(31) NN        
CiDigitalAlarmState_State INTEGER NN        
CiDigitalAlarmState_StateDesc VARCHAR(31) NN        
CiDigitalAlarmState_SubConditionActiveTime TIMESTAMP NN        
CiDigitalAlarmState_SuppressedAlarmCount INTEGER NN        
CiDigitalAlarmState_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        
Delay INTEGER NN        
DeltaTime INTEGER NN        
Description VARCHAR(254) 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        
FullName VARCHAR(254) NN        
HelpPage VARCHAR(64) NN        
HelpViewClass VARCHAR(23) NN        
HelpViewId INTEGER NN        
HelpViewLink INTEGER NN        
HelpViewName VARCHAR(254) NN        
Historian TINYINT NN        
Id INTEGER NN        
InvariantRecordId VARCHAR(40) NN        
Latched BIT 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        
Rights INTEGER 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        
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
pkCiDigitalAlarm Index Id
Id
idxId Index Id
idxParentGroupId Index ParentGroupId
idxFullName Index FullName
idxConsParentAlarmObjId Index ConsParentAlarmObjId
idxCiDigitalAlarmState_Id Index CiDigitalAlarmState_Id

See Also

Alarm Server Side Synchronization

Published June 2018