Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Plant SCADA

CiDigitalAlarm

  • Last UpdatedJul 18, 2023
  • 3 minute read

ColumnName

DataType

Primary
Key

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

idxId

Index

Id

idxParentGroupId

Index

ParentGroupId

idxFullName

Index

FullName

idxConsParentAlarmObjId

Index

ConsParentAlarmObjId

idxCiDigitalAlarmState_Id

Index

CiDigitalAlarmState_Id

See Also

Alarm Server Side Synchronization

TitleResults for “How to create a CRG?”Also Available in