Stores History of actions done to an Enterprise Package. Stores actual data rather than SP-ID since the subpackage could be deleted.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| ep_id | integer | not null | Enterprise Package ID |
| chrono1 | integer | not null | Update timestamp universal time in sec |
| chrono2 | integer | not null | Update timestamp (milli seconds) |
| action_datetime | date | not null | Date and time of action |
| action | integer | not null | Action Codes - Action - EP Created - EP Deleted - SP Added - SP Deleted - EP Reset - EP Submitted-Execute - EP Submitted-Backout - EP Submitted-Cancel - EP Execute OK - EP Execute Failed - EP Backout OK - EP Backout Failed - EP Cancelled |
| enterprise_package_name | char(40) | with null | Name of Enterprise Package |
| product_name | char(60) | with null | For SP actions, Product Name |
| provider_name | char(20) | with null | For SP Actions, Provider Name |
| usernames | char(40) | not null | For a SP action, username associated with that provider.
For an EP action, delimited string of 'product:username' |
| product_package_name | char(60) | with null | For SP Actions, Sub-package name |
| eccm_configurationid | integer | with null | The eccm_configurationid of the user submitting the package for execution. Is used in the EP execution history report. |
Product Name: AllFusion Change Manager Enterprise Workbench
Table Type: Table