vrpt_ProjectResourceHierarchyListTaskLink

Updated February 04, 2026 15:47

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_slackDays	Project Activity (Task) Slack Days	decimal
ACT_STACK	Project Activity (Task) Stack	nvarchar
ACT_statusDescription	Project Activity (Task) Status Description	nvarchar
ftr_description	Trade Description	nvarchar
Id	Project Resource Id	int
inv_record_code	Inventory Record Code	nvarchar
proj_active	Indicates if the Project is Active or Not	bit
proj_actualCost	Actual Cost	decimal
proj_actualTime	Actual Time	decimal
proj_agent	Agent	nvarchar
proj_authorizationDate	Authorization Date	datetime
proj_authorizationRequired	Indicates if the project record requires authorization	bit
proj_authorizationValue	Authorization Value	decimal
proj_authorized	Indicates if the project record is authorized	bit
proj_BidContNo	Bid Contract Number	nvarchar
proj_budgetAmount	Budget Amount	decimal
proj_closedDate	Closed Date	datetime
proj_comments	Comments	nvarchar
proj_completion	Completion	datetime
proj_cont_fk	Contractor Id	int	vr_Vendor
proj_contractorActual	Contractor Actual	decimal
proj_createdDate	Record Creation Date	datetime
proj_creator_fk	User Id (Record Creator)	int	vr_users
proj_cst_fk	Account Id	int	vr_account
proj_description	Description	nvarchar
proj_dp_fk	Department Id	int	vr_Department
proj_dueDate	Due Date	datetime
proj_email	Email	nvarchar
proj_estimatedCost	Estimated Cost	decimal
proj_estimatedHours	Estimated Hours	decimal
proj_estimatedLabor	Estimated Labor	decimal
proj_estimatedMaterial	Estimated Material	decimal
proj_estimatedTime	Estimated Time	decimal
proj_ev_fk	Event Id	int	vr_Event
proj_eventTemplate	Indicates if the project record is from a event template	bit
proj_fb_fk	Building Id	int	vr_building
proj_fd_fk	Facility Id	int	vr_Facility
proj_fiscalYear	Fiscal Year	int
proj_fiscalYearEnd	Fiscal Year End	int
proj_fn_fk	Fund Type Id	int
proj_hoursActual	Hours Actual	decimal
proj_hoursBudget	Hours Budget	decimal
proj_hoursEstimated	Hours Estimated	decimal
proj_laborActual	Labor Actual	decimal
proj_laborBudget	Labor Budget	decimal
proj_laborEstimated	Labor Estimated	decimal
proj_modifiedDate	Last Modified Date	datetime
proj_modifier_fk	User Id (Record Modifier)	int	vr_users
proj_name	Name	nvarchar
proj_ns_fk	Entity Id	int	vr_Entity
proj_number	Project Number	nvarchar
proj_otherActual	Other Actual	decimal
proj_otherBudget	Other Budget	decimal
proj_otherEstimated	Other Estimated	decimal
proj_overdue	Indicates if the project record is overdue	bit
proj_parent_fk	Parent Project Id	int
proj_parentTag	Parent Tag	nvarchar
proj_partActual	Part Actual	decimal
proj_partBudget	Part Budget	decimal
proj_partEstimated	Part Estimated	decimal
proj_pk	Project Record Id	int	vr_Project
proj_prepStartDate	Prep Start Date	datetime
proj_priority	Priority	nvarchar
proj_projectID	Project Id	nvarchar
proj_pt_fk	Project Type Id	int	vr_ProjectType
proj_requestDate	Request Date	datetime
proj_requestor	Requestor	nvarchar
proj_requestorPhone	Requestor Phone	nvarchar
proj_requesttemplate	Indicates if the project record is from a request template	bit
proj_reserved2	Reserved 2	decimal
proj_reserved3	Reserved 3	decimal
proj_reserved4	Reserved 4	decimal
proj_rq_fk	Requestor Id	int	vr_Requestor
proj_scheduledDate	Scheduled Date	datetime
proj_site	Site	nvarchar
proj_ss_fk	Status Id	int	vr_Status
proj_statusDescription	Status Description	nvarchar
proj_subsystemDescription	Sub System Description	nvarchar
proj_supervisor	Surpervisor	nvarchar
proj_systemDescription	System Description	nvarchar
proj_syt_fk	System Type Id	int	vr_SystemType
proj_traveltrp_fk	Travel Trip Id	int	vrpt_travelTrip
proj_tripTemplate	Indicates if the project record is from a trip template	bit
proj_user_fk	User Id	int	vr_users
proj_useSig	Indicates if the project record uses signatures	bit
proj_warranty	Project Warranty	datetime
proj_wk_fk	Technician Id	int	vrpt_Technician
prs_act_fk	Project Activity (Task) Id	int	vrpt_ProjectTask
prs_createdDate	Record Creation Date	datetime
prs_creator_fk	User Id (Record Creator)	int	vr_users
prs_curr_fk	Currency Id	int	vrpt_Currency
prs_description	Project Resource Description	nvarchar
prs_exch_date	Currency Exchange Date	datetime
prs_exch_fk	Currency Exchange Id	int
prs_ftr_fk	Trade Id	int	vr_Trade
prs_hours	Project Resource Hours	decimal
prs_inv_fk	Part Inventory Id	int	vrpt_PartInventoryList
prs_item_fk	Item Id	int
prs_itemtype_fk	Item Type Id	int
prs_modifiedDate	Last Modified Date	datetime
prs_modifier_fk	User Id (Record Modifier)	int	vr_users
prs_pk	Project Resource Id	int
prs_quantity	Project Resource Quantity	decimal
prs_startDate	Project Resource Start Date	datetime
prs_type	Project Resource Type	nvarchar
prs_unitCost	Project Resource Unit Cost	decimal
prs_wk_fk	Technician Id	int	vrpt_Technician
ptt_code	Project Task Type Code	nvarchar
ptt_description	Project Task Type Description	nvarchar
wk_name	Technician Name	nvarchar
wo_number	Work Order Number	nvarchar

Articles in this section