{
  "derived": {
    "age_seconds": 190178.840317,
    "is_stuck_running": false,
    "last_log_at": "2026-02-05T16:30:19Z",
    "now_utc": "2026-02-07T21:19:58Z",
    "stuck_reason": null,
    "updated_at_utc": "2026-02-05T16:30:19Z"
  },
  "job": {
    "attempt_count": 1,
    "correlation_id": "e553c74a928e47c9893910188860c21a",
    "created_at": "2026-02-05T16:30:14.293363+00:00",
    "debug_session_id": null,
    "job_type": "reconcile_user",
    "last_error": null,
    "next_run_at": null,
    "reason": "credential changed",
    "reconcile_job_id": 112,
    "status": "done",
    "updated_at": "2026-02-05T16:30:19.732619+00:00",
    "user_id": 10
  },
  "logs": [
    {
      "action": "RECONCILE_ENQUEUED",
      "correlation_id": "e553c74a928e47c9893910188860c21a",
      "created_at": "2026-02-05T16:30:14.297863",
      "debug_session_id": null,
      "error_message": null,
      "id": 1727,
      "ok": true,
      "provider_type": "ACCESS_BROKER",
      "reconcile_job_id": 112,
      "request_json": {
        "deduped": false,
        "reason": "credential changed",
        "source": "credential route",
        "user_id": 10
      },
      "response_json": {
        "job_id": 112
      }
    },
    {
      "action": "RECONCILE_JOB_START",
      "correlation_id": "e553c74a928e47c9893910188860c21a",
      "created_at": "2026-02-05T16:30:14.646468",
      "debug_session_id": null,
      "error_message": null,
      "id": 1730,
      "ok": true,
      "provider_type": "ACCESS_BROKER",
      "reconcile_job_id": 112,
      "request_json": {
        "attempt_count": 1,
        "job_id": 112,
        "job_type": "reconcile_user",
        "reason": "credential changed",
        "user_id": 10
      },
      "response_json": null
    },
    {
      "action": "PIN_ADD",
      "correlation_id": "e553c74a928e47c9893910188860c21a",
      "created_at": "2026-02-05T16:30:15.683489",
      "debug_session_id": null,
      "error_message": null,
      "id": 1731,
      "ok": true,
      "provider_type": "SCHLAGE_HOME",
      "reconcile_job_id": 112,
      "request_json": {
        "access_code_last4": "2222",
        "adopted_from_list": false,
        "device_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
        "existing_code_last4": null,
        "name": "AB U10 C7",
        "outbound_keys": [
          "name",
          "accessCode",
          "scheduleType",
          "scheduleDetails"
        ],
        "pin_last4": "2222",
        "scheduleDetails_keys": [],
        "scheduleType": "Always",
        "schedule_end": null,
        "schedule_start": null
      },
      "response_json": {
        "created": true,
        "receipt_id": "1e2925df-2a21-4231-9559-fe6e04caa78c",
        "result": {
          "ok": true,
          "response": {
            "id": "1e2925df-2a21-4231-9559-fe6e04caa78c"
          }
        },
        "updated": false
      }
    },
    {
      "action": "SCHLAGE_RECEIPT_PERSISTED",
      "correlation_id": "e553c74a928e47c9893910188860c21a",
      "created_at": "2026-02-05T16:30:15.683489",
      "debug_session_id": null,
      "error_message": null,
      "id": 1732,
      "ok": true,
      "provider_type": "SCHLAGE_HOME",
      "reconcile_job_id": 112,
      "request_json": {
        "credential_id": 7,
        "grant_id": 27,
        "previous_receipt_id": null,
        "receipt_id": "1e2925df-2a21-4231-9559-fe6e04caa78c",
        "user_id": 10
      },
      "response_json": null
    },
    {
      "action": "PIN_DELETE",
      "correlation_id": "e553c74a928e47c9893910188860c21a",
      "created_at": "2026-02-05T16:30:16.256082",
      "debug_session_id": null,
      "error_message": null,
      "id": 1733,
      "ok": true,
      "provider_type": "SCHLAGE_HOME",
      "reconcile_job_id": 112,
      "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": "e553c74a928e47c9893910188860c21a",
      "created_at": "2026-02-05T16:30:17.142573",
      "debug_session_id": null,
      "error_message": null,
      "id": 1734,
      "ok": true,
      "provider_type": "TTLOCK",
      "reconcile_job_id": 112,
      "request_json": {
        "base_host": "https://api.ttlock.com",
        "method": "GET",
        "path": "/v3/lock/listKeyboardPwd",
        "payload": {
          "accessToken": "***",
          "clientId": "6636adfbf3f9483d946082b74f20797c",
          "date": 1770309016258,
          "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": "e553c74a928e47c9893910188860c21a",
      "created_at": "2026-02-05T16:30:17.149352",
      "debug_session_id": null,
      "error_message": null,
      "id": 1735,
      "ok": true,
      "provider_type": "TTLOCK",
      "reconcile_job_id": 112,
      "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_DELETE",
      "correlation_id": "e553c74a928e47c9893910188860c21a",
      "created_at": "2026-02-05T16:30:18.926655",
      "debug_session_id": null,
      "error_message": null,
      "id": 1736,
      "ok": true,
      "provider_type": "TTLOCK",
      "reconcile_job_id": 112,
      "request_json": {
        "base_host": "https://api.ttlock.com",
        "method": "POST",
        "path": "/v3/keyboardPwd/delete",
        "payload": {
          "accessToken": "***",
          "clientId": "6636adfbf3f9483d946082b74f20797c",
          "date": 1770309017153,
          "deleteType": 2,
          "keyboardPwdId": 50957532,
          "lockId": 28991110
        },
        "url": "https://api.ttlock.com/v3/keyboardPwd/delete"
      },
      "response_json": {
        "description": "\u8868\u793a\u6210\u529f\u6216\u662f",
        "errcode": 0,
        "errmsg": "none error message or means yes"
      }
    },
    {
      "action": "PIN_REVOKE",
      "correlation_id": "e553c74a928e47c9893910188860c21a",
      "created_at": "2026-02-05T16:30:18.933444",
      "debug_session_id": null,
      "error_message": null,
      "id": 1737,
      "ok": true,
      "provider_type": "TTLOCK",
      "reconcile_job_id": 112,
      "request_json": {
        "context": {
          "credential_id": 6,
          "source": "reconcile",
          "user_id": 10
        },
        "lock_id": 28991110,
        "vendor_pin_id": "50957532"
      },
      "response_json": {
        "description": "\u8868\u793a\u6210\u529f\u6216\u662f",
        "errcode": 0,
        "errmsg": "none error message or means yes"
      }
    },
    {
      "action": "PIN_DELETE",
      "correlation_id": "e553c74a928e47c9893910188860c21a",
      "created_at": "2026-02-05T16:30:18.933444",
      "debug_session_id": null,
      "error_message": null,
      "id": 1738,
      "ok": true,
      "provider_type": "TTLOCK",
      "reconcile_job_id": 112,
      "request_json": {
        "lock_id": null,
        "message": null,
        "pin_last4": "1111",
        "resolved_vendor_pin_id": null,
        "vendor_pin_id": "50957532"
      },
      "response_json": {
        "ok": true,
        "result": {
          "description": "\u8868\u793a\u6210\u529f\u6216\u662f",
          "errcode": 0,
          "errmsg": "none error message or means yes"
        }
      }
    },
    {
      "action": "PASSCODE_LIST",
      "correlation_id": "e553c74a928e47c9893910188860c21a",
      "created_at": "2026-02-05T16:30:19.705159",
      "debug_session_id": null,
      "error_message": null,
      "id": 1739,
      "ok": true,
      "provider_type": "TTLOCK",
      "reconcile_job_id": 112,
      "request_json": {
        "base_host": "https://api.ttlock.com",
        "method": "GET",
        "path": "/v3/lock/listKeyboardPwd",
        "payload": {
          "accessToken": "***",
          "clientId": "6636adfbf3f9483d946082b74f20797c",
          "date": 1770309018938,
          "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": "e553c74a928e47c9893910188860c21a",
      "created_at": "2026-02-05T16:30:19.723264",
      "debug_session_id": null,
      "error_message": null,
      "id": 1740,
      "ok": true,
      "provider_type": "TTLOCK",
      "reconcile_job_id": 112,
      "request_json": {
        "lock_id": 28991110,
        "name": "AB U10 C7",
        "note": "listed_ok_but_not_found",
        "pin_last4": "2222",
        "resolution_attempted": true,
        "resolved_vendor_pin_id": null,
        "vendor_pin_id": null
      },
      "response_json": {
        "already": true,
        "ok": true
      }
    },
    {
      "action": "RECONCILE_JOB_DONE",
      "correlation_id": "e553c74a928e47c9893910188860c21a",
      "created_at": "2026-02-05T16:30:19.732619",
      "debug_session_id": null,
      "error_message": null,
      "id": 1741,
      "ok": true,
      "provider_type": "ACCESS_BROKER",
      "reconcile_job_id": 112,
      "request_json": {
        "attempt_count": 1,
        "job_id": 112,
        "user_id": 10
      },
      "response_json": {
        "job_status": "done",
        "summary": {
          "adds_updates": 1,
          "desired": 1,
          "removes": 4
        }
      }
    }
  ]
}

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