Dim.RequestResolution
Request assets in have an attribute called Resolution. This is a single select list used to indicate the how the Request was resolved (Implemented, Rejected). This table contains Type 1 data for the Request Resolution values defined in your instance.
Table Description
| Column Name | Description | DataType |
|---|---|---|
| RequestResolutionKey | Data Mart identifier for this data | int |
| RequestResolutionOid | Identifier for this data | int |
| RequestResolutionName | Name | varchar |
| RequestResolutionOrder | The order this value appears in the VersionOne drop-down list | int |
| RequestResolutionAssetState | State of the list value (Active or Closed) | int |
| RequestResolutionCreateDateUTC | Date and time this value was created | datetime |
| RequestResolutionLastModifiedDateUTC | Date and time this value was last modified | datetime |
| RequestResolutionCreatedByKey | Data Mart identifier of the Member that created this value | int |
| RequestResolutionLastModifiedByKey | Data Mart identifier of the Member that last modified this value | int |
| RequestResolutionCreateDateKey | Foreign Key to Dim.Date for the Create Date | int |
| RequestResolutionLastModifiedDateKey | Foreign Key to Dim.Date for the Last Modified Date | int |