CDBAlarmSummary

System Model > Alarms > Alarm Server Database Specification > CDBAlarmSummary

ColumnName	DataType	Attribute	NotNull	Comment
RecordId	VARCHAR(100)	Attr Indexed Unique ReadOnly RecordId	NN
RecordTime	TIMESTAMP	Attr ReadOnly Constraint	NN
FileId	VARCHAR(17)	Attr Indexed ReadOnly	NN
FileOffset	INTEGER	Attr ReadOnly	NN
SeqNo	ULONGLONG	Attr ReadOnly SequenceNo	NN
Id	INTEGER	Attr Indexed ReadOnly Constraint	NN
AckUserName	VARCHAR(65)	Attr ReadOnly	NN
DisabledByValue	TINYINT	Attr ReadOnly	NN
DisabledByDesc	VARCHAR(65)	Attr ReadOnly	NN
ClientAddress	INTEGER	Attr ReadOnly	NN
ClientAddressDesc	VARCHAR(16)	Attr ReadOnly	NN
SeverityDesc	VARCHAR(32)	Attr ReadOnly	NN
SeverityValue	INTEGER	Attr ReadOnly	NN
State	INTEGER	Attr ReadOnly	NN
StateDesc	VARCHAR(24)	Attr ReadOnly	NN
Deleted	BIT	Attr ReadOnly	NN
Cached	BIT	Attr ReadOnly Constraint	NN
ActiveTime	TIMESTAMP	Attr ReadOnly	NN
InactiveTime	TIMESTAMP	Attr ReadOnly	NN
AckTime	TIMESTAMP	Attr ReadOnly	NN
UnAckTime	TIMESTAMP	Attr ReadOnly	NN
DisabledTime	TIMESTAMP	Attr ReadOnly	NN
ReceiptTime	TIMESTAMP	Attr ReadOnly	NN
DisabledEndTime	TIMESTAMP	Attr ReadOnly	NN
VisibleTime	TIMESTAMP	Attr ReadOnly	NN
Source	VARCHAR(256)	Attr ReadOnly Constraint	NN
ConditionName	VARCHAR(65)	Attr ReadOnly	NN
SubConditionName	TIMESTAMP	Attr ReadOnly	NN
AggregateName	VARCHAR(63)	Attr ReadOnly	NN
AckComment	VARCHAR(33)	Attr ReadOnly	NN
Message	VARCHAR(257)	Attr ReadOnly	NN
EncodedMessage	VARCHAR(254)	Attr ReadOnly	NN
SourceMessage	VARCHAR(257)	Attr ReadOnly	NN
EncodedSourceMessage	VARCHAR(254)	Attr ReadOnly	NN
Location	VARCHAR(33)	Attr ReadOnly	NN
CustomStringField1	VARCHAR(254)	Attr ReadOnly	NN	Full User Name
CustomStringField2	VARCHAR(254)	Attr ReadOnly	NN	Native_SumDesc
CustomStringField3	VARCHAR(254)	Attr ReadOnly	NN	Native_Comment
CustomStringField4	VARCHAR(254)	Attr ReadOnly	NN	UserLocation
CustomStringField5	VARCHAR(254)	Attr ReadOnly	NN	InvariantRecordId
CustomStringField7	VARCHAR(254)	Attr ReadOnly	NN	UserDesc
CustomStringField8	VARCHAR(254)	Attr ReadOnly	NN	<reserved field>
CustomNumericField1	TINYINT	Attr ReadOnly	NN	<reserved field>
CustomNumericField2	TINYINT	Attr ReadOnly	NN	MarkAsDeleted - used to identify the record has been deleted, e.g. By AlarmSumDelete()
CustomNumericField3	TINYINT	Attr ReadOnly	NN	Logged - used to identify the record has been exported to alarm summary log device
CustomNumericField4	UINTEGER	Attr ReadOnly	NN	<reserved field>
CustomNumericField5	UINTEGER	Attr ReadOnly	NN	<reserved field>
CustomNumericField6	UINTEGER	Attr ReadOnly	NN	<reserved field>
CustomNumericField7	INTEGER	Attr ReadOnly	NN	StateNumeric
CustomNumericField8	INTEGER	Attr ReadOnly	NN	<reserved field>
CustomNumericField9	INTEGER	Attr ReadOnly	NN	<reserved field>
CustomNumericField10	ULONGLONG	Attr ReadOnly	NN	<reserved field>
CustomNumericField11	ULONGLONG	Attr ReadOnly	NN	<reserved field>
CustomNumericField12	ULONGLONG	Attr ReadOnly	NN	<reserved field>
CustomNumericField13	LONGLONG	Attr ReadOnly	NN	Duration of the alarm condition referred by the alarm summary record
CustomNumericField14	LONGLONG	Attr ReadOnly	NN	<reserved field>
CustomNumericField15	LONGLONG	Attr ReadOnly	NN	<reserved field>
CustomNumericField16	FLOAT	Attr ReadOnly	NN	Value
CustomNumericField17	FLOAT	Attr ReadOnly	NN	SetPoint
CustomNumericField18	FLOAT	Attr ReadOnly	NN	<reserved field>
CustomNumericField19	REAL	Attr ReadOnly	NN	<reserved field>
CustomNumericField20	REAL	Attr ReadOnly	NN	<reserved field>
CustomNumericField21	REAL	Attr ReadOnly	NN	<reserved field>
CustomNumericField22	TIMESTAMP	Attr ReadOnly	NN	<reserved field>
CustomNumericField23	TIMESTAMP	Attr ReadOnly	NN	<reserved field>
CustomNumericField24	TIMESTAMP	Attr ReadOnly	NN	<reserved field>
AreaOfInterestId	INTEGER	Attr ReadOnly AOI	NN
AreaOfInterest	VARCHAR(255)	Attr ReadOnly AOI	NN

IndexName	IndexType	Columns
pkCDBAlarmSummary	Index	RecordId RecordI
idxRecordId	Index	RecordId
idxFileId	Index	FileId
idxTime	Index	Time
idxRecordTime	Index	RecordTime
idxId	Index	Id
idxSource	Index	Source
idxDeleted	Index	Deleted
idxInvariantRecordId	Index	InvariantRecordId