vr_WorkOrder

Updated February 05, 2026 15:59

Field Name	Field Description	Data Type	FK Join
AccountProgramCode	Account Program Code	nvarchar
AccountProgramId	Account Program Id	int
ActionRequested	Action Requested	nvarchar
ActionRequiredByDepartment	Action Required by Department	bit
AdditionalReference	Additional Reference	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
AssetTagNumber	Asset Tag Number	nvarchar
AutoPrint	Auto Print	bit
BatchJobId	Batch Job Id	int	vr_BatchJob
BillFixedCost	Bill Fixed Cost	bit
BMP	Indicates if the record is on a building maintenance program	bit
BuildingCode	Building Code	nvarchar
BuildingId	Building Id	int	vr_building
BuildingName	Building Name	nvarchar
BuildingServicesSignOff	Building Services Sign Off	datetime
CEEquipmentId	Biomed Equipment Id	int	vr_CEEquipment
CEEquipmentTagNumber	Biomed Equipment Tag Number	nvarchar
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
CloseDateLocked	Close Date Locked	bit
CompletionDate	Completion (Closed) Date	datetime
CompletionDateDateOnly	Completion (Closed) Date Only	date
ContractorCost	Total Contractor Cost	decimal
CPPendingDeferral	Capital Planning Pending Deferral	bit
CPWorkElementId	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
DepartmentBillingFrequency	Department Billing Frequency	int
DepartmentCode	Department Code	nvarchar
DepartmentHead	Department Head	nvarchar
DepartmentId	Department Id	int	vr_Department
DepartmentName	Department Name	nvarchar
DepartmentSignOff	Department Sign Off	datetime
DepartmentTypeId	Department Type Id	int	vr_departmentType
DistrictId	District Id	int	vr_District
ECRIId	ECRI Id	int
EntityId	Entity Id	int	vr_Entity
EntityTagNumber	Entity Tag Number	nvarchar
EquipmentId	Equipment Id	int	vr_equipment
EquipmentTagNumber	Equipment Tag Number	nvarchar
EstimateCost	Estimate Cost	decimal
EstimatedEndDate	Estimated End Date	datetime
EstimatedStartDate	Estimated Start Date	datetime
EstimateHours	Estimate Hours	decimal
EventCode	Event Code	nvarchar
EventId	Event Id	int	vr_Event
EventName	Event Name	nvarchar
ExcludedFromRequestor	Excluded From Requestor	bit
ExternalSource	External Source	nvarchar
FacilityCode	Facility Code	nvarchar
FacilityId	Facility Id	int	vr_facility
FacilityName	Facility Name	nvarchar
FinishDate	Finish Date	datetime
FiscalStart	Fiscal Year Start	nvarchar
FloorCode	Floor Code	nvarchar
FloorDescription	Floor Description	nvarchar
FloorId	Floor Id	int	vr_floor
FloorNumber	Floor Number	nvarchar
FloorUniqueId	Floor Unique Id	nvarchar
FromDevice	From Device	bit
FromMedTester	From Med Tester	bit
FromService	From Service	bit
FullStatus	Concatenated field (Status Description + Status Note)	nvarchar
GISTechCode	GIS Tech Code	int
GroupId	Group Id	int	vr_Group
GroupTagNumber	Group Tag Number	nvarchar
Id	Work Order Id	int
InheritedXCoordinate	Inherited X Coordinate	float
InheritedYCoordinate	Inherited Y Coordinate	float
InspectionFindingId	Inspection Finding Id	int	vrpt_InspectionFinding
InspectionFindingNumber	Inspection Finding Number	nvarchar
IsClosed	Is Closed	bit
IsMultiTaskWO	Is Multi Task WO	bit
IsTemplate	Is Template	bit
IsTicket	Is Ticket	bit
ItemDescription	Item Description	nvarchar
ItemDescriptionCombined	Item Description Combined	nvarchar
ItemGISUniqueId	Item GIS Unique Id	uniqueidentifier
ItemId	Item Id	int
ItemTagNumber	Item Tag Number	nvarchar
ItemTagNumberCombined	Item Tag Number Combined	nvarchar
ItemTypeId	Item Type Id	int
ItemVendorMakeModelId	Item Vendor Made Model Id	int
ITEquipmentId	IT Equipment Id	int	vr_ITEquipment
ITEquipmentTagNumber	IT Equipment Tag Number	nvarchar
LaborCost	Total Labor Cost	decimal
LaborHours	Total Labor Hours	decimal
LastSensorNotification	Last Sensor Notification	datetime
Latitude	Latitude	nvarchar
LinearAssetId	Linear Asset Id	int	vr_LinearAsset
LinkedWorkOrderId	Work Order Id	int	vr_WorkOrders
LocationCode	Location Code	nvarchar
LocationGISUniqueId	Location GIS Unique Id	uniqueidentifier
LocationId	Location Id	int
LocationName	Location Name	nvarchar
LocationTypeId	Location Type Id	int
Longitude	Longitude	nvarchar
LRSEnd	LRS End	decimal
LRSGeometry	LRS Geometry	geometry
LRSStart	LRS Start	decimal
MaterialCost	Total Material Cost	decimal
ModelNumber	Model Number	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
ModifierName	Modifier Name	nvarchar
NotifyMe	Indicates Whether the Notify Me Box is Checked	bit
Number	Work Order Number	nvarchar
OperatorError	Operator Error	bit
OperatorId	User Id (Operator Id)	int	vr_Users
OtherChargeLocked	Other Charge Locked	bit
OtherCost	Total Other Cost	decimal
OutOfService	Indicates Whether the Item Tied to the Work Order is Out of Service	bit
OverageAccountCode	Overage Account Code	nvarchar
OverageAccountId	Overage Account Id	int	vr_account
PostDate	Post Date	datetime
PotentialRiskToOperator	Potential Risk To Operator	bit
PotentialRiskToPatient	Potential Risk To Patient	bit
PreventArchival	Prevent Archival	bit
PrintDate	Last Print Date	datetime
PriorityCode	Priority Code	nvarchar
PriorityDescription	Priority Description	nvarchar
PriorityDisplayColor	Priority Display Color	nvarchar
PriorityDueInterval	Priority Due Interval	int
PriorityDueIntervalType	Priority Due Interval Type	nvarchar
PriorityId	Priority Id	int	vr_Priority
ProjectAccountId	Account Id	int	vr_account
ProjectActivityId	Project Activity (Task) Id	int	vrpt_ProjectTask
ProjectClosedDate	Project Closed Date	datetime
ProjectId	Project Id	int	vr_project
ProjectManagerId	Technician Id	int	vrpt_Technician
ProjectName	Project Name	nvarchar
ProjectNumber	Project Number	nvarchar
ReferenceNumber	Reference Number	nvarchar
RepairCenterCloseTask	Repair Center Close Task	bit
RepairCenterCode	Repair Center Code	nvarchar
RepairCenterDupeCheck	Repair Center Dupe Check	bit
RepairCenterDupeCheckRange	Repair Center Dupe Check Range	int
RepairCenterExcludeNotifyTechnicianPM	Repair Center Exclude Notify Technician PM	bit
RepairCenterId	Repair Center Id	int	vr_RepairCenter
RepairCenterName	Repair Center Name	nvarchar
RepairCenterNotLocatedCounter	Repair Center Not Located Counter	int
RepairCenterOverageAccountId	Repair Center Overage Account Id	int	vr_account
RepairCenterPositionBasedRate	Repair Center Postition Based Rate	bit
RepairCenterPromptforPrint	Repair Center Prompt for Print	bit
RepairCenterTQM	Repair Center TQM	smallint
RequestDate	Request Date	datetime
RequestDateDateOnly	Request Date Date Only	date
RequestLogId	Request Log Id	int	vrpt_Request
RequestLogNumber	Request Log Number	nvarchar
RequestorEmail	Requestor Email	nvarchar
RequestorId	Requestor Id	int	vr_Requestor
RequestorName	Requestor Name	nvarchar
RequestorPhone	Requestor Phone	nvarchar
RiskFactor	Risk Factor	int
SerialNumber	Item Serial Numer	nvarchar
ServiceJob	Service Job	bit
SignedOff	Signed Off	bit
SignOffTime	Sign Off Time	datetime
SignOffUserId	Sign Off User Id	int	vr_users
SignOffUserName	Sign Off User Name	nvarchar
SkipZoneAutoAssign	Skip Zone Auto Assign	bit
SLPostDate	Sub Ledger Post Date	datetime
StartCreationDate	Start Creation Date	datetime
StatusAllowNote	Indicates if this record allows a status note	bit
StatusCode	Status Code	nvarchar
StatusDescription	Status Description	nvarchar
StatusId	Status Id	int	vr_Status
StatusLocked	Status Locked	bit
StatusNote	Status Note	nvarchar
SubLocation	Item Sub Location	nvarchar
SupervisorName	Supervisor Name	nvarchar
TaxCompound	Indicates if the record utilizes tax compound	bit
TaxRate1	Tax Rate 1	decimal
TaxRate2	Tax Rate 2	decimal
TaxRateId	Tax Rate Id	int	vr_TaxRate
TaxRateName	Tax Rate Name	nvarchar
TaxRateWOContratcor	Tax Rate WO Contractor	bit
TaxRateWOLabor	Taxt Rate WO Labor	bit
TaxRateWOOtherCharge	Tax Rate WO Other Charge	bit
TaxRateWOPart	Tax Rate WO Part	bit
TechComments	Tech Comments	nvarchar
ToolId	Tool Id	int	vr_Tool
ToolTagNumber	Tool Tag Number	nvarchar
TQM	TQM	bit
UIExport	UI Export	bit
VehicleId	VehicleId	int	vr_Vehicle
VehicleTagNumber	Vehicle Tag Number	nvarchar
WarrantyJob	Warranty Job	bit
wo_workNotDone	Obsolete Column (No Longer Used)	bit
WorkOrderSubTypeCode	Work Order SubType Code	nvarchar
WorkOrderSubTypeDescription	Work Order SubType Description	nvarchar
WorkOrderSubTypeId	Work Order SubType Id	int	vr_WorkOrderSubType
WorkOrderTypeCode	Work Order Type Code	nvarchar
WorkOrderTypeDescription	Work Order Type Description	nvarchar
WorkOrderTypeDesignated	Work Order Type Designation	smallint
WorkOrderTypeId	Work Order Type Id	int	vr_WorkOrderType
WorkOrderTypeRequireGeneralComment	Work Order Type Require General Comment	bit
XCoordinate	X Coordinate	nvarchar
YCoordinate	Y Coordinate	nvarchar

Articles in this section