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 |
NUMBER |
Legacy enum category of the task. (0 => MAINTENANCE. 1 => CLEANING. 2 => RELOCATION. 3 => INSPECTION. 4 => LOW_SOC. 5 => VEHICLE_SWAP. 6 => DAMAGE. 7 => ACCESS_AND_TELEMATICS. 8 => VEHICLE_FAULT. 9 => REGULATORY_AND_COMPLIANCE. 10 => BILLING_AND_CUSTOMER_CHARGE. 11 => ADMINISTRATIVE) |
category_name |
TEXT |
String label for category. |
category_id |
NUMBER |
Foreign key to the task category (replaces the legacy category enum). |
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. |