eccm_actionlog

Stores subpackage execution reports and for Element Action report (depending on LOG_TYPE). KEY1 and KEY2 values are depending on the LOG_TYPE. Multiple rows are identified by a SEQ value. Log text is stored as HEXRAW.

Column Name Column Datatype Column Null Option Column Comment
key1 integer not null Identifies the Enterprise Subpackage (EP_ID) report or the Element action (ECCMUSERID) report depending on LOG_TYPE
key2 integer not null Identifies Enterprise subPackage by (SP_ID) or an Element ACTION for a dedicated sessionID (SESSIONID)
chrono1 integer not null Update timestamp universal time in sec
chrono2 integer not null Update timestamp (milli seconds)
log_type smallint not null Identifies an Enterprise SubPackage report row (EwDB.LOG_PKGACTION value 3) or an Element ACTION log row (EwDB.LOG_ELMACTION value 2)
seq smallint not null Sequence number allocated for multiple rows
log_text byte(1900) with null Log text is converted binary coded over multiple rows

Product Name: AllFusion Change Manager Enterprise Workbench

Table Type: Table


Copyright © 2006 CA. All rights reserved.