Dim.TaskType
Task assets in have an attribute called Type. This is a single select list used to indicate the Type of the Task (Design). This table contains Type 1 data for the Task Type values defined in your instance.
Table Description
| Column Name | Description | DataType |
|---|---|---|
| TaskTypeKey | Data Mart unique identifier for this value | int |
| TaskTypeOid | Identifier for this value | int |
| TaskTypeName | Name | nvarchar |
| TaskTypeOrder | The order this value appears in the list | int |
| TaskTypeAssetState | State of the list value (Active or Closed) | varchar |
| TaskTypeCreateDateUTC | UTC Date the value was created | datetime |
| TaskTypeLastModifiedDateUTC | UTC Date the value was last modified | datetime |
| TaskTypeCreatedByKey | Data Mart identifier of the Member that created this value | int |
| TaskTypeLastModifiedByKey | Data Mart identifier of the Member that last modified this value | int |