This table keeps track of each notify, and what happened to it.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | integer | not null | Unique (to the table) numeric identifier. |
| del | integer | not null | Deleted flag (0=active 1=inactive/marked as deleted) |
| last_mod | integer | with null | Last modification time, for purging |
| nlh_hdr | nvarchar(40) | with null | Msg header text |
| nlh_msg | nvarchar(4000) | with null | Message text |
| nlh_msg_html | long nvarchar | with null | html version of notification if sent via mail |
| nlh_c_alias | byte(16) | with null | The nlh c alias value for this Notify_Log_Header. |
| nlh_c_addressee | byte(16) | with null | Alias contact |
| nlh_email | nvarchar(50) | with null | Resolved addressee email address of notification sent email not associated with contact |
| nlh_cm_method | integer | with null | The notify method value for this Notify_Log_Header. |
| nlh_transition | integer | with null | Notify method used - redefined in majic, points to 'noturg' object Transition point |
| nlh_pri | integer | with null | Generating notification enum priority of transition event |
| nlh_type | integer | with null | FYI or ack |
| nlh_ack_time | integer | with null | How long for ack |
| nlh_status | integer | with null | Pending send, sent FYI, |
| nlh_user_ack | nvarchar(40) | with null | Sent ack, acked, nacked, cleared. Who acknowledged or cleared it. |
| nlh_start | integer | not null | Notification start date and |
| nlh_ack_by | integer | with null | Time deadline for ack. |
| nlh_end | integer | with null | Time of ACK or FYI final |
| cntxt_obj | nvarchar(30) | with null | Termination of sequence Context for notification |
| cmth_used | integer | with null | The cmth used value for this Notify_Log_Header. |
Product Name: Unicenter Service Desk
Table Type: Table