arg_stathist

Contains status history information for primary objects

Column Name Column Datatype Column Null Option Column Comment
object_uuid byte(16) not null Status Object. 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
shivid smallint not null Version. Second part of the primary key. Foreign key to one of the following fields: arg_itemver.ivid, arg_assetver.avivid
shstatus integer not null Status. Third part of the primary key.
shstatdt date not null Date. Fourth part of the primary key.
object_type smallint with null Object type
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.