workorder_asset_links_v1

This is a technical table that contains the links between workorders and assets.

By definition, there is a many-to-many relationship between workorders and assets:

  • 1 workorder can be linked to many assets, e.g. 1 maintenance task for a group of 6 elevators
  • 1 asset can be part of many work orders over a period of time, e.g. monthly inspections per elevator

Any data engineer that wants to combine assets and workorders in reports and data analysis should include this link table in queries and data sets.

 

Data structure

ColumnMeaningComment
wo_idForeign database key of the workorder 
wo_referenceReference of the workordere.g. WRK-123456
asset_idForeign database key of the asset 
asset_referenceReference of the assete.g. AST-12345
wo_creation_datetimeDate and time of workorder creationIn local timezone
wo_update_datetimeDate and time of workorder creationIn local timezone