Service Contract Change
The Service Contract Change fact includes measures based on Contract Changes (tsctm320).
Transformation of extracted data:
- Latest Change
-
Only the latest change is available for analysis.
- Deleted lines
- Deleted service contract changes are stored in the Service Contract Change fact table. Deleted service contract changes are available for analysis. However, service contract changes with status open that are deleted, are hidden in the fact table and not available for analysis.
This diagram shows the star schema: