Contains information about relationships between entities. Relationships are links between related UAPM objects that describe the interdependencies between them. These links help to locate and retrieve the information faster. A record is appended to this table when a relationship is created between objects. This information can be viewed by selecting the respective node under Primary or Secondary object’s relationship nodes in an object’s main view.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| acadid | integer | not null | Relationship definition ID. Primary key. |
| object_uuid | byte(16) | not null | Primary object. Second 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. Object UUID is the Unicenter Unique ID that is assigned to UAPM objects at the time of creation. This field stores the primary object's uuid. |
| ac1ivid | smallint | not null | Primary Object Version. Third part of the primary key. Foreign key to one of the following fields: arg_itemver.ivid, arg_assetver.avivid |
| acdatedt | date | not null | Date. Fourth part of the primary key. Stores the date and time of relationship creation. |
| actimetm | nvarchar(8) | not null | Time. Fifth part of the primary key. |
| object_type | smallint | with null | Object type |
| accommnt | nvarchar(255) | with null | Comments |
| actext1 | nvarchar(30) | with null | Change ID/Max Model Group. Foreign key to the dlkey column of the arg_drpdnlst table. |
| acint1 | smallint | with null | SW license password Info |
| acdate1 | date | with null | SW license password date |
| 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