Dim.EffectiveAssetState
This table contains Type 1 data for Effective Asset State values. An Effective Asset State is based on the real AssetState and the Reporting Category assigned to the Status value. Effective Asset States only apply to Primary Workitems (Story, Defect, and TestSets) and Epics.
Table Description
| Column Name | Description | DataType |
|---|---|---|
| StatusKey | Data Mart identifier for a Status Value | int |
| AssetStateKey | Foreign Key to the Dim.AssetState identifier for the real AssetState | int |
| EffectiveAssetStateName | Label for the Effective AssetState | varchar |