vrpt_WorkOrderResponseTime

Updated January 27, 2026 16:22

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
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
ftr_code	Trade Code	nvarchar
ftr_description	Trade Description	nvarchar
FullStatus	Concatenated field (Status Description + Status Note)	nvarchar
Id	Work Order Id	int	vr_WorkOrder
month_completiondate	Month the Work Order was Completed In	int
monthyear	Month and Year the Work Order was Completed In	nvarchar
OneDayResponse	Indicates if the Work Order was Responsed to within 24 Hours from the Request Date	bit
PRI_DESCRIPTION	Priority Description	nvarchar
RC_CODE	Repair Center Code	nvarchar
RC_NAME	Repair Center Name	nvarchar
requestMonth	Month the Work Order was Requested	nvarchar
responseDays	Response Time in Days (Request Date to Labor Cost Date (Completion Date if not Labor Cost))	int
responseHours	Response Time in Hours (Request Date to Labor Cost Date (Completion Date if not Labor Cost))	int
responseMinutes	Response Time in Minutes (Request Date to Labor Cost Date (Completion Date if not Labor Cost))	int
responseTime	Work Order Labor Transaction Date (Date of Work)	datetime
StatusDescription	Status Description	nvarchar
StatusNote	Status Note	nvarchar
totalhours	Total Hours	decimal
wc_code	Work Order Type Code	nvarchar
WC_description	Work Order Type Description	nvarchar
wk_id	Technician Record Id	nvarchar
wk_name	Technician Name	nvarchar
wo_completiondate	Completion (Closed) Date	datetime
WO_NUMBER	Work Order Number	nvarchar
WO_PK	Work Order Id	int
WO_PRI_FK	Priority Id	int	vr_Priority
WO_REQUESTDATE	Request Date	datetime
wo_status	Work Order Status Note	nvarchar
year_completiondate	Year the Work Order was Completed In	int
yearmonth_completiondate	Year and Month the Work Order was Completed In	nvarchar

Articles in this section