vrpt_ProjectTask

Updated January 13, 2026 15:43

Field Name	Field Description	Data Type	FK Join
ACT_ACTIVE	Indicates if the Project Activity is Active or Not	bit
ACT_actualEndDate	Actual End Date	datetime
ACT_actualStartDate	Actual Start Date	datetime
ACT_CreatedDate	Record Creation Date	datetime
ACT_CREATOR_FK	User Id (Record Creator)	int	vr_users
ACT_DESCRIPTION	Project Activity (Task) Description	nvarchar
ACT_estimateEndDate	Project Activity (Task) Estimated End Date	datetime
ACT_estimateStartDate	Project Activity (Task) Estimated Start Date	datetime
ACT_FIXED	Project Activity (Task) Fixed	bit
ACT_fixedCost	Project Activity (Task) Fixed Cost	decimal
ACT_LEVEL	Project Activity (Task) Level	decimal
ACT_ModifiedDate	Last Modified Date	datetime
ACT_MODIFIER_FK	User Id (Record Modifier)	int	vr_users
ACT_NAME	Project Activity (Task) Name	nvarchar
ACT_NOTES	Project Activity (Task) Notes	nvarchar
ACT_percentCMPL	Project Activity (Task) Percent Complete	decimal
ACT_percentComplete	Project Activity (Task) Percent Complete	int
ACT_PHONE	Project Activity (Task) Phone	nvarchar
ACT_PK	Project Activity (Task) Id	int	vrpt_ProjectTask
act_proj_fk	Project Id	int	vr_Project
act_requestorEmail	Project Activity (Task) Requestor Email	nvarchar
act_requestorPhone	Project Activity (Task) Requestor Phone #	nvarchar
ACT_slackDays	Project Activity (Task) Slack Days	decimal
ACT_STACK	Project Activity (Task) Stack	nvarchar
ACT_statusDescription	Project Activity (Task) Status Description	nvarchar
cont_code	Contractor Code	nvarchar
cont_name	Contractor Name	nvarchar
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
ftr_code	Trade Code	nvarchar
ftr_description	Trade Description	nvarchar
Id	Project Id	int	vr_Project
ptt_code	Project Task Type Code	nvarchar
ptt_description	Project Task Type Description	nvarchar
tagDescription	Tag Description	nvarchar
tagNumber	Tag Number	nvarchar
wk_id	Technician Record Id	nvarchar
WK_NAME	Technician Name	nvarchar
wo_number	Work Order Number	nvarchar

Articles in this section