thebench.bio #1 Ecosystem for the Bio-Tech Industry
All Clinical Data Management questions

Question 13 of 20 Intermediate Practical

How should an EDC study build be tested before go-live?

Short answer

Test the build against pre-approved test cases traced to the protocol and the data management plan, covering forms, visit schedule, edit checks, derivations, user roles and integrations. Record actual results and evidence, assess every failure, and release only after sign-off, with changes after go-live under change control.

Why

EMA's computerised systems guideline treats trial specific configuration as something to pre-specify, verify against the protocol and data management plan, and test before release to production. It asks for traceability from each requirement to a test, pre-approved test cases stating the software version, prerequisites, steps and expected result, and recorded actual results with evidence. Where possible the tester should not be the author of the test case.

User acceptance testing involves the people who will use the system, because they spot problems specifications miss, such as a visit window that cannot be entered for real dosing schedules. Testing should focus on critical functions: eligibility forms, randomization or IRT links, primary endpoint fields, SAE forms and the edit checks on them. A protocol amendment that changes forms triggers the same process, and the team decides whether new fields apply to all participants or only those enrolled after the amendment.

How to work it through

  1. List requirements from the protocol, schedule of assessments and data management plan.
  2. Rank them by risk so critical functions get the deepest testing.
  3. Write and approve test cases with expected results before testing starts.
  4. Execute in a test environment, recording actual results and screenshots for each step.
  5. Log and assess every failure, fix it, and retest, including regression tests on related functions.
  6. Obtain sign-off and release to production with the tested version recorded.

An example

A 12 visit oncology study build has 180 requirements, 40 rated critical. Testers run 410 test cases. 23 fail, including a check that allowed dosing before the randomization date and a missing SAE seriousness field on the unscheduled visit form.

Both are fixed and retested along with 35 regression cases. A site coordinator in user acceptance testing notes that the day 1 visit window rejects same day screening and dosing, which the protocol allows. That requirement is corrected before go-live.

Where the answer stops holding

Testing cannot prove a build is error free, only that tested scenarios work. Vendors' platform validation covers the software, not the sponsor's study configuration. Tight timelines tempt teams to test only the happy path, which misses the edge cases where real data break checks.

A strong answer covers

  • Requirements traced to tests
  • Pre-approved test cases with expected results
  • Risk focus on critical functions
  • User acceptance testing with real users
  • Change control after go-live and for amendments

Common mistakes

  • Relying on the vendor's platform validation as proof the study build works.
  • Writing expected results after seeing the actual result.
  • Skipping regression testing after a fix.