🔬 DermSpX

Coverage

summaries (Dermatoscan reads)	5,869 rows · 2,968 MRNs (99.6% of charted)
notes (charted MRNs)	2,981 MRNs
codes	2,982 MRNs
paths	1,330 MRNs
rxs	2,346 MRNs

Dermatoscan reads PMH from summaries.note/rx/code. MRNs not in summaries return blank PMH on NFC tap (Tedi's bug). Per Ivo's confirmed query: SELECT note,rx,code FROM notes_test.summaries WHERE mrn=$mrn ORDER BY visit DESC LIMIT 1

50 most recent MRNs with notes but NO summary

These are the highest-value gaps to fill — recent activity, no PMH on NFC tap.

MRN	visits	last visit
22434	32	2025-05-29	RAG bundle →
31740	26	2025-05-22	RAG bundle →
12894	103	2025-05-20	RAG bundle →
35263	4	2025-04-30	RAG bundle →
39686	9	2025-04-26	RAG bundle →
34025	41	2025-04-18	RAG bundle →
40806	13	2025-04-11	RAG bundle →
18068	10	2025-04-10	RAG bundle →
35847	6	2025-04-05	RAG bundle →
29654	4	2025-04-04	RAG bundle →
41509	5	2025-04-01	RAG bundle →
36651	8	2025-03-21	RAG bundle →
28499	36	2024-12-10	RAG bundle →
25972	6	2024-11-11	RAG bundle →
41114	10	2024-10-28	RAG bundle →
90235	22	2024-08-29	RAG bundle →
5413	137	2024-07-12	RAG bundle →
38316	14	2024-07-11	RAG bundle →
28157	15	2024-05-08	RAG bundle →
41229	11	2024-05-07	RAG bundle →
40158	5	2024-04-22	RAG bundle →
43182	1	2024-04-18	RAG bundle →
39028	7	2024-04-09	RAG bundle →
28487	22	2024-03-27	RAG bundle →
9377	23	2024-01-17	RAG bundle →
33189	9	2023-06-05	RAG bundle →
25541	24	2023-04-27	RAG bundle →
497	41	2022-12-07	RAG bundle →
41948	2	2022-11-18	RAG bundle →
23719	20	2021-12-27	RAG bundle →
18055	17	2020-12-02	RAG bundle →
36204	6	2020-09-15	RAG bundle →
34628	8	2017-03-29	RAG bundle →
21602	2	2011-09-09	RAG bundle →