Batch detail

Dataset	Stored Procedure	Comment
BHBatch	Embedded query	Gets the Batches executed between two dates
BHPhase	Embedded query	Gets the Recipes used between two dates
BHParamValue	Embedded query	Gets the Units used between two dates
GetUniqueID	spGetUniqueIDByDate	Gets the Unique IDs used between two dates
GetProcessCell	spGetProcessCellByDate	Gets the Process Cells used between two dates
AbnormalStateChanges	Embedded query	Gets the Abnormal State Changes
BHPhase_BHParameters	Embedded query	Gets the Phase Data and Parameters

Parameter	Where used	Comment
StartTime	All Procedures	Start Time; can be set to Null
EndTime	All Procedures	End Time; can be set to Null
SearchWord	NA	User Defined Batch Filter
ProcessCell	NA	Process Cell Filter
RecipeName	NA	Recipe Filter
UniqueID	NA	Unique ID Filter
UnitName	NA	Unit Name Filter

Object	Data Item	Data Source	Type
Batch ID	batchid	BHBatch	Data
Unique ID	uniqueid	BHBatch	Data
Recipe Name	recipefilename	BHBatch	Data
Area Name	area	BHBatch	Data
Process Cell	processcell	BHBatch	Data
Product Code	productcode	BHBatch	Data
Product Description	productdescription	BHBatch	Data
Formulation Name	formulationname	BHBatch	Data
Formulation Description	formulationdescription	BHBatch	Data
Completion State	completionstate	BHBatch	Data
Start Time	starttimeexecution	BHBatch	Data
End Time	endtimeexecution	BHBatch	Data
Duration	endtimeexecution - starttimeexecution	BHBatch	Calculated

Table	Dataset	Comment
table_BHPhase	BHParam_BHPhase_ BHMaterial	Phase Data
table_ AbnormalStateChanges	AbnormalState- Changes	Abnormal State Changes
table_Alarms	GetUniqueID_ BatchIDForAlarms	Alarms and Events
table_Failures	GetBatchFailures	Failures
Setpoint vs Actual	BHParamValue	Sub Report