TRAINING PIPELINE

SQL Server / Azure SQL
Policies, claims, complaints, payments
               │
               ▼
Point-in-time feature query
QueryVersion = 4
AsOfDate = fixed
               │
               ▼
Validated dataset snapshot
DatasetVersion = 3
SchemaVersion = 2
               │
               ▼
Train / Validation / Test split
Seed = 42
               │
               ▼
Feature transformations + Trainer
PipelineVersion = 2
               │
               ▼
Evaluation and approval
               │
               ▼
Saved model.zip
ModelVersion = 7


                       PRODUCTION PIPELINE

Eligible current policies
               │
               ▼
Same feature definitions
FeatureVersion = 2
               │
               ▼
Load approved model.zip
ModelVersion = 7
               │
               ▼
Probability + predicted class
               │
               ▼
Store model and feature versions
               │
               ▼
Approved retention workflow

Key rule:

Training logic ≠ Production logic
               ↓
       Training-serving skew

Shared, versioned definitions
               ↓
       Reproducible behaviour