vrpt_TechnicianProductive

Updated January 20, 2026 15:44

Field Name	Field Description	Data Type	FK Join
FWOR_HOURS	Labor Hours	decimal
fwor_pk	Labor Id	int	vr_workorderLabor
FWOR_TRANSDate	Labor Transaction Date	datetime
fwor_wk_fk	Labor Technician Id	int
fwor_woTask_fk	Work Order Task Id	int	vr_WorkOrderTask
Id	Labor Id	int	vr_workorderLabor
LaborCost	Labor Cost	decimal
NON_PRODUCTIVE_HOURS	Non Productive Hours	decimal
NonWorkOrderHours	Non Work Order Hours	decimal
PRODUCTIVE_HOURS	Productive Hours	decimal
RC_CODE	Repair Center Code	nvarchar
RC_NAME	Repair Center Name	nvarchar
rc_pk	Repair Center Id	int	vr_RepairCenter
ti_code	Time Type Code	nvarchar
ti_description	Time Type Description	nvarchar
ti_IsProductiveInProductiveReport	Indicates if the productive time type record is included the productive time system report	bit
ti_productiveTime	Indicates if the time type record is productive time	bit
ti_productiveTimeReports	Indicates if the productive time type record is available for productive time reports	bit
transDate	Transaction Date	datetime
wc_code	Work Order Type Code	nvarchar
wc_description	Work Order Type Description	nvarchar
wk_active	Indicates Whether the Technician Record is Active or Not	bit
WK_FIRSTNAME	Technician First Name	nvarchar
WK_ID	Technician Record Id	nvarchar
WK_LASTNAME	Technician Last Name	nvarchar
WK_Name	Technician Name	nvarchar
wo_number	Work Order Number	nvarchar
WorkOrderHours	Work Order Hours	decimal