{
  "derived": {
    "age_seconds": 163140.865781,
    "is_stuck_running": false,
    "last_log_at": "2026-02-05T22:20:59Z",
    "now_utc": "2026-02-07T19:40:00Z",
    "stuck_reason": null,
    "updated_at_utc": "2026-02-05T22:20:59Z"
  },
  "job": {
    "attempt_count": 1,
    "correlation_id": "af41bec2c6dc46289f1cb8738d1c5bf2",
    "created_at": "2026-02-05T22:20:56.317314+00:00",
    "debug_session_id": null,
    "job_type": "reconcile_user",
    "last_error": null,
    "next_run_at": null,
    "reason": "access level changed",
    "reconcile_job_id": 147,
    "status": "done",
    "updated_at": "2026-02-05T22:20:59.676915+00:00",
    "user_id": 10
  },
  "logs": [
    {
      "action": "RECONCILE_ENQUEUED",
      "correlation_id": "af41bec2c6dc46289f1cb8738d1c5bf2",
      "created_at": "2026-02-05T22:20:56.321079",
      "debug_session_id": null,
      "error_message": null,
      "id": 2053,
      "ok": true,
      "provider_type": "ACCESS_BROKER",
      "reconcile_job_id": 147,
      "request_json": {
        "deduped": false,
        "reason": "access level changed",
        "source": "user-access-level route",
        "user_id": 10
      },
      "response_json": {
        "job_id": 147
      }
    },
    {
      "action": "RECONCILE_JOB_START",
      "correlation_id": "af41bec2c6dc46289f1cb8738d1c5bf2",
      "created_at": "2026-02-05T22:20:56.329624",
      "debug_session_id": null,
      "error_message": null,
      "id": 2055,
      "ok": true,
      "provider_type": "ACCESS_BROKER",
      "reconcile_job_id": 147,
      "request_json": {
        "attempt_count": 1,
        "job_id": 147,
        "job_type": "reconcile_user",
        "reason": "access level changed",
        "user_id": 10
      },
      "response_json": null
    },
    {
      "action": "PIN_DELETE",
      "correlation_id": "af41bec2c6dc46289f1cb8738d1c5bf2",
      "created_at": "2026-02-05T22:20:56.843041",
      "debug_session_id": null,
      "error_message": null,
      "id": 2056,
      "ok": true,
      "provider_type": "SCHLAGE_HOME",
      "reconcile_job_id": 147,
      "request_json": {
        "device_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
        "name": "AB U10 C2",
        "pin_last4": null,
        "receipt_id": null,
        "receipt_numeric_ignored": false
      },
      "response_json": {
        "already": true,
        "ok": true
      }
    },
    {
      "action": "PASSCODE_LIST",
      "correlation_id": "af41bec2c6dc46289f1cb8738d1c5bf2",
      "created_at": "2026-02-05T22:20:57.599922",
      "debug_session_id": null,
      "error_message": null,
      "id": 2057,
      "ok": true,
      "provider_type": "TTLOCK",
      "reconcile_job_id": 147,
      "request_json": {
        "base_host": "https://api.ttlock.com",
        "method": "GET",
        "path": "/v3/lock/listKeyboardPwd",
        "payload": {
          "accessToken": "***",
          "clientId": "6636adfbf3f9483d946082b74f20797c",
          "date": 1770330056845,
          "lockId": 28991110,
          "pageNo": 1,
          "pageSize": 200
        },
        "url": "https://api.ttlock.com/v3/lock/listKeyboardPwd"
      },
      "response_json": {
        "list": [
          {
            "endDate": 1801866030751,
            "isCustom": 1,
            "keyboardPwd": "***1111",
            "keyboardPwdId": 50957532,
            "keyboardPwdName": "***",
            "keyboardPwdType": 3,
            "keyboardPwdVersion": 4,
            "lockId": 28991110,
            "nickName": "keith",
            "receiverUsername": "",
            "sendDate": 1770330034000,
            "senderUsername": "keith@ac5.ca",
            "startDate": 1770329971618,
            "status": 1
          }
        ],
        "pageNo": 1,
        "pageSize": 200,
        "pages": 1,
        "total": 1
      }
    },
    {
      "action": "PIN_DELETE",
      "correlation_id": "af41bec2c6dc46289f1cb8738d1c5bf2",
      "created_at": "2026-02-05T22:20:57.610260",
      "debug_session_id": null,
      "error_message": null,
      "id": 2058,
      "ok": true,
      "provider_type": "TTLOCK",
      "reconcile_job_id": 147,
      "request_json": {
        "lock_id": 28991110,
        "name": "AB U10 C2",
        "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": "PASSCODE_LIST",
      "correlation_id": "af41bec2c6dc46289f1cb8738d1c5bf2",
      "created_at": "2026-02-05T22:20:58.313945",
      "debug_session_id": null,
      "error_message": null,
      "id": 2059,
      "ok": true,
      "provider_type": "TTLOCK",
      "reconcile_job_id": 147,
      "request_json": {
        "base_host": "https://api.ttlock.com",
        "method": "GET",
        "path": "/v3/lock/listKeyboardPwd",
        "payload": {
          "accessToken": "***",
          "clientId": "6636adfbf3f9483d946082b74f20797c",
          "date": 1770330057616,
          "lockId": 28991110,
          "pageNo": 1,
          "pageSize": 200
        },
        "url": "https://api.ttlock.com/v3/lock/listKeyboardPwd"
      },
      "response_json": {
        "list": [
          {
            "endDate": 1801866030751,
            "isCustom": 1,
            "keyboardPwd": "***1111",
            "keyboardPwdId": 50957532,
            "keyboardPwdName": "***",
            "keyboardPwdType": 3,
            "keyboardPwdVersion": 4,
            "lockId": 28991110,
            "nickName": "keith",
            "receiverUsername": "",
            "sendDate": 1770330034000,
            "senderUsername": "keith@ac5.ca",
            "startDate": 1770329971618,
            "status": 1
          }
        ],
        "pageNo": 1,
        "pageSize": 200,
        "pages": 1,
        "total": 1
      }
    },
    {
      "action": "PIN_DELETE_BLOCKED",
      "correlation_id": "af41bec2c6dc46289f1cb8738d1c5bf2",
      "created_at": "2026-02-05T22:20:58.323659",
      "debug_session_id": null,
      "error_message": null,
      "id": 2060,
      "ok": true,
      "provider_type": "TTLOCK",
      "reconcile_job_id": 147,
      "request_json": {
        "attempted_vendor_pin_id": "50957532",
        "expected_prefix": "AB U10 ",
        "job_user_id": 10,
        "lock_id": 28991110,
        "note": "name_prefix_mismatch",
        "pin_last4": "1111",
        "reason": "blocked_cross_user_delete_guard",
        "resolved_name": "AB U9 C6"
      },
      "response_json": {
        "blocked": true,
        "ok": true
      }
    },
    {
      "action": "PASSCODE_LIST",
      "correlation_id": "af41bec2c6dc46289f1cb8738d1c5bf2",
      "created_at": "2026-02-05T22:20:59.037839",
      "debug_session_id": null,
      "error_message": null,
      "id": 2061,
      "ok": true,
      "provider_type": "TTLOCK",
      "reconcile_job_id": 147,
      "request_json": {
        "base_host": "https://api.ttlock.com",
        "method": "GET",
        "path": "/v3/lock/listKeyboardPwd",
        "payload": {
          "accessToken": "***",
          "clientId": "6636adfbf3f9483d946082b74f20797c",
          "date": 1770330058326,
          "lockId": 28991110,
          "pageNo": 1,
          "pageSize": 200
        },
        "url": "https://api.ttlock.com/v3/lock/listKeyboardPwd"
      },
      "response_json": {
        "list": [
          {
            "endDate": 1801866030751,
            "isCustom": 1,
            "keyboardPwd": "***1111",
            "keyboardPwdId": 50957532,
            "keyboardPwdName": "***",
            "keyboardPwdType": 3,
            "keyboardPwdVersion": 4,
            "lockId": 28991110,
            "nickName": "keith",
            "receiverUsername": "",
            "sendDate": 1770330034000,
            "senderUsername": "keith@ac5.ca",
            "startDate": 1770329971618,
            "status": 1
          }
        ],
        "pageNo": 1,
        "pageSize": 200,
        "pages": 1,
        "total": 1
      }
    },
    {
      "action": "PIN_DELETE",
      "correlation_id": "af41bec2c6dc46289f1cb8738d1c5bf2",
      "created_at": "2026-02-05T22:20:59.041425",
      "debug_session_id": null,
      "error_message": null,
      "id": 2062,
      "ok": true,
      "provider_type": "TTLOCK",
      "reconcile_job_id": 147,
      "request_json": {
        "lock_id": 28991110,
        "name": "AB U10 C7",
        "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": "af41bec2c6dc46289f1cb8738d1c5bf2",
      "created_at": "2026-02-05T22:20:59.667709",
      "debug_session_id": null,
      "error_message": "schlage_delete_404_treated_ok",
      "id": 2063,
      "ok": true,
      "provider_type": "SCHLAGE_HOME",
      "reconcile_job_id": 147,
      "request_json": {
        "device_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
        "name": "AB U10 C7",
        "pin_last4": null,
        "receipt_id": "fbde9b97-270e-49c2-820e-175034bf5361",
        "receipt_numeric_ignored": false
      },
      "response_json": {
        "already": true,
        "http_status": 404,
        "ok": true
      }
    },
    {
      "action": "RECONCILE_JOB_DONE",
      "correlation_id": "af41bec2c6dc46289f1cb8738d1c5bf2",
      "created_at": "2026-02-05T22:20:59.677918",
      "debug_session_id": null,
      "error_message": null,
      "id": 2064,
      "ok": true,
      "provider_type": "ACCESS_BROKER",
      "reconcile_job_id": 147,
      "request_json": {
        "attempt_count": 1,
        "job_id": 147,
        "user_id": 10
      },
      "response_json": {
        "job_status": "done",
        "summary": {
          "adds_updates": 0,
          "desired": 0,
          "removes": 5
        }
      }
    }
  ]
}

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