Not owned by DSM. Each row in this table describes an individual item within a prerequisite, dependency, or incompatibility expression. 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 | See ca_requirement_spec.owner_bobject_uuid. |
| requirement_spec_type | integer1 | not null | See ca_requirement_spec.requirement_spec_type |
| group_sequence | smallint | not null | See ca_requirement_spec_group.group_sequence. |
| item_sequence_number | integer1 | not null | The ordinal number of the item within its group. |
| referenced_object_uuid | byte(16) | with null | The uuid of the item that is a prerequisite, dependency, or incompatibility. |
| spec_item_operator | nvarchar(5) | with null | "Defines how the prequisite, dependency, or incompatibility is described. EQ = exact match to the referenced object LE = the referenced object or an earlier version GE = the referenced object or a later version THRU = versions from the referenced object through the upper bound. See upper_bound_sw_def_uuid. UPTO = versions from the referenced object up to, but not including the upper bound. See upper_bound_sw_def_uuid. " |
| not_indicator | integer1 | with null | When the value is 1, the group has the boolean operator "NOT" applied to it. |
| item_type_id | integer1 | with null | "When the value is 1, the item refers to a service
pack or patch and referenced_object_uuid contains
the uuid of the corresponding row in ca_software_def.
When the value is 2, the item refers to a specific installation package of a service pack or patch, and referenced_object_uuid contains the uuid of the corresponding row in ca_install_package. When the value is 3, the item refers to a class id, class_id will contain a reference to the ca_class_def table and referenced_object_uuid will be null. " |
| upper_bound_sw_def_uuid | byte(16) | with null | "See spec_item_operator. When spec_item_operator is ""THRU"" or ""UPTO"", upper_bound_sw_def_uuid will contain the UUID of the row in the ca_software_def table that is the upper bound of the version range. " |
| lang_code | nchar(5) | with null | This is almost always null, but if present, it indicates that a particular language is indicated as a prerequiste, dependency, or incompatibility. |
| class_id | integer | with null | When item_type_id is 3, this contains a class id that indicates an operating system prerequisite, dependency, or incompatibility. See ca_class_def and ca_class_hierarchy. |
Product Name: Unicenter Patch Management
Table Type: Table