vrpt_SimpleTask

Updated January 20, 2026 15:14

Field Name	Field Description	Data Type	FK Join
fj_code	Task Type Code	nvarchar
fj_description	Task Type Description	nvarchar
fj_ftr_fk	Trade Id	int	vr_Trade
fj_pk	Task Type Id	int	vr_TaskType
fjs_code	Task Sub Type Code	nvarchar
fjs_description	Task Sub Type Description	nvarchar
fjs_pk	Task Sub Type Id	int
fo_active	Indicates if the Record is Active or Not	bit
fo_approvalLevel	Task Approval Level	int
fo_approvalSignoffNumber	Task Approval Signoff Number	int
fo_averageTime	Task Average Time	decimal
fo_code	Task Code	nvarchar
fo_createdDate	Record Creation Date	datetime
fo_creator_fk	User Id (Record Creator)	int	vr_users
fo_description	Task Description	nvarchar
fo_fj_fk	Task Type Id	int	vr_TaskType
fo_ftr_fk	Trade Id	int	vr_Trade
fo_modifiedDate	Last Modified Date	datetime
fo_modifier_fk	User Id (Record Modifier)	int	vr_users
fo_pk	Task Id	int	vrpt_task
fo_pri_fk	Priority Id	int	vr_Priority
fo_requireActionRequested	Indicates if the Record requires action requested	bit
fo_requireFAQ	Indicates if the Record requires FAQ	bit
Id	Task Id	int	vrpt_task