vrpt_WorkOrderTaskForWO

Updated January 27, 2026 16:32

Field Name	Field Description	Data Type	FK Join
AcknowledgedBY	Acknowledged By	nvarchar
AcknowledgedInitials	Acknowledged Initials	nvarchar
authorized	Authorized	int
Completed_Located_WorkDone	Completed Located Work Not Done	int
CON_Number	Contract Number	nvarchar
cont_code	Contractor Code	nvarchar
cont_name	Contractor Name	nvarchar
fa_code	Failure Code	nvarchar
fa_description	Failure Description	nvarchar
fas_code	Failure SubCode Code	nvarchar
fas_description	Failure SubCode Description	nvarchar
fj_code	Task Type Code	nvarchar
fj_description	Task Type Description	nvarchar
fjs_code	Task SubType Code	nvarchar
fjs_description	Task SubType Description	nvarchar
fo_averageTime	Task Average Time	decimal
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
fo_estimatedCost	Task Estimated Cost	decimal
fo_pmTaskSheet	Task Sheet	nvarchar
fo_shutdownnotification	Indicates if the Task requires a shutdown notification	bit
foadd_additionalInfo	Additional Information	nvarchar
Id	Work Order Task Id	int	vr_WorkOrderTask
resolutionText	Resolution Text	nvarchar
rts_code	Rate Scheduled Code	nvarchar
rts_description	Rate Schedule Description	nvarchar
scheduled	Indicates if the Work Order Task has been Scheduled or Not	bit
wo_requestDate	Request Date	datetime
wotask_acknowledgedDate	Acknowledged Date	datetime
wotask_completedPastDueDays	Days Completed Past Due Date	int
woTask_completionDate	Completion Date (Closed Date)	datetime
woTask_DueDate	Task Due Date	datetime
wotask_EstimateTime	Estimated Time	decimal
woTask_failedPM	Indicates if the PM Failed	bit
woTask_finishDate	Finish Date	datetime
wotask_finishPastDueDays	How Many Days the Finish Date is Past the Due Date	int
woTask_hasInspection	Has Inspection	bit
woTask_notLocated	Not Located	bit
woTask_pk	Work Order Task Id	int	vr_WorkOrderTask
wotask_pm_fk	PM Schedule Id	int	vr_PMSchedule
wotask_requireacknowledgement	Indicates if the Work Order Task Requires Acknowledgement	bit
wotask_rts_fk	Rate Schedule Id	int	vr_rateSchedule
woTask_wo_fk	Work Order Id	int	vr_WorkOrder
woTask_workNotDone	Work Not Done	bit

Articles in this section