el_tasks
Tasks are stored in their own collection, and can have a many-to-many relationship with Person records, Element451 user records and Element451 Teams records.
This model extracts some key data from the Tasks object, making it ready for analysis.
el_tasks
33 rows
| Column | Description | Data Type |
|---|---|---|
| created_at | Date and time when the task was created | TIMESTAMP_NTZ |
| task_name | Name of the task | VARCHAR |
| task_id | Identifier for a task | VARCHAR |
| overdue | Indicates whether the task is overdue (true/false) | BOOLEAN |
| due_datetime | Due date and time for the task | TIMESTAMP_NTZ |
| subdom | Identifier for a specific domain or subset | VARCHAR |
| status_detailed | Detailed status of the task | VARCHAR |
| task_duration_days | Duration of the task in days | NUMBER |
| timezone_offset | Timezone offset | NUMBER |
| completed_on_time | Indicates whether the task was completed on time (true/false) | BOOLEAN |
| done_at | Date and time when the task was marked as done | TIMESTAMP_NTZ |
| due_datetime_local | Local due date and time for the task | TIMESTAMP_NTZ |
| last_updated_by | Identifier of the last person who updated the task | VARCHAR |
| timezone | Timezone of the task | VARCHAR |
| assigned_to | Identifier of the assigned person | VARCHAR |
| upcoming | Indicates whether the task is upcoming (true/false) | BOOLEAN |
| due_date | Due date for the task | TIMESTAMP_NTZ |
| task_note | Additional note related to the task | VARCHAR |
| due_today | Indicates whether the task is due today (true/false) | BOOLEAN |
| task_type | Type of the task | VARCHAR |
| task_category | "internal", "external". Defines the responsibility for the task. Internal tasks are assigned to staff. External tasks, or contact tasks, are assigned to students. | VARCHAR |
| etl_loaded_at | Date and time when the data was loaded into ETL | TIMESTAMP_NTZ |
| assigned_at_local | Local date and time when the task was assigned | TIMESTAMP_NTZ |
| task_budgeted_days | Budgeted duration of the task in days | NUMBER |
| assigned_at | Date and time when the task was assigned | TIMESTAMP_NTZ |
| related_to | Identifier related to the task | VARCHAR |
| created_by | Identifier of the creator of the task | VARCHAR |
| completed | Indicates whether the task is completed (true/false) | BOOLEAN |
| active_client | Indicates whether the client is active (true/false) | BOOLEAN |
| status_basic | Basic status of the task (e.g., Complete) | VARCHAR |
| created_at_local | Local date and time when the task was created | TIMESTAMP_NTZ |
| done_at_local | Local date and time when the task was marked as done | TIMESTAMP_NTZ |
| updated_at | Date and time when the task was last updated | TIMESTAMP_NTZ |
Was this page helpful?