Contains information about archived event notifications. UAPM assigns different status values to Event notification records depending on the notifications issue status. When all notifications associated with an event notification record are issued, the Achieved In History status is assigned to it and a record is added to this table..
| Column Name | Column Datatype | Column Null Option | Column Comment |
| hnhrid | integer | not null | Reminder record ID. First part of the primary key. Foreign key to the arg_hsrem table. |
| hnid | smallint | not null | Notification ID. Second part of the primary key. |
| hnsys | smallint | with null | System, Manual |
| hntype | smallint | with null | Notification type |
| hntext | nvarchar(3700) | with null | Notification Text |
| hnissudt | date | with null | Issue date |
| hnrecip | nvarchar(50) | with null | Recipient |
| hnrtype | smallint | with null | Type of Recipient |
| contact_uuid | byte(16) | with null | Recipient. Foreign key to the ca_contact table. |
| hnsndate | date | with null | Date sent |
| hnrvdate | date | with null | Date Ack. |
| hnrvfrom | nvarchar(50) | with null | Ack. By |
| hnrvtype | smallint | with null | Ack. Type |
| hncpdate | date | with null | Date comp/Del |
| creation_user | nvarchar(64) | with null | User or process that created the record. |
| creation_date | integer | with null | Creation date |
| last_update_user | nvarchar(64) | with null | Last update user |
| last_update_date | integer | with null | Last update date |
| version_number | integer | with null | Version number |
Product Name: Unicenter Asset Portfolio Management
Table Type: Table