Previous Topic: Notification_Urgency TableNext Topic: Notify_Msg_Tpl Table


Notify_Log_Header Table

This table keeps track of each notify, and what happened to it.

Field

Data Type

Reference

Remarks

cmth_used

INTEGER

Contact_Method ::id

 

cntxt_obj

STRING 30

 

Specifies the termination of sequence Context for notification.

context_instance

STRING 30

 

Contains the persistent ID of the associated Activity Log for the notifications.

del

INTEGER NOT_NULL

Active_Boolean_ Table::enum

Deleted flag

0—Active

1—Inactive/marked as deleted

id

INTEGER UNIQUE NOT_NULL KEY

 

Unique (to the table) Numeric ID.

last_mod

LOCAL_TIME

 

Specifies the last modification time, for purging.

nlh_ack_by

LOCAL_TIME

 

Specifies the time deadline for ack.

nlh_ack_time

DURATION

 

Specifies how long for ack.

nlh_c_addressee

UUID

ca_contact::uuid

Specifies the alias contact.

nlh_c_alias

UUID

 

 

nlh_cm_method

INTEGER

Notification_ Urgency::enum

 

nlh_email

STRING 50

 

Specifies the resolved email address (the email notification sent was not associated with the proper contact).

nlh_end

LOCAL_TIME

 

Specifies the time of ACK or FYI final.

nlh_hdr

STRING 40

 

Specifies the msg header text.

nlh_msg

STRING 4000

 

Specifies the message text.

nlh_msg_html

STRING 32768

 

Specifies the html version of notification if sent through mail.

nlh_pri

INTEGER

 

Generating notification enum priority of transition event

nlh_start

LOCAL_TIME NOT_NULL

 

Specifies the notification start date.

nlh_status

INTEGER

 

Pending send, sent FYI.

nlh_transition

INTEGER

 

Specifies the notify method used - redefined in majic, points to 'noturg' object Transition point.

nlh_type

INTEGER

 

FYI or ack

nlh_user_ack

STRING 40

 

Sent ack, acked, nacked, cleared. Who acknowledged or cleared it.