Dim.TaskStatus
Task assets in have an attribute called Status. This is a single select list used to indicate the Status of the Task (In Progress). This table contains Type 1 data for the Task Status values defined in your instance.
Table Description
| Column Name | Description | DataType |
|---|---|---|
| TaskStatusKey | Data Mart unique identifier for this value | int |
| TaskStatusOid | Identifier for this value | int |
| TaskStatusName | Name | nvarchar |
| TaskStatusOrder | The order this value appears in the list | int |
| TaskStatusAssertState | State of the list value (Active or Closed) | int |
| TaskStatusCreateDateUTC | UTC Date the value was created | datetime |
| TaskStatusLastModifiedDateUTC | UTC Date the value was last modified | datetime |
| TaskStatusCreatedByKey | Data Mart identifier of the Member that created this value | int |
| TaskStatusLastModifiedByKey | Data Mart identifier of the Member that last modified this value | int |
| TaskStatusCreateDateKey | Foreign Key to Dim.Date for the Create Date | int |
| TaskStatusLastModifiedDateKey | Foreign Key to Dim.Date for the Last Modified Date | int |