{"title":"Mike.ai Scottish completion supervision queue","route":"/mike-ai/supervision-queue","accountName":"Northstar Legal Group","boundary":"Fictional sample workspace. Controlled public artefact. Not affiliated with any law firm.","dataBoundary":"fictional-sample-and-metadata-only","objective":"Give conveyancing managers a review queue that combines matter, lane, risk, reviewer, ageing, SLA pressure and export-lock state before completion packs leave the workflow.","items":[{"id":"sq-source-funds-gift","matter":"NS-042 purchase","lane":"AML and source of funds","workflow":"Scottish completion readiness","jurisdiction":"Scotland","risk":"high","status":"review-required","reviewer":"risk-partner","ageHours":19,"slaHours":8,"ageingBand":"overdue","assignment":{"primaryReviewer":"risk-partner","backupReviewer":"supervising-partner","team":"Risk and compliance","acceptedAt":"2026-06-29T14:00:00Z","lastTouchedAt":"2026-06-30T08:10:00Z","instruction":"Clear source trail or confirm the external pack must remain locked.","escalationPath":"Risk partner -> supervising partner -> completion operator"},"reviewerHistory":[{"at":"2026-06-29T14:00:00Z","reviewer":"completion-operator","action":"assigned","note":"Source-of-funds gap routed from completion readiness check."},{"at":"2026-06-30T08:10:00Z","reviewer":"risk-partner","action":"review-held","note":"Gifted-deposit trail still needs donor statement evidence."}],"sourceRef":"AML/SOF metadata row 04","nextAction":"Risk partner to clear gifted-deposit trail or keep external completion pack locked.","exportLocked":true,"exportLockReason":"Gifted-deposit source trail is not reviewer-cleared against bank-statement evidence.","auditExport":{"state":"blocked","checkedAt":"2026-06-30T08:30:00Z","evidence":["AML/SOF metadata row 04 linked","Risk-partner clearance missing"],"nextAuditStep":"Record risk-partner clearance and attach donor statement evidence before external release."},"operationalTags":["locked","overdue","same-day","partner-review"]},{"id":"sq-advance-notice","matter":"NS-077 sale and purchase","lane":"RoS and advance notice","workflow":"Scottish completion readiness","jurisdiction":"Scotland","risk":"high","status":"blocked","reviewer":"title-reviewer","ageHours":11,"slaHours":6,"ageingBand":"overdue","assignment":{"primaryReviewer":"title-reviewer","backupReviewer":"supervising-partner","team":"Title and RoS controls","acceptedAt":"2026-06-29T16:20:00Z","lastTouchedAt":"2026-06-30T08:45:00Z","instruction":"Confirm advance notice state and discharge dependency before pack release.","escalationPath":"Title reviewer -> supervising partner -> risk partner"},"reviewerHistory":[{"at":"2026-06-29T16:20:00Z","reviewer":"fee-earner","action":"evidence-gap-opened","note":"Advance notice status missing from completion checklist."},{"at":"2026-06-30T08:45:00Z","reviewer":"title-reviewer","action":"dependency-confirmed","note":"Discharge dependency still open; RoS evidence not ready for export."}],"sourceRef":"RoS/advance notice metadata row 02","nextAction":"Confirm advance notice and discharge dependency before partner export window.","exportLocked":true,"exportLockReason":"RoS advance notice and discharge dependency are not confirmed in the source metadata.","auditExport":{"state":"blocked","checkedAt":"2026-06-30T09:00:00Z","evidence":["RoS/advance notice metadata row 02 linked","Discharge dependency outstanding"],"nextAuditStep":"Attach advance notice confirmation and discharge dependency outcome."},"operationalTags":["locked","overdue","same-day","partner-review"]},{"id":"sq-cashroom-mismatch","matter":"NS-118 purchase","lane":"Cashroom and settlement","workflow":"Scottish completion readiness","jurisdiction":"Scotland","risk":"medium","status":"evidence-requested","reviewer":"cashroom-liaison","ageHours":4,"slaHours":4,"ageingBand":"overdue","assignment":{"primaryReviewer":"cashroom-liaison","backupReviewer":"completion-operator","team":"Cashroom and settlement","acceptedAt":"2026-06-30T05:15:00Z","lastTouchedAt":"2026-06-30T08:55:00Z","instruction":"Reconcile lender drawdown and client balance before same-day readback.","escalationPath":"Cashroom liaison -> completion operator -> supervising partner"},"reviewerHistory":[{"at":"2026-06-30T05:15:00Z","reviewer":"completion-operator","action":"assigned","note":"Mismatch raised during settlement statement readback."},{"at":"2026-06-30T08:55:00Z","reviewer":"cashroom-liaison","action":"evidence-requested","note":"Drawdown confirmation requested before final balance sign-off."}],"sourceRef":"Completion statement metadata row 08","nextAction":"Resolve lender drawdown and client balance mismatch before same-day readback.","exportLocked":false,"exportLockReason":"Internal readback is required, but the external pack is not locked because no client-facing output is queued.","auditExport":{"state":"internal-ready","checkedAt":"2026-06-30T09:05:00Z","evidence":["Completion statement metadata row 08 linked","Cashroom reviewer assigned"],"nextAuditStep":"Record reconciled drawdown figure before moving to external-ready."},"operationalTags":["overdue","same-day"]},{"id":"sq-lbtt-ads","matter":"NS-126 purchase","lane":"LBTT and ADS","workflow":"Scottish completion readiness","jurisdiction":"Scotland","risk":"medium","status":"review-required","reviewer":"completion-operator","ageHours":5,"slaHours":12,"ageingBand":"within-sla","assignment":{"primaryReviewer":"completion-operator","backupReviewer":"fee-earner","team":"Tax and completion operations","acceptedAt":"2026-06-30T04:30:00Z","lastTouchedAt":"2026-06-30T08:00:00Z","instruction":"Keep ADS position provisional until client confirmation is recorded.","escalationPath":"Completion operator -> fee earner -> supervising partner"},"reviewerHistory":[{"at":"2026-06-30T04:30:00Z","reviewer":"fee-earner","action":"client-confirmation-needed","note":"ADS status depends on client response."},{"at":"2026-06-30T08:00:00Z","reviewer":"completion-operator","action":"internal-note-updated","note":"LBTT/ADS output marked provisional pending confirmation."}],"sourceRef":"Tax metadata row 05","nextAction":"Mark LBTT/ADS confirmation as provisional until client confirmation is recorded.","exportLocked":false,"exportLockReason":"No external lock is active; provisional wording remains visible in the internal pack.","auditExport":{"state":"internal-ready","checkedAt":"2026-06-30T09:10:00Z","evidence":["Tax metadata row 05 linked","Provisional ADS wording recorded"],"nextAuditStep":"Attach client confirmation before marking the row external-ready."},"operationalTags":[]},{"id":"sq-lender-condition","matter":"NS-141 purchase","lane":"Lender and insurance","workflow":"Scottish completion readiness","jurisdiction":"Scotland","risk":"medium","status":"approved","reviewer":"supervising-partner","ageHours":2,"slaHours":12,"ageingBand":"within-sla","assignment":{"primaryReviewer":"supervising-partner","backupReviewer":"completion-operator","team":"Lender condition review","acceptedAt":"2026-06-30T07:00:00Z","lastTouchedAt":"2026-06-30T08:40:00Z","instruction":"Carry approved lender evidence into the completion note and audit export register.","escalationPath":"Supervising partner -> completion operator"},"reviewerHistory":[{"at":"2026-06-30T07:00:00Z","reviewer":"completion-operator","action":"evidence-attached","note":"Lender condition and insurance evidence attached to partner pack."},{"at":"2026-06-30T08:40:00Z","reviewer":"supervising-partner","action":"cleared","note":"Evidence accepted for controlled external export."}],"sourceRef":"Lender/insurance metadata row 06","nextAction":"Keep approved evidence attached to internal partner pack and carry to completion note.","exportLocked":false,"exportLockReason":"Reviewer clearance is recorded; no export-lock reason remains active.","auditExport":{"state":"external-ready","checkedAt":"2026-06-30T09:15:00Z","evidence":["Lender/insurance metadata row 06 linked","Supervising-partner clearance recorded"],"nextAuditStep":"Include in audit export with reviewer and timestamp metadata."},"operationalTags":["audit-ready","partner-review"]},{"id":"sq-search-title","matter":"NS-158 purchase","lane":"Search and title","workflow":"Scottish completion readiness","jurisdiction":"Scotland","risk":"low","status":"evidence-requested","reviewer":"fee-earner","ageHours":3,"slaHours":24,"ageingBand":"within-sla","assignment":{"primaryReviewer":"fee-earner","backupReviewer":"title-reviewer","team":"Search and title evidence","acceptedAt":"2026-06-30T06:20:00Z","lastTouchedAt":"2026-06-30T08:20:00Z","instruction":"Attach the missing search reference before manager readback.","escalationPath":"Fee earner -> title reviewer -> supervising partner"},"reviewerHistory":[{"at":"2026-06-30T06:20:00Z","reviewer":"fee-earner","action":"evidence-requested","note":"Coal/mining search reference missing from source list."},{"at":"2026-06-30T08:20:00Z","reviewer":"title-reviewer","action":"review-note-added","note":"Manager readback can proceed once reference is attached."}],"sourceRef":"Search/title metadata row 09","nextAction":"Attach missing coal/mining search reference before manager readback.","exportLocked":false,"exportLockReason":"No export lock is active; the row remains in evidence-requested internal review.","auditExport":{"state":"internal-ready","checkedAt":"2026-06-30T09:20:00Z","evidence":["Search/title metadata row 09 linked","Manager readback pending"],"nextAuditStep":"Attach missing search reference before external-ready state."},"operationalTags":[]}],"filterPresets":[{"label":"Locked exports","href":"https://mikeai.co.uk/supervision-queue?exportLocked=locked","summary":"Rows blocking external completion packs."},{"label":"SLA overdue","href":"https://mikeai.co.uk/supervision-queue?ageing=overdue","summary":"Rows at or beyond SLA."},{"label":"Same-day clearance","href":"https://mikeai.co.uk/supervision-queue?operation=same-day","summary":"Rows that need same-day operational action."},{"label":"Partner review","href":"https://mikeai.co.uk/supervision-queue?operation=partner-review","summary":"Rows assigned to partner-led clearance."},{"label":"Audit ready","href":"https://mikeai.co.uk/supervision-queue?operation=audit-ready","summary":"Rows ready for controlled audit export."}],"csv":"matter,lane,workflow,risk,status,reviewer,age_hours,sla_hours,ageing_band,assignment_team,backup_reviewer,reviewer_history_count,source_ref,next_action,export_locked,export_lock_reason,audit_export_state,audit_next_step,row_id\n\"NS-042 purchase\",\"AML and source of funds\",\"Scottish completion readiness\",\"high\",\"review-required\",\"risk-partner\",\"19\",\"8\",\"overdue\",\"Risk and compliance\",\"supervising-partner\",\"2\",\"AML/SOF metadata row 04\",\"Risk partner to clear gifted-deposit trail or keep external completion pack locked.\",\"true\",\"Gifted-deposit source trail is not reviewer-cleared against bank-statement evidence.\",\"blocked\",\"Record risk-partner clearance and attach donor statement evidence before external release.\",\"sq-source-funds-gift\"\n\"NS-077 sale and purchase\",\"RoS and advance notice\",\"Scottish completion readiness\",\"high\",\"blocked\",\"title-reviewer\",\"11\",\"6\",\"overdue\",\"Title and RoS controls\",\"supervising-partner\",\"2\",\"RoS/advance notice metadata row 02\",\"Confirm advance notice and discharge dependency before partner export window.\",\"true\",\"RoS advance notice and discharge dependency are not confirmed in the source metadata.\",\"blocked\",\"Attach advance notice confirmation and discharge dependency outcome.\",\"sq-advance-notice\"\n\"NS-118 purchase\",\"Cashroom and settlement\",\"Scottish completion readiness\",\"medium\",\"evidence-requested\",\"cashroom-liaison\",\"4\",\"4\",\"overdue\",\"Cashroom and settlement\",\"completion-operator\",\"2\",\"Completion statement metadata row 08\",\"Resolve lender drawdown and client balance mismatch before same-day readback.\",\"false\",\"Internal readback is required, but the external pack is not locked because no client-facing output is queued.\",\"internal-ready\",\"Record reconciled drawdown figure before moving to external-ready.\",\"sq-cashroom-mismatch\"\n\"NS-126 purchase\",\"LBTT and ADS\",\"Scottish completion readiness\",\"medium\",\"review-required\",\"completion-operator\",\"5\",\"12\",\"within-sla\",\"Tax and completion operations\",\"fee-earner\",\"2\",\"Tax metadata row 05\",\"Mark LBTT/ADS confirmation as provisional until client confirmation is recorded.\",\"false\",\"No external lock is active; provisional wording remains visible in the internal pack.\",\"internal-ready\",\"Attach client confirmation before marking the row external-ready.\",\"sq-lbtt-ads\"\n\"NS-141 purchase\",\"Lender and insurance\",\"Scottish completion readiness\",\"medium\",\"approved\",\"supervising-partner\",\"2\",\"12\",\"within-sla\",\"Lender condition review\",\"completion-operator\",\"2\",\"Lender/insurance metadata row 06\",\"Keep approved evidence attached to internal partner pack and carry to completion note.\",\"false\",\"Reviewer clearance is recorded; no export-lock reason remains active.\",\"external-ready\",\"Include in audit export with reviewer and timestamp metadata.\",\"sq-lender-condition\"\n\"NS-158 purchase\",\"Search and title\",\"Scottish completion readiness\",\"low\",\"evidence-requested\",\"fee-earner\",\"3\",\"24\",\"within-sla\",\"Search and title evidence\",\"title-reviewer\",\"2\",\"Search/title metadata row 09\",\"Attach missing coal/mining search reference before manager readback.\",\"false\",\"No export lock is active; the row remains in evidence-requested internal review.\",\"internal-ready\",\"Attach missing search reference before external-ready state.\",\"sq-search-title\"","markdown":"# Mike.ai Scottish completion supervision queue\n\nBoundary: Fictional sample workspace. Controlled public artefact. Not affiliated with any law firm.\nData mode: fictional-sample-and-metadata-only\n\nStatus: External completion exports stay locked until reviewer clearance is recorded\nReadiness score: 41/100\nRows: 6\nExport locks: 2\nOverdue SLA rows: 3\nSame-day rows: 3\nAudit-ready rows: 1\n\n## Export Lock Reasons\n\n- NS-042 purchase: Gifted-deposit source trail is not reviewer-cleared against bank-statement evidence.\n- NS-077 sale and purchase: RoS advance notice and discharge dependency are not confirmed in the source metadata.\n\n## Review Rows\n\n- NS-042 purchase | AML and source of funds | high | review-required | risk-partner | overdue 19/8h | Assignment: Risk and compliance, backup supervising-partner | Source: AML/SOF metadata row 04 | Export locked: yes | Lock reason: Gifted-deposit source trail is not reviewer-cleared against bank-statement evidence. | Audit: blocked | History entries: 2 | Next: Risk partner to clear gifted-deposit trail or keep external completion pack locked.\n- NS-077 sale and purchase | RoS and advance notice | high | blocked | title-reviewer | overdue 11/6h | Assignment: Title and RoS controls, backup supervising-partner | Source: RoS/advance notice metadata row 02 | Export locked: yes | Lock reason: RoS advance notice and discharge dependency are not confirmed in the source metadata. | Audit: blocked | History entries: 2 | Next: Confirm advance notice and discharge dependency before partner export window.\n- NS-118 purchase | Cashroom and settlement | medium | evidence-requested | cashroom-liaison | overdue 4/4h | Assignment: Cashroom and settlement, backup completion-operator | Source: Completion statement metadata row 08 | Export locked: no | Lock reason: Internal readback is required, but the external pack is not locked because no client-facing output is queued. | Audit: internal-ready | History entries: 2 | Next: Resolve lender drawdown and client balance mismatch before same-day readback.\n- NS-126 purchase | LBTT and ADS | medium | review-required | completion-operator | within-sla 5/12h | Assignment: Tax and completion operations, backup fee-earner | Source: Tax metadata row 05 | Export locked: no | Lock reason: No external lock is active; provisional wording remains visible in the internal pack. | Audit: internal-ready | History entries: 2 | Next: Mark LBTT/ADS confirmation as provisional until client confirmation is recorded.\n- NS-141 purchase | Lender and insurance | medium | approved | supervising-partner | within-sla 2/12h | Assignment: Lender condition review, backup completion-operator | Source: Lender/insurance metadata row 06 | Export locked: no | Lock reason: Reviewer clearance is recorded; no export-lock reason remains active. | Audit: external-ready | History entries: 2 | Next: Keep approved evidence attached to internal partner pack and carry to completion note.\n- NS-158 purchase | Search and title | low | evidence-requested | fee-earner | within-sla 3/24h | Assignment: Search and title evidence, backup title-reviewer | Source: Search/title metadata row 09 | Export locked: no | Lock reason: No export lock is active; the row remains in evidence-requested internal review. | Audit: internal-ready | History entries: 2 | Next: Attach missing coal/mining search reference before manager readback.\n","status":{"totalItems":6,"lockedCount":2,"overdueCount":3,"sameDayCount":3,"highRiskCount":2,"auditReadyCount":1,"oldestAgeHours":19,"reviewerHistoryCount":12,"exportLockReasons":["NS-042 purchase: Gifted-deposit source trail is not reviewer-cleared against bank-statement evidence.","NS-077 sale and purchase: RoS advance notice and discharge dependency are not confirmed in the source metadata."],"readinessScore":41,"reviewerLoad":{"risk-partner":1,"title-reviewer":1,"cashroom-liaison":1,"completion-operator":1,"supervising-partner":1,"fee-earner":1},"releaseLabel":"External completion exports stay locked until reviewer clearance is recorded"}}