Safety Databases · Section 10.9
~6 min read · The Drug Safety Coach — Global PV Career Course
Key points
Full text
Everything this module has covered — case intake, workflow, coded data, E2B(R3) transmission, built-in analytics — depends on the underlying database system itself being demonstrably trustworthy, not just assumed to be. Computer System Validation (CSV) is the formal, documented process organisations go through to prove a safety database performs exactly as intended — that data entered correctly is stored correctly, that workflow routing actually routes the way it’s configured to, that reports generate accurate output — before the system goes live for regulated use, and again after any significant configuration change or software update.
21 CFR Part 11, the FDA regulation governing electronic records and electronic signatures, sets specific requirements a validated system has to meet, and audit trails are among its most operationally significant provisions. A compliant audit trail has to capture, automatically and without relying on a user to remember to log anything manually, exactly who changed what data, when, for essentially every meaningful action taken on a case — a data field being edited, a workflow state transition, a causality reassessment, a narrative revision.
Critically, that audit trail record has to be tamper-evident: once created, a user cannot simply edit or delete an audit trail entry to make an earlier action disappear from the record. This is precisely what makes a validated safety database’s data genuinely trustworthy to an external party in a way that an informal spreadsheet or an unvalidated system simply couldn’t be — a regulator or auditor doesn’t have to take a company’s word that a case wasn’t quietly altered after the fact; the system itself provides tamper-evident proof either way.
This is exactly why regulatory inspections of a company’s pharmacovigilance system examine the database itself, not only the content of individual cases — an inspector verifying PV system compliance will commonly review validation documentation and audit trail records specifically, looking for evidence the system was properly validated, that access controls are appropriately restricted, and that consequential changes to case data (a late causality reassessment, a narrative revision close to a PBRER submission deadline) are fully traceable with a documented rationale. The database’s own integrity is, in a real sense, as much a subject of regulatory scrutiny as any individual case it contains.
Important
A tamper-evident audit trail is what makes a safety database’s data actually trustworthy to a regulator, beyond simply trusting the company’s word. If a causality assessment gets changed from "Possible" to "Unlikely" three days before a PBRER submission, the audit trail shows exactly who made that change, when, and — depending on the system’s configuration — often requires a documented reason. This is precisely the kind of record an inspector will specifically look for around any consequential, late-stage case change.
Quick check
Test yourself before moving on — no pressure, just click an answer.
1. What makes a safety database’s audit trail genuinely trustworthy to an external regulator or auditor?