ca_requirement_spec

Not owned by DSM. Each row in this table, along with ca_requirement_spec_group and ca_requirement_spec_item, describes a boolean expression which document prerequisites, dependencies, and incompatibilities among software releases, patches, and service packs. The contents of this table should not be modified directly by the user except on direct instructions from CA.

Column Name Column Datatype Column Null Option Column Comment
owner_object_uuid byte(16) not null The uuid of the object for which the expression describes a prerequiste, dependency, or incompatiblity. See owner_object_type.
requirement_spec_type integer1 not null "The type of expression: 1 = prerequisite 2 = dependency 3 = incompatibility "
owner_object_type integer1 not null "When the value is 1, the expression applies to a service pack or patch and object_owner_uuid contains the uuid of the corresponding row in ca_software_def. When the value is 2,the expression applies to a specific installation package of a service pack or patch, and owner_object_uuid contains the uuid of the corresponding row in ca_install_package. "
name nvarchar(64) with null 2 if the expression applies to a specific installation package of a service pack or patch (ca_install_package)
creation_user nvarchar(64) with null  
creation_date integer with null  
last_update_user nvarchar(64) with null  
last_update_date integer with null  
version_number integer with null  
source_type_id integer with null The type code identifying the source of data. See the ca_source_type table.

Product Name: Unicenter Patch Management

Table Type: Table


Copyright © 2006 CA. All rights reserved.