workorders_v1

This view contains the list of workorders in Spacewell Asset.

 

Data structure

ColumnMeaningComment
wo_idUnique database IDPrimary key of a service request
wo_referenceInternal numbere.g. WRK-123456
wo_unique_referenceUnique GUID of the workorder 
wo_external_referenceExternal identifier of the workorder 
wo_financial_referenceFinancial identifier of the workorder 
wo_nameName of the workorder 
wo_descriptionDescription of the workorder 
wo_priority_numberNumerical value of workorder prioritye.g. 1, 2, 3, ...
wo_priority_nameName of workorder prioritye.g. high, medium, low
wo_typeType of the workorder 
wo_maintenance_scheduleName of the maintenance schedule that has generated the work order 
wo_classClass of workorder: PREVENTIVE or CORRECTIVEIs PREVENTIVE when the workorder was generated from a maintenance schedule, else CORRECTIVE
service_type_nameName of service type 
service_type_referenceReference of service type 
service_type_l3Level 3 of service typeIn case of a service types hierarchy that has 3 levels
service_type_l2Level 2 of service typeIn case of a service types hierarchy that has 2 or more levels
service_type_l1Level 1 of service typeAlways available
wo_creation_datetimeCreation date and time of the workorderIn local timezone
wo_close_datetimeClosing date and time of the workorderIn local timezone
last_modified_datetimeDate and time when the workorder was last modifiedIn local timezone
location_idForeign key to locationsContains the location of the workorder
region_codeCode of the Region where the workorder is located 
region_nameName of the Region where the workorder is located 
site_codeCode of the Site where the workorder is located 
site_nameName of the Site where the workorder is located 
building_codeCode of the Building where the workorder is located 
building_nameName of the Building where the workorder is located 
floor_codeCode of the Floor where the workorder is located 
floor_nameName of the Floor where the workorder is located 
room_codeCode of the Room where the workorder is located 
room_nameName of the Room where the workorder is located 
wo_status_nameName of the workorder status 
wo_status_codeCode of the workorder status 
wo_status_classClass of the workorder status: OPEN or CLOSED= CLOSED when there is a value in wo_close_datetime, else OPEN
wo_requester_organization_nameName of organization that requested the workorderderived from the person who requested
wo_assigned_organization_nameName of organization to who the workorder is assigned 
wo_responsible_organization_nameName of the organization that is responsible for the workorder 
wo_taskforceTeam to who the workorder is assigned for execution 
wo_estimated_workNumber of hours estimated 
wo_actual_workNumber of hours recorded 
parent_wo_idForeign key to parent workorderIn case where workorders are in a hierarachy (work breakdown structure)
parent_wo_referenceReference of parent workorderIn case where workorders are in a hierarachy (work breakdown structure)
contract_idForeign key to a contractIn case where a workorder is linked to a contract
service_request_idForeign key to a service requestIn case where a workorder is linked to a service request
service_request_referenceReference of the linked service request 
project_idForeign key to a projectIn case where a workorder is linked to a project
purchase_order_idForeign key to a purchase orderIn case where a workorder is linked to a purchase order
invoice_idForeign key to an invoiceIn case where a workorder is linked to an invoice