{
  "p": {
    "provider_id": "TP-110",
    "name": "Paris CDG Executive Cars",
    "station": "CDG",
    "country": "FR",
    "contract_id": "TC-110",
    "contract_start": "2026-01-01",
    "contract_end": "2027-06-30",
    "status": "active",
    "rate_model": "per_seat",
    "base_rate": 97.49,
    "currency": "EUR",
    "vehicle_types": "Minibus 8, Coach 16, Sedan 3",
    "capacity_max": 16,
    "meet_and_greet": 1,
    "flight_tracking": 0,
    "sla_minutes": 29,
    "contact_name": "Sofie Moreau",
    "contact_email": "ops@pariscdgtransfers.com",
    "contact_phone": "+34 9352177",
    "notes": null
  },
  "contract": {
    "contract_id": "TC-110",
    "provider_id": "TP-110",
    "station": "CDG",
    "entity_scope": "ALL",
    "start_date": "2026-01-01",
    "end_date": "2027-06-30",
    "currency": "EUR",
    "sla_minutes": 29,
    "waiting_time_included_minutes": 30,
    "waiting_time_rate": 36.77,
    "night_surcharge_pct": 0,
    "airport_access_fee": 0,
    "cancellation_hours": 4,
    "no_show_charge_pct": 0,
    "payment_terms": "Net 14, invoice",
    "payment_terms_days": 14,
    "flight_tracking_required": 0,
    "meet_and_greet_included": 1,
    "sla_penalty_pct": 0,
    "auto_renew": 0,
    "renewal_notice_days": 90,
    "signed_on": "2025-11-23",
    "signed_by": "R. Menon",
    "status": "active"
  },
  "contacts": [
    {
      "contact_id": "TCT-49",
      "provider_id": "TP-110",
      "role": "account_manager",
      "name": "Liam Laurent",
      "email": "account@pariscdgexecutiv.example",
      "phone": "+42 44 9254824",
      "hours": "Mon–Fri 09:00–17:00",
      "primary_contact": 1
    },
    {
      "contact_id": "TCT-52",
      "provider_id": "TP-110",
      "role": "billing",
      "name": "Marc Byrne",
      "email": "billing@pariscdgexecutiv.example",
      "phone": "+42 80 8154732",
      "hours": "Mon–Fri 09:00–17:00",
      "primary_contact": 0
    },
    {
      "contact_id": "TCT-50",
      "provider_id": "TP-110",
      "role": "dispatch",
      "name": "Chloe Meyer",
      "email": "dispatch@pariscdgexecutiv.example",
      "phone": "+37 70 5728553",
      "hours": "24/7",
      "primary_contact": 0
    },
    {
      "contact_id": "TCT-51",
      "provider_id": "TP-110",
      "role": "night_desk",
      "name": "Chloe Novak",
      "email": "night@pariscdgexecutiv.example",
      "phone": "+41 35 8706594",
      "hours": "22:00–06:00",
      "primary_contact": 0
    },
    {
      "contact_id": "TCT-53",
      "provider_id": "TP-110",
      "role": "operations",
      "name": "Anna Novak",
      "email": "operations@pariscdgexecutiv.example",
      "phone": "+36 86 2523430",
      "hours": "Mon–Sun 06:00–22:00",
      "primary_contact": 0
    }
  ],
  "tariffs": [
    {
      "tariff_id": "TT-53",
      "contract_id": "TC-110",
      "provider_id": "TP-110",
      "vehicle_class": "sedan",
      "seats_max": 3,
      "rate_basis": "per_seat",
      "rate": 68.17,
      "currency": "EUR",
      "applies_from": "06:00",
      "applies_to": "22:00",
      "min_charge": 54.54,
      "note": null
    },
    {
      "tariff_id": "TT-54",
      "contract_id": "TC-110",
      "provider_id": "TP-110",
      "vehicle_class": "sedan",
      "seats_max": 3,
      "rate_basis": "per_seat",
      "rate": 81.18,
      "currency": "EUR",
      "applies_from": "22:00",
      "applies_to": "06:00",
      "min_charge": 61.35,
      "note": "Night tariff. Most crew transfers fall in this window."
    },
    {
      "tariff_id": "TT-55",
      "contract_id": "TC-110",
      "provider_id": "TP-110",
      "vehicle_class": "mpv",
      "seats_max": 6,
      "rate_basis": "per_seat",
      "rate": 94.43,
      "currency": "EUR",
      "applies_from": "06:00",
      "applies_to": "22:00",
      "min_charge": 75.54,
      "note": null
    },
    {
      "tariff_id": "TT-56",
      "contract_id": "TC-110",
      "provider_id": "TP-110",
      "vehicle_class": "mpv",
      "seats_max": 6,
      "rate_basis": "per_seat",
      "rate": 115.42,
      "currency": "EUR",
      "applies_from": "22:00",
      "applies_to": "06:00",
      "min_charge": 84.99,
      "note": "Night tariff. Most crew transfers fall in this window."
    },
    {
      "tariff_id": "TT-57",
      "contract_id": "TC-110",
      "provider_id": "TP-110",
      "vehicle_class": "minibus",
      "seats_max": 12,
      "rate_basis": "per_seat",
      "rate": 149.65,
      "currency": "EUR",
      "applies_from": "06:00",
      "applies_to": "22:00",
      "min_charge": 119.72,
      "note": null
    },
    {
      "tariff_id": "TT-58",
      "contract_id": "TC-110",
      "provider_id": "TP-110",
      "vehicle_class": "minibus",
      "seats_max": 12,
      "rate_basis": "per_seat",
      "rate": 169.77,
      "currency": "EUR",
      "applies_from": "22:00",
      "applies_to": "06:00",
      "min_charge": 134.69,
      "note": "Night tariff. Most crew transfers fall in this window."
    },
    {
      "tariff_id": "TT-59",
      "contract_id": "TC-110",
      "provider_id": "TP-110",
      "vehicle_class": "coach",
      "seats_max": 30,
      "rate_basis": "per_seat",
      "rate": 250.09,
      "currency": "EUR",
      "applies_from": "06:00",
      "applies_to": "22:00",
      "min_charge": 200.07,
      "note": null
    },
    {
      "tariff_id": "TT-60",
      "contract_id": "TC-110",
      "provider_id": "TP-110",
      "vehicle_class": "coach",
      "seats_max": 30,
      "rate_basis": "per_seat",
      "rate": 275.77,
      "currency": "EUR",
      "applies_from": "22:00",
      "applies_to": "06:00",
      "min_charge": 225.08,
      "note": "Night tariff. Most crew transfers fall in this window."
    }
  ],
  "fleet": [
    {
      "fleet_id": "TF-33",
      "provider_id": "TP-110",
      "vehicle_class": "sedan",
      "seats": 3,
      "count_total": 3,
      "count_dedicated": 0,
      "wheelchair_accessible": 0,
      "luggage_capacity": "2 cases",
      "avg_age_years": 3.18,
      "note": null
    },
    {
      "fleet_id": "TF-34",
      "provider_id": "TP-110",
      "vehicle_class": "mpv",
      "seats": 6,
      "count_total": 11,
      "count_dedicated": 5,
      "wheelchair_accessible": 0,
      "luggage_capacity": "6 cases",
      "avg_age_years": 2.05,
      "note": null
    },
    {
      "fleet_id": "TF-35",
      "provider_id": "TP-110",
      "vehicle_class": "minibus",
      "seats": 12,
      "count_total": 8,
      "count_dedicated": 3,
      "wheelchair_accessible": 1,
      "luggage_capacity": "14 cases",
      "avg_age_years": 6.62,
      "note": null
    },
    {
      "fleet_id": "TF-36",
      "provider_id": "TP-110",
      "vehicle_class": "coach",
      "seats": 30,
      "count_total": 3,
      "count_dedicated": 0,
      "wheelchair_accessible": 0,
      "luggage_capacity": "34 cases",
      "avg_age_years": 6.52,
      "note": null
    }
  ],
  "audits": [
    {
      "audit_id": "TAU-9",
      "provider_id": "TP-110",
      "audited_on": "2026-05-28",
      "auditor": "SGS (contracted)",
      "operator_licence_ref": "FR-PSV-89268",
      "licence_expiry": "2026-11-01",
      "insurance_ref": "INS-396061",
      "insurance_expiry": "2026-08-14",
      "insured_value": 9000000,
      "driver_vetting_ok": 1,
      "drug_alcohol_policy_ok": 1,
      "vehicle_inspection_ok": 1,
      "gps_tracking_ok": 0,
      "score": 4.32,
      "outcome": "pass_with_actions",
      "actions": null,
      "reinspect_due": "2027-05-28"
    }
  ],
  "use": {
    "legs": 520,
    "cost": 161169.1,
    "cost_per_leg": 309.94057692307695,
    "seats": 1554,
    "late_pct": 26.153846153846153,
    "delay_total": 5463,
    "rest_impact": 2199,
    "failures": 10,
    "pooled": 47
  },
  "byPeriod": [
    {
      "period": "2026-03",
      "legs": 492,
      "cost": 151111.15,
      "late_pct": 29.065040650406505
    },
    {
      "period": "2026-04",
      "legs": 508,
      "cost": 161962.51,
      "late_pct": 32.28346456692913
    },
    {
      "period": "2026-05",
      "legs": 550,
      "cost": 173708.6,
      "late_pct": 26.90909090909091
    },
    {
      "period": "2026-06",
      "legs": 468,
      "cost": 142869.57,
      "late_pct": 29.700854700854702
    },
    {
      "period": "2026-07",
      "legs": 516,
      "cost": 154484.03,
      "late_pct": 27.906976744186046
    },
    {
      "period": "2026-08",
      "legs": 520,
      "cost": 161169.1,
      "late_pct": 26.153846153846153
    }
  ]
}