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