This table is used by the workflow component of Unicenter Patch Management to manage the progession of service packs, patches, policies, and deployments through the review, approval, testing, and deployment processes. 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 |
| workflow_uuid | byte(16) | not null | The uuid of the workflow object as assigned by the UPM workflow manager when the referenced object (object_uuid) requires attention. |
| result | integer | with null | The result of the operation. |
| when_created | integer | with null | The date/time the operation was created. The date/time is recorded as the number of seconds that have elapsed since January 1, 1970 at midnight GMT. |
| when_completed | integer | with null | The date/time the operation was completed. The value is null until the operation is complete. The date/time is recorded as the number of seconds that have elapsed since January 1, 1970 at midnight GMT. |
| success_next_state | smallint | with null | The state to set if the operation succeeds. The value depends on the type of object being managed. See the ca_install_package.status or upm_baseline.status or upm_deployment.status. |
| failure_next_state | smallint | with null | The state to set if the operation fails. The value depends on the type of object being managed. See the ca_install_package.status or upm_baseline.status or upm_deployment.status. |
| object_type | smallint | not null | "The type of object being managed by the UPM workflow component. 1 = service pack or patch - see ca_install_package 2 = baseline (a.k.a. policy) - see upm_baseline 3 = deployment - see upm_deployment " |
| object_uuid | byte(16) | not null | The uuid of the object being managed. See object_type. |
Product Name: Unicenter Patch Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| workflow_uuid |