Contains information about current event reminders. Event Notification records generate event reminders or notifications that are delivered to the recipients through emails. A record is added to this table when an event notification record generates a notification.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| erid | integer | not null | Event ID. Primary key. |
| object_uuid | byte(16) | with null | Object ID. Foreign key to one of the following fields: ca_company.company_uuid, ca_contact.contact_uuid, ca_location.location_uuid, ca_owned_resource.own_resource_uuid, ca_model_def.model_uuid, arg_legaldoc.legaldoc_uuid |
| object_type | smallint | with null | Object type |
| erobtype | smallint | with null | Event object type |
| erissudt | date | with null | Issue date |
| erstat | smallint | with null | Process Status |
| ersys | smallint | with null | Type |
| erevid | integer | with null | Event rule. Foreign key to the arg_evdefhdr table. |
| erivid | smallint | with null | Version. Foreign key to one of the following fields: arg_itemver.ivid, arg_assetver.avivid |
| erkey1 | nvarchar(32) | with null | Fields defining a unique key for this event entry |
| erkey2 | nvarchar(32) | with null | Fields defining a unique key for this event entry |
| erkey3 | nvarchar(32) | with null | Fields defining a unique key for this event entry |
| erkey4 | nvarchar(32) | with null | Fields defining a unique key for this event entry |
| erkey5 | nvarchar(32) | with null | Fields defining a unique key for this event entry |
| erkey6 | nvarchar(32) | with null | Fields defining a unique key for this event entry |
| erkey7 | nvarchar(32) | with null | Fields defining a unique key for this event entry |
| erevntdt | date | with null | Event date |
| contact_uuid | byte(16) | with null | Primary key. Unique identifier. |
| erchngdt | date | with null | Date created |
| eroldv | nvarchar(255) | with null | Old Value. Indicates the old or original value of a field. Notifications are generated in change events when a value of field is changed. |
| ernewv | nvarchar(255) | with null | New value. Indicates the new field value. |
| erextup | smallint | with null | External update |
| eradinfo | nvarchar(255) | with null | Additional info |
| 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 |
| termination_date | date | with null | Termination date |
| recurring_interval | smallint | with null | Recurring interval |
| 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