Field Service → Billing SLA (SQL Models)

Pure SQL models that power BI reporting (Qlik Sense in my environment).
Focus: compute SLA response time and billing latency by Work Order and ERP invoice line.

Highlights

• Multi-CTE pipeline with OUTER APPLY for line↔job pairing
• Calendar indexing (week/day) + robust date math
• TZ/DST normalization via UDF
• Technician/scheduler ranking & pivoting
• STRING_AGG and XML STUFF(...FOR XML PATH('')) patterns

Start here

• Main query: /sql/fsm_wo_billing_sla.sql
• CTE map: /sql/00_README.md

Sanitization (portfolio-safe)

• FieldServiceDB (source), WarehouseDW (DW/ERP), AnalyticsDB (UDFs)
• PII removed; emails replaced by display names.