vrpt_Request

Updated January 19, 2026 16:52

Field Name	Field Description	Data Type	FK Join
AcceptedDate	Accepted Date	datetime
AcceptorId	User Id	int	vr_users
AccountId	Account Id	int	vr_account
AccountProgramId	Account Program Id	int
ActionRequested	Action Requested	nvarchar
AreaId	Area Id	int	vr_area
AssetId	Asset Id	int	vr_asset
AuditId	Capital Planning Audit Id	int	vrpt_cpAudit
Authorized	Authorized	bit
BuildingId	Building Id	int	vr_building
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
DepartmentId	Department Id	int	vr_Department
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
FacilityId	Facility Id	int	vr_facility
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 this request record is ignored	bit
IgnoredDate	Ignored Date	datetime
ItemId	Item Id	int
ItemTypeId	Item Type Id	int
ITEquipmentId	IT Equipment Id	int	vr_ITEquipment
KeyHolderId	Key Holder Id	int	vr_KeyHolder
KeyId	Key Id	int	vr_Key
kh_name	Key Holder Name	nvarchar
Latitude	Latitude	float
LocationCode	Location Code	nvarchar
LocationId	Location Id	int
LocationName	Location Name	nvarchar
LocationTypeId	Location Type Id	int
LOG_CREATOR_FK	User Id (Record Creator)	int	vr_users
LOG_MODIFIER_FK	User Id (Record Modifier)	int	vr_users
log_number	Request Log Number	nvarchar
LOG_PK	Request Log Id	int	vr_Request
LOG_requestDate	Request Date	datetime
Longitude	Longitude	float
lt_code	Request Log Type Code	nvarchar
lt_description	Request Log Type Description	nvarchar
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
ReferenceNumber	Reference Number	nvarchar
RejectedDate	Rejected Date	datetime
RejectedReason	Rejected Reason	nvarchar
RejectorId	Rejector Id	int	vr_users
RepairCenterId	Repair Center Id	int	vr_RepairCenter
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
RequestTypeId	Request Type Id	int	vr_RequestType
SamAccount	Sam Account	nvarchar
Source	Source	nvarchar
SourceId	Source Id	int
StatusDescription	Status Description	nvarchar
StatusId	Status Id	int	vr_Status
StatusNote	Status Note	nvarchar
TaskId	Task Id	int	vrpt_Task
TaskTypeId	Task Type Id	int	vr_TaskType
TemplateId	Template Id	int
ToolId	Tool Id	int	vr_Tool
VehicleId	VehicleId	int	vr_Vehicle
XCoordinate	X Coordinate	float
YCoordinate	Y Coordinate	float

Articles in this section