Contains information about archived event reminders. Achieved event reminders are the notifications or reminders that are issued to the recipients. Once an email notification is issued, a record is added to this table.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| hrid | integer | not null | Event. 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 |
| hrobtype | smallint | with null | Event object type |
| hrissudt | date | with null | Issue date |
| hrstat | smallint | with null | Process Status |
| hrsys | smallint | with null | Type |
| hrevid | integer | with null | Event rule ID |
| hrivid | smallint | with null | Version. Foreign key to one of the following fields: arg_itemver.ivid, arg_assetver.avivid |
| hrkey1 | nvarchar(32) | with null | Fields defining a unique key for this event entry |
| hrkey2 | nvarchar(32) | with null | Fields defining a unique key for this event entry |
| hrkey3 | nvarchar(32) | with null | Fields defining a unique key for this event entry |
| hrkey4 | nvarchar(32) | with null | Fields defining a unique key for this event entry |
| hrkey5 | nvarchar(32) | with null | Fields defining a unique key for this event entry |
| hrkey6 | nvarchar(32) | with null | Fields defining a unique key for this event entry |
| hrkey7 | nvarchar(32) | with null | Fields defining a unique key for this event entry |
| hrevntdt | date | with null | Event date |
| contact_uuid | byte(16) | with null | Set By. Foreign key to the ca_contact table. |
| hrchngdt | date | with null | Date created |
| hroldv | nvarchar(255) | with null | Old value |
| hrnewv | nvarchar(255) | with null | New value |
| hrextup | smallint | with null | External update |
| hradinfo | 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 |
| last_update_date | integer | with null | Last update date |
| termination_date | date | with null | Termination date |
| recurring_interval | smallint | with null | Recurring interval |
| version_number | integer | with null | Version number |
Product Name: Unicenter Asset Portfolio Management
Table Type: Table