Dim.BuildStatus
Build Runs in Agility have an attribute called Status. This is a single select list used to indicate the result of the Build (Passed, Failed). This table contains Type 1 data for the Build Run Status values defined in your instance.
Table Description
| Column Name | Description | DataType |
|---|---|---|
| BuildStatusKey | Data Mart identifier for this data | int |
| BuildStatusOid | VersionOne identifier for this data | int |
| BuildStatusName | Name | varchar |
| BuildStatusOrder | The order this value appears in the VersionOne drop-down list | int |
| BuildStatusAssetState | State of the list value (Active or Closed) | varchar |
| BuildStatusCreateDateUTC | Date and time this value was created | datetime |
| BuildStatusLastModifiedDateUTC | Date and time this value was last modified | datetime |
| BuildStatusCreatedByKey | Foreign Key to Dim.Member for the person who created this value | int |
| BuildStatusLastModifiedByKey | Foreign Key to Dim.Member for the person who last modified this value | int |
| BuildStatusCreateDateKey | Foreign Key to Dim.Date for the Create Date | int |
| BuildStatusLastModifiedDateKey | Foreign Key to Dim.Date for the Last Modified Date | int |