HistoryCapabilities
- Last UpdatedSep 21, 2017
- 1 minute read
The HistoryCapabilities table holds each Procedure information of the executed Recipe or Formula.
|
Field |
Description |
Allow Null |
Type |
|---|---|---|---|
|
ProcedureTokenId |
Unique ID when combined with instance – maps to ProcedureToken Id in main database. |
No |
Integer |
|
ProcedureToken |
Increment 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 |
|
CapabilityRootId |
Specifies the parent Capability root ID |
No |
Integer |
|
CapabilityVersion |
Specifies the parent Capability version |
No |
Integer |
|
CapabilityName |
Specifies the parent Capability name |
Yes |
nVarchar |
|
Sequence |
Specifies the sequence of execution for this Capability. The sequence is based on where it falls in the procedure. |
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 |
|
ChecksumTarget |
Specifies the checksum calculated for all the Capability Parameter targets. |
No |
Integer |
|
RuntimeState |
Specifies runtime. This will be Done or Aborted once the control Recipe is complete. |
No |
Integer |
|
StartDateOffset |
Specifies the offset value from when the Capability was started. |
No |
Integer |
|
CompleteDate |
Specifies the offset value from when the Capability was completed. |
Yes |
Integer |
|
InstructionValue |
Specifies the Operator instruction. |
Yes |
nVarchar |
|
DocumentView |
Specifies the description on the document |
Yes |
nVarchar |
|
DocumentViewUrl |
Specifies the URL link of the document that you can open |
Yes |
nVarchar |