Dim.TestType
Test assets in have an attribute called Type. This is a single select list used to indicate the Type of the Test (Functional). This table contains Type 1 data for the Test Type values defined in your instance.
Table Description
| Column Name | Description | DataType |
|---|---|---|
| TestTypeKey | Datamart unique identifier for this value | int |
| TestTypeOid | Identifier for this value | int |
| TestTypeName | Name | nvarchar |
| TestTypeOrder | The order this value appears in the dropdown list | int |
| TestTypeAssetState | State of the list value | varchar |
| TestTypeCreateDateUTC | UTC Date the value was created | datetime |
| TestTypeLastModifiedDateUTC | UTC Date the value was last modified | datetime |
| TestTypeCreatedByKey | Data Mart identifier of the Member that created this value | int |
| TestTypeLastModifiedByKey | Data Mart identifier of the Member that last modified this value | int |
| TestTypeCreateDateKey | Foreign Key to Dim.Date for the Create Date | int |
| TestTypeLastModifiedDateKey | Foreign Key to Dim.Date for the Last Modified Date | int |