System Model > Alarms > Alarm Server Database Specification > CiTimestampedAlarm

CiTimestampedAlarm

ColumnName

DataType

PrimaryKey

NotNull

Flags

Default
Value

Comment

AutoInc
ACLAsText VARCHAR(253) NN        
AccessControlList INTEGER NN        
AcqError SMALLINT NN        
AlarmCanDisable BIT NN        
AlarmCanRespond BIT NN        
AlarmCategory SMALLINT NN        
AlarmDisabled BIT NN        
AlarmHandlerMethod INTEGER NN        
AlarmLastUpdateTime TIMESTAMP NN        
AlarmRedirection BIT NN        
AlarmSeverity SMALLINT NN        
AlarmSource INTEGER NN        
AlarmState INTEGER NN        
AlarmViewClass VARCHAR(23) NN        
AlarmViewLink INTEGER NN        
AlmUnspSeverity SMALLINT NN        
AlmUnspState INTEGER NN        
Background INTEGER NN        
CiTimestampedAlarmState_AcceptComment VARCHAR(253) NN        
CiTimestampedAlarmState_AcceptUser VARCHAR(63) NN        
CiTimestampedAlarmState_ActiveSubCondition VARCHAR(31) NN        
CiTimestampedAlarmState_AreaOfInterestId INTEGER NN        
CiTimestampedAlarmState_CanDisable BIT NN        
CiTimestampedAlarmState_CanRespond BIT NN        
CiTimestampedAlarmState_CondName VARCHAR(23) NN        
CiTimestampedAlarmState_Cookie INTEGER NN        
CiTimestampedAlarmState_CurrSuppressingCond VARCHAR(127) NN        
CiTimestampedAlarmState_CurrSuppressingConsType TINYINT NN        
CiTimestampedAlarmState_Disabled BIT NN        
CiTimestampedAlarmState_DisabledEndTime TIMESTAMP NN        
CiTimestampedAlarmState_EvtSeqNumberSet INTEGER NN        
CiTimestampedAlarmState_InactiveTime TIMESTAMP NN        
CiTimestampedAlarmState_Message VARCHAR(253) NN        
CiTimestampedAlarmState_OrigSuppressingCond VARCHAR(127) NN        
CiTimestampedAlarmState_OrigSuppressingConsType TINYINT NN        
CiTimestampedAlarmState_Response VARCHAR(253) NN        
CiTimestampedAlarmState_ResponseUser VARCHAR(63) NN        
CiTimestampedAlarmState_ResponsibleEntityType TINYINT NN        
CiTimestampedAlarmState_SeverityDesc VARCHAR(31) NN        
CiTimestampedAlarmState_StateDesc VARCHAR(31) NN        
CiTimestampedAlarmState_SuppressedAlarmCount INTEGER NN        
ColourPalette INTEGER NN        
ConditionActiveTime TIMESTAMP NN        
ConfigUser VARCHAR(63) NN        
ConfigVersion INTEGER NN        
ConsAlarmsTypeDesc VARCHAR(63) NN        
ConsParentAlarmObjId INTEGER NN        
DataTimestamp TIMESTAMP NN        
DeltaTime INTEGER NN        
DisableTime TIMESTAMP NN        
DisplayTime TIMESTAMP NN        
Equipment VARCHAR(254) NN        
ExclusiveCtrlActive BIT NN        
Foreground INTEGER NN        
HelpPage VARCHAR(64) NN        
HelpViewId INTEGER NN        
HelpViewName VARCHAR(254) NN        
Id INTEGER NN        
Latched BIT NN        
MarkerColourGood INTEGER NN        
MobileHelpViewId INTEGER NN        
NoteText VARCHAR(253) NN        
NoteTime TIMESTAMP NN        
ObjectLink INTEGER NN        
OnTime TIMESTAMP NN        
PagingGroup VARCHAR(80) NN        
ParentGroupName VARCHAR(254) NN        
Quality INTEGER NN        
StateNumeric SMALLINT NN        
SummaryRecordId INTEGER NN        
SuppressingCondition VARCHAR(127) NN        
SuppressingConsTypeDesc VARCHAR(63) NN        
TypeName VARCHAR(63) NN        
UserLocation VARCHAR(20) NN        
UsrAlmSeverity SMALLINT NN        
UsrAlmState INTEGER NN        
UsrAlmUnspSeverity SMALLINT NN        
UsrAlmUnspState INTEGER NN        
WSAlmSeverity SMALLINT NN        
WSAlmState INTEGER NN        
WSAlmUnspSeverity SMALLINT NN        
WSAlmUnspState INTEGER NN        
Abstract BIT NN        
AckTime TIMESTAMP NN        
AlarmArea INTEGER NN        
AlarmCanLocate BIT NN        
AlarmCanUnaccept BIT NN        
AlarmDesc VARCHAR(31) NN        
AlarmEnableConfirm TINYINT NN        
AlarmHandlerObjectId INTEGER NN        
AlarmPrivilege SMALLINT NN        
AlarmRemovable BIT NN        
AlarmSeverityDesc VARCHAR(31) NN        
AlarmSourceValid BIT NN        
AlarmType VARCHAR(23) NN        
AlarmViewId INTEGER NN        
AlarmViewName VARCHAR(254) NN        
AlmUnspSeverityDesc VARCHAR(31) NN        
AlmUnspStateDesc VARCHAR(31) NN        
Blink BIT NN        
CiTimestampedAlarmState_AcceptTime TIMESTAMP NN        
CiTimestampedAlarmState_Accepted BIT NN        
CiTimestampedAlarmState_AreaOfInterest VARCHAR(253) NN        
CiTimestampedAlarmState_CanAccept BIT NN        
CiTimestampedAlarmState_CanRemove BIT NN        
CiTimestampedAlarmState_CanUnaccept BIT NN        
CiTimestampedAlarmState_ConditionActiveTime TIMESTAMP NN        
CiTimestampedAlarmState_CurrSuppressingAlarmId INTEGER NN        
CiTimestampedAlarmState_CurrSuppressingConsDesc VARCHAR(63) NN        
CiTimestampedAlarmState_DisableTime TIMESTAMP NN        
CiTimestampedAlarmState_DisabledBy VARCHAR(253) NN        
CiTimestampedAlarmState_EvtSeqNumberClear INTEGER NN        
CiTimestampedAlarmState_Id INTEGER NN        
CiTimestampedAlarmState_LastUpdateTime TIMESTAMP NN        
CiTimestampedAlarmState_OrigSuppressingAlarmId INTEGER NN        
CiTimestampedAlarmState_OrigSuppressingConsDesc VARCHAR(63) NN        
CiTimestampedAlarmState_ReceiptTime TIMESTAMP NN        
CiTimestampedAlarmState_ResponseTime TIMESTAMP NN        
CiTimestampedAlarmState_ResponsibleEntity VARCHAR(127) NN        
CiTimestampedAlarmState_Severity INTEGER NN        
CiTimestampedAlarmState_State INTEGER NN        
CiTimestampedAlarmState_SubConditionActiveTime TIMESTAMP NN        
CiTimestampedAlarmState_VisibleTime TIMESTAMP NN        
Comment VARCHAR(254) NN        
ConfigTime TIMESTAMP NN        
ConfigValid BIT NN        
ConsAlarmsType TINYINT NN        
ConsParentAlarmCond INTEGER NN        
CustomFilters VARCHAR(253) NN        
Delay INTEGER NN        
Description VARCHAR(254) NN        
DisplayName VARCHAR(79) NN        
DocumentContent INTEGER NN        
ExcludeFromExclCtrl BIT NN        
ExclusiveCtrlUser VARCHAR(254) NN        
FullName VARCHAR(254) NN        
HelpViewClass VARCHAR(23) NN        
HelpViewLink INTEGER NN        
Historian TINYINT NN        
InvariantRecordId VARCHAR(40) NN        
MarkerColourBad INTEGER NN        
MemoryUsage INTEGER NN        
Name VARCHAR(63) NN        
NoteTextLong INTEGER NN        
NoteUser VARCHAR(63) NN        
OffTime TIMESTAMP NN        
PagingEnabled BIT NN        
ParentGroupId INTEGER NN        
Priority SMALLINT NN        
Rights INTEGER NN        
StoredDynMetadataFields INTEGER NN        
SuppressingAlarmId INTEGER NN        
SuppressingConsType TINYINT NN        
TypeDesc VARCHAR(63) NN        
TypeNum SMALLINT NN        
UserMethods BIT NN        
UsrAlmSeverityDesc VARCHAR(31) NN        
UsrAlmStateDesc VARCHAR(31) NN        
UsrAlmUnspSeverityDesc VARCHAR(31) NN        
UsrAlmUnspStateDesc VARCHAR(31) NN        
WSAlmSeverityDesc VARCHAR(31) NN        
WSAlmStateDesc VARCHAR(31) NN        
WSAlmUnspSeverityDesc VARCHAR(31) NN        
WSAlmUnspStateDesc VARCHAR(31) NN        

IndexName

IndexType

Columns
pkCiTimestampedAlarm Index Id
Id
idxId Index Id
idxParentGroupId Index ParentGroupId
idxFullName Index FullName
idxConsParentAlarmObjId Index ConsParentAlarmObjId
idxCiTimestampedAlarmState_Id Index CiTimestampedAlarmState_Id

See Also

Alarm Server Side Synchronization

Published June 2018