The Seven Pillars of Data Management, a novel in seven acts.
Chapter II, The Quality Collapse. Pillar II: Data Quality. Part 1 of 5.
The greatest enemy of knowledge is not ignorance; it is the illusion of knowledge.
Daniel J. Boorstin
The Error
The child was four years old. His name was Thomas Beaulieu, and he had his mother’s dark curly hair and his father’s wide, serious eyes: eyes that followed the world with the solemn attention of someone who understood, even at four, that things mattered. He liked dinosaurs and the colour blue and a stuffed rabbit named Capitaine that he carried in the crook of his left arm with the protective tenderness of a soldier cradling a wounded comrade. He was, by every account that would later be assembled in court filings and incident reports and the devastating testimony of his parents, a healthy boy. A boy with no allergies, no chronic conditions, no history of hospitalization. A boy who should have gone to the Gatineau Hills that October weekend to see the leaves change colour with his family, as they did every autumn, and who should have come home with maple syrup on his jacket and dirt under his fingernails and stories about the squirrel that had stolen his granola bar.
Instead, Thomas Beaulieu spent that weekend in the Paediatric Intensive Care Unit of the Ottawa campus of Lakeview Health Alliance, his small body swollen with anaphylactic shock, his mother’s face pressed against the glass of the observation window, her husband’s hand gripping hers with a force that left bruises neither of them would notice for days.
Thomas survived. This is important to say at the outset, because the story that follows will take the reader to dark places, and it is important to know, as one enters those places, that the child lived. He spent eleven days in intensive care and another four on the paediatric ward. He would carry an EpiPen for the rest of his life: not because he had a previously undiagnosed allergy, but because the anaphylactic reaction had sensitized his immune system in ways his immunologist described as “unpredictable and permanent.” A four-year-old boy’s biology, permanently altered, because the data in his medical record was wrong.
Not hacked. Not stolen. Not exposed to malicious actors or sold on the dark web or leaked by a disgruntled employee. Simply, catastrophically, wrong.
The Institution
Lakeview Health Alliance was, at the time of the incident, the third-largest integrated healthcare network in Canada. Headquartered in Ottawa, with a governing board that included two former provincial deputy ministers, a retired Supreme Court justice, and the kind of philanthropists whose names appeared on the sides of buildings, Lakeview operated fourteen hospitals, sixty-three primary care clinics, eleven long-term care facilities, and a research institute affiliated with the University of Ottawa that had produced three Canada Research Chairs in the preceding decade. Its catchment area stretched from the Quebec border to the edge of Algonquin Park, serving 2.3 million patients across eastern Ontario and western Quebec under cross-provincial agreements that were considered a model for interprovincial healthcare delivery.
Lakeview had been formed in 2014 through the amalgamation of four independent hospital networks: a restructuring driven by the Ontario Ministry of Health’s push toward integrated care and funded, in part, by a $340 million capital grant that the Minister of Health had announced at a press conference in the atrium of the Ottawa Civic Hospital, flanked by smiling administrators and a banner that read: “One Network. One Standard. One Patient.”
One patient. The slogan had been chosen by a branding agency in Toronto that billed $180,000 for the work. It was printed on letterhead, embroidered on lab coats, etched into the glass doors of the new administrative headquarters on Carling Avenue. It appeared in the annual report, in the strategic plan, in the recruitment materials sent to medical students across the country.
One patient. The irony would become evident only later, when investigators discovered that the same patient could exist in Lakeview’s systems as three, four, or in one documented case, seven different records: each with different identifiers, different medical histories, and different allergy profiles, scattered across databases that had been merged in name but never reconciled in fact.
Thomas Beaulieu existed in Lakeview’s electronic health record system as two patients. One was a four-year-old boy in Ottawa with no known allergies. The other was a seventy-eight-year-old woman in Pembroke with a documented penicillin allergy. Their records had been merged during a data migration in 2019. Nobody knew.
The Day
On October 14th, a Tuesday, Thomas developed a fever and a sore throat. His mother, Isabelle Beaulieu, a bilingual litigation associate at a mid-sized Ottawa law firm, did what any parent would do: she brought him to the Lakeview-affiliated paediatric clinic on Bank Street. The clinic was busy: it was the first week of respiratory virus season, and the waiting room was full of children with runny noses and anxious parents with hand sanitizer: and the triage nurse, a woman named Colleen Dwyer who had been working twelve-hour shifts for six consecutive days, brought Thomas through in twenty-two minutes. A reasonable time. Not an unusual time. A time that would later be scrutinized by lawyers, journalists, and a College of Nurses investigator, as though the speed of triage could explain what happened next.
The attending physician, Dr. Amir Hassani, was a family medicine resident in his second year of practice at the clinic. He was competent, careful, and liked by his colleagues. He examined Thomas, diagnosed a bacterial pharyngitis, a strep throat, and, following the standard clinical pathway, prescribed amoxicillin, a penicillin-class antibiotic that has been the first-line treatment for streptococcal pharyngitis in children for over forty years.
Before writing the prescription, Dr. Hassani did what every physician is trained to do: he checked the patient’s allergy record in the electronic health record system. The system was called CareConnect, a platform developed by a Canadian health IT vendor and deployed across all fourteen Lakeview hospitals and all sixty-three clinics as part of the 2014 amalgamation. CareConnect was Lakeview’s “single source of truth” for patient information. It was the system that the $340 million investment was supposed to enable. It was the system that the banner in the atrium had promised would deliver “One Network. One Standard. One Patient.”
Dr. Hassani opened Thomas Beaulieu’s record in CareConnect. The allergy field displayed: “No Known Allergies.” He prescribed amoxicillin. He printed the prescription. He handed it to Isabelle Beaulieu with instructions on dosage, timing, and what to watch for.
What he did not know, what CareConnect did not show him, because the data was wrong, was that Thomas Beaulieu’s record had been contaminated during a data migration five years earlier, when the allergy profile of a seventy-eight-year-old woman named Thérèse Beaulieu-Fortin in Pembroke had been partially merged with Thomas’s record. The merge had correctly overwritten Thérèse’s name, date of birth, and address with Thomas’s information. But in the process, it had also overwritten Thomas’s allergy profile, which, at the time of the merge, was blank because he had never been tested, with a corrupted fragment of Thérèse’s record. The corruption had stripped Thérèse’s penicillin allergy flag from the merged record and replaced it with “No Known Allergies.”
The system said the child had no allergies. The system was wrong. And in medicine, when the system is wrong, people bleed.
Thomas took his first dose of amoxicillin at 6:15 PM. By 6:47 PM, his lips were swelling. By 6:52 PM, he could not breathe. By 7:03 PM, the paramedics were cutting away his shirt to administer epinephrine in the back of an ambulance racing down the Queensway, siren splitting the October dark, while Isabelle Beaulieu held her son’s hand and whispered, in French, the words that parents whisper when the world is ending: “Ça va aller, mon coeur. Ça va aller.”
It’s going to be okay, my heart. It’s going to be okay.
She did not know if it was true. She said it anyway. That is what parents do.
Get the next one
A note a week on technical selling, enterprise data, and what actually moves deals. No pitch.
One email a week at most. Unsubscribe any time.