Skip to main content
System StatusContact Support Agility Community


This feature is available in Enterprise and Ultimate editions.

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