| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| fb_code | Building Code | nvarchar | |
| fb_name | Building Name | nvarchar | |
| fd_code | Facility Code | nvarchar | |
| fd_name | Facility Name | nvarchar | |
| ff_code | Floor Code | nvarchar | |
| ff_description | Floor Description | nvarchar | |
| fo_code | Task Code | nvarchar | |
| fo_description | Task Description | nvarchar | |
| fu_description | Area Description | nvarchar | |
| fu_roomNumber | Area Room Number | nvarchar | |
| fulltaskDescription | Task Code + Task Description | nvarchar | |
| Id | Work Order Id | int | vr_WorkOrder |
| pri_code | Priority Code | nvarchar | |
| pri_description | Priority Description | nvarchar | |
| tradeList | List of Trades on the Work Order | nvarchar | |
| wc_code | Work Order Type Code | nvarchar | |
| wc_description | Work Order Type Description | nvarchar | |
| wo_actionRequested | Action Requested | nvarchar | |
| wo_number | Work Order Number | nvarchar | |
| wo_pk | Work Order Id | int | vr_WorkOrder |
| wo_requestDate | Request Date | datetime | |
| wo_requestor | Requestor | nvarchar | |
| wo_requestorNamePhone | Requestor Name + Requestor Phone # | nvarchar | |
| wo_requestorPhone | Requestor Phone # | nvarchar | |
| wo_supervisor | Work Order Supervisor | nvarchar |