Dim.RequestCategory
Request in have an attribute called Category (Request Type in the UI). This is a single select list used to categorize the Request being reported (i.e. Feature, Defect). This table contains Type 1 data for the Request Category values defined in your instance.
Table Description
| Column Name | Description | DataType |
|---|---|---|
| RequestCategoryKey | Data Mart identifier for this data | int |
| RequestCategoryOid | Identifier for this data | int |
| RequestCategoryName | Name | varchar |
| RequestCategoryOrder | The order this value appears in the drop-down list | int |
| RequestCategoryAssetState | State of this value (Active or Closed) | varchar |
| RequestCategoryCreateDateUTC | Date and time this value was created | datetime |
| RequestCategoryLastModifiedDateUTC | Date and time this value was last modified | datetime |
| RequestCategoryCreatedByKey | Data Mart identifier of the Dim.Member that created this value | int |
| RequestCategoryLastModifiedByKey | Data Mart identifier of the Dim.Member that last modified this value | int |
| RequestCategoryCreateDateKey | Foreign Key to Dim.Date for the Create Date | int |
| RequestCategoryLastModifiedDateKey | Foreign Key to Dim.Date for the Last Modified Date | int |