Contains audit information for fields that have changed. An audit trail is a chronological list of changes made to the value of a field over time. A record is added to this table whenever value of a field is changed. Audit trails information of an object can be viewed by selecting the Audit Trail of Changes node in an object’s main view.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| object_uuid | byte(16) | not null | Object ID. First part of the primary key. 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 |
| table_name | nvarchar(32) | not null | Table name of field being audited. Second part of the primary key. First part of foreign key to the arg_field_def table. |
| field_name | nvarchar(32) | not null | Field name of field being audited. Third part of the primary key. Second part of foreign key to the arg_field_def table. |
| hsinstnc | integer | not null | Instance. Fourth part of the primary key. |
| last_update_date | integer | not null | Last update date. Fifth part of the primary key. |
| object_type | smallint | with null | Object type |
| hsaction | nvarchar(10) | with null | Action |
| hstblbl | nvarchar(60) | with null | Object |
| hsfddefi | integer | with null | Audit trail definition ID |
| hsfilbl | nvarchar(60) | with null | Field label |
| hsovalue | nvarchar(50) | with null | Audit trail old value |
| hsvalue | nvarchar(50) | with null | Audit trail New Value |
| hsotext | nvarchar(255) | with null | Old Text |
| hstext | nvarchar(255) | with null | New text |
| hsadinfo | 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 |
| version_number | integer | with null | Version number |
Product Name: Unicenter Asset Portfolio Management
Table Type: Table