| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| crw_description | Crew Description | nvarchar | |
| crw_tagNumber | Crew Tag Number | nvarchar | |
| fo_code | Task Code | nvarchar | |
| fo_description | Task Description | nvarchar | |
| ftr_code | Trade Code | nvarchar | |
| ftr_description | Trade Description | nvarchar | |
| Id | Work Order Task Schedule Id | int | |
| wk_id | Technician Record Id | nvarchar | |
| wk_name | Technician Name | nvarchar | |
| wo_pk | Work Order Id | int | vr_WorkOrder |
| wos_comment | Schedule Comment | nvarchar | |
| wos_completionDate | Schedule Completion Date | datetime | |
| wos_crw_fk | Crew Id | int | vrpt_crew |
| wos_duration | Schedule Duration | decimal | |
| wos_pk | Work Order Task Schedule Id | int | |
| wos_startdate | Schedule Start Date | datetime |