vrpt_WorkOrderListing

Updated January 27, 2026 16:10

Field Name	Field Description	Data Type	FK Join
fb_code	Building Code	nvarchar
fb_name	Building Name	nvarchar
fd_code	Facility Code	nvarchar
fd_name	Facility Name	nvarchar
ff_code	Floor Code	nvarchar
ff_description	Floor Description	nvarchar
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
fu_description	Area Description	nvarchar
fu_roomNumber	Area Room Number	nvarchar
fulltaskDescription	Task Code + Task Description	nvarchar
Id	Work Order Id	int	vr_WorkOrder
pri_code	Priority Code	nvarchar
pri_description	Priority Description	nvarchar
tradeList	List of Trades on the Work Order	nvarchar
wc_code	Work Order Type Code	nvarchar
wc_description	Work Order Type Description	nvarchar
wo_actionRequested	Action Requested	nvarchar
wo_number	Work Order Number	nvarchar
wo_pk	Work Order Id	int	vr_WorkOrder
wo_requestDate	Request Date	datetime
wo_requestor	Requestor	nvarchar
wo_requestorNamePhone	Requestor Name + Requestor Phone #	nvarchar
wo_requestorPhone	Requestor Phone #	nvarchar
wo_supervisor	Work Order Supervisor	nvarchar