Skip to content
Data flow diagram templates

DFD — Clinical Trial Data Capture

Phase III electronic data capture from site eCRF to database lock, separating the identifiable site zone from the pseudonymised sponsor EDC and exposing the subject-key read that is the trial's re-identification path.

Template previewData flow diagram
Phase III trial — data capture to lockLEVEL 1Site zone (identifiable)Sponsor EDC (pseudonymised)External reviewInvestigator siteCentrallaboratoryData monitoringcommitteeRegulator (FDA)1Capture eCRF2Pseudonymise andkey3Run edit checks4Raise and resolvequery5Reconcile lab data6Lock and exportSDTM7Report to DMCD1eCRF databaseD2Subject identitykeyD3Query logD4Lab result storeD5Audit trail (21 CFR11)visit data + adverse eventssubject name + date of birthpseudonym mappingpseudonymised eCRFnew + changed fieldsedit-check failureopen queries (312)query responseLOINC lab resultsaccession linklab panelclean eCRFreconciled labslock signatureSDTM submissionsafety datachange historyinterim safety reportquery for clarificationcorrected value4 entities · 7 processes · 5 stores · 20 flows · 7 boundary crossingsCrossing — “pseudonymised eCRF”: Pseudonymise and key (Site zone (identifiable)) → eCRF database (Sponsor EDC (pseudonymised)).Crossing — “query for clarification”: Raise and resolve query (Sponsor EDC (pseudonymised)) → Investigator site (Site zone (ide…Crossing — “query response”: Investigator site (Site zone (identifiable)) → Raise and resolve query (Sponsor EDC (pseudonymised…Crossing — “LOINC lab results”: Central laboratory (outside) → Reconcile lab data (Sponsor EDC (pseudonymised)).Crossing — “accession link”: Subject identity key (Site zone (identifiable)) → Reconcile lab data (Sponsor EDC (pseudonymised)).Crossing — “SDTM submission”: Lock and export SDTM (Sponsor EDC (pseudonymised)) → Regulator (FDA) (External review).Crossing — “interim safety report”: Report to DMC (Sponsor EDC (pseudonymised)) → Data monitoring committee (External review).

Make it your own.

title "Phase III trial — data capture to lock"
level 1

entity "Investigator site"
entity "Central laboratory"
entity "Data monitoring committee"
entity "Regulator (FDA)"

process 1 "Capture eCRF"
process 2 "Pseudonymise and key"
process 3 "Run edit checks"
process 4 "Raise and resolve query"
process 5 "Reconcile lab data"
process 6 "Lock and export SDTM"
process 7 "Report to DMC"

store D1 "eCRF database"
store D2 "Subject identity key"
store D3 "Query log"
store D4 "Lab result store"
store D5 "Audit trail (21 CFR 11)"

boundary "Site zone (identifiable)" { "Investigator site", 1, 2, D2 }
boundary "Sponsor EDC (pseudonymised)" { 3, 4, 5, 6, 7, D1, D3, D4, D5 }
boundary "External review" { "Data monitoring committee", "Regulator (FDA)" }

"Investigator site" -> 1 : "visit data + adverse events"
1 -> 2 : "subject name + date of birth"
2 -> D2 : "pseudonym mapping"
2 -> D1 : "pseudonymised eCRF"
D1 -> 3 : "new + changed fields"
3 -> D3 : "edit-check failure"
D3 -> 4 : "open queries (312)"
4 -> "Investigator site" : "query for clarification"
"Investigator site" -> 4 : "query response"
4 -> D1 : "corrected value"
"Central laboratory" -> 5 : "LOINC lab results"
D2 -> 5 : "accession link"
5 -> D4 : "lab panel"
D1 -> 6 : "clean eCRF"
D4 -> 6 : "reconciled labs"
6 -> D5 : "lock signature"
6 -> "Regulator (FDA)" : "SDTM submission"
D1 -> 7 : "safety data"
D5 -> 7 : "change history"
7 -> "Data monitoring committee" : "interim safety report"