{
  "derived": {
    "age_seconds": 190265.041426,
    "is_stuck_running": false,
    "last_log_at": "2026-02-05T16:28:52Z",
    "now_utc": "2026-02-07T21:19:57Z",
    "stuck_reason": null,
    "updated_at_utc": "2026-02-05T16:28:52Z"
  },
  "job": {
    "attempt_count": 1,
    "correlation_id": "8c2fed6277354b2cac57a1ca9d0fef26",
    "created_at": "2026-02-05T16:28:51.593892+00:00",
    "debug_session_id": null,
    "job_type": "drift_enforce_lock_truth",
    "last_error": null,
    "next_run_at": null,
    "reason": "door provisioned drift_enforce SCHLAGE_HOME 93f26d40-0381-5277-bee3-23cf44cda5ac door:1 device:2",
    "reconcile_job_id": 103,
    "status": "done",
    "updated_at": "2026-02-05T16:28:52.931930+00:00",
    "user_id": 0
  },
  "logs": [
    {
      "action": "RECONCILE_ENQUEUED",
      "correlation_id": "8c2fed6277354b2cac57a1ca9d0fef26",
      "created_at": "2026-02-05T16:28:51.598614",
      "debug_session_id": null,
      "error_message": null,
      "id": 1653,
      "ok": true,
      "provider_type": "ACCESS_BROKER",
      "reconcile_job_id": 103,
      "request_json": {
        "job_type": "drift_enforce_lock_truth",
        "reason": "door provisioned drift_enforce SCHLAGE_HOME 93f26d40-0381-5277-bee3-23cf44cda5ac door:1 device:2",
        "source": "door route",
        "user_id": 0
      },
      "response_json": {
        "job_id": 103
      }
    },
    {
      "action": "DRIFT_ENFORCE_JOB_START",
      "correlation_id": "8c2fed6277354b2cac57a1ca9d0fef26",
      "created_at": "2026-02-05T16:28:51.606221",
      "debug_session_id": null,
      "error_message": null,
      "id": 1654,
      "ok": true,
      "provider_type": "ACCESS_BROKER",
      "reconcile_job_id": 103,
      "request_json": {
        "attempt_count": 1,
        "job_id": 103,
        "job_type": "drift_enforce_lock_truth",
        "reason": "door provisioned drift_enforce SCHLAGE_HOME 93f26d40-0381-5277-bee3-23cf44cda5ac door:1 device:2",
        "user_id": 0
      },
      "response_json": null
    },
    {
      "action": "DRIFT_ENFORCE_DELETE_PIN",
      "correlation_id": "8c2fed6277354b2cac57a1ca9d0fef26",
      "created_at": "2026-02-05T16:28:52.926496",
      "debug_session_id": null,
      "error_message": null,
      "id": 1655,
      "ok": true,
      "provider_type": "ACCESS_BROKER",
      "reconcile_job_id": 103,
      "request_json": {
        "code_last4": null,
        "correlation_id": "job",
        "device_external_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
        "integration_device_id": 2,
        "name": "AB U9 C6",
        "provider_code_id": "22107165-8a98-b9c3-e468-b1cc89072d3b",
        "provider_type": "SCHLAGE_HOME",
        "stray_id": null
      },
      "response_json": {
        "result": {
          "already": false,
          "deleted_by": "receipt",
          "ok": true,
          "provider_code_id": "22107165-8a98-b9c3-e468-b1cc89072d3b",
          "receipt_numeric_ignored": false,
          "result": {
            "ok": true,
            "response": {
              "id": "ab37be9a-14f3-42d2-b995-0a628f8c6952"
            }
          }
        }
      }
    },
    {
      "action": "DRIFT_ENFORCE_JOB_DONE",
      "correlation_id": "8c2fed6277354b2cac57a1ca9d0fef26",
      "created_at": "2026-02-05T16:28:52.932714",
      "debug_session_id": null,
      "error_message": null,
      "id": 1656,
      "ok": true,
      "provider_type": "ACCESS_BROKER",
      "reconcile_job_id": 103,
      "request_json": {
        "attempt_count": 1,
        "job_id": 103
      },
      "response_json": {
        "adds": {
          "attempted": 0,
          "failed": 0,
          "ok": 0
        },
        "analysis": {
          "adds": 0,
          "blocked": 0,
          "deletes": 1,
          "doors": 1,
          "grace_bypassed_deletes": 1,
          "invalid_expected": 0
        },
        "deletes": {
          "attempted": 1,
          "failed": 0,
          "ok": 1
        },
        "enforce_plan": {
          "doors": [
            {
              "actual": [
                {
                  "code_name": "AB U9 C6",
                  "provider_receipt_id": "22107165-8a98-b9c3-e468-b1cc89072d3b",
                  "source": "lock",
                  "vendor_pin_id": null
                }
              ],
              "adds": [],
              "blocked_by_grace": [],
              "deletes": [
                {
                  "code_name": "AB U9 C6",
                  "eligible_at": "2026-02-05T17:28:51Z",
                  "first_seen_at": "2026-02-05T16:28:51Z",
                  "first_seen_source": "inferred_now",
                  "grace_bypassed": true,
                  "provider_receipt_id": "22107165-8a98-b9c3-e468-b1cc89072d3b",
                  "reason": "credential_revoked_or_missing",
                  "source": "lock",
                  "vendor_pin_id": null
                }
              ],
              "door_id": 1,
              "expected": [],
              "external_device_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
              "integration_device_id": 2,
              "invalid_expected": [],
              "provider_type": "SCHLAGE_HOME",
              "summary": {
                "adds": 0,
                "blocked": 0,
                "deletes": 1,
                "grace_bypassed_deletes": 1,
                "invalid_expected": 0
              }
            }
          ],
          "filters": {
            "door_id": null,
            "integration_device_id": 2,
            "provider_type": "SCHLAGE_HOME"
          },
          "generated_at": "2026-02-05T16:28:51Z",
          "grace_window_seconds": 3600,
          "mode": "ultra_strict",
          "summary": {
            "adds": 0,
            "blocked": 0,
            "deletes": 1,
            "doors": 1,
            "grace_bypassed_deletes": 1,
            "invalid_expected": 0
          }
        },
        "failures": [],
        "generated_at": "2026-02-05T16:28:51Z",
        "ok": true,
        "summary": {
          "adds_attempted": 0,
          "adds_failed": 0,
          "adds_succeeded": 0,
          "deletes_attempted": 1,
          "deletes_failed": 0,
          "deletes_succeeded": 1,
          "failures": []
        },
        "target": {
          "external_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
          "integration_device_id": 2,
          "provider_type": "SCHLAGE_HOME"
        }
      }
    }
  ]
}

