vrpt_ScheduledHoursByTechnician

Updated January 19, 2026 17:22

Field Name	Field Description	Data Type	FK Join
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
Id	Work Order Task Schedule Id	int	vr_WorkOrderTaskSchedule
shft_description	Shift Description	nvarchar
shft_duration	Shift Duration	decimal
wk_firstName	Technician First Name	nvarchar
wk_id	Technician Record Id	nvarchar
wk_lastName	Technician Last Name	nvarchar
wk_pk	Technicain Id	int	vrpt_Technician
wo_number	Work Order Number	nvarchar
wos_duration	Work Order Schedule Duration	decimal
wos_footer	Work Order Schedule Footer	nvarchar
wos_pk	Work Order Task Schedule Id	int	vr_WorkOrderTaskSchedule
wos_startDate	Work Order Schedule Start Date	datetime
wotask_wo_fk	Work Order Id	int	vr_WorkOrder