Previous Topic: Notify_Object_Attr TableNext Topic: NR_Comment Table


Notify_Rule Table

List of object attribute contacts and definitions for notification rules.

Field

Data Type

Reference

Remarks

id

INTEGER

 

UNIQUE

NOT_NULL KEY

persid

nvarchar(30)

 

Specifies the object key

del

INTEGER

 

Delete indicator

sym

nvarchar(128)

 

Symbolic description

REQUIRED

description

nvarchar(500)

 

Long description

condition

nvarchar(30)

Spell_Macro

Specifies the foreign key to the condition macro.

obj_type

nvarchar(30)

 

Specifies the object type as cr, chg, or iss

REQUIRED

last_mod_dt

LOCAL_TIME

 

Audit trail date

last_mod_by

UUID

ca_contact

Audit trail user

default_rule

INTEGER

 

1—Default rule; do not allow condition

cr_notify_info

nvarchar(30)

ntfm

Specifies the foreign key for 'cr' obj_type to condition macro.

chg_notify_info

nvarchar(30)

ntfm

Specifies the foreign key for 'chg' obj_type to condition macro.

iss_notify_info

nvarchar(30)

ntfm

Specifies the foreign key for 'iss' obj_type to condition macro.

mgs_notify_info

nvarchar(30)

ntfm

Specifies the foreign key for 'mgs' obj_type to condition macro.

kd_notify_info

nvarchar(30)

ntfm

Specifies the foreign key for 'kd' obj_type to condition macro.

kd_comment_ notify_info

nvarchar(30)

ntfm

Specifies the foreign key for 'kd_comment' obj_type to condition macro.

krc_notify_info

nvarchar(30)

ntfm

Specifies the foreign key for 'krc' obj_type to condition macro.

sa_notify_info

nvarchar(30)

ntfm

Specifies the foreigh key for 'sa' obj_type to condition macro.

cnt_notify_info

nvarchar(30)

ntfm

Specifies the foreigh key for 'cnt' obj_type to condition macro.

ci_notify_info

nvarchar(30)

ntfm

Specifies the foreigh key for 'ci' obj_type to condition macro.

tenant

UUID

ca_tenant

Specifies the UUID of the tenant.

ntfr_ntflist

LREL

ntfl

Associated Object Contacts

ntfr_ctplist

LREL

ctp

Associated Contact Types

ntfr_macrolist

LREL

macro

Macros (aty's) using this rule