Each row in this table identifies a patch or service.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| install_pkg_uuid | byte(16) | not null | The uuid of the patch or service pack |
| source_type_id | integer | not null | The type code identifying the source of data. See the ca_source_type table. |
| package_uuid | byte(16) | with null | Used by UPM to record the uuid of the Unicenter Software Delivery package after this patch or service pack has been packaged for used with USD. |
| release_notes | long nvarchar | with null | Contains the vendor's release notes associated with this patch or service pack. |
| status | integer1 | with null | "Used by UPM to manage the state of the patch or service pack. 1 = new 2 = not applicable 3 = pending user acceptance 4 = pending workflow acceptance 5 = accepted 6 = deferred by user 7 = packaging 8 = file downloading failed 9 = testing 10 = pending approval 11 = approved 12 = inactive " |
| user_instructions | long nvarchar | with null | Contains any special instructions associated with the patch or service pack. |
| is_downloadable | integer1 | with null | 1 if the patch or service pack can be downloaded, 0 if not. |
| creation_user | nvarchar(64) | with null | |
| is_active | integer1 | with null | See ca_software_def.is_active. |
| creation_date | integer | with null | |
| last_update_user | nvarchar(64) | with null | |
| last_update_date | integer | with null | |
| sw_def_uuid | byte(16) | with null | The uuid of the associated software release, service pack, or patch as identified in the ca_software_def table. |
Product Name: Unicenter Patch Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| install_pkg_uuid | upm_deployment | install_pkg_uuid |
| install_pkg_uuid | ca_install_step | install_pkg_uuid |