arg_assetver

Contains information about asset versions. UAPM supports multiple version tracking and allows specifying current status for software assets. A new record is added to this table when a new version and the current status is specified for a software asset. This information can be viewed by selecting the respective node under Status history for asset versions node of assets main view.

Column Name Column Datatype Column Null Option Column Comment
own_resource_uuid byte(16) not null Primary key. UUID to uniquely identify the owned resource within tables supporting ownership information.
avivid smallint not null Version ID. Second part of the primary key.
model_uuid byte(16) with null Model uuid. Foreign key to the ca_model_def table.
avacqdt date with null Acquire date
avstatus integer with null Status
avstatdt date with null Status date
avcurrnt smallint with null Current flag
creation_user nvarchar(64) with null Creation user
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


Copyright © 2006 CA. All rights reserved.