Dim.Environment
In Agility Regression Suites are paired with an Environment to generate a Test Set which will be scheduled for execution with a given iteration. The Environment is the technical setup used for running tests, such as operating system, client, database, etc. This table contains Type 1 data for the Environments defined in your instance.
Table Description
| Column Name | Description | DataType |
|---|---|---|
| EnvironmentKey | Datamart unique identifier for this Environment | int |
| EnvironmentOid | VersionOne unique identifier for this Environment | int |
| EnvironmentName | Name | nvarchar |
| EnvironmentDisplayId | Environment Identifier visible in VersionOne grids | varchar |
| EnvironmentProjectName | Name of Project where Environment is defined | nvarchar |
| EnvironmentProjectKey | Foreign Key to the Project where this Environment is defined | int |
| EnvironmentAssetState | AssetState for this Environment | varchar |
| EnvironmentCreatedByName | Name of Member that created this Environment | nvarchar |
| EnvironmentLastModifiedByName | Name of Member that last modified this Environment | nvarchar |
| EnvironmentCreateDateUTC | UTC Date when this Environment was created | datetime |
| EnvironmentLastModifiedDateUTC | UTC Date of when this Environment was last modified | datetime |
| EnvironmentCreatedByKey | Foreign Key the Dim.Member that created this Environment | int |
| EnvironmentLastModifiedByKey | Foreign Key the Dim.Member that last modified this Environment | int |