This view contains the list of workorders in Spacewell Asset.
Data structure
| Column | Meaning | Comment |
|---|---|---|
| wo_id | Unique database ID | Primary key of a service request |
| wo_reference | Internal number | e.g. WRK-123456 |
| wo_unique_reference | Unique GUID of the workorder | |
| wo_external_reference | External identifier of the workorder | |
| wo_financial_reference | Financial identifier of the workorder | |
| wo_name | Name of the workorder | |
| wo_description | Description of the workorder | |
| wo_priority_number | Numerical value of workorder priority | e.g. 1, 2, 3, ... |
| wo_priority_name | Name of workorder priority | e.g. high, medium, low |
| wo_type | Type of the workorder | |
| wo_maintenance_schedule | Name of the maintenance schedule that has generated the work order | |
| wo_class | Class of workorder: PREVENTIVE or CORRECTIVE | Is PREVENTIVE when the workorder was generated from a maintenance schedule, else CORRECTIVE |
| service_type_name | Name of service type | |
| service_type_reference | Reference of service type | |
| service_type_l3 | Level 3 of service type | In case of a service types hierarchy that has 3 levels |
| service_type_l2 | Level 2 of service type | In case of a service types hierarchy that has 2 or more levels |
| service_type_l1 | Level 1 of service type | Always available |
| wo_creation_datetime | Creation date and time of the workorder | In local timezone |
| wo_close_datetime | Closing date and time of the workorder | In local timezone |
| last_modified_datetime | Date and time when the workorder was last modified | In local timezone |
| location_id | Foreign key to locations | Contains the location of the workorder |
| region_code | Code of the Region where the workorder is located | |
| region_name | Name of the Region where the workorder is located | |
| site_code | Code of the Site where the workorder is located | |
| site_name | Name of the Site where the workorder is located | |
| building_code | Code of the Building where the workorder is located | |
| building_name | Name of the Building where the workorder is located | |
| floor_code | Code of the Floor where the workorder is located | |
| floor_name | Name of the Floor where the workorder is located | |
| room_code | Code of the Room where the workorder is located | |
| room_name | Name of the Room where the workorder is located | |
| wo_status_name | Name of the workorder status | |
| wo_status_code | Code of the workorder status | |
| wo_status_class | Class of the workorder status: OPEN or CLOSED | = CLOSED when there is a value in wo_close_datetime, else OPEN |
| wo_requester_organization_name | Name of organization that requested the workorder | derived from the person who requested |
| wo_assigned_organization_name | Name of organization to who the workorder is assigned | |
| wo_responsible_organization_name | Name of the organization that is responsible for the workorder | |
| wo_taskforce | Team to who the workorder is assigned for execution | |
| wo_estimated_work | Number of hours estimated | |
| wo_actual_work | Number of hours recorded | |
| parent_wo_id | Foreign key to parent workorder | In case where workorders are in a hierarachy (work breakdown structure) |
| parent_wo_reference | Reference of parent workorder | In case where workorders are in a hierarachy (work breakdown structure) |
| contract_id | Foreign key to a contract | In case where a workorder is linked to a contract |
| service_request_id | Foreign key to a service request | In case where a workorder is linked to a service request |
| service_request_reference | Reference of the linked service request | |
| project_id | Foreign key to a project | In case where a workorder is linked to a project |
| purchase_order_id | Foreign key to a purchase order | In case where a workorder is linked to a purchase order |
| invoice_id | Foreign key to an invoice | In case where a workorder is linked to an invoice |