(Derived from stored last_result_json; provider grouping uses execution logs.)

{
  "doors": [
    {
      "actual": [
        {
          "code_name": "AB U9 C6",
          "provider_receipt_id": "22107165-8a98-b9c3-e468-b1cc89072d3b",
          "source": "lock",
          "vendor_pin_id": null
        }
      ],
      "adds": [],
      "blocked_by_grace": [],
      "deletes": [
        {
          "code_name": "AB U9 C6",
          "eligible_at": "2026-02-05T17:28:51Z",
          "first_seen_at": "2026-02-05T16:28:51Z",
          "first_seen_source": "inferred_now",
          "grace_bypassed": true,
          "provider_receipt_id": "22107165-8a98-b9c3-e468-b1cc89072d3b",
          "reason": "credential_revoked_or_missing",
          "source": "lock",
          "vendor_pin_id": null
        }
      ],
      "door_id": 1,
      "expected": [],
      "external_device_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
      "integration_device_id": 2,
      "invalid_expected": [],
      "provider_type": "SCHLAGE_HOME",
      "summary": {
        "adds": 0,
        "blocked": 0,
        "deletes": 1,
        "grace_bypassed_deletes": 1,
        "invalid_expected": 0
      }
    }
  ],
  "filters": {
    "door_id": null,
    "integration_device_id": 2,
    "provider_type": "SCHLAGE_HOME"
  },
  "generated_at": "2026-02-05T16:28:51Z",
  "grace_window_seconds": 3600,
  "mode": "ultra_strict",
  "summary": {
    "adds": 0,
    "blocked": 0,
    "deletes": 1,
    "doors": 1,
    "grace_bypassed_deletes": 1,
    "invalid_expected": 0
  }
}