BatchTask Table (243)
Batch task request details, corresponding to the message body of a batch request messageFields
| Name | Description | Type | Nullable |
|---|---|---|---|
| BatchTask_id | Primary key | PK | No |
| BatchTaskDefinition_id | Batch task definition, which is populated from code attributes | FK BatchTaskDefinition | Yes |
| description | Description of task (for monitoring and debugging) | String(254) | No |
| dbTag | Database tag that this task applies to, to ensure tasks are execute on the correct database only | String(39) | No |
| state | 0=Unknown; 1=New; 2=Assigned; 3=Started; 4=Succeeded; 5=Failed | Int | No |
| detailsTable | Optional table containing further details that will not fit in the standard request/response fields | TableNumber | Yes |
| detailsRecord | Optional record containing further details that will not fit in the standard request/response fields | RecordId | Yes |
| request | The batch request, specifying what to do | String(254) | Yes |
| response | The response from the batch task processor | String(254) | Yes |
| startCount | Number of times this batch task has been started (0 for tasks that have never been executed) | Id | Yes |
| lastStarted | When was this job last started | DateTime | Yes |
| progressPercent | Task progress, in percent of estimated total | UShort | Yes |
| progressDescription | Descriptive text for the current stage | String(254) | Yes |
| registered | Registered when | UtcDateTime | No |
| registered_associate_id | Registered by whom | FK associate | No |
| updated | βheartbeatβ that is updated once a minute by the batch task process | UtcDateTime | No |
| updated_associate_id | βheartbeatβ that is updated once a minute by the batch task process | FK associate | No |
| updatedCount | βheartbeatβ that is updated once a minute by the batch task process | UShort | No |
| FileName | The filename related to the batchtask. | String(260) | Yes |
Indexes
| Fields | Types | Description |
|---|---|---|
| state | Int | Index |
| BatchTaskDefinition_id, state | FK, Int | Index |
Relationships
| Table | Description |
|---|---|
| associate | Employees, resources and other users - except for External persons |
| BatchTaskDefinition | Batch task definitiopns, populated from the SuperOffice.CRM.BatchProcessing.BatchTask attribute |
Replication Flags
- None
Security Flags
- No access control via userβs Role.