| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| cont_code | Contractor Code | nvarchar | |
| cont_name | Contractor Name | nvarchar | |
| fa_code | Failure Code | nvarchar | |
| fa_description | Failure Description | nvarchar | |
| fa_pk | Failure Code Id | int | vr_failureCode |
| fas_code | Failure Code | nvarchar | |
| fas_description | Failure Description | nvarchar | |
| fas_pk | Failure Code Id | int | vr_failureCode |
| fj_code | Task Type Code | nvarchar | |
| fj_description | Task Type Description | nvarchar | |
| fo_averageTime | Task Average Time | decimal | |
| fo_code | Task Code | nvarchar | |
| fo_description | Task Description | nvarchar | |
| fo_pk | Task Id | int | vrpt_task |
| Id | Work Order Task Id | int | vr_WorkOrderTask |
| scheduled | Indicates if the record is scheduled | bit | |
| woTask_completionDate | Completion Date (Closed Date) | datetime | |
| wotask_con_fk | Contract Id | int | vr_contract |
| 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_fo_fk | Task Id | int | vrpt_task |
| woTask_notLocated | Not Located | bit | |
| woTask_pk | Work Order Task Id | int | vr_WorkOrderTask |
| wotask_ven_fk | Vendor Id | int | vr_Vendor |
| woTask_wo_fk | Work Order Id | int | vr_WorkOrder |
| woTask_workNotDone | Work Not Done | bit |