Batch exceptions
The following tables outline the different components of the report.
Datasets
Dataset | Stored Procedure | Comment |
---|---|---|
GetUniqueID | spGetUniqueIDByDate | Gets the unique IDs used between two dates |
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 |
AbnormalState- Changes | Embedded Query | Get the abnormal state changes for a unique ID |
GetUniqueID_ BatchIDForAlarms | Embedded Query | Gets alarms |
GetIntoleranceData | Embedded Query | Gets In tolerance data |
GetBatchFailures | Embedded Query | Gets batch failures |
Report 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 Name filter |
UnitName | NA | Unit Name filter |
UniqueID | NA | Unique ID filter |
Heading Data
Object | Data Item | Data Source | Type |
---|---|---|---|
Start Time | StartTime | User input | Parameter |
End Time | EndTime | User input | Parameter |
Table Datasets
Table | Dataset | Comment |
---|---|---|
table1_AbnormalState- Changes | AbnormalState- Changes | Abnormal State Changes |
table_Alarms | GetUniqueID_BatchIDForAlarms | Alarms |
table_BatchFailures | GetBatchFailures | Batch Failures |
table_OutOfTolerance | GetIntoleranceData | Out of Tolerance data |
Provide Feedback