Learn / Clinical Research Management / Data management and trial statistics
Clinical data management
13 minute read · 6-question quiz
What you will learn
Describe the stages of the clinical data management process
Design a simple CRF and explain the role of the data management plan
Explain queries, coding and reconciliation
Clinical data management (CDM) collects, cleans and prepares trial data so that statisticians can analyse them reliably and regulators can trust them. The aim is a database that is complete, accurate, consistent and verifiable.
Stages
- Planning: write the data management plan (DMP), covering CRF design, data flow, validation checks, coding, reconciliation and lock procedures.
- CRF design: create forms (paper or electronic) that collect exactly what the protocol needs, no more and no less.
- Database build and validation: build the electronic data capture (EDC) system with edit checks and test it (user acceptance testing) before use.
- Data entry or capture: staff enter data at the site into the EDC, or data are entered from paper CRFs.
- Data cleaning: automatic and manual checks find missing, inconsistent or implausible values, and queries go to the site for resolution.
- Coding: adverse events are coded with MedDRA and medicines with the WHO Drug Dictionary.
- Reconciliation: safety data in the clinical database are compared with the safety database; laboratory and other external data are matched to the main database.
- Database lock: the database is closed to changes before analysis.
- Archiving and transfer.
CRF design principles
- Collect only data needed for the protocol's endpoints, safety and compliance.
- Use clear questions and standard formats for dates and units.
- Prefer coded choices to free text.
- Order fields to match the visit flow.
- Limit duplication.
- Provide completion guidelines.
Data cleaning and queries
Edit checks run automatically when data are entered, flagging for example a heart rate of 300, a visit date before consent, or a missing mandatory field. When a check fails, a query is raised to the site, which responds by correcting or confirming the value, with an audit trail. Data managers also run manual review and listings to find patterns the system cannot catch, such as a site with unusually uniform values.
Coding
Verbatim terms recorded by sites ("tummy ache", "stomach pain") are mapped to standard dictionary terms (MedDRA for events) so they can be grouped and counted.
Database lock
Lock happens only when all queries are closed, coding and reconciliation are complete, protocol deviations are classified, and sign-offs are obtained. After lock, unblinding and analysis proceed. Unlocking is exceptional and fully documented.
Summary
CDM aims for complete, accurate, consistent and verifiable data, following a data management plan.
CRFs collect only what is needed; edit checks and queries clean data with an audit trail.
MedDRA and the WHO Drug Dictionary standardise adverse event and medicine terms.
Database lock follows closed queries, coding and reconciliation; changes after lock are exceptional.
Check your understanding
Draft study guide. Spotted an error or something unclear? Tell us at hello@scintria.com. This is educational material, not clinical or regulatory advice.