| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| de_code | Device Code | nvarchar | |
| de_description | Device Description | nvarchar | |
| dp_code | Department Code | nvarchar | |
| dp_name | Department Name | nvarchar | |
| Id | Work Order Id | int | vr_Workorder |
| ownerdepartment_code | Owner Department Code | nvarchar | |
| ownerdepartment_name | Owner Department Name | nvarchar | |
| rc_code | Repair Center Code | nvarchar | |
| rc_name | Repair Center Name | nvarchar | |
| wc_designated | Work Order Designation | smallint | |
| wo_number | Work Order Number | nvarchar | |
| wo_requestDate | Request Date | datetime | |
| woTask_completionDate | Completion Date (Closed Date) | datetime | |
| woTask_pk | Work Order Task Id | int | vr_WorkOrderTask |
| woTask_workNotDone | Work Not Done | bit |