Stores records of tasks associated with work orders
Data model
Fields
| Field | Type | Description |
|---|---|---|
| wtask_attendant_id | INT | Unique Specialist Identifier Assigned to the Task |
| wtask_attendant_name | NVARCHAR (100) | Name of the specialist associated with the task |
| wtask_attention_end_date | DATETIME | Task End Date |
| wtask_attention_start_date | DATETIME | Start date of task attention |
| wtask_description* | VARCHAR (MAX) | Task Description |
| wtask_id* | INT | Unique task identifier |
| wtask_manual_programmed | BIT | Determines if a task was manually scheduled |
| wtask_order* | INT | Determine the order of tasks |
| wtask_tentative_attention_start_date | DATETIME | Tentative date of start of task care |
| wtask_work_id* | INT | Unique identifier of the order associated with the task |
| wtask_work_state_id* | INT | Process state default |
Primary Key
| PK__AFLS_WOR__B1F75E2FB866CDC6 |
|---|
| wtask_id |