enterprise_package

Enterprise Package is a combination of product specific sub packages.

Column Name Column Datatype Column Null Option Column Comment
ep_id integer not null Identifies Enterprise Package
ep_name char(40) not null Stores name of the Enterprise Package, This is an alternate key and is unique across all the configurations.
eccm_configurationid integer not null For every logon to multiple providers through the web page, ECCM Configuration ID identifies a combination by storing the provider names and the corresponding product codes. There should only be one instance of a product per configuration. This should be enforced by the application.
submitting_eccmuserid integer not null  
ep_lastaction integer not null  
ep_executionstate integer not null Stores the execution state of an Enterprise Package 0 for Idle 1 for "Submitted for Execution" 2 for "Submitted for Backout" 3 for "Submitted for Cancellation" 4 for In Execution
ep_executionstatus integer not null Stores the package status for an Enterprise Package 0 for Initial 1 for "Execution Failed" 2 for "Execution Successful" 3 for "Backout Failed" 4 for "Backout Successful"
comments char(80) with null Comments
ep_executionwindowbegin date not null Specifies the time frame within which the Enterprise Package is scheduled for Execution
ep_executionwindowend date not null Specifies the time frame within which the Enterprise Package is scheduled for Execution
ep_executionstart date not null Stores the time when Enterprise Package Starts execution
ep_executionfinish date not null Stores the time when Enterprise Package successfully completed execution.
datetime_updated date not null Datetime of the last update
chrono1 integer not null Update timestamp universal time in sec
chrono2 integer not null Update timestamp (milli seconds)

Product Name: AllFusion Change Manager Enterprise Workbench

Table Type: Table


Copyright © 2006 CA. All rights reserved.