Contains information about current event notifications. UAPM facilitates efficient workflow within the organization through Events and Notifications. Events can be either system maintained or user maintained. An event record is created when the conditions specified in the event definition are met and a record is added to this table.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| nyerid | integer | not null | Reminder record id. First part of the primary key. Foreign key to the arg_evrem table. |
| nyid | smallint | not null | Notification id. Second part of the primary key. |
| nysys | smallint | with null | System, Manual. This value indicates whether the event notification is manual or system maintained. |
| nytype | smallint | with null | Notification type |
| nytext | nvarchar(3700) | with null | Notification text that is included in the notification email body. |
| nyissudt | date | with null | Issue date. The date on which the notification needs to be issued. |
| nyrecip | nvarchar(50) | with null | Recipient. Recipient id. |
| nyrtype | smallint | with null | Type of recipient-can be 'initial' and 'escalation'. Initial is the primary and 'escalation' are secondary recipients of the notifications. |
| contact_uuid | byte(16) | with null | Primary key. Unique identifier. |
| nysndate | date | with null | Date sent. Date on which the notification is delivered to the recipient. |
| nyrvdate | date | with null | Date Ack. |
| nyrvfrom | nvarchar(50) | with null | Ack. By. Displays the recipients' email address, if they acknowledge receipt of this notification |
| nyrvtype | smallint | with null | Ack.Type. Displays completed as acknowledgment type, when the notification is issued and acknowledged. |
| nycpdate | 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