HistoryParameters

RecipeParameter
MapId

ID that maps back to ID in RecipeParameterMap table in the main database.

No

Integer

RecipeParameter
MapInstance

Increments the value if a Recipe Parameter is used more than once in a recipe execution.

No

Integer

ProcedureTokenId

ID that points to the parent History Capability. This will be null if this is an Equipment Parameter

No

Integer

ProcedureToken
Instance

Parent History Capability

No

Integer

Equipment
ParameterId

ID that maps back to the equipment parameter in the main database

No

Integer

Equipment
ParameterName

Name of Equipment parameter

Yes

nVarchar

EquipementParameterDescription

Description of the Equipment parameter

Yes

nVarchar

FormulaParameter
Id

ID that maps back to the formula parameter in the main database

No

Integer

FormulaParameterName

Name of Formula parameter

Yes

nVarchar

FormulaParameterDescription

Description of the Formula parameter

Yes

nVarchar

ParameterType

Type of parameter

No

Integer

ParameterData
Type

DataType of the parameter

No

Integer

UnitOfMeasure

Name of unit of measure for parameter

Yes

nVarchar

TargetModifiedBy
User

Name of user that modified the target value at execution.

Yes

nVarchar

TargetModifiedBy
UserDoneBy

Name of user that performed the DoneBy on the target value change

Yes

nVarchar

TargetModifiedBy
UserCheckBy

Name of user that performed the CheckBy on the target value change

Yes

nVarchar

TargetModified
DoneByComment

Comment from the DoneBy on the target value change

Yes

nVarchar

TargetModified
CheckByComment

Comment from the CheckBy on the target value change

Yes

nVarchar

TargetModified
DateUtc

Time of the target value change

Yes

DateTime

ControlRecipeId

ID that points to the parent HistoryControlRecipe

No

Integer

OriginalTarget
Value

Specifies the target value from the Formula. In database, this field shows up as OriginalTargetValue. This is stored in neutral culture.

Yes

nVarchar

NewTargetValue

Specifies the possibly modified target value written to controller (may be the same as Original value). In database, this field shows up as NewTargetValue. This is stored in neutral culture.

Yes

nVarchar

MaxValue

Specifies the Max value enforced at execution time. It is the most constricted Max value between the formula and equipment. In database, this field shows up as MaxValue. This is stored in neutral culture.

Yes

nVarchar

MinValue

Specifies the Min value enforced at execution time. It is the most constricted Min value between the formula and equipment. In database, this field shows up as MinValue. This is stored in neutral culture.

Yes

nVarchar

ActualValue

Specifies the final actual value for the parameter. In the database, this field shows up as ActualValue. This is stored in neutral culture.

No

nVarchar

ActualModifiedBy
User

Name of user that modified the actual value at execution, when the manual capability was in ‘WaitForAck’ state.

Yes

nVarchar

ActualModifiedBy
UserDoneBy

Name of user that performed the DoneBy on the actual value change

Yes

nVarchar

ActualModifiedBy
UserCheckBy

Name of user that performed the CheckBy on the actual value change

Yes

nVarchar

ActualModified
DoneByComment

Comment from the DoneBy on the actual value change

Yes

nVarchar

ActualModified
CheckByComment

Comment from the CheckBy on the actual value change

Yes

nVarchar

ActualModified
DateUtc

Time of the actual value change

Yes

DateTime

FrequentlyUsed

Specifies if the capability parameter was mapped and executed with a formula parameter that was marked as frequently used.

No

Boolean

TargetModified
DateOffset

Specifies the offset value from when the Target was modified.

No

Integer

ActualModified
DateOffset

Specifies the offset value from when the Actual value state was modified.

No

Integer

ListDataType

Contains the list data type of the parameter, if any.

Yes

nVarchar

OriginalValueEnumValue

Contains the original formula enum value of the parameter if it is of data type enum list

Yes

Integer

NewValueEnum
Value

Contains the modified enum value of the parameter if it is of data type enum list

Yes

Integer

ActualEnumValue

Contains the actual enum value of the parameter if it is of data type enum list

Yes

Integer