CCDM logo
Focused certification exam prep
Start practice

CCDM Domain 2: Data Entry, Coding, and Query Management - Complete Study Guide 2026

TL;DR
  • Domain 2 tests data entry conventions, coding dictionaries, and the full query lifecycle in scenario form.
  • Candidates should know MedDRA and WHO Drug coding logic, not just definitions.
  • Query aging, discrepancy classification, and resolution documentation are recurring exam themes.
  • The V2 study guide (July 22, 2025) tests seven task domains and excludes Personnel Management Tasks entirely.

What Domain 2 Actually Covers

Domain 2: Data Entry, Coding, and Query Management sits at the operational core of the CCDM exam. Where Domain 1 focuses on how a CRF and data management plan are built, Domain 2 tests what happens once real subject data starts flowing into a clinical database. That includes how data is captured and verified, how verbatim terms get mapped to standardized coding dictionaries, and how discrepancies are identified, queried, and resolved through to database lock.

This domain rewards candidates who have actually worked discrepancy queues and coding review cycles, not just those who memorized definitions. If you're mapping out your overall exam strategy, the CCDM Exam Domains 2026 guide is a useful companion to see how Domain 2 weighs against the other six areas before you allocate study time.

Foundational Source: Nearly every Domain 2 concept traces back to the Good Clinical Data Management Practices (GCDMP) manual. If you're studying from generic data management textbooks instead of GCDMP chapters on data cleaning and coding, you're studying the wrong material.

Data Entry Conventions and Standards

A large share of Domain 2 content addresses how data enters the system in the first place, and how entry methods affect downstream data quality. Candidates need working familiarity with:

  • Single vs. double data entry: when each approach is appropriate, and how discrepancy rates between first- and second-pass entry are handled.
  • Data Entry Guidelines (DEGs): the document that tells entry staff how to transcribe ambiguous, missing, or corrected source data consistently.
  • Self-evident corrections: what qualifies as a correction data management can make without querying the site, and what must always be queried.
  • Edit checks at point of entry: range checks, format checks, and cross-field logic that fire during entry rather than in batch review.

Domain 2: Data Entry, Coding, and Query Management

Candidates must understand not just what these conventions are, but why a given method is chosen for a given trial design and data risk profile.

  • Recognize when double data entry is justified versus single entry with verification
  • Distinguish self-evident corrections from discrepancies requiring a formal query
  • Apply DEG logic to scenario-based CRF entry examples

Medical and Drug Coding Fundamentals

Coding is where many candidates lose points, because it requires both conceptual understanding and applied judgment. Domain 2 exam items commonly present a verbatim term - an adverse event description or a concomitant medication name exactly as recorded - and ask what the correct coding action is.

Core coding topics you need to master include:

  • MedDRA structure: the hierarchy from Lowest Level Term (LLT) up through Preferred Term (PT), High Level Term (HLT), and System Organ Class (SOC), and how a single verbatim term maps to a specific LLT.
  • WHO Drug Dictionary coding: how concomitant medications and study treatments are coded to active ingredient and ATC classification.
  • Autoencoding vs. manual coding: when a verbatim term autoencodes cleanly and when it routes to a medical coder for manual review.
  • Coding queries: when an unclear or misspelled verbatim term must be queried back to the site before it can be coded, versus when the coder can resolve it independently.
  • Dictionary version control: why re-coding is required when a study upgrades MedDRA or WHO-DD versions mid-trial.
Exam Pattern to Notice: Coding questions rarely ask you to define MedDRA. They present a messy verbatim term and ask you to identify the correct next action - code, query, or escalate to a medical coder. Practice recognizing the difference.

The Query Management Lifecycle

Query management is arguably the single most tested concept in Domain 2. The exam expects you to know the full lifecycle, end to end, and to apply it to specific scenarios rather than recite steps in the abstract.

  1. Discrepancy identification: generated by edit checks, manual review, coding review, or SAE reconciliation.
  2. Query generation: writing a clear, unambiguous query that a site coordinator can act on without back-and-forth.
  3. Query routing and tracking: assignment to the correct site contact and monitoring of query status and aging.
  4. Site response and data correction: updating the CRF or EDC entry, with the correction traceable to the original query.
  5. Query closure: verifying the correction actually resolves the discrepancy before marking it closed.

Metrics matter here too. Candidates should understand query aging thresholds, why open query counts are tracked as a data quality indicator, and how query volume trends inform database lock readiness. These metrics also tie directly into the oversight responsibilities covered in Domain 3: Project Management and Vendor Oversight, since query backlog is a standard CRO performance metric.

Key Takeaway

Memorize the query lifecycle as a sequence of decisions, not a flowchart. The exam will ask "what happens next" at a specific point in a scenario, not "list the steps."

How Domain 2 Questions Are Framed on the Exam

Domain 2 items are almost always scenario-based rather than fact-recall. A typical item describes a specific data situation - a discrepant lab value, an ambiguous verbatim term, an aging open query - and asks you to select the most appropriate action among plausible-sounding options. Several distractor answers will describe technically correct processes that are simply wrong for the situation described.

This is a key reason candidates who rely purely on flashcard memorization tend to struggle. The CCDM difficulty guide discusses this scenario-heavy format across all domains, but Domain 2 is where it shows up most sharply, because real-world query and coding decisions rarely have one textbook-perfect answer without context.

To prepare effectively, work through as many realistic discrepancy and coding scenarios as you can find, ideally using timed practice sets on the main practice test hub so you get used to making these judgment calls under exam time pressure rather than in an open-book study session.

Where Domain 2 Fits Among the Seven Tested Domains

The current V2 study guide, dated July 22, 2025, identifies seven tested task domains and explicitly excludes Personnel Management Tasks from the exam blueprint. Within Programming Tasks, only the ad hoc SQL query task (P.5) is tested - meaning candidates are not expected to master broader programming skills, but they are expected to understand basic query logic against a clinical database, which overlaps conceptually with Domain 2's discrepancy identification work.

DomainPrimary FocusRelationship to Domain 2
Domain 1: CRF Design and Data Management PlanningBuilding the collection instruments and DMPDefines the fields and edit check specs Domain 2 processes downstream
Domain 2: Data Entry, Coding, and Query ManagementEntry, coding, discrepancy resolutionCore operational domain covered in this guide
Domain 3: Project Management and Vendor OversightTimeline, budget, CRO/vendor performanceUses query metrics from Domain 2 as oversight indicators
Domain 4: Protocol Review and Data ValidationProtocol-driven validation logicShares edit check and discrepancy concepts with Domain 2
Domain 5: System Validation and User Acceptance TestingEDC build validation and UATValidates the entry screens and edit checks Domain 2 relies on
Domain 6: Site Training and CommunicationTraining sites on data entry expectationsFeeds directly into data entry quality addressed in Domain 2

Notice how Domain 2 threads through nearly every other domain. That interconnection is exactly why the full domains guide recommends studying Domain 2 concepts before Domains 3 through 6 - it gives you the operational vocabulary those domains assume you already have.

Who Uses These Skills on the Job

Domain 2 skills map almost one-to-one onto the daily responsibilities of clinical data coordinators, data management associates, and medical coding specialists at CROs, sponsors, and biotech companies. If you're evaluating whether the certification itself translates into hiring value, the CCDM jobs overview and the ROI analysis on CCDM certification both point to query management and coding proficiency as skills employers explicitly screen for in interviews, separate from the credential itself.

Understanding this domain deeply also has practical career value beyond the exam: query resolution turnaround and coding accuracy are commonly cited performance metrics in data management job descriptions, which is worth keeping in mind if you're also researching typical compensation on the CCDM salary guide.

A Realistic Study Timeline for Domain 2

Generic study techniques only help if they're anchored to CCDM's actual domain structure. Here's a focused two-week block built specifically around Domain 2's two heaviest sub-areas - coding and query lifecycle - rather than a generic weekly template.

Week 1

Data Entry and Coding Fundamentals

  • Read GCDMP chapters on data entry conventions and medical coding
  • Build a personal reference sheet of MedDRA hierarchy levels and WHO Drug coding logic
  • Work 20-30 verbatim-term coding scenarios, checking your reasoning against GCDMP guidance
Week 2

Query Management Application

  • Map the full query lifecycle from discrepancy identification to closure from memory
  • Practice scenario questions on query aging, escalation, and self-evident corrections
  • Take a timed Domain 2 practice set and review every missed item against the lifecycle steps

For a full multi-domain schedule that slots this block into your broader prep, see the CCDM Study Guide 2026, which sequences all domains ahead of exam day.

Registration and Exam Mechanics Refresher

A few practical facts are worth keeping in mind while you plan your Domain 2 study block, since they affect scheduling decisions:

  • The exam is administered by the Society for Clinical Data Management through Prolydian, with live remote proctoring.
  • In high-income countries, the fee is $250 for SCDM members and $325 for nonmembers.
  • You get 3.5 hours total, and breaks are permitted, but the exam clock keeps running during breaks - plan your pacing across all seven domains accordingly.
  • Eligibility requires a bachelor's degree plus at least two years of full-time clinical data management experience, an associate's degree plus at least three years, or at least four years of full-time experience (equivalent part-time experience counts).
  • Certification is valid for three years, with renewal fees of $95 for members and $150 for nonmembers in high-income countries.

If you want a full breakdown of every fee scenario, the CCDM Certification Cost 2026 guide covers pricing across income tiers and membership status in detail. And if you're still deciding whether the credential is worth pursuing at all, the CCDM pass rate article gives useful qualitative context on exam difficulty without relying on invented numbers.

Plan Your Timing: Because break time counts against your 3.5-hour clock, rehearse Domain 2 scenario questions under timed conditions well before exam day - don't save your first timed run for the actual test. Practice sets on the CCDM practice test hub can help build that pacing instinct.

Frequently Asked Questions

Is Domain 2 the most heavily tested domain on the CCDM exam?

The V2 study guide identifies seven task domains overall, and while exact weighting isn't published as a fixed percentage, Domain 2's data entry, coding, and query management content overlaps with concepts tested in Domains 1, 3, and 4, making it one of the more foundational areas to master early.

Do I need to know SQL for Domain 2?

Domain 2 itself doesn't require SQL. The only programming content tested anywhere on the exam is ad hoc SQL query task P.5 within Programming Tasks, which is a separate, narrowly scoped area rather than part of Domain 2.

What's the best single source for Domain 2 content?

The Good Clinical Data Management Practices (GCDMP) manual is the preparation foundation SCDM points to, and its chapters on data cleaning, coding, and query management map directly onto Domain 2's tested content.

Are Personnel Management Tasks part of Domain 2?

No. The current V2 study guide explicitly excludes Personnel Management Tasks from the exam entirely, so you don't need to prepare staffing or team-management content for Domain 2 or any other domain.

How does Domain 2 relate to Domain 1 and Domain 4 on the exam?

Domain 1 defines the CRF fields and edit check specifications that Domain 2 processes during entry and query resolution, while Domain 4 focuses on protocol-driven validation logic that often triggers the discrepancies Domain 2 covers - studying them together reinforces the same core concepts from different angles.

Ready to pass your CCDM exam?

Put this into practice with free CCDM questions across every exam domain.