Contains a list of software definitions. << these two columns are specific to Unicenter Patch Management (and eventually eVM). >>
| Column Name | Column Datatype | Column Null Option | Column Comment |
| sw_def_uuid | byte(16) | not null | Primary key. Unique identifier for a software definition, which can be used as a foreign key to tables that track software or software attributes. |
| name | nvarchar(255) | with null | The identifying name of the software definition. |
| sw_version_label | nvarchar(64) | with null | Used to capture the major/minor version of a release (for example, UAM 4.0) or the build version of a patch (for example, Q123456) - text values. |
| language | nvarchar(50) | with null | Used to differentiate between different language releases of the same product (for example, MS Word German and MS Word Spanish). |
| creation_user | nvarchar(64) | with null | User or process that created the record. |
| creation_date | integer | with null | Date the record was created. |
| last_update_user | nvarchar(64) | with null | User or process that last updated the record. |
| last_update_date | integer | with null | Date the record was last updated. |
| version_number | integer | with null | Version number for transaction integrity. |
| sw_version_number | char(20) | with null | Used to capture the major/minor version of a release (for example, 4.0) or the build version of a patch (for example, 123456) - numeric values. |
| replication_flag | integer | with null | Numeric flag indicating that records of installed instances of a software definition should exist at the enterprise level. |
| software_type_id | integer | not null | Allows for classification of the software into one of several groups: Suite, Product, Component, Patch. Foreign key to the ca_software_type table. |
| source_type_id | integer | not null | Indicates the source of the software definition record (e.g. published by CA, added by the user, or added by a heuristic discovery scanner). Foreign key to the ca_source_type table. |
| description | nvarchar(500) | with null | The software definition description. |
| auto_rep_version | date | with null | Internal revision number used for replication and maintained by the DBMS. |
| manufacturer_uuid | byte(16) | with null | Foreign key to the company_uuid field of the ca_company table indicating the manufacturer of the software. |
| bit_support_id | byte(16) | with null | Bit support ID |
| chip_set_id | byte(16) | with null | Chip set ID |
| domain_uuid | byte(16) | with null | Domain uuid |
| impact | integer1 | with null | "For patches, this column describes the type of problem that the patch fixes. 1 = data loss 2 = availability 3 = functional 4 = performance 5 = security 6 = usability " |
| severity | integer1 | with null | "For patches, this column describes the severity of the problem that the patch fixes. 1 = critical 2 = high 3 = medium 4 = low " |
| is_active | integer1 | not null | |
| no_longer_available | integer1 | with null | |
| family_sw_def_uuid | byte(16) | with null | |
| lang_code | nchar(5) | with null | |
| class_id | integer | with null | |
| linear_sequence_number | integer | with null | |
| filter_from_view | integer1 | with null |
Product Name: Unicenter Patch Management
Table Type: Table