HistoryControlRecipes
- Last UpdatedApr 21, 2017
- 2 minute read
The HistoryControlRecipe table holds each Recipe or Formula download execution instance.
|
Field |
Description |
Allow Null |
Type |
|---|---|---|---|
|
ControlRecipeId |
Unique Id – maps to ControlRecipe Id in the main database. |
No |
Integer |
|
SiteId |
Specifies the Site where this Control Recipe is executed |
No |
Integer |
|
EquipmentRootId |
Specifies the parent Equipment Root ID |
No |
Integer |
|
EquipmentVersion |
Specifies the parent Equipment version |
No |
Integer |
|
EquipmentName |
Specifies the parent Equipment name |
Yes |
nVarchar |
|
RecipeRootId |
Specifies the parent Recipe root ID. If this is a Formula download, this may be null. |
Yes |
Integer |
|
RecipeVersion |
Specifies the parent Recipe version. If this is a Formula download, this may be null. |
Yes |
Integer |
|
RecipeName |
Specifies the parent Recipe name. If this is a Formula download, this will be the Formula name. |
Yes |
nVarchar |
|
FormulaRootId |
Specifies the parent Formula root ID. |
No |
Integer |
|
FormulaVersion |
Specifies the Formula version. |
No |
Integer |
|
FormulaName |
Specifies the parent Formula name. |
Yes |
nVarchar |
|
FormulaTemplate |
Specifies the parent Formula Template root ID |
No |
Integer |
|
FormulaTemplate |
Specifies the parent Formula Template version |
No |
Integer |
|
FormulaTemplate |
Specifies the parent Formula Template name. |
Yes |
nVarchar |
|
ProcedureRootId |
Specifies the parent Procedure root ID. If this is a procedureless Recipe, this will be null. |
Yes |
Integer |
|
ProcedureVersion |
Specifies the parent Procedure version. If this is a procedureless Recipe, this will be null. |
Yes |
Integer |
|
ProcedureName |
Specifies the parent Procedure name. If this is a procedureless Recipe, this will be null. |
Yes |
nVarchar |
|
StartDateUtc |
Specifies the DateTime when the Recipe was started. |
Yes |
DateTime |
|
CompleteDateUtc |
Specifies the DateTime when the Recipe was completed (Done or Aborted). It will be null if still executing. This DateTime value will be greater or equal to all other DateTimes (ex. CreatedDate) in all the child records. This can be used for ETL extraction. |
Yes |
DateTime |
|
ChecksumTarget |
Specifies the checksum calculated for all the Equipment Parameter targets |
No |
Integer |
|
NoProcedure |
Specifies if this is a Recipe with procedure or without procedure. |
No |
Bit |
|
RuntimeState |
Specifies the runtime state. This will be Done or Aborted once the Recipe is complete |
No |
Integer |
|
RecipeTemplate |
Specifies the parent Recipe Template root ID |
No |
Integer |
|
RecipeTemplate |
Specifies the parent Recipe Template version |
No |
Integer |
|
RecipeTemplate |
Specifies the parent Recipe Template name. |
Yes |
nVarchar |
|
AssignDateUTC |
Specifies the assign date when the Recipe was assigned. |
No |
Integer |
|
AssignDateOffset |
Specifies the offset value from when the Recipe was assigned. |
No |
Integer |
|
StartDateOffset |
Specifies the offset value from when the Recipe was started. |
No |
Integer |
|
CompleteDate |
Specifies the offset value from when the Recipe was completed. |
No |
Integer |
|
BatchSize |
Specifies the Formula batch size. |
Yes |
nVarchar |
|
UnitofMeasure |
Specifies the unit of measure used for batch. |
Yes |
nVarchar |