Batch table (PIBATCH)
- Last UpdatedJan 13, 2023
- 1 minute read
- PI System
- PI Server
The PIBATCH table is the database for the PI Batch objects such as PI Campaigns, PI Batches, PI UnitBatches, and PI Transfer Records. This database is independent of PIBatch Subsystem and the databases it maintains. The PI Batch table is actually part of the PI archive and is therefore maintained by PI Archive Subsystem. PI Batch Subsystem records information about each batch in this table, whether the batches are in progress or terminated. See the
Applications Guide
for details on how to access data in this table.
The table name is PIBATCH. The primary key is Handle. It is rarely used in batch searches.
|
PIBATCH Attributes |
Description |
|
UnitName |
Unit name to search |
|
Handle |
Unique identifier for a single batch entry |
|
BID |
Batch ID |
|
ProdID |
Product ID |
|
StartTime |
Batch start time |
|
StartStatus |
Status of batch start time |
|
StopTime |
Batch end time |
|
StopStatus |
Status of batch end time |
|
BIDsearch |
Wild card search string for batch IDs |
|
ProdIDsearch |
Wild card search string for product IDs |
|
SearchStart |
Time to search from |
|
SearchStop |
Time to search to |
|
Count |
Maximum number of batches to retrieve |
|
NEWUnitName |
Changing the unit on which a batch is run by altering attribute is not supported. |
The PI Module and PI Batch database approach replaces the PI Batch Subsystem, the earlier solution for batch data. Refer to the PI SDK Help files for details about the Module and Batch databases.