Backward tracing
These tables outline the different components of the report.
Datasets
Dataset | Stored Procedure | Comment |
|---|---|---|
GetRecipeNames | spGetRecipeNamesByDate | Gets the Recipes used between two dates |
GetUnitName | spGetUnitNameByDate | Gets the Units used between two dates |
GetProcessCell | spGetProcessCellByDate | Gets the Process Cells used between two dates |
GetUniqueID | spGetUniqueIDByDate | Gets the Unique IDs used between two dates |
GetLotID | spGetLotIDByDate | Gets the Lot Names used between two dates |
GetBatchUsageData | spGetBatchUsageDataByDate | Gets the Lots used by batches |
GetEquipmentNames | spGetLotID_UnitNameByDate | Gets the Equipment used between two dates |
GetEquipmentUsed- ByBatch | spGetEquipmentUsedBy- BatchByDate | Gets the Equipment used by batches |
Report Parameters
Parameter | Where used | Comment |
|---|---|---|
StartTime | All Procedures | Start Time |
EndTime | All Procedures | End Time |
SearchWord | NA | User Defined Batch Filter |
ProcessCell | NA | Process Cell Filter |
RecipeName | NA | Recipe Name Filter |
ReportType | NA | Query Parameter |
QueryParam | GetUniqueID | Query Parameter |
UnitName | GetUnitName | Unit Name Filter |
Heading Data
Object | Data Item | Data Source | Type |
|---|---|---|---|
Unique ID | QueryParam | BHBatch | Parameter |
Batch ID | BatchID | BHBatch | Data |
Recipe Name | Recipefilename | BHBatch | Data |
Area Name | area | BHBatch | Data |
Process Cell | Processcell | BHBatch | Data |
Product Description | productdescription | BHBatch | Data |
Formulation Name | formulationname | BHBatch | Data |
Formulation Description | formulationdescription | BHBatch | Data |
Completion State | completionstate | BHBatch | Data |
Table Datasets
Table | Dataset | Comment |
|---|---|---|
table_GetBatchUsageData | GetBatchUsageData | Batch Usage |
table_GetEquipmentUsed- ByBatch | GetEquipmentUsed- ByBatch | Equipment Usage |
Provide Feedback