Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
OOA_OH_Idnr int NUMBER(38,0) int int false ID of the notification object.
OOA_EscTime int NUMBER(38,0) int int true Escalation time in minutes.
OOA_Object varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of the escalation object.
OOA_ActAtRun smallint NUMBER(38,0) smallint smallint true Indicates that the object is generated at runtime or at activation time.
OOA_Type smallint NUMBER(38,0) smallint smallint true Type of notification object. 0 = question, 1 = message, 2 = alarm, 3 = email
OOA_Priority smallint NUMBER(38,0) smallint smallint true Priority of the notification. 1 = high, 2 = normal, 3 = low
OOA_Text varchar(max) CLOB clob(20480 k) INLINE LENGTH 8004 COMPACT text true Content/body of the notification.
OOA_Execute varchar (255) VARCHAR2 (255 CHAR) varchar(255) varchar (255) true Action to be executed. (e.g. play .wav file)
OOA_StartType varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Start type of the notification object.
OOA_IntAccount varchar (16) VARCHAR2 (16 CHAR) varchar(16) varchar (16) true Name of the internal account.
OOA_AutoDeact char (1) CHAR (1 CHAR) char(1) char (1) true Indicates whether or not the notification object quits automatically when the escalation hits. J = quit automatically on escalation
OOA_External int NUMBER(38,0) int int true Type of external notification. 1 = snmp, 2 = email
OOA_Subject varchar (512) VARCHAR2 (512 CHAR) varchar(512) varchar (512) true Subject (for email only)
OOA_AttachReports varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true RunId or a script variable which returns a RunId. Attach all available reports of the RunId's task.
OOA_AttachFile varchar (1024) VARCHAR2 (1024 CHAR) varchar(1024) varchar (1024) true Path of a file to attach.
OOA_ReportSrc smallint NUMBER(38,0) smallint smallint true Source of attached reports. 0 = database, 1 = external files, 2 = all

Indexes:

Name Fields Primary Unique Clustered Nonclustered
NK_OOA_Execute OOA_Execute false false false false
NK_OOA_Object OOA_Object false false false false
PK_OOA OOA_OH_Idnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_OOA_OH OOA_OH_Idnr OH_Idnr

Return to the Index File