vr_WorkOrderTaskSchedule

Updated March 24, 2026 14:58

Field Name	Field Description	Data Type	FK Join
Id	Work Order Task Schedule Id	int
CompletionDate	Completion Date	datetime
StartDate	Start Date	datetime
Duration	Duration	decimal
EndDate	End Date	datetime
CarryOver	Carry Over	bit
IncludeSaturday	Indicates if Saturday is included	bit
IncludeSunday	Indicates if Sunday is included	bit
Comment	Comment	nvarchar
ReadOnDevice	Read on Device	bit
CreatorId	User Id (Record Creator)	int	vr_users
CreatedDate	Record Creation Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
ModifiedDate	Last Modified Date	datetime
TechnicianId	Technician Id	int	vrpt_Technician
TechnicianCode	Technician Code	nvarchar
TechnicianName	Technician Name	nvarchar
TechnicianChargeRate	Technician Charge Rate	decimal
TechnicianEmail	Technician Email	nvarchar
TechnicianLastFirst	Technician Last and First Name	nvarchar
TechnicianUserId	Technician's User Id	int	vr_users
TechnicianHasEmail	Indicates if Technician has Email	bit
TechnicianAllowSMS	Indicates if Technician allows SMS	bit
TechnicianHasSMS	Indicates if Technician has SMS	bit
ShiftId	Shift Id	int	vr_shift
ShiftCode	Shift Code	nvarchar
ShiftDescription	Shift Description	nvarchar
ShiftStart	Shift Start	nvarchar
ShiftEnd	Shift End	nvarchar
ShiftDifferential	Shift Differential	decimal
TaskId	Task Id	int	vrpt_Task
TaskCode	Task Code	nvarchar
TaskDescription	Task Description	nvarchar
TradeId	Trade Id	int	vr_Trade
TradeCode	Trade Code	nvarchar
TradeDescription	Trade Description	nvarchar
WorkOrderId	Work Order Id	int	vr_WorkOrder
WorkOrderTaskId	Work Order Task Id	int	vr_WorkOrderTask
WorkOrderTaskCompletionDate	Work Order Task Completion Date	datetime
CrewId	Crew Id	int	vrpt_crew
CrewTagNumber	Crew Tag Number	nvarchar
CrewDescription	Crew Description	nvarchar

Articles in this section