vrpt_WorkOrder

Updated January 27, 2026 13:10

Field Name	Field Description	Data Type	FK Join
AccountProgramId	Account Program Id	int
ActionRequested	Action Requested	nvarchar
ActionRequiredByDepartment	Action Required by Department	bit
AdditionalReference	Additional Reference	nvarchar
AreaId	Area Id	int	vr_area
AssetId	Asset Id	int	vr_asset
AutoPrint	Auto Print	bit
BatchJobId	Batch Job Id	int	vr_BatchJob
BillFixedCost	Indicates if the work order record has a fixed cost bill	bit
BuildingId	Building Id	int	vr_building
BuildingServicesSignOff	Building Services Sign Off	datetime
CEEquipmentId	Biomed Equipment Id	int	vr_CEEquipment
Charge	Indicates Whether the Work Order is Chargeable	bit
ChargeAccountCode	Account Code	nvarchar
ChargeAccountId	Account Id (Charge Account)	int	vr_account
ChargeAccountName	Account Name	nvarchar
CloseLast24Hour	Indicates Whether the Work Order was Closed in the Last 24 Hours	bit
CompletionDate	Completion (Closed) Date	datetime
CPPendingDeferral	Indicates if the work order record is deferred	bit
CPWorkElementId	Capital Planning Work Element Id	int	vr_CPWorkElement
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
CurrencyExchangeDate	Currency Exchange Date	datetime
CurrencyExchangeId	Currency Exchange Id	int
CurrencyId	Currency Id	int	vrpt_Currency
DepartmentAction	Department Action	nvarchar
DepartmentHead	Department Head	nvarchar
DepartmentId	Department Id	int	vr_Department
DepartmentSignOff	Department Sign Off Date	datetime
ECRIId	Emergency Care Research Institute Id	int
EntityId	Entity Id	int	vr_Entity
EquipmentId	Equipment Id	int	vr_equipment
EstimateCost	Estimate Cost	decimal
EstimatedEndDate	Estimated End Date	datetime
EstimatedStartDate	Estimated Start Date	datetime
EstimateHours	Estimate Hours	decimal
ExcludedFromRequestor	Indicates if the work order record	bit
ExternalSource	External Source	nvarchar
FacilityId	Facility Id	int	vr_facility
FinishDate	Finish Date	datetime
FinishRequestComparison	Finish Request Comparison	int
FiscalStart	Fiscal Start	nvarchar
FloorId	Floor Id	int	vr_floor
FromDevice	Indicates if the work order record was created from mobile device	bit
FromMedTester	Indicates if the work order record was created from medtester	bit
FromService	Indicates if the work order record was created from service	bit
FullStatus	Concatenated field (Status Description + Status Note)	nvarchar
GISTechCode	GIS Tech Code	int
GroupId	Group Id	int	vr_Group
Id	Work Order Id	int	vr_workorder
IsClosed	Indicates if the work order record is closed	bit
IsTemplate	Indicates if the work order record is from a template	bit
IsTicket	Indicates if the work order record is from a ticket	bit
ItemId	Item Id	int
ItemTypeId	Item Type Id	int
ItemTypeName	Item Type Name	nvarchar
ITEquipmentId	IT Equipment Id	int	vr_ITEquipment
LastSensorNotification	Last Sensor Notification	datetime
Latitude	Latitude	nvarchar
LinearAssetId	Linear Asset Id	int	vr_LinearAsset
LinkedWorkOrderId	Work Order Id	int	vr_workorder
LocationId	Location Id	int
LocationTypeId	Location Type Id	int
Longitude	Longitude	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	Work Order Number	nvarchar
OpenLast24Hour	Open Last 24 Hour	int
OperatorError	Operator Error	bit
OperatorId	User Id (Operator Id)	int	vr_users
OutOfService	Indicates if the work order record item is out of service	bit
OverageAccountId	Overage Account Id	int	vr_account
PostDate	Post Date	datetime
PotentialRiskToOperator	Indicates if the work order record is a potential risk to the operator	bit
PotentialRiskToPatient	Indicates if the work order record is a potential risk to the patient	bit
PreventArchival	Indicates if the work order record is set to prevent archival	bit
PrintDate	Print Date	datetime
PriorityId	Priority Id	int	vr_Priority
ProjectActivityId	Project Activity Id	int	vr_project
ProjectId	Project Id	int
ReferenceNumber	Reference Number	nvarchar
RepairCenterId	Repair Center Id	int	vr_RepairCenter
RequestDate	Request Date	datetime
RequestLogId	Request Log Id	int	vr_Request
RequestorEmail	Requestor Email	nvarchar
RequestorId	Requestor Id	int	vr_Requestor
RequestorName	Requestor Name	nvarchar
RequestorPhone	Requestor Phone	nvarchar
ServiceJob	Indicates if the work order record is a service job	bit
SignedOff	Indicates if the work order record is signed off	bit
SignOffTime	Sign Off Time	datetime
SignOffUserId	Sign Off User Id	int	vr_users
SkipZoneAutoAssign	Indicates if the work order record is set to skip zone automatic assignments	bit
SLPostDate	Sub Ledger Post Date	datetime
StartCreationDate	Start Creation Date	datetime
StatusDescription	Status Description	nvarchar
StatusId	Status Id	int	vr_Status
StatusNote	Status Note	nvarchar
SupervisorName	Supervisor Name	nvarchar
TaxCompound	Indicates if the the work order record utilizes tax compound	bit
TaxRate1	Tax Rate 1	decimal
TaxRate2	Tax Rate 2	decimal
TaxRateId	Tax Rate Id	int	vr_TaxRate
TechComments	Technician Comments	nvarchar
ToolId	Tool Id	int	vr_Tool
TQM	Indicates if the work order record utilizes surveys	bit
UIExport	Indicates if the work order record is available for Universal Integration Export	bit
VehicleId	VehicleId	int	vr_Vehicle
WarrantyJob	Warranty Job	bit
WOFinishRequestDayDiff	Difference in days from request date to finish date	int
WOIsClosed	Work Order is closed	int
WOIsOpen	Work Order is open	int
WorkOrderSubTypeId	Work Order Sub Type Id	int
WorkOrderTypeId	Work Order Type Id	int	vr_WorkOrderType
XCoordinate	X Coordinate	nvarchar
YCoordinate	Y Coordinate	nvarchar

Articles in this section