2.1 KiB
Ghost in the Registry
Category: Database
Points: 240
Description
<iframe src="" style="background-image: url('https://deadface.sfo3.cdn.digitaloceanspaces.com/2026/img/wayfinder/ghost_in_the_registry.png');background-size:cover;background-position:center center;background-origin:content-box;background-repeat:no-repeat;background-color:rgba(40, 40, 40,0);min-height:80px;height:130px;width:100%;padding:10px;border:none" title="Thumbnail"></iframe> <sup>Created By: <code>@syyntax</code></sup> <style> .tiny-text { font-size: 6px; color: #1a1a1a; } </style> <span class="tiny-text">flag{9de3c45430f57b1a}</span>
Diverted narcotics need a paper trail that leads nowhere. Investigators suspect a fabricated patient — one who is issued controlled-substance prescriptions but has never actually been seen for a single clinical encounter. Aurora uses one enterprise patient_id across all of its systems, so records join across databases. Find the patient who has at least one Schedule II prescription but zero encounters in aurora_ehr, and report their MRN.
Use provided MySQL shell.
Submit the MRN as deadface{MRN}. Example: deadface{AH-1234567}.