| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| fb_code | Building Code | nvarchar | |
| fb_name | Building Name | nvarchar | |
| fu_description | Area Description | nvarchar | |
| fu_unitID | Area Location Id | nvarchar | |
| Id | Work Order Task Id | int | vr_WorkOrderTask |
| wc_code | Work Order Type Code | nvarchar | |
| wc_description | Work Order Type Description | nvarchar | |
| wc_pk | Work Order Type Id | int | vr_WorkOrderType |
| wcs_code | Work Order SubType Code | nvarchar | |
| wcs_description | Work Order SubType Description | nvarchar | |
| wcs_pk | Work Order SubType Id | int | vr_WorkOrderSubType |
| wo_actionRequested | Action Requested | nvarchar | |
| wo_completionDate | Completion (Closed) Date | datetime | |
| wo_number | Work Order Number | nvarchar | |
| wo_pk | Work Order Id | int | vr_WorkOrder |
| wo_requestDate | Request Date | datetime |