TaskExecutionStatusStep Table

The TaskExecutionStatusStep table stores progress data for rule or background task steps.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for TaskExecutionStatusStep table

Database Column

Details

TaskExecutionStatusStepID

Type: integer. Key. Generated ID

Auto-generated task step execution status ID

TaskExecutionStatusID

Type: integer. Key

Foreign key to TaskExecutionStatus table.

TaskStepID

Type: integer. Key

The ID of task step.

BeaconRuleAction PropertyID

Type: integer. Key. Nullable

The ID of rule action subtask.

DateStarted

Type: datetime. Nullable

Start date and time for a step.

DateCompleted

Type: datetime. Nullable

Completion date and time for a step.

EventTypeStatusID

Type: integer. Key

Foreign key to the EventTypeStatus table

BeaconUID

Type: unique identifier. Key. Nullable

Beacon ID.

EventTypeID

Type: integer. Key. Nullable

Foreign key to the EventType table

EventID

Type: integer. Key. Nullable

Foreign key to the Event table

Location

Type: text (max 255 characters). Nullable

Server name where operation was performed.

TaskParameters

Type: XML. Nullable

parameters for the task step.