| taskId | integer | The internal ID of this Task. |
| projectId | integer | A reference into the activeProjects view, indicating the Project this Task is part of. |
| workflowId | integer | The internal ID of the workflow that this Task is flowing through. |
| workflowName | string | The name of the workflow that this Task is flowing through. |
| stepCount | integer | The ordinal step number of the currently active Task Step. |
| parentId | integer | If this task is part of a sub-workflow, this is the taskId of the task in the parent workflow that spawned this one. Otherwise, not set. |
| parentStepCount | integer | If this task is part of a sub-workflow, this is the step number of the currently active Task Step in the parent workflow. Otherwise, 0. |
| status | integer | Indicates the last event of interest that happened with this Task. One of the following values:
- 1: Editing / translation is in progress for this Task.
- 2: This Task was started.
- 3: The Task was marked for revisiting.
- 4: The Task was completed.
- 5: The Task was exported for offline translation.
- 6: An offline translation was imported.
|
| taskNumInProject | integer | The ordinal number of this Task in the associated Project. |
| creationDate | date | When this Task was created. |
| dueDate | date | When this Task is due (optional). |
| expectedDuration | integer | The number of hours the Task is expected to take to complete (optional). |
| completionDate | date | When the Task was completed. |
| completionStatus | integer | Indicates the status of this task. One the following values:
- 0: Not started
- 1: In progress, successful so far
- 2: In progress, with failures
- 3: Completed successfully
- 4: Failed
- 5: Canceled
|
| currentTaskStepId | integer | A foreign key into the activeTaskSteps table indicating which Task Step is currently active |
| priority | integer | The priority of this Task. |
| includeInCost | boolean | Should this Task’s cost be included in the total cost for the Project? |
| sourceAsset | string | The AIS Path of the source asset. |
| targetAsset | string | The AIS Path of the target asset. |
| type | integer | Ignored. |
| totalWordCount | integer | The total number of words processed by this Task. Not set if the task never caused an asset to be segmented. |
| mtWordCount | integer | The number of words processed by this Task with an MT match. |
| iceWordCount | integer | The number of words processed by this Task with a TM ICE match. Not set if the task never caused an asset to be segmented. |
| perfectWordCount | integer | The number of words processed by this Task with a 100% TM match. Not set if the task never caused an asset to be segmented. |
| repetitionWordCount | integer | The number of words processed by this Task with a TM repetition. Not set if the task never caused an asset to be segmented. |
| creatorName | string | The username of the user who created this task. |
| scopingConfigName | string | The name of the associated scoping configuration. |
| scopingConfigDescription | string | The description of the scoping configuration associated with this Cost Model. |
| defaultScopingConfiguration | string | Indicates whether the description of the scoping configuration associated with this Cost Model. |
| translatedSegments | integer | The number of segments processed so far. |
| totalSegments | integer | The total number of segments to be processed. |