Work Order

The work order fact includes measures based on work order (tswcs200).

Transformation of extracted data:

Deleted lines

Deleted work orders are stored in the work order fact table. Deleted work orders are available for analysis.

This diagram shows the star schema: