{
  "derived": {
    "age_seconds": 163187.191116,
    "is_stuck_running": false,
    "last_log_at": "2026-02-05T22:20:28Z",
    "now_utc": "2026-02-07T19:40:15Z",
    "stuck_reason": null,
    "updated_at_utc": "2026-02-05T22:20:28Z"
  },
  "job": {
    "attempt_count": 1,
    "correlation_id": "9fb98bd03aea4819924e6e5a6ba5d905",
    "created_at": "2026-02-05T22:20:25.413299+00:00",
    "debug_session_id": null,
    "job_type": "reconcile_user",
    "last_error": null,
    "next_run_at": null,
    "reason": "doors changed",
    "reconcile_job_id": 141,
    "status": "done",
    "updated_at": "2026-02-05T22:20:28.627085+00:00",
    "user_id": 9
  },
  "logs": [
    {
      "action": "RECONCILE_ENQUEUED",
      "correlation_id": "9fb98bd03aea4819924e6e5a6ba5d905",
      "created_at": "2026-02-05T22:20:25.417151",
      "debug_session_id": null,
      "error_message": null,
      "id": 2008,
      "ok": true,
      "provider_type": "ACCESS_BROKER",
      "reconcile_job_id": 141,
      "request_json": {
        "deduped": false,
        "reason": "doors changed",
        "source": "user-door route",
        "user_id": 9
      },
      "response_json": {
        "job_id": 141
      }
    },
    {
      "action": "RECONCILE_JOB_START",
      "correlation_id": "9fb98bd03aea4819924e6e5a6ba5d905",
      "created_at": "2026-02-05T22:20:25.438688",
      "debug_session_id": null,
      "error_message": null,
      "id": 2009,
      "ok": true,
      "provider_type": "ACCESS_BROKER",
      "reconcile_job_id": 141,
      "request_json": {
        "attempt_count": 1,
        "job_id": 141,
        "job_type": "reconcile_user",
        "reason": "doors changed",
        "user_id": 9
      },
      "response_json": null
    },
    {
      "action": "PASSCODE_LIST",
      "correlation_id": "9fb98bd03aea4819924e6e5a6ba5d905",
      "created_at": "2026-02-05T22:20:26.268093",
      "debug_session_id": null,
      "error_message": null,
      "id": 2011,
      "ok": true,
      "provider_type": "TTLOCK",
      "reconcile_job_id": 141,
      "request_json": {
        "base_host": "https://api.ttlock.com",
        "method": "GET",
        "path": "/v3/lock/listKeyboardPwd",
        "payload": {
          "accessToken": "***",
          "clientId": "6636adfbf3f9483d946082b74f20797c",
          "date": 1770330025474,
          "lockId": 28991110,
          "pageNo": 1,
          "pageSize": 200
        },
        "url": "https://api.ttlock.com/v3/lock/listKeyboardPwd"
      },
      "response_json": {
        "list": [],
        "pageNo": 1,
        "pageSize": 200,
        "pages": 0,
        "total": 0
      }
    },
    {
      "action": "PIN_DELETE",
      "correlation_id": "9fb98bd03aea4819924e6e5a6ba5d905",
      "created_at": "2026-02-05T22:20:26.277586",
      "debug_session_id": null,
      "error_message": null,
      "id": 2012,
      "ok": true,
      "provider_type": "TTLOCK",
      "reconcile_job_id": 141,
      "request_json": {
        "lock_id": 28991110,
        "name": "AB U9 C1",
        "note": "listed_ok_but_not_found",
        "pin_last4": null,
        "resolution_attempted": true,
        "resolved_vendor_pin_id": null,
        "vendor_pin_id": null
      },
      "response_json": {
        "already": true,
        "ok": true
      }
    },
    {
      "action": "PIN_DELETE",
      "correlation_id": "9fb98bd03aea4819924e6e5a6ba5d905",
      "created_at": "2026-02-05T22:20:26.780457",
      "debug_session_id": null,
      "error_message": null,
      "id": 2013,
      "ok": true,
      "provider_type": "SCHLAGE_HOME",
      "reconcile_job_id": 141,
      "request_json": {
        "device_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
        "name": "AB U9 C1",
        "pin_last4": null,
        "receipt_id": null,
        "receipt_numeric_ignored": false
      },
      "response_json": {
        "already": true,
        "ok": true
      }
    },
    {
      "action": "PIN_DELETE",
      "correlation_id": "9fb98bd03aea4819924e6e5a6ba5d905",
      "created_at": "2026-02-05T22:20:27.233072",
      "debug_session_id": null,
      "error_message": null,
      "id": 2014,
      "ok": true,
      "provider_type": "SCHLAGE_HOME",
      "reconcile_job_id": 141,
      "request_json": {
        "device_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
        "name": "AB U9 C7",
        "pin_last4": null,
        "receipt_id": null,
        "receipt_numeric_ignored": false
      },
      "response_json": {
        "already": true,
        "ok": true
      }
    },
    {
      "action": "PIN_DELETE",
      "correlation_id": "9fb98bd03aea4819924e6e5a6ba5d905",
      "created_at": "2026-02-05T22:20:27.787737",
      "debug_session_id": null,
      "error_message": null,
      "id": 2015,
      "ok": true,
      "provider_type": "SCHLAGE_HOME",
      "reconcile_job_id": 141,
      "request_json": {
        "device_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
        "name": "AB U9 C6",
        "pin_last4": null,
        "receipt_id": null,
        "receipt_numeric_ignored": false
      },
      "response_json": {
        "already": true,
        "ok": true
      }
    },
    {
      "action": "PASSCODE_LIST",
      "correlation_id": "9fb98bd03aea4819924e6e5a6ba5d905",
      "created_at": "2026-02-05T22:20:28.616124",
      "debug_session_id": null,
      "error_message": null,
      "id": 2016,
      "ok": true,
      "provider_type": "TTLOCK",
      "reconcile_job_id": 141,
      "request_json": {
        "base_host": "https://api.ttlock.com",
        "method": "GET",
        "path": "/v3/lock/listKeyboardPwd",
        "payload": {
          "accessToken": "***",
          "clientId": "6636adfbf3f9483d946082b74f20797c",
          "date": 1770330027790,
          "lockId": 28991110,
          "pageNo": 1,
          "pageSize": 200
        },
        "url": "https://api.ttlock.com/v3/lock/listKeyboardPwd"
      },
      "response_json": {
        "list": [],
        "pageNo": 1,
        "pageSize": 200,
        "pages": 0,
        "total": 0
      }
    },
    {
      "action": "PIN_DELETE_BLOCKED",
      "correlation_id": "9fb98bd03aea4819924e6e5a6ba5d905",
      "created_at": "2026-02-05T22:20:28.620391",
      "debug_session_id": null,
      "error_message": null,
      "id": 2017,
      "ok": true,
      "provider_type": "TTLOCK",
      "reconcile_job_id": 141,
      "request_json": {
        "attempted_vendor_pin_id": "50957532",
        "expected_prefix": "AB U9 ",
        "job_user_id": 9,
        "lock_id": 28991110,
        "note": "vendor_pin_id_not_in_passcode_list",
        "pin_last4": null,
        "reason": "blocked_cross_user_delete_guard",
        "resolved_name": null
      },
      "response_json": {
        "blocked": true,
        "ok": true
      }
    },
    {
      "action": "RECONCILE_JOB_DONE",
      "correlation_id": "9fb98bd03aea4819924e6e5a6ba5d905",
      "created_at": "2026-02-05T22:20:28.627085",
      "debug_session_id": null,
      "error_message": null,
      "id": 2018,
      "ok": true,
      "provider_type": "ACCESS_BROKER",
      "reconcile_job_id": 141,
      "request_json": {
        "attempt_count": 1,
        "job_id": 141,
        "user_id": 9
      },
      "response_json": {
        "job_status": "done",
        "summary": {
          "adds_updates": 0,
          "desired": 0,
          "removes": 5
        }
      }
    }
  ]
}

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