BatchProcessExecution Table

BatchProcessExecution is a table storing the details of batch processes requested and executed.

Table 1. Database columns for BatchProcessExecution table

Database Column

Details

BatchProcessExecutionID

Type: integer. Key. Generated ID

A unique identifier for a batch processor.

GUID

Type: unique identifier. Key

The GUID identifying a batch process execution.

BatchProcessTypeID

Type: integer. Key

The type of this batch process execution. Foreign key to the BatchProcessType table.

Submitted

Type: datetime. Key

The date and time at which this batch process execution was submitted.

OperatorLogin

Type: text (max 512 characters). Nullable

The login name of the operator requesting the batch process, NULL indicates a system request.

BeaconID

Type: integer. Key. Nullable

The ID of the beacon which requested a batch process execution. Foreign key to the Beacon table.

BatchProcessorHostname

Type: text (max 128 characters). Key. Nullable

The batch processor responsible for the execution of this batch process. A processor by this name may be in the BatchProcessor table, but this is not required.

BatchProcessStatusID

Type: integer

Status of the batch process execution. Foreign key to the BatchProcessStatus table.

StartTime

Type: datetime. Nullable

The date and time the batch process execution was started.

FinishTime

Type: datetime. Key. Nullable

The date and time the batch process execution finished.

Progress

Type: integer

Percentage indicator of how far through the batch process execution is.

ReturnCode

Type: integer. Nullable

The return code of the batch process execution.

Output

Type: text. Nullable

Contains any output reported by a batch process execution.

GroupName

Type: text (max 50 characters). Nullable

The group name used to partition this batch process. Only relevant for types that require separation by group.

TenantUID

Type: text (max 40 characters). Key. Nullable

The tenant UID for this batch process. Only relevant for types that require separation by tenant.

RawMessage

Type: text. Nullable

The raw, serialized message. Used for pending messages to reconstruct the queue when the batch processor restarts.