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.
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.