HistoryTransitions
- Last UpdatedSep 12, 2016
- 1 minute read
This table stores the Transition history.
|
Field |
Description |
Allow Null |
Type |
|---|---|---|---|
|
ProcedureTokenId |
Unique ID when combined with Instance – maps to ProcedureToken Id in main database. |
No |
BigInt |
|
ProcedureToken |
Value is incremented each time a procedure token is executed. |
No |
Integer |
|
ControlRecipeId |
Specifies the parent control recipe ID |
No |
Integer |
|
ProcedureToken |
Specifies the Label/Name of the token |
No |
nVarchar |
|
Sequence |
Specifies the sequence of execution for this transition. The sequence is based on where it falls in the procedure. |
No |
Integer |
|
TokenType |
Specifies the type of transition token (ex. loop, branch one, etc) |
No |
Integer |
|
StartDateUtc |
Specifies the DateTime when the Capability was started |
No |
DateTime |
|
CompleteDateUtc |
Specifies the DateTime when the capability was completed (Done or Aborted). It will be null if still executing. |
Yes |
DateTime |
|
RuntimeState |
Specifies runtime state. This will be Done or Aborted or Forced once the token execution is complete |
No |
Integer |
|
Transition |
Specifies the transition expression. |
Yes |
nVarchar |
|
StartDateOffset |
Specifies the offset value from when the Capability was started. |
No |
Integer |
|
CompletedDate |
Specifies the offset value from when the Capability was completed. |
No |
Integer |