arg_itemver

Contains information about model versions. In UAPM, each version of software is added to the respective software model. A record is added to this table when a new version is added to any model. Once it is added to the model, assets based on the model can select any of the versions listed in the model.

Column Name Column Datatype Column Null Option Column Comment
model_uuid byte(16) not null Model uuid. First part of the primary key. Foreign key to the ca_model_def table.
ivid smallint not null Version id. Second part of the primary key.
ivname nvarchar(100) with null Version name.
ivavfrdt date with null Availablr from date.
ivavtodt date with null Availablr to date.
ivsuppdt date with null Support date.
ivyear2k date with null Year 2000 date.
ivmannbr nvarchar(50) with null Manufacturer's id.
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.
sw_def_uuid byte(16) with null Software definition id.

Product Name: Unicenter Asset Portfolio Management

Table Type: Table


Copyright © 2006 CA. All rights reserved.