electronic crf design data management - icsscicssc.org/documents/fundamentals of data management/tab...
TRANSCRIPT
Dat
a M
anag
emen
t
1
ICSSC
Electronic CRF DesignElectronic CRF Design
Erik Jolles,Senior Data Manager,
Family Health International
Dat
a M
anag
emen
t
2
ICSSC
DefinitionsDefinitions
eCRFs are the electronic representation of paper data collection formsThese can be duplicated from paper data collection forms or can themselves be the tool that is used for data collection
Data Entry screenData Fax entry screens (OCR,ICR)EDC – Entry screens
Dat
a M
anag
emen
t
3
ICSSC
Some general GuidelinesSome general Guidelines
eCRFs should be very similar to paper CRFsShould mimic the design and flow of paper CRF
eCRFs should have built-in edit checks tagged to each data field and also tagged to the form as a wholeIf there are no paper CRFs majority of the data cleaning will take place during the completion of the eCRFs.
Dat
a M
anag
emen
t
4
ICSSC
Things to ConsiderThings to Consider
Ease of entryAvoid over crowdingMatch electronic form to paper form as much as possibleUse of pre-coded answer setsAvoid excessive use of text fieldsAE designs
Dat
a M
anag
emen
t
5
ICSSC
Ease of data entryEase of data entry
Dat
a M
anag
emen
t
6
ICSSC
PrePre--coded Answer Setscoded Answer Sets
Dat
a M
anag
emen
t
7
ICSSC
Radio ButtonsRadio Buttons
Dat
a M
anag
emen
t
8
ICSSC
Check BoxesCheck Boxes
Dat
a M
anag
emen
t
9
ICSSC
DatesDates
Dates can be designed to be entered as a single item; however, you may have problems with incomplete datesFHI uses separate items for each part of the date and a derivation to get the dateWe also need to keep in mind the format that the dates will be collected (e.g., dd/mm/yyyy, mm/dd/yyyy, dd/mon/yyyy) and set up the screens appropriately.
Dat
a M
anag
emen
t
10
ICSSC
Repeating RecordsRepeating Records
Dat
a M
anag
emen
t
11
ICSSC
Text FieldsText Fields
Dat
a M
anag
emen
t
12
ICSSC
Text Fields (2)Text Fields (2)
Dat
a M
anag
emen
t
13
ICSSC
Testing of eCRFsTesting of eCRFs
eCRFs should be tested for ease of entry and data cleaning programsElectronic checkTab orderOrder of items on the formAnswer sets (code lists)
Dat
a M
anag
emen
t
14
ICSSC
Tools for testingTools for testing
Test data – to test error specifications and train data entry staffData base specificationsList of tablesError specification documentVariables and formats in each tableList of pre-coded answer sets (codelists)Expected error matrix
Dat
a M
anag
emen
t
15
ICSSC
ConclusionsConclusions
Design eCRFs as you would paper CRFsError checks should be tested for each eCRF and tested with test dataeCRF should be reviewed not only by study team but also by data entry staffStore documentation of for the design of the eCRFs