Description:
Represents tasks created and tracked within the platform. Tasks may be linked to damages, issues, vehicles, users, or branches. Each task includes metadata about category, priority, state, assignment, and lifecycle timestamps.
🔑 Primary Key
id
| Field Name | Data Type | Description |
|---|---|---|
id |
NUMBER |
Unique identifier for the task. |
title |
TEXT |
Short title or summary of the task. |
description |
TEXT |
Detailed description of the task. |
state |
NUMBER |
Current state of the task. (0 => NEW. 1 => IN_PROGRESS. 2 => RECURRING. 3 => COMPLETED) |
state_name |
TEXT |
String label for state. |
priority |
NUMBER |
Priority level of the task. (0 => LOW. 1 => NORMAL. 2 => HIGH. 3 => SEVERE) |
priority_name |
TEXT |
String label for priority. |
created_at |
TIMESTAMP_TZ |
Timestamp when the task was created. |
updated_at |
TIMESTAMP_TZ |
Timestamp when the task was last updated. |
branch_id |
NUMBER |
Identifier of the branch associated with the task. |
created_by |
NUMBER |
Identifier of the user who created the task. |
updated_by |
NUMBER |
Identifier of the user who last updated the task. |
assigned_to |
NUMBER |
Identifier of the user assigned to the task. |
issue_id |
NUMBER |
Identifier of the issue linked to the task (if applicable). |
vehicle_id |
NUMBER |
Identifier of the vehicle associated with the task. |
guser_id |
NUMBER |
Identifier of the user related to the task (if applicable). |
recurring_task_id |
NUMBER |
Identifier of the recurring task this task belongs to (if generated from a recurring schedule). |
role_id |
NUMBER |
Identifier of the role associated with the task (if role-based assignment). |
damage_id |
NUMBER |
Identifier of the damage record related to the task (if applicable). |
category_id |
NUMBER |
Foreign key to the task category, as configured by the operator. The legacy category and category_name columns were removed in September 2026. |
task_template_uuid |
TEXT |
Identifier of the task template from which this task may have been created. |
_snowflake_inserted_at |
TIMESTAMP_NTZ |
System timestamp when the record was inserted into Snowflake. |
_snowflake_updated_at |
TIMESTAMP_NTZ |
System timestamp when the record was last updated in Snowflake. |
_snowflake_deleted |
BOOLEAN |
True if the record was deleted in the source. |