vr_Request

Updated February 04, 2026 17:07

Field Name	Field Description	Data Type	FK Join
Accepted	Accepted	bit
AcceptedDate	Accepted Date	datetime
AcceptorId	User Id	int	vr_users
AcceptorName	Acceptor Name	nvarchar
AccountCode	Account Code	nvarchar
AccountId	Account Id	int	vr_account
AccountName	Account Name	nvarchar
AccountProgramId	Account Program Id	int
ActionRequested	Action Requested	nvarchar
AreaDescription	Area Description	nvarchar
AreaId	Area Id	int	vr_area
AreaLocationCode	Area Location Code (Location Id)	nvarchar
AreaRoomNumber	Area Room Number	nvarchar
AssetId	Asset Id	int	vr_asset
AuditId	Capital Planning Audit Id	int
AuditNumber	Capital Planning Audit Number	int
Authorized	Authorized	bit
BrowseDisplayNumber	Browse Display Number	bigint
BuildingCode	Building Code	nvarchar
BuildingGISUniqueId	Building GIS Unique Id	uniqueidentifier
BuildingId	Building Id	int	vr_building
BuildingName	Building Name	nvarchar
BuildingNameBrowse	Building Name	nvarchar
CEEquipmentId	Biomed Equipment Id	int	vr_CEEquipment
Comments	Comments	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
CustodialCompDate	Custodial Completion Date	datetime
CustodialFlooring	Custodial Flooring	nvarchar
CustodianId	Custodian Id	int	vrpt_Technician
CustodianName	Custodian Name	nvarchar
DepartmentCode	Department Code	nvarchar
DepartmentId	Department Id	int	vr_Department
DepartmentName	Department Name	nvarchar
DistrictId	District Id	int	vr_district
EntityId	Entity Id	int	vr_Entity
EquipmentId	Equipment Id	int	vr_equipment
EstimateCost	Estimate Cost	decimal
EstimateStartDate	Estimate Start Date	datetime
ExternalCode	External Code	nvarchar
ExternalSource	External Source	nvarchar
FacilityCode	Facility Code	nvarchar
FacilityGISUniqueId	Facility GIS Unique Id	uniqueidentifier
FacilityId	Facility Id	int	vr_facility
FacilityName	Facility Name	nvarchar
FloorCode	Floor Code	nvarchar
FloorCodeBrowse	Floor Code	nvarchar
FloorId	Floor Id	int	vr_floor
FullStatus	Concatenated field (Status Description + Status Note)	nvarchar
GroupId	Group Id	int	vr_Group
Id	Request Id	int
Ignored	Indicates if the record is ignored	bit
IgnoredDate	Ignored Date	datetime
isPending	Indicates if the record is pending	bit
ItemDescription	Item Description	nvarchar
ItemGISUniqueId	Item GIS Unique Id	uniqueidentifier
ItemId	Item Id	int
ItemTagNumber	Item Tag Number	nvarchar
ItemTypeId	Item Type Id	int
ItemWarrantyDate	Item Warranty Date	datetime
ITEquipmentId	IT Equipment Id	int	vr_ITEquipment
KeyDescription	Key Description	nvarchar
KeyHolderCode	Key Holder Code	nvarchar
KeyHolderId	Key Holder Id	int	vr_KeyHolder
KeyHolderName	Key Holder Name	nvarchar
KeyId	Key Id	int	vr_Key
KeyNumber	Key Number	nvarchar
Latitude	Latitude	float
LinearAssetId	Linear Asset Id	int	vr_LinearAsset
LocationCode	Location Code	nvarchar
LocationId	Location Id	int
LocationName	Location Name	nvarchar
LocationRoofWarranty	Location Roof Warranty	datetime
LocationTypeId	Location Type Id	int
LocationWarrantyDate	Location Warranty Date	datetime
Longitude	Longitude	float
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
NotifyMe	Indicates Whether the Notify Me Box is Checked	bit
Number	Request Number	nvarchar
ProjectId	Project Id	int	vr_project
ProjectNumber	Project Number	nvarchar
ReferenceNumber	Reference Number	nvarchar
Rejected	Indicates if the record is rejected	bit
RejectedDate	Rejected Date	datetime
RejectedReason	Rejected Reason	nvarchar
RejectorId	Rejector Id	int	vr_users
RejectorName	Rejector Name	nvarchar
RepairCenterCloseTask	Repair Center Close Task	bit
RepairCenterCode	Repair Center Code	nvarchar
RepairCenterId	Repair Center Id	int	vr_RepairCenter
RepairCenterIsChargeable	Repair Center Is Chargeable	bit
RepairCenterName	Repair Center Name	nvarchar
RepairCenterPromptForPrint	Repair Center Prompt For Print	bit
RequestDate	Request Date	datetime
RequestNumber	Request Number	nvarchar
RequestorEmail	Requestor Email	nvarchar
RequestorId	Requestor Id	int	vr_Requestor
RequestorName	Requestor Name	nvarchar
RequestorPhone	Requestor Phone	nvarchar
RequestTypeCode	Request Type Code	nvarchar
RequestTypeDescription	Request Type Description	nvarchar
RequestTypeId	Request Type Id	int	vr_RequestType
RequestTypeIsCustodial	Request Type Is Custodial	bit
RequestTypeIsKey	Request Type Is Key	bit
SamAccount	Sam Account	nvarchar
SourceCode	Source Code	nvarchar
SourceDescription	Source Description	nvarchar
SourceId	Source Id	int
SRPStatusUrl	Service Request Portal Status URL	nvarchar
StatusAllowNote	Indicates if this record allows a status note	bit
StatusDescription	Status Description	nvarchar
StatusId	Status Id	int	vr_Status
StatusNote	Status Note	nvarchar
StatusWorkOrder	Status Work Order	bit
TaskCode	Task Code	nvarchar
TaskDescription	Task Description	nvarchar
TaskDuration	Task Duration	decimal
TaskId	Task Id	int	vrpt_Task
TaskOptionId	Task Option Id	int
TaskTypeCode	Task Type Code	nvarchar
TaskTypeDescription	Task Type Description	nvarchar
TaskTypeId	Task Type Id	int	vr_TaskType
TaskWrapperCode	Task Wrapper Code	nvarchar
TaskWrapperDescription	Task Wrapper Description	nvarchar
TaskWrapperId	Task Wrapper Id	int
TemplateDescription	Template Description	nvarchar
TemplateId	Template Id	int
ToolId	Tool Id	int	vr_Tool
UIExport	Indicates if the record is available for universal integration export	bit
VehicleId	VehicleId	int	vr_Vehicle
WorkOrderId	Work Order Id	int	vr_WorkOrder
WorkOrderNumber	Work Order Number	nvarchar
XCoordinate	X Coordinate	float
YCoordinate	Y Coordinate	float

Articles in this section