Project Data Tables Database > td Schema : td.TASKS Table |
Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
---|---|---|---|---|---|---|---|
TASK_ID | The record ID. | int | 4 | ||||
TASK_TYPE | The task type. For example, Import Library, Install Patch. | varchar | 255 | ||||
TASK_DESCRIPTION | A free text description of this item. | varchar | 255 | ||||
TASK_CREATED_BY | The name of the user who initiated the task. | varchar | 255 | ||||
TASK_START_TIME | The time the task was started according to the server clock. | datetime | 4 | ||||
TASK_END_TIME | The time the task was completed according to the server clock. | datetime | 4 | ||||
TASK_RESULT | This string is different for each type of task. | varchar | 16 | ||||
TASK_VER_STAMP | The version number of this record. | int | 4 | ||||
TASK_VTS | The version time stamp. | varchar | 20 | ||||
TASK_PROGRESS | A number between 0 and 100 indicating the percent of task completed. | int | 4 | ||||
TASK_PASSED | Y if task succeeded. | varchar | 1 | ||||
TASK_FAILURE_REASON | A description of the failure or reason for failure. | varchar | 16 | ||||
TASK_STATE | The TASK_STATE_ID of the current state of the task. | int | 4 | ||||
TASK_CONTEXT | This string is task-dependant. | varchar | 255 |