HistoryParameterExts
- Last UpdatedApr 21, 2017
- 1 minute read
The HistoryParameterExts table stores the Parameter Extension values when the Recipe execution is completed (Done or Aborted/Stopped).
|
Field |
Description |
Allow Null |
Type |
|---|---|---|---|
|
HistoryParameter |
ID that points to the parent HistoryParameterExtDef. |
No |
Integer |
|
RecipeParameter |
ID that points to the parent HistoryParameter. |
No |
Integer |
|
ValueModifiedBy |
Name of the user that modified the value at execution. |
Yes |
nVarchar |
|
OriginalValue |
Specifies the value from the Formula. |
Yes |
nVarchar |
|
NewValue |
Specifies the possibly modified value written to the controller (may be the same as Original value). |
Yes |
nVarchar |
|
ValueModifiedBy |
Name of the user that performed the Done By action on the value change. |
Yes |
nVarchar |
|
ValueModifiedBy |
Name of the user that performed the Check By action on the value change. |
Yes |
nVarchar |
|
ValueModifiedDoneByComment |
Comment from the Done By action on the value change. |
Yes |
nVarchar |
|
ValueModified |
Comment from the Check By action on the value change. |
Yes |
nVarchar |
|
ValueModifiedDateUtc |
Time of the value change. |
Yes |
DateTime |
|
ValuesFrom |
Specifies whether the Parameter Extension value is from Formula. |
No |
Bit |
|
ValuesModified |
Specifies the offset value from the datetime when the Parameter Extension was modified |
No |
Integer |
|
NewValueEnum |
Contains the modified enum value of the parameter if it is of data type enumlist |
Yes |
Integer |
|
OriginalValueEnumValue |
Contains the original formula enum value of the parameter if it is of data type enumlist |
Yes |
Integer |