Name Type MSSql Type Oracle Type DB2 Nullable Description
OOA_OH_Idnr int NUMBER(38,0) int false reference to the object header (OH)
OOA_EscTime int NUMBER(38,0) int true escalation time in minutes
OOA_Object varchar (200) VARCHAR2 (200 CHAR) varchar(200) true object name
OOA_ActAtRun smallint NUMBER(38,0) smallint true activation at runtime?
OOA_Type smallint NUMBER(38,0) smallint true call operator type 0=question, 1=message, 2=alarm, 3=email
OOA_Priority smallint NUMBER(38,0) smallint true priority: 1= high, 2 = normal, 3 = low
OOA_Text varchar(max) CLOB clob(20480 k) INLINE LENGTH 8004 COMPACT true text to send
OOA_Execute varchar (255) VARCHAR2 (255 CHAR) varchar(255) true action to be executed (e.g. play .wav file)
OOA_StartType varchar (200) VARCHAR2 (200 CHAR) varchar(200) true start type
OOA_IntAccount varchar (16) VARCHAR2 (16 CHAR) varchar(16) true account
OOA_AutoDeact char (1) CHAR (1 CHAR) char(1) true J=Quit automatically on escalation
OOA_External int NUMBER(38,0) int true bit array for external notification 1=SNMP, 2=eMail
OOA_Subject varchar (255) VARCHAR2 (255 CHAR) varchar(255) true subject (for mail)
OOA_AttachReports varchar (32) VARCHAR2 (32 CHAR) varchar(32) true RunID or a script variable which returns a runID
OOA_AttachFile varchar (255) VARCHAR2 (255 CHAR) varchar(255) true Path of a file to attach
OOA_ReportSrc smallint NUMBER(38,0) smallint true Source of attached reports (0=Database, 1=Ext. 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