Sub Package is a product specific package which is included in an Enterprise package. There can be multiple Harvest and/or multiple Endevor packages in a single Enterprise package.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| sp_id | integer | not null | Unique ID which identifies a sub package within an Enterprise package. |
| ep_id | integer | not null | |
| product_code | integer | not null | A numeric field to identify products. 0 for ECCM, 1 for Harvest and 2 for Endevor |
| provider_name | char(20) | with null | Provider Name is the product specific location (machine name for Endevor/broker for Harvest) to which the user logs on. |
| product_packageid | integer | not null | Stores the package id of the sub-package, if available. Either Product packageid or Product package name must be non-NULL. |
| product_package_name | char(60) | with null | Stores the package name of the sub-product. Either Product packageid or Product Package Name must be non-NULL. |
| sp_priority | integer | not null | Determines the order of execution of subpackages within one Enterprise Package |
| sp_lastaction | integer | not null | |
| sp_executionstate | integer | not null | Stores the execution state for a Sub Package 0 for Idle 1 for In Execution |
| sp_executionstatus | integer | not null | Stores the package status for a Sub Package 0 for Initial 1 for "Execution Failed" 2 for "Execution Successful" 3 for "Backout Failed" 4 for "Backout Sucessful" |
| comments | char(80) | with null | |
| sp_executionstart | date | not null | Stores the time when Sub Package Starts execution |
| sp_executionfinish | date | not null | Stores the time when Sub Package finished execution |
| datetime_updated | date | not null | Datetime of the last update |
Product Name: AllFusion Change Manager Enterprise Workbench
Table Type: Table