AVEVA™ Plant SCADA

CiTimestampedAlarm

Save PDF

CiTimestampedAlarm

Save PDF

Last UpdatedJul 18, 2023
3 minute read

ColumnName	DataType	NotNull
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
idxId	Index	Id
idxParentGroupId	Index	ParentGroupId
idxFullName	Index	FullName
idxConsParentAlarmObjId	Index	ConsParentAlarmObjId
idxCiTimestampedAlarmState_Id	Index	CiTimestampedAlarmState_Id

AVEVA™ Plant SCADA

CiTimestampedAlarm

Table of Contents

CiTimestampedAlarm

See Also

Related Links