| 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 |  |