The Execution table contains one entry for each request execution.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| executionid | integer | not null | Unique over all executions NOTE: next ID kept in
LookOutIdControl
|
| requestid | integer | not null | The ID from the Request table for the request which was executed. |
| serverid | integer | with null | The ID from the LookOutServer table for the Script Manager server that performed this execution. |
| userid | integer | not null | The ID of user who initiated execution. |
| executionstarttime | date | not null | The Datetime at which this execution began. |
| executionendtime | date | with null | The DateTime which this execution completed. This field is initially set to NULL, and is updated when the execution ends. When this field contains a NULL value the execution is either ACTIVE or has CRASHED. |
Product Name: Data Transformer
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| executionid | error | executionid |
| executionid | ddtablemodify | executionid |
| executionid | ddtable | executionid |
| executionid | scriptmessagelog | executionid |