← All work

DocNexus.ai · case study

Drug-to-security crosswalk

Mapping every drug claim since 2017 to the company that sold it on that date, and to its listed security.

In progressOct 2026 – presentData & Analytics, Quant & Math

Every pharmacy and medical drug claim, mapped to the selling company on the service date, its ultimate parent, and the listed security with validity windows, plus a separate royalty layer. Phase 1 of 10 is complete.

Methods and relative results only. Client figures, internal names and scale are not published.

Rules that each fix a real past error

Key on drug codes, never on names or claim organisation fields. Validity windows are half-open and joins use the actual service date. Ownership changes apply from the legal close date, and pending deals are never applied. A primary ticker is never set from a royalty. Unknown is never shown as private: every blank carries a reason code.

Why the rules exist

An audit of the earlier mapping found the company taken from claim organisation fields on about ~20% of pharmacy claims, a wrong ticker on 16.1% of pharmacy and 14.8% of medical claims, deals applied before they closed, and rows labelled private without evidence.

Phase one built the full-history drug-volume grain; it ties out to source in 117 of 117 months. A small residual shortfall in three months is labelled unexplained rather than explained away.