| 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 |