Skip to main content
System StatusContact Support
VersionOne Community

Dim.Request

This feature is available in Enterprise and Ultimate editions.

This table contains Type 1 data for Requests defined in your VersionOne instance.

Table Description

Column Name Description Datatype
RequestKey Datamart unique identifier for this Request int
RequestOid VersionOne identifier for this Request int
RequestName Request Name nvarchar
RequestDisplayId Request identifier visible in VersionOne 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 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
  • Was this article helpful?