Dim.Request
This table contains Type 1 data for Requests defined in your instance.
Table Description
| Column Name | Description | DataType |
|---|---|---|
| RequestKey | Datamart unique identifier for this Request | int |
| RequestOid | Identifier for this Request | int |
| RequestName | Request Name | nvarchar |
| RequestDisplayId | Request identifier visible in grid | varchar |
| RequestProjectKey | Foreign Key to the Project containing this Request | int |
| RequestProjectName | Name of the Project containing this Request | nvarchar |
| RequestOwnerKey | Foreign Key to the Member who owns this Request | int |
| RequestOwnerName | Name of the Member who owns this Request | nvarchar |
| RequestRequestedBy | Requested By value for this Request | nvarchar |
| RequestReference | Reference value for this Request | nvarchar |
| RequestTypeName | Type value for this Request | nvarchar |
| RequestPriorityName | Priority value for this Request | nvarchar |
| RequestStatusName | Status value for this Request | nvarchar |
| RequestSourceName | Source value for this Request | nvarchar |
| RequestResolutionName | Resolution value for this Request | nvarchar |
| RequestAssetState | Request Asset State | varchar |
| RequestCreatedByName | Full Name of the Member who created this Request | nvarchar |
| RequestLastModifiedByName | Full Name of the Member who last modified this Request | nvarchar |
| RequestClosedDateUTC | The UTC date and time this Request was Closed / Archived | datetime |
| RequestClosedDateKey | Foreign Key to Dim.Date for the Closed Date | int |
| RequestClosedByID | Foreign Key the Dim.Member that closed this Request | int |
| RequestClosedByName | The name of the Member that closed this Request | nvarchar |
| RequestCreateDateUTC | UTC Date the Request was created | datetime |
| RequestLastModifiedDateUTC | UTC Date the Request was last modified | datetime |
| RequestCreatedByKey | Foreign Key to the Member who created this Request | int |
| RequestLastModifiedByKey | Foreign Key to the Member who last modified this Request | int |
| RequestCreateDateKey | Foreign Key to Dim.Date for the Create Date | int |
| RequestLastModifiedDateKey | Foreign Key to Dim.Date for the Last Modified Date | int |