vrpt_WorkOrderTaskEquipment

Updated January 27, 2026 16:29

Field Name	Field Description	Data Type	FK Join
dp_code	Department Code	nvarchar
dp_name	Department Name	nvarchar
fb_code	Building Code	nvarchar
fb_name	Building Name	nvarchar
fd_code	Facility Code	nvarchar
fd_name	Facility Name	nvarchar
fm_description	Equipment Description	nvarchar
fm_tagNumber	Equipment Tag Number	nvarchar
fo_averagetime	Task Average Time	decimal
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
fo_estimatedcost	Task Estimated Cost	decimal
fu_description	Area Description	nvarchar
fu_roomNumber	Area Room Number	nvarchar
fu_unitID	Area Location Id	nvarchar
Id	Work Order Id	int	vr_WorkOrder
itemType_name	Item Type Name	nvarchar
itemtype_pk	Item Type Id	int	vr_WebTMAItemTypes
jco_description	Joint Commission Category Description	nvarchar
rc_code	Repair Center Code	nvarchar
rc_name	Repair Center Name	nvarchar
TaskHours	Total Hours for the Task	decimal
TaskLabor	Total Labor Cost for the Task	decimal
TaskLaborRetail	Total Labor Retail for the Task	decimal
TaskOther	Total Other Cost for the Task	decimal
TaskOtherRetail	Total Other Retail Costs for the Task	decimal
TaskParts	Total Parts Cost for the Task	decimal
TaskPartsRetail	Total Parts Retail Cost for the Task	decimal
wc_code	Work Order Type Code	nvarchar
wc_description	Work Order Type Description	nvarchar
wc_designated	Work Order Designation	smallint
wo_actionRequested	Action Requested	nvarchar
wo_completionDate	Completion (Closed) Date	datetime
wo_number	Work Order Number	nvarchar
wo_pk	Work Order Id	int	vr_WorkOrder
wo_requestDate	Request Date	datetime
wot_comment	Work Order Task Comment	nvarchar
woTask_pk	Work Order Task Id	int	vr_WorkOrderTask
woTask_wo_fk	Work Order Id	int	vr_WorkOrder

Articles in this section