Service Contract Quote

The Service Contract Quote fact includes measures based on Contract Quotes (tsctm200).

Transformation of extracted data:

Deleted lines

Deleted service contract quotes are stored in the Service Contract Quote fact table. Deleted service contract quotes are available for analysis. However, service contract quotes with status free that are deleted, are hidden in the fact table and not available for analysis.

This diagram shows the star schema